Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with ODBC driver on Win 64
Message
De
06/06/2011 17:12:25
 
 
À
06/06/2011 12:20:07
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Versions des environnements
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01510942
Message ID:
01513232
Vues:
52
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform