Re: ODBC connection using instant client...

In article <d8rpg4$e3j$1_at_nntp.fujitsu-siemens.com>, Volker Hetzer <volker.hetzer_at_ieee.org> wrote:
>Hi!
>I'm trying to use the instantclient for odbc.
>I've installed everything, base in c:\oracle\instantclient10_1,
>odbc addon as well, did the .bat file
>and now I'm trying to connect to my database.
>However, when I try to connect with
>DRIVER=Oracle in
>c:\oracle\10g\instantclient10_1;UID=me;PWD=mypasswd;DBQ=mytnsname
>
>I get a IM002 0 {[Microsoft][ODBC Driver Manager] Data source not found
>and no standard driver supplied}
>
>What am I doing wrong?

In my notes to myself on how to install both the ODBC and SQL*Plus stuff I see the following tasks you don't mention:

Creating and editing SQLPATH and PATH in the environment variables

Creating and copying the TNSNAMES.ORA and SQLNET.ORA files (have to be in both the Instant Client and in the .\network\admin directory under it)

Adding a registry entry (needed for SQL*Plus, ODBC doesn't need it).

This is working with a 10g RAC server to link Access 2000/2002/2003 to Oracle and to run SQL*Plus. Unfortunately the INstant Client does not contain SQL*Loader.

Mike Squires

-- 

Mike Squires (mikes at cs.indiana.edu)     317 233 9456 (w) 812 333 6564 (h)
mikes at siralan.org             546 N Park Ridge Rd., Bloomington, IN 47408