In Access 97, I have successfully created a DSN-less pass-thru query
to Oracle using the MS ODBC For Oracle driver. I used a connection
string like this:
ODBC;Driver={Mi crosoft ODBC For Oracle}; Server=our_tnsn ame;
UID=my_userid; PWD=my_password
However, our DBAs are concerned about this driver and have insisted we
use the Oracle ODBC Driver [from Oracle] instead.
I've tried a number of formats for the connection string, none of
which work. Here is an example:
ODBC;Driver={Or acle ODBC Driver}; dbq=our_tnsname ; UID=my_userid;
PWD=my_password
The error I get from this is:
Reserved error (-7778); there is no message for this error.
Is there a way to make this work? If so, how?
Thanks,
Bruce