15Sep/091
ODBC on 64bit Windows
Been trying to deploy my app to the Staging area this week and I ran into more problems I wanted to share. My Crystal Reports objects weren't able to connect programmatically to the ODBC. I'm still trying to figure out what the issue is, but I ran into this bit of secret knowledge that I wanted to share from DevArticles.
In a 64 bit windows server operating system, there are TWO odbc managers. When you pull up the usual menu for the odbc / dsn system, it is for the 64 bit odbc manager, and 32 bit applications (vb 6.0) will not work using these dsn's.
This is where the 32 bit odbc manager is:
C:\Windows\SysWOW64\odbcad32.exe
Now that's useful information. Especially since I'm still building 32bit apps.
September 16th, 2009 - 15:50
This actually turned out to be the solution to my problem. I just had to do a reset of my machine from a bunch of installs I had performed during the day.