V
Vince
On my Win2k PC I'm trying to execute a pass through query in Access 97
(Access 2000 gives me the same results) per a dsn-less connection against an
Oracle 9.2.0.4 database residing on a unix server.
I keep getting an eror window: "ODBC -- call failed"
In that window I click OK and get another window: "[Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified(#0)"
Here's the value in Query Properties|ODBC Connect Str:
ODBC;connect_string = "Driver={Oracle in Ora920}; Host=hostname; Port=1521;
SID=thesid; UID=myid; PWD=mypwd;"
If I remove "UID=myid; PWD=mypwd;" from connect_string, I'm prompted to
select a dsn. If I make a selection, I'm prompted for userid/password,
supply same, and all works.
I've tried numerous drivers, none work. Is something wrong with the syntax
of my connect_string? Other suggestions?
(Access 2000 gives me the same results) per a dsn-less connection against an
Oracle 9.2.0.4 database residing on a unix server.
I keep getting an eror window: "ODBC -- call failed"
In that window I click OK and get another window: "[Microsoft][ODBC Driver
Manager] Data source name not found and no default driver specified(#0)"
Here's the value in Query Properties|ODBC Connect Str:
ODBC;connect_string = "Driver={Oracle in Ora920}; Host=hostname; Port=1521;
SID=thesid; UID=myid; PWD=mypwd;"
If I remove "UID=myid; PWD=mypwd;" from connect_string, I'm prompted to
select a dsn. If I make a selection, I'm prompted for userid/password,
supply same, and all works.
I've tried numerous drivers, none work. Is something wrong with the syntax
of my connect_string? Other suggestions?