DevOps, CI/CD and Automation

Please help, I don't know what else to try.

I'm writing automated test scripts and frequently need to access the database to verify data values. These scripts run under multiple environments and have to validate several different flavors of database products. I use ODBC to establish the database connection and this works well under everything except the following environment:

Database Host:
Windows Server 2008, Standard Edition
Oracle 10g

Client:
Windows Server 2008 Standard (64-bit)
Oracle 11g client software installed.

Following recommendations here on the Oracle site, I used the OUI to remove the Oracle ODBC driver that is installed with the client software and installed RDBODBC3320_x64.msi.

I was unable to connect to the database at all using the Oracle 10g client software under this environment, but it is my understanding that Oracle 11g should work. I don't have much choice. The Oracle 10g client refused to install in this environment.

I am able to create a DSN for the database using the ODBC Data Source Administrator. I specify the configuration correctly, but when I try to test the connection, it returns the error:

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

I interpret this to mean that I'm reaching the server and database, but it isn't recognizing the connection as being from a legitimate account. Am I wrong?

From this client machine, I am able to connect to and query the database using SQLPlus, so it isn't that the database is unavailable from the test machine.

On the host server, I am able to create an ODBC configuration that tests successfully. That is, of course, the 10g version of the ODBC driver.

I hope someone can supply an answer, this is a high visibility item that is making me look foolish.

Thanks,

Dave P.