I know this will be odd, but we need to connect some new machines to an old database. Our new machines are Win7, 64 bit, Professional. We have a couple old Access databases which link to data on our Oracle server. HP-UX Oracle version 8.0.6. (Stop laughing)
Here is where I am at. I have managed to install the 8.0.6 client on these machines as well as 32 bit Win7 Pro. The 32 bit machines work without a hitch. On the 64 bit machines, I can successfully set up the DSN and retrieve data using the Oracle ODBC test app. I can also run Custom VB apps which use OLE to link to the Oracle data with success.
When I try and retrieve data in the Access database I receive an error 6413 Driver's SQLSetConnectAttr failed IM006.
I can not use the newer Oracle drivers as they will not connect to this older version of the database server.
Any thoughts are appreciated.