Connecting Allworx 6x to FreePBX 2.10.1.9

Posted at 5:05:04 PM in Installations (41)

I have not had a chance to do any trunk to trunk PBX connecting before. A client wanted setup his Allworx 6x and had previously had it setup with POTS lines. He had ordered POTS lines to get the same config as he had in a previous office but that order didn't come through. I suggested we try getting him setup using SIP instead of the POTS lines.I was unfamiliar with Allworx and tried to find a way to reconfigure the IP phones that came with the system, but quickly found out that wouldn't work....

Read More "Connecting Allworx 6x to FreePBX 2.10.1.9"

Written by Leonard Rogers on Thursday, March 28, 2013 | Comments (0)

Connecting Copfilter's SpamAssassin to Gmail's IMAP folders for Bayes Scoring

Posted at 2:06:51 PM in Installations (41)

I had an issue connecting my copfilter to gmail's folders in an effort to setup bayes scoring. Initially, the problem was with the need for a secure connection. Previous to V2, we could not use SSL. After upgrading to V2, I was still having issues connecting.I was able to connect with these settings: IMAP server:imap.gmail.com:993 Require SSL:Yes User name: your Gmail account name The account name is what precedes @gmail.com in your Gmail address. If your Gmail address is nospam@gmail.com,...

Read More "Connecting Copfilter's SpamAssassin to Gmail's IMAP folders for Bayes Scoring"

Written by Leonard Rogers on Tuesday, March 19, 2013 | Comments (0)

AVG 2013 Free Edition Freezes PC

Posted at 11:31:29 AM in Installations (41)

Just an observation. I believe I saw this in the paid edition also, but when AVG updates, the entire PC seems to freeze. This is just a download and patch to their databases. I cannot imagine what it is that it's doing that would cause such a problem, except that the program is not sharing the CPU which is just plain bad programming.

Written by Leonard Rogers on Wednesday, February 13, 2013 | Comments (0)

HP Officejet Pro 8500 910A Server 2003 install FAIL

Posted at 10:48:18 PM in Installations (41)

One of the great frustrations of IT is chasing one's tail around and around in circles. Nothing drives me up a wall more that starting a simple job and then because of poor support from the vendor, I have to try every machination to try and get something done. Such is the case with the HP Officejet Pro 8500 910A install. It was just a simple network install. Nothing to it, right?Well, the problem is, if you pick the server 2003 driver for this printer, it isn't the right driver. Well, it is, but...

Read More "HP Officejet Pro 8500 910A Server 2003 install FAIL"

Written by Leonard Rogers on Saturday, September 15, 2012 | Comments (0)

Clamwin Anti-virus Review

Posted at 11:43:11 AM in Installations (41)

ClamwinThis Anti-Virus has a very small foot print. From what I can tell, it has no real-time protection from virus' that might find their way onto your computer through the network or through web browsing. Certainly, it doesn't work for files that you download and install through your web browser. There is an option when you install it that has plug-ins for Internet Explorer and Outlook. I've seen it stop virus' in outlook, but it didn't stop it from coming, the pop up alert and virus prevention...

Read More "Clamwin Anti-virus Review"

Written by Leonard Rogers on Saturday, July 14, 2012 | Comments (0)

AsteriskNOW Install - 10 Second disconnect extension to extension

Posted at 11:22:14 PM in Installations (41)

I discovered more important information on the proper network setup. I was getting disconnected on calls to voice mail, attempting to record greetings, echo test or just calling another extension. I believed it was caused by one of the upgrades to FreePBX or Asterisk addons. I ended up installing AsteriskNOW 3 times before I found the problem.1. VERBOSE settings in CLI will not give the error. I also discovered that the extra v's you see after the -r sets the level of verbosity. The default is...

Read More "AsteriskNOW Install - 10 Second disconnect extension to extension"

Written by Leonard Rogers on Saturday, February 11, 2012 | Comments (0)

AsteriskNOW Install - Network

Posted at 8:45:34 PM in Installations (41)

One thing to note. Changes to the OS don't take effect immediately. I'm sure there is a command to run that will install the changes, but I'm not a Linux guru. Namely, the IP address assigned to the network card. It doesn't register until after a reboot.When I first setup my AsteriskNOW PBX server, I used an internal network address. However, when it came time to install the SIP trunks, that setup proved to be impossible to work with. My router is behind several routers, so port forwarding was...

Read More "AsteriskNOW Install - Network"

