https://community.blueprism.com/t5/Product-Forum/odbc-connection-to-oracle/m-p/71106#M23711 Hi,<BR />Anyone out there successfully able to create a validation list with an odbc connection into an oracle database?<BR /><BR />I've installed the odbc drivers and can successfully connect to an oracle db via sqlplus.<BR /><BR />But I'm getting an error when attempting to connect via decipher.<BR /><BR />My connection string:<BR />Driver={Oracle in instantclient_19_9};Server=servername.sanmina-sci.com:1531;Database=osp1;Uid=username;Password=password;<BR /><BR />Error message<BR /><SPAN>Could not connect: Unable to validate the connection string. Reason: ERROR [HY000] [Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error</SPAN><BR /><BR />What would the correct connection string be? Or is there some setup step I missed?<BR /><BR />thanks<BR /><BR />------------------------------<BR />Allan Nicolas<BR />Enterprise Wide Application Manager<BR />Sanmina<BR />America/Vancouver<BR />------------------------------<BR /> Mon, 07 Dec 2020 20:48:00 GMT anicolas 2020-12-07T20:48:00Z https://community.blueprism.com/t5/Product-Forum/odbc-connection-to-oracle/m-p/71106#M23711 Hi,<BR />Anyone out there successfully able to create a validation list with an odbc connection into an oracle database?<BR /><BR />I've installed the odbc drivers and can successfully connect to an oracle db via sqlplus.<BR /><BR />But I'm getting an error when attempting to connect via decipher.<BR /><BR />My connection string:<BR />Driver={Oracle in instantclient_19_9};Server=servername.sanmina-sci.com:1531;Database=osp1;Uid=username;Password=password;<BR /><BR />Error message<BR /><SPAN>Could not connect: Unable to validate the connection string. Reason: ERROR [HY000] [Oracle][ODBC][Ora]ORA-12560: TNS:protocol adapter error</SPAN><BR /><BR />What would the correct connection string be? Or is there some setup step I missed?<BR /><BR />thanks<BR /><BR />------------------------------<BR />Allan Nicolas<BR />Enterprise Wide Application Manager<BR />Sanmina<BR />America/Vancouver<BR />------------------------------<BR /> Mon, 07 Dec 2020 20:48:00 GMT https://community.blueprism.com/t5/Product-Forum/odbc-connection-to-oracle/m-p/71106#M23711 anicolas 2020-12-07T20:48:00Z https://community.blueprism.com/t5/Product-Forum/odbc-connection-to-oracle/m-p/71107#M23712 Please take a look at the following articles for an Oracle connection and BP. (you need to use 32bits oracle drivers)<BR /><BR /><BR /><A href="https://portal.blueprism.com/customer-support/support-center#/path/Installation-Platform/Configuration/Connections/1161201422/How-do-I-configure-the-OLEDB-VBO-to-connect-to-an-Oracle-database.htm" target="test_blank">https://portal.blueprism.com/customer-support/support-center#/path/Installation-Platform/Configuration/Connections/1161201422/How-do-I-configure-the-OLEDB-VBO-to-connect-to-an-Oracle-database.htm</A><BR /><BR /><A href="https://portal.blueprism.com/customer-support/support-center#/path/Automation-Design/Application-Integration/Oracle/1141623872/How-do-I-create-an-Oracle-OLEDB-connection-to-work-with-Blue-Prism.htm" target="test_blank">https://portal.blueprism.com/customer-support/support-center#/path/Automation-Design/Application-Integration/Oracle/1141623872/How-do-I-create-an-Oracle-OLEDB-connection-to-work-with-Blue-Prism.htm</A><BR /><BR />------------------------------<BR />Luis Lopez<BR />Customer Support Engineer English and Spanish<BR />Blue Prism Ltd<BR />------------------------------<BR /> Tue, 02 Feb 2021 16:56:00 GMT https://community.blueprism.com/t5/Product-Forum/odbc-connection-to-oracle/m-p/71107#M23712 expertcr 2021-02-02T16:56:00Z