RDBPROD: Oracle ODBC Driver for Rdb "Test Connection" Errors (Doc ID 1138699.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle ODBC Driver for Rdb - Version 3.0 and later
Generic Windows


Symptoms

You are creating a Data Source Name (DSN) using the ODBC Data Source Administrator and the Oracle ODBC Driver for Rdb. When you click "Test Connection" instead of getting a "Connection successful" dialog box, you get an error dialog box.

1.

FAILED: Service Connection test
rc=-1
SQLState=08S01
[Oracle][ODBC][Rdb] GetHostByName() Call Ret 0 Err#11001 WSAHOST_NOT_FOUND Host not found

This error indicates that the name in Server: has a problem. The name could be misspelled or some other network issue is making it impossible to reach the server by its name.


2.

FAILED: Service Connection test
rc=-1
SQLState=08S01
[Oracle][ODBC][Rdb] Connect Ret -1 Err#10061 WSAECONNREFUSED Connection refused

In this case your connection attempted to contact a machine, but the machine was not listening for an ODBC connection on the port that was reached. There are a couple of potential causes.

a. Wrong server: Server name or TCP/IP address are wrong, but they specify an existing machine.
b. Wrong port: SQL/Services is listening on a non-standard port and Alternate Port Number or Object: is not specified correctly. Or SQL/Services is listening on a standard port, but Alternate Port Number or Object: directs the ODBC driver to a different port.


3.

FAILED: Service Connection test
rc=-1
SQLState=08S01
[Oracle][ODBC][Rdb] Connect Ret -1 Err#10060 WSAETIMEDOUT Operation timed out

This error is caused by using an incorrect or unreachable TCP/IP address in Server:. The TCP/IP address does not exist or is not reachable on your network.


4.

FAILED: Service Connection test
rc=-1
SQLState=08004
[Oracle][ODBC][Rdb] %SQLSRV-E-SVCNOTRUN, The requested service is not running

This error indicates that the name in Service: has a problem. The name could be misspelled or the service requested may not be active on the OpenVMS server.


5.

FAILED: Service Connection test
rc=-1
SQLState=S1000
[Oracle][ODBC][Rdb] %SQLSRV-F-GETACCINF, Oracle SQL/Services authorization failed

This indicates the UserID: or User Name or Password are incorrect. Make sure the user name is spelled correctly and the correct password is provided.


6.

FAILED: Service Connection test
rc=-1
SQLState=S1000
[Oracle][ODBC][Rdb] %RDB-E-NO_PRIV, privilege denied by database facility

While the account information used will allow access to the OpenVMS server, this account does not have privileges to allow it to access the database. Use another UserID: or User Name and the appropriate Password or GRANT the required access inside the database.


7.

FAILED: Service Connection test
rc=-1
SQLState=08004
[Oracle][ODBC][Rdb] %RDB-E-BAD_DB_FORMAT, personnel does not reference a database known to Rdb
-RMD-E-FNF, file not found

The Attach Statement: for a universal service may be incorrect. The root-file-spec or logical name may be spelled wrong, or on the OpenVMS server the logical name may be defined incorrectly.


8.

FAILED: Service Connection test
rc=-1
SQLState=S1000
[Oracle][ODBC][Rdb] %RDB-E-WRONG_ODS, the on-disk structure of the database file is not supported by this version
-RDMS-F-ROOTMAJVER, database format 71.0 is not compatible with software version 72.1

The Attach Statement: for a universal service may be incorrect. The root-file-spec might be referring to an old version of the database. Alternately, the SQL/Services service definition for a database or universal service may have the wrong SQL version: specified.


9.

FAILED: Service Connection test
rc=-1
SQLState=S1000
[Oracle][ODBC][Rdb] %SQL-F-SYNTAX_ERR, Syntax error

The Attach Statement: for a universal service is incorrect. Check the spelling of ATTACH. ATTACH must be spelled out. It cannot be abbreviated. You can also get this error if the single-quotation marks are missing around 'FILENAME root-file-spec' or the first single-quotation mark is missing.


10.

FAILED: Service Connection test
rc=-1
SQLState=S1000
[Oracle][ODBC][Rdb] %SQL-F-DBSPECSYNERR, Syntax error in database specification

Again, the Attach Statement: for a universal service is incorrect. In particular check the spelling of FILENAME. Again, it must be spelled out, one word, and not abbreviated.


11.

FAILED: Service Connection test
rc=-1
SQLState=S1000
[Oracle][ODBC][Rdb] %SQL-F-UNTSTR, Unterminated string found

The Attach Statement: for a universal service is incorrect. This occurs if the second single-quotation mark is missing around 'FILENAME root-file-spec'.


12.

FAILED: Service Connection test
rc=-1
SQLState=08S01
[Oracle][ODBC][Rdb] %SQLSRV-F-EXECSTARTUPERR, Fatal executor process startup error

This error will occur with a database service when there is a problem with the SQL/Services service definition. The service has Min Executors: set to 0 and another error that won't allow the executor to start, e.g., incorrect root file specification in the ATTACH clause or FILENAME is not spelled out.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms