Michael Squires wrote:
> 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.
The problem I have is that I can't even register the data source because the driver
isn't found.
Did you no have to register it?
What is your odbc connection string?
Lots of Greetings!
Volker
Received on Fri Jun 17 2005 - 07:10:15 CDT