Written by Leonard Rogers on Saturday, February 11, 2012 | Comments (0)

Joomla 2.5.1 Still no PostgreSQL option available

Posted at 11:26:37 AM in Installations (41)

I've been checking the Joomla multi database support ever since an article came out in Jan 2012. This is one example: http://www.itweb.co.za/index.php?option=com_content&view=article&id=50936:Joomla-gets-database,-search-supportSo, I went to the Joomla web site and installed it on my PHP server with PostgreSQL extensions installed. I checked all the requirements and pgsql and pdo_pgsql show as registered in php_info(). But PostgreSQL does not show as an option for database install. I posted...

Read More "Joomla 2.5.1 Still no PostgreSQL option available"

Written by Leonard Rogers on Friday, February 03, 2012 | Comments (2)

AsteriskNOW Install

Posted at 6:29:02 PM in Installations (41)

Just recently installed AsteriskNOW 1.7.1 32-bit ISO Image http://www.asterisk.org/downloads. This is my first installation and was done as a test while I'm investigating options for a client request. I should keep better notes, but my style of investigation leaves little for education for others. However, I will try to document what I've found so far.I originally found Asterisk on sourceForge.com while looking for telephony solutions. When I downloaded the ISO image, I had no idea I was also...

Read More "AsteriskNOW Install"

Written by Leonard Rogers on Thursday, February 02, 2012 | Comments (0)

RDP printing from Windows XP and Microsoft 2008 R2 servers

Posted at 3:14:39 PM in Installations (41)

Easy Print RDP printingWell, it's suppose to be easy. On my Windows XP clients, the printers were all showing up on the server as remote printers with the session ID attached to the end just like they were suppose to, but nothing would print. Nothing showed up in the print queue. Print jobs just vaporized. After much research, I discovered this happens when you install the Remote Desktop Host Role on the Domain Controller. Microsoft recommends against it. They suggest you install RDP Host on a...

Read More "RDP printing from Windows XP and Microsoft 2008 R2 servers"

Written by Leonard Rogers on Thursday, January 12, 2012 | Comments (1)

Adding Win XP printer share to Win 7 64 Bit OS

Posted at 5:33:31 PM in Installations (41)

Excellent information on how to do this on this page:Copied here.I found the answer here:-http://social.answers.microsoft.com/Forums/en-US/w7hardware/thread/bd43f9f6-e231-484f-a3b8-e06afeee7c7eThis post says:-The 32bit driver name is different than the 64bit driver name. You will need to create a Local Port which will basically copy the print formated data to the xpmachine share.Here's the KB how to perform this taskhttp://support.microsoft.com/kb/282842on Windows 7Add PrinterLocal PrinterAdd...

Read More "Adding Win XP printer share to Win 7 64 Bit OS"

Written by Leonard Rogers on Wednesday, November 30, 2011 | Comments (0)

Peachtree freezes on pop-up message for end-of-year wizard

Posted at 3:58:53 PM in Installations (41)

Peachtree Quantum 2012 freezes when Peachtree starts when the user gets a message that the end of the year is approaching requesting if the user would like to run the end-of-year accounting audit wizard.The PC was Windows XP SP3. The problem was the PC did not have IE 8 (Internet Explorer 8) installed. I twas still using IE 6. Another message also popped up indicating that the screens could not be displayed properly because the version of Internet Explorer needed to be upgraded. However, because...

Read More "Peachtree freezes on pop-up message for end-of-year wizard"

Written by Leonard Rogers on Thursday, November 17, 2011 | Comments (0)

Clam Antivirus and Clam Sentinel

Posted at 5:47:55 PM in Installations (41)

I'm a recent convert to Clam AV. Mostly because it has a small resource usage foot print and the design focuses on virus checking. I used AVG before, but in 2011's version, the software hogged up so much memory and resources that programs were really running slow. Then on the upgrade to 2012, I ran into a lot of problems with programs and network devices hanging up. Outlook wouldn't retrieve email. The PC that had the AVG network admin software installed on it started losing it's network connection...

Read More "Clam Antivirus and Clam Sentinel"

Written by Leonard Rogers on Thursday, October 27, 2011 | Comments (6)

Acronis server image on Dell T310

Posted at 1:48:29 PM in Installations (41)

I just recently bought 2 T310 servers from Dell. Nice servers with fast SATA drives. I wanted to make a backup image of the server in case I screwed something up during the install, however; Acronis couldn't see the SATA drive. I checked for updates and applied them, but still not luck. This I found this post on Techguy.org from back in 2008 that still works today! Check out the post athttp://forums.techguy.org/all-other-software/697371-solved-acronis-true-image-sata.htmlUse safe mode and you...

Read More "Acronis server image on Dell T310"

Written by Leonard Rogers on Monday, October 24, 2011 | Comments (0)

Wordpress with PostreSQL

Posted at 12:36:14 PM in Installations (41)

I noticed a few things after my installation of Wordpress with PostgreSQL as the data backend. I used pg4wp, found on this site. I downloaded the latest version 1.2.2 but got errors during the installation, but Wordpress indicated it had installed successfully, so I didn't worry about it too much. Then as I was trying to add categories, the new categories wouldn't show up. I had enabled PG4WP_DEBUG and reviewed the log files.The first problem was a duplicate key which violated the unique constraint...

Read More "Wordpress with PostreSQL"

Written by Leonard Rogers on Monday, October 24, 2011 | Comments (0)

Setting up Wordpress on Ubuntu

Posted at 4:01:02 PM in Installations (41)

Extremely frustrating.Wordpress boasts an easy install. However, I find that after a week of work, I still don't have a fully functioning Wordpress site.My installation started from scratch. I'm mostly an IIS asp classic type designer and... I'm mostly backend. My artistic flair leaves a lot to be desired. The desire to get Wordpress installed came from a client who was trying to compete with Godaddy's offering. He designs web sites, but they are still bland in comparison to todays flashy colorful...

Read More "Setting up Wordpress on Ubuntu"

Written by Leonard Rogers on Saturday, October 22, 2011 | Comments (0)

Win 7 login issues to Windows 2000 workgroup share

Posted at 2:13:30 PM in Installations (41)

