MS Access ODBC on Windows 7

By HonestBroker ·
A colleague who has an MS access application that connects via ODBC to an Oracle database, recently had their laptop upgraded to Windows 7.
The company sys admin logged on remotely, installed an Oracle Client and set up a System DSN. In the ODBC configuration dialog box, the support guy clicked on the Test Connection, entered the credentials and got "Test Successful".
How can this DSN be made available to my non-admin colleague and the MS access application that needs it?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

workaround ?

by highlander718 In reply to MS Access ODBC on Windows ...

not sure why your non-admin colleague is not seing the System DSN, but a workaround might be to setup a user DSN. Do you have WinNT authentication on the Oracle machine ? Because in that case it is even better to use User DSN.

Collapse -

Reponse To Answer

by HonestBroker In reply to workaround ?

Very useful suggestion! the non-admin user can create a User DSN and when they Test Connection -> "Test Successful"!
However in MS Access, when creating the ODBC linkage it returns with "ODBC--call failed". Not very informative eh?
I suppose that now we know it is an MS-Access specific issue - should I re-post elsewhere as an MS-Access query?

Collapse -

Is it a 64 bit machine?

by Slayer_ In reply to MS Access ODBC on Windows ...

If so, check if access is running in 32 bit mode. Look in task manager and see if beside the process, does it say *32. If so. The ODBC in the control panel won't work, you have to set the 32 bit version. Located here "C:\windows\SysWOW64\odbcad32.exe"

Collapse -

Reponse To Answer

by HonestBroker In reply to Is it a 64 bit machine?

I just got to check the system now and it is in fact the System Type is 32-bit Operating System and only one odbcad32.exe installed.

Related Discussions

Related Forums