PDA

View Full Version : Newbee needing ODBC help... Please


FlyBoy
09-25-2009, 02:03 AM
I'm evaluating this product and I've hit a snag, probably because I'm not familiar enough with it. Help Please...

I've written an install and am testing it on Vista 64bit. The install requires the setup of an ODBC driver and profile which I do in the Pre Install action (See Attached PreInstall.txt).
After the files have been installed I launch an .exe that uses the ODBC connection to generate SQL commands and make changes to a database file if that file pre-existed on the machine. The connection profile also serve a desktop application that the install is... installing :-)

The ODBC profile and driver are not getting set up correctly and Vista 64 is killing me. The ODBC driver is a 32bit driver. Vista 64 has two odbcad32.exe files, one in system32 (for 64bit), the other in windows/syswow64 (for 32bit) nice that they are named the same...NOT. If I set the profile up manually using the 32bit odbcad32.exe I'm in business and everything works, but I can't get the installer to create the profile. I even tried pushing the values to the registry with the registry object (See Attached PrevAttempt.txt). Vista 64 also keeps the 32bit driver info separate from the 64bit info. The 32bit info is in HKLM/Software/Wow6432Node??? Turning on the logging with extended errors gives me nothing (See Attached SetupLog.txt). Everything succeeds? Accept for the errors that tell me the components cannot be found. But that is because I'm trying to create them. I guess I'm just not seeing how...

How do I install an ODBC driver and create the profile for Vista64??? Any ideas or leads will be appreciated. Collect launch user information is checked.

Thanks... Looking to purchase soon.

FlyBoy
09-25-2009, 03:32 AM
Its early so I guess I'm getting a little flaky in the brain. I realized finally from the 3505 error that the ODBC.ConfigDataSource was throwing was because I was referencing "Sweet" for the Driver description. When I changed it to "Adaptive Server Anywhere 8.0" my error changed to a 3512 error... Still not sure whats up, but at least the error is different. Again, if I set the data source up manually everything works. Its not a Vista64 problem, its occuring on XP as well.

The ODBC driver is getting set up, its the DataSource that I'm stuck on. So if I want to set up a data source named "My DataSource" using the Adaptive Server Anywhere 8.0 driver, what is the syntax? Thank you.

FlyBoy
09-25-2009, 05:12 AM
Time for sleep. I must have looked at these lines of code 100 X's and it just occurred to me that I was missing the DSN parameter... Added that Parm and I'm up and flying. Thanks