Quote:
> I'm trying to attach to an Oracle 7.0 server with the VB standard
>edition. I've got the CONNECT property set to "ODBC;DSN=xxxxx" and I'm
>prompted for a username and password...but when I enter them I get the
>following error:
> "ODBC--call failed [Microsoft][ODBC.DLL] Driver's SQLSetConnectOption
> failed[Oracle][ODBC Oracle Driver]Driver not capable.
>[Oracle][ODBC Oracle
> Driver][Oracle OCI[Error while trying to retrieve text for ORA-09301.
> (#9301)"
>Any suggestions would be greatly appreciated.
9301 is a generic connection error message use by older Oracle client libs
when a connection fails. It literally says that you've tried to connect to
the local Oracle DOS database and failed.
What it really means is that you tried to connect to the RDBMS with bad
connect information or missing SQLNET, the client libs then tried a default
connection to the local DOS database and failed.
So, I'm trying to say your connect string is bad or your sqlnet is missing
or improperly configured.
Quote: