Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with ODBC driver on Win 64
Message
From
06/06/2011 17:12:25
 
 
To
06/06/2011 12:20:07
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01510942
Message ID:
01513232
Views:
51
>Ok, after more information, the situation we have is that I need to force my application to use the System DSN of the 32 bits version which is in C:\Windows\SysWOW64\odbcad32.exe. So, this is the focus. But, is this something I have control on in my application? The System DNS is already created. It is just that my application, by default, or any other .NET application BTW, uses by default the 64 bits version of the System DSN on a 64 bits OS. So, I have no idea presently what I can change in my Setup.exe to handle this.

Ok, lets provide more information as this is going nowhere.

1. I compile my application on a Windows 7 64 bits OS with .NET Framework 4.0.

2. The application is installed on client sites by the use of Setup.exe which is built from my project.

3. This works well on 32 bits OS clients.

4. It fails on 64 bits OS clients because, by default, my .NET application tries to use the 64 bits version of Odbcad32.exe in %systemdrive%WindowsSystem32 folder. But, it has to use the 32 bits version of Odbcad32.exe in the %systemdrive%WindowsSysWoW64 folder. Yes, I know. The directory naming as well as the files is confusing. But, this is what it is.

5. My Setup.exe, in Configuration Manager, is set up to Any CPU. Any other combinations results in a no compile possibility.

6. So, the goal is to assure that even under a 64 bits OS that the 32 bits version of Odbcad32 will be used. But, how can we control that?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform