Problem solve
Get help with specific problems with your technologies, process and projects.
Setting up ODBC driver for migration
The easiest thing to do is to install the Oracle Client software on your workstation. This will install the ODBC driver. In Control Panel->Administrative Tools, there is an ODBC manager. With this tool, you can Add a new ODBC Data Source Name (or DSN). Now go to MS Access and choose File->Export. In the Save File As box, choose ODBC Datasources(). The wizard will then ask you which DSN to use. Use the DSN you created above.
This was last published in January 2004
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments