Ok, here's the deal: I have a C # /. NET application available for the Oracle 8 database, which works well on our 32-bit machines. It works using the v.8 ODBC client, 9i client, or XE 10g client. However, nothing works on a 64-bit Windows machine. I successfully installed the 11g 64-bit client, only to find that it refuses to talk to the v8 database, so I guess I need the 10g, 9i or 8i 64-bit client. I tried 9i and 10g XE with no luck. I have not tried the full 10g client yet.
I installed MDAC 2.8, but none of these ODBC drivers appeared in the Data Tools → ODBC Data Source Management Tool, apparently because they are not 64 bits. Ony MS SQL came out.
The strange thing is that there is an old Cognos Impromptu program that works fine - it seems you can easily find and use the 32-bit v8 client that is installed on the system, but my application cannot.
I found that I could see and create / edit ODBC data sources by making a copy of the ODBC data source tool shortcut, changing it to a different path (replace system32 with SYSWOW64), but the data sources that I create there are somehow hidden from my application. Is there a way to point my .NET application to a specific data source, perhaps by creating a DSN file and specifying the full local path, for example?
It drives me crazy. Help!
source
share