DevOps, CI/CD and Automation

Last month we were able to connect to our 10.2 database using a DSN-LESS ODBC connection string from dot net. A few things have changed. For one, the Oracle 11G client was installed. I don't know if this is related.

Currently I can create a DSN entry and connect:

{color:#008000}DRIVER={Oracle in Ora102};
DBQ=WQTMC1;
UID=SOME_USER;
PWD=Temp1234!;{color}

TNSNames.ora Entry
{color:#008000}WQTMC1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =WQTMC1-S-7999)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WQTMC1.SHOWCO.COM)
)
){color}

Before I was able to connect like this

{color:#008000}DRIVER={Oracle in Ora102};
SERVER= (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =WQTMC1-S-7999)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = WQTMC1.SHOWCO.COM)
)
);
UID=SOME_USER;
PWD=Temp1234!;{color}

This doesn't work anymore. SERVER doesn't seem to be one of the Oracle ODBC key words. I don't know if the 11g client installation is hosing things up or if I just have not figured out how to do this yet.

I've spent hours looking for this, but have not been able to resolve the issue.

Thanks

Barry