Windows 7 is here and we have to learn how to connect it to old legacy systems. I have several old MS 2000 servers running in workgroup mode and need to connect the Windows 7 machine to those PCs.In order to find the server, Ihad to go into advance settings in the Network and Sharing Centerpanel (found on the control panel) and change the settings to allow shares. These are the settings Turn on network discovery Turn on file and printer sharing Turn off Public folder sharing (may need...

Read More "Win 7 login issues to Windows 2000 workgroup share"

Written by Leonard Rogers on Wednesday, August 17, 2011 | Comments (0)

Windows 7 Printer install error 0x0000001c

Posted at 7:46:26 PM in Installations (41)

I just finished a windows 7 printer installation and at first got an error 0x0000001c. I wasn't able to find any good information. I did find an error wiki site, but after reviewing it, it appears to only be a gimmick to sell an error checker.In any case, I had downloaded the driver for another windows 7 PC and had no problems installing it. My printer is a networked Sharp copier/printer MX-M503N. The problem I found was that I was installing a 64bit driver on a 32bit PC. Once I attempted this...

Read More "Windows 7 Printer install error 0x0000001c"

Written by Leonard Rogers on Tuesday, August 09, 2011 | Comments (0)

Outlook, IMAP and Gmail google

Posted at 11:33:51 PM in Installations (41)

I had a problem today where Outlook 2007 kept giving an access error for a gmail account on both the SMTP and IMAP connections. The error message always popped up requesting the password be entered again and a message indicating that the user should login to their gmail web interface. Calling the company that setup the account didn't do any good. They could see no problems and said they didn't change anything. We didn't get a chance to call Google about the issue.The user was able to login to...

Read More "Outlook, IMAP and Gmail google"

Written by Leonard Rogers on Monday, August 01, 2011 | Comments (0)

Microsoft Office 2010 Beta and the Q drive

Posted at 11:32:37 PM in Installations (41)

I just found out that Microsoft office 2010 Beta takes over the Q drive. It doesn't matter that it's already mapped to a network drive. Once the software is installed, the local assignment takes over that drive letter and suddenly all applications that depended on the Q drive network map will no longer function. This is similar to Microsoft taking over the M drive for Microsoft Mail. That didn't go over too well either.I personally like to assign the Q drive to my quickbooks applications. When...

Read More "Microsoft Office 2010 Beta and the Q drive"

Written by Leonard Rogers on Tuesday, July 19, 2011 | Comments (0)

Office Move

Posted at 7:52:55 AM in Installations (41)

Well, the move is almost complete. The move consisted of 38 phone stations and 45 network devices. Of those devices 8 were servers and I also moved the mail server. Argosoft was finally not meeting up the the standards I needed so I upgraded to hmailserver. I am having one problem with that. It seems the POP accounts are getting locked by iPhones accessing the same mail accounts as Mac Operating systems. One of those devices checks every minute and ignores the request to check less often.The biggest...

Read More "Office Move"

Written by Leonard Rogers on Friday, July 08, 2011 | Comments (0)

Peachtree Registration Page

Posted at 1:12:39 PM in Installations (41)

Peachtree has changed it's registration page. It use to be http://www.peacthree.com/register and this link shows on installation software up through Peachtree 2011. WhenI tried to re-register my older version of Peachtree I also found that my customer number no longer worked. Sage software is going through some consolidation and all the old customer numbers have now been replaced with 10 digit customer numbers. In any case, the right location to register your Peachtree products is: https://customers.sagenorthamerica.com/irj/portal/anonymous/login...

Read More "Peachtree Registration Page"

Written by Leonard Rogers on Wednesday, June 22, 2011 | Comments (0)

Cannot connect to NumberCruncher

Posted at 6:56:14 PM in Installations (41)

We connect to a Remote Desktop (RDP) to use NumberCruncher (NC) and Quickbooks (QB). In order to use NumberCruncher the way we have it set up, requires that QB be open. Even with this is done, sometimes you have to find the NC data connector description file and then find the QBW file via a wizard inside NC. The RDP connections worked fine, but QB and NC were being opened for the very first time and required some setup. QB gave numerous welcome screens and those had to be addressed before NC would...

Read More "Cannot connect to NumberCruncher"

Written by Leonard Rogers on Thursday, June 16, 2011 | Comments (0)

Validity Sensors DDK

Posted at 8:49:47 PM in Installations (41)

Just got a new Dell Vostro 3550 Laptop which comes with pre-installed software and new-age gadgets. Validity Sensors DDK is one of those programs and appears to be part of the computers finger print security which the name seems to imply.The name of the company that supposedly produces this product is Software Informer, Inc. But a visit to their web site gives absolutely no information (seehttp://validity-sensors-ddk.software.informer.com/). They claim 4903 people use the product which makes me...

Read More "Validity Sensors DDK"

Written by Leonard Rogers on Tuesday, May 17, 2011 | Comments (3)

VPN between RV042 and RVS4000 routers

Posted at 6:37:14 PM in Installations (41)

I followed the instructions on the Cisco web site on setting up the VPN between these two routers. The biggest area of concern for me was a change in description in setting up the IPSec portion of the VPN.The IP address info in the Local Group Setup and the Remote Group Setup is very straight forward. In the IPSec Setup, the Phase1 DH Group, and the Phase2 DH Group on the RV042 simply say, Group1, Group2 and Group5. There isn't much description on what those groups actually represent. In the RVS4000...

Read More "VPN between RV042 and RVS4000 routers"

Written by Leonard Rogers on Thursday, May 12, 2011 | Comments (0)

Server Room Temperature Monitor

Posted at 6:39:21 PM in Installations (41)

I spent a couple of days researching computer room temperature monitor solutions and found many and varied solutions. What drove my crazy was the ridiculous pricing. The prices started at about $200 and went up as high as $800. Most of the products on gave were only thermometers that couldn't record any history. They would however notify you if the temperature exceeded a certain level. The higher end recorders were self contained and would record the temperature on a round paper disk that you...

Read More "Server Room Temperature Monitor"

Written by Leonard Rogers on Thursday, May 05, 2011 | Comments (0)

Repairs to gotomypc printer after messing around with the manual install

Posted at 9:41:14 AM in Installations (41)

After the problems that I was checking with gotomypc printers in the last post. The customer was not able to print at all. I looked on the remote desktop and found that the gotomypc driver was there, but it wasn't loading when the user connected via gotomypc. After some research, the only solution was to reinstall gotomypc on the host computer again. I'm not sure if there is a work around for this, but it did repair the problem.Btw, this is when I noticed that the waiting state is normal for gotomypc...

Read More "Repairs to gotomypc printer after messing around with the manual install"

Written by Leonard Rogers on Sunday, April 17, 2011 | Comments (1)

HP Laserjet 1020-1022 series printer and Gotomypc

Posted at 4:28:02 PM in Installations (41)

I have a customer that recently wanted to print documents from her remote PC via gotomypc. Her local printer was an HP Laserjet 1020 printer. While I was investigating this issue, I discovered that the gotomypc printer on the remote PC was hung in a waiting state. (Note: the waiting state is normal for the gotomypc printer. I found that it sits in a waiting state when the printer works, so this isn't unusual.) All the print jobs would just disappear unless she chose to print on one of the PCs...

Read More "HP Laserjet 1020-1022 series printer and Gotomypc"

Written by Leonard Rogers on Friday, April 08, 2011 | Comments (0)

Peachtree 2009 SR5 Update

Posted at 12:39:38 AM in Installations (41)

Well Sage software did it again. They released a tax update to download automatically into Peachtree 2009 Complete accounting (also Quantum 2009) but didn't download the required SR update to go along with the Tax update. When I went to the menu option, Services/Check for updates, I got nothing.So we are forced to go to a link that only shows up in the Tax update completion screen and if you don't get it there, you'll have to hunt for it.Here's the link:http://www.peachtree.com/readmore/Peachtree_2009SR5You...

Read More "Peachtree 2009 SR5 Update"

Written by Leonard Rogers on Saturday, March 12, 2011 | Comments (0)

More on Blackberry to iPhone contacts transfer

Posted at 8:57:14 AM in Installations (41)

I got ahold of both the Blackberry and iPhone yesterday to perform the transfer. We did have to go back to the Verizon store so they could activate the Blackberry phone again. On the Blackberry, I just needed to direct the browser to m.google.com and install the Google Sync software. The page contains an link for all the Google mobile apps and then individual links for the separate Google apps so you can download and install them one at a time. The app installed without a problem. I set up the...

Read More "More on Blackberry to iPhone contacts transfer"

Written by Leonard Rogers on Tuesday, March 08, 2011 | Comments (0)

pgAdmin 3 installation error 0xc0150002

Posted at 5:22:27 PM in Installations (41)

Installed pgAdmin on a newly setup Windows XP Pro machine.  I kept getting this error with pgAdmin 3 version 1.10.4, which I had just downloaded from the pgAdmin site.  I tried downloading and installing their most recent version 1.12.2.  That version gave an error which indicated that a reinstall might fix it.  

This site had the fix.  Apparently, pgAdmin needs to have the Microsoft C++ 2005 distribution package installed.

Written by Leonard Rogers on Wednesday, March 02, 2011 | Comments (0)

Google voice

Posted at 3:05:20 PM in Installations (41)

I just setup Google voice to pick up my voice mail for my cell phone instead of the standard that Verizon offers. My issues with with the standard voicemail is the limited storage, limited days they keep the message, the abrupt notification when you go to check new messages that it’s going to delete the expired messages, the fact that there’s no date and time stamp on the message until you are forced to delete the message.The pluses on Google voice is their storage. You delete messages...

Read More "Google voice"

Written by Leonard Rogers on Tuesday, March 01, 2011 | Comments (0)

Blackberry to iPhone contacts transfer

Posted at 2:17:25 PM in Installations (41)

I have a client that went with the Verizon iPhone after his Blackberry umbilical cord broke. It appears that it might be in the phone side, because it won’t charge, it won’t backup or synchronize or update. Now the problem was how to get the contacts out of the blackberry and into the iPhone.My client told me that the people at the Verizon store were no help. I have always thought that they would have all the gadgets needed to perform these tasks, but apparently not. Or at least, they...

Read More "Blackberry to iPhone contacts transfer"

Written by Leonard Rogers on Tuesday, March 01, 2011 | Comments (0)

Verizon USB 727 broadband modem Novatel Wireless

Posted at 3:47:57 PM in Installations (41)

I just finished reinstalling a laptop and needed to install the Verizoncellular modem. Ifound the drivers online at http://www.vzam.net/download/supported.aspxwhich lists several models. The one for the USB727 was downloaded and installed, but every step of the way, I got pop ups that indicated it couldn't find some part of the hardware. Ihave always installed USB device software first, then inserted the USB device. However, this time, that apparently doesn't work.I'm not sure if it would have...

Read More "Verizon USB 727 broadband modem Novatel Wireless"

Written by Leonard Rogers on Wednesday, February 23, 2011 | Comments (0)

Cargowise EDI SQL server upgrade from 2005 to 2008

Posted at 2:56:49 PM in Installations (41)

Cargowise has a split in upgrade paths depending on the SQL server you are running. We were left out of a new upgrade because we were using SQL 2005, so we decided to make the switch. The instructions from Cargowise EDI for the migration simply are: backup the database copy the backup files to the new server Install 2008 R2 restore the database Re deploy the Controller and web interface.Their instructions start with installing 2008 server first. These didn't work very well for me...

Read More "Cargowise EDI SQL server upgrade from 2005 to 2008"

Written by Leonard Rogers on Friday, February 11, 2011 | Comments (0)

Cargowise EDI shared printer setup

Posted at 2:49:43 PM in Installations (41)

The Controller PC manages all the print jobs in Cargowise EDI. Printers that are directly connected to the Controller PC are available to all the workstations. The printers do not have to be setup on each workstation. Cargowise EDI has it's own interface for selecting the printer. If you have a shared network printer, it will not automatically be seen by Cargowise EDI. The Controller software runs as a service. In order for the printers to be seen, they need to run with the same permissions as...

Read More "Cargowise EDI shared printer setup"

Written by Leonard Rogers on Friday, February 11, 2011 | Comments (0)

Cargowise EDI setup for SQL database at remote location

Posted at 10:18:34 PM in Installations (41)

The database engine behind Cargowise is MS SQL. We installed the 2005 Express package that came with Cargowise's installation package. The ideal software installation wants everything on the same network. This becomes important when setting up file locations in the admin section of Cargowise. These file locations are processed by the Controller (which is a PC that communicates with the SQL server to run jobs such as FTP, email and print jobs). The file locations are always relative to the computer...

Read More "Cargowise EDI setup for SQL database at remote location"

Written by Leonard Rogers on Monday, January 31, 2011 | Comments (0)

Apache server not responding on any IP or port

Posted at 3:14:18 PM in Installations (41)

After installing a minimum install Fedora 14 text mode, I yum'd httpd and started the service. I could not get it to respond on any IP address. I rannetstat -tun |grep 80and found that httpd was running and listening on port 80. After searching around, I found that iptables and ip6tables had been installed as part of the minimum install package and I'm sure they were setup as a workstation which wouldn't have a web server. I ran service iptables stopand checked the web server again and it worked.Now...

Read More "Apache server not responding on any IP or port"

Written by Leonard Rogers on Wednesday, January 26, 2011 | Comments (0)

Fedora 14 Install experiences

Posted at 2:44:54 PM in Installations (41)

I have been trying to get Fedora 14 to install over the network. Everything I did failed all around the missing repomd.xml. The only installation that worked was using the DVD. I'm updating an old server that doesn't have much memory which are all problems and I didn't want the graphics client installed. I did the network install because it allowed the use of a kickstart file. Once I started using the kickstart file, it refused to look back at the CD for the repository.To get a text based server...

Read More "Fedora 14 Install experiences"

Written by Leonard Rogers on Friday, January 21, 2011 | Comments (0)

repomd.xml repository installation file used by yum

Posted at 11:01:36 AM in Installations (41)

Many Linux installations (my favorite is Fedora though I'm not sure why) use yum to update their program files and libraries. During recent installation attempts with Fedora 14, I kept getting error messages saying repomd.xml could not be found which is a very important file used by yum to perform it's upgrades. I discovered that this file is normally found in a directory called repodata off the base directory provided. So if you are trying to provide the location for this file and it is located...

Read More "repomd.xml repository installation file used by yum"

Written by Leonard Rogers on Friday, January 21, 2011 | Comments (0)

Database conversion Postgresql

Posted at 10:09:14 PM in Installations (41)

I've been working on a postgresql version of Blog 9.0.  I'm in the testing phases now and will be looking at the other functions of this blog.

This has been an uphill course.  I manually converted all of the all of the database table and field names to lower case.  Postgresql is extremely case sensitive.  I didn't get all of the fields and found that as long as all the names are in lower case in the actual database, apparently the code can have whatever case structure it wants.  The ASP pages still find the correct tables and names.

I had a big issue with bigint and bigserial field types.  bigint is a 8 byte integer which gives an outrageous range on index keys.  I started out converting all of the field extractions from Int8 to cLng and that worked, but there was a lot of work to do to fix all of them.  I instead discovered that you can specify in ODBC to treat int8 as int4 which is the same as the integer used by MS SQL and visual basic.  After I made that change, I was able to view all of the screens with one exception.  I did not have a layout picked.  The database creation tool did not copy anything into that field and when I displayed the web pages, I got an error on invalid "/" or "" in query.  It turns out that I was submitting a null and as soon as I selected one of the valid templates, those errors went alway also.

 

 

 

Written by Leonard Rogers on Monday, December 20, 2010 | Comments (0)