I have a vista 64 bit and there are not any drivers for access how do I install the odbc drivers so that I can use access. The only drivers there are for sql
Go to C:\Windows\syswow64 and execute odbcad32.exe in order to work with your MS office databases.
Alternatively you can also run the file from C:\Windows\System32 which has the same odbcad32.exe file.
Hope this helps !
Thanks for the reply, I have done all of that and still doesn't work. What I realized the other day is that a page will come up OK if it is html and also with a connection to the database but it is when I make a recordset I have the problem.
Your Office 2003 is 32bit correct as their is not a 64bit version of Office 2003 ? So you only need a 32bit ODBC Driver for Oracle, thus I would uninstall the 64bit version in case it is for some reason being picked up in instances you do not realize and then just configure the 32bit Oracle TNS listener (or Oracle Instant client) to connect to your target database, if that works then configure a 32bit DSN (user or system) to use it and you should then be able to connect with your application.
Alternatively OpenLink Software have a suite of ODBC Drivers including Oracle for both 32bit and 64 bit windows (and many other OS'es), and I would download our 32bit Windows Oracle Driver and try that. These can be downloaded by selecting on of the solution presented in our new solution wizard at: