https://community.blueprism.com/t5/Digital-Exchange/Getting-Access-denied-error-while-trying-to-connect-in-Data/m-p/49150#M30 Hello Vijaya,&nbsp;<BR /><BR />I am including our link to making a connection to an Oracle DB from Blue Prism. This connection string must be built in a specific format and typically the root cause of this type of error, I just want you to verify you are building the string using the parameters as described in this article. <BR /> <UL> <LI><A href="http://portal.blueprism.com/customer-support/support-center#/path/1161201422" target="test_blank">http://portal.blueprism.com/customer-support/support-center#/path/1161201422</A></LI> </UL> This article mentioned having an issue despite being able to connect with ODBC. The solution for them was to try using he server/sdi vs the name in the tnsnames.ora file. <BR /> <UL> <LI><A href="https://social.msdn.microsoft.com/Forums/vstudio/en-US/452f4eb5-f86e-4c02-8826-69b01f3e6bb5/ora12154-tnscould-not-resovle-the-connect-identifier-specified?forum=vssetup" target="test_blank">https://social.msdn.microsoft.com/Forums/vstudio/en-US/452f4eb5-f86e-4c02-8826-69b01f3e6bb5/ora12154-tnscould-not-resovle-the-connect-identifier-specified?forum=vssetup</A></LI> </UL> This article mentioned a lot of items to check. One of the last comments was around ensuring that the TNS_ADMIN variable exists for both the user and the system variables, it resolved the issue for this user in the article<BR /> <UL> <LI><A href="https://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error" target="test_blank">https://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error</A></LI> </UL> This article did a great job explaining other things to investigate, and breaking down the possible causes of the error as well as items to check. <BR /> <UL> <LI><A href="https://www.tekstream.com/oracle-error-messages/ora-12154-tns-could-not-resolve-service-name/" target="test_blank">https://www.tekstream.com/oracle-error-messages/ora-12154-tns-could-not-resolve-service-name/</A></LI> </UL> <BR />Hopefully one of these articles help your case. Please let me know if you continue to have issues.<BR /><BR />------------------------------<BR />Regards, <BR /><BR />David Flores<BR />Sr. Product Consultant<BR />blue prism<BR />------------------------------<BR /> Tue, 23 Jul 2019 05:08:00 GMT david.flores 2019-07-23T05:08:00Z https://community.blueprism.com/t5/Digital-Exchange/Getting-Access-denied-error-while-trying-to-connect-in-Data/m-p/49149#M29 Hi,<BR /><BR />I am trying to connect to Oracle DB using Data - OLEDB VBO and getting Access Denied error. The error does not have detailed description of the error like access denied to what, OLEDB or ORACLE DB. <BR />I am able to connect to Oracle DB successfully using ODBC in my windows box, but not through Blue Prism.<BR /><BR /><span class="lia-inline-image-display-wrapper" image-alt="5765.png"><img src="https://community.blueprism.com/t5/image/serverpage/image-id/5947i595FD9294E0013FB/image-size/large?v=v2&amp;px=999" role="button" title="5765.png" alt="5765.png" /></span><BR /><BR />------------------------------<BR />Vijaya Bhaskar V<BR />Lead<BR />IBM<BR />Europe/London<BR />------------------------------<BR /> Wed, 26 Jun 2019 12:25:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Getting-Access-denied-error-while-trying-to-connect-in-Data/m-p/49149#M29 Vijaya_BhaskarV 2019-06-26T12:25:00Z https://community.blueprism.com/t5/Digital-Exchange/Getting-Access-denied-error-while-trying-to-connect-in-Data/m-p/49150#M30 Hello Vijaya,&nbsp;<BR /><BR />I am including our link to making a connection to an Oracle DB from Blue Prism. This connection string must be built in a specific format and typically the root cause of this type of error, I just want you to verify you are building the string using the parameters as described in this article. <BR /> <UL> <LI><A href="http://portal.blueprism.com/customer-support/support-center#/path/1161201422" target="test_blank">http://portal.blueprism.com/customer-support/support-center#/path/1161201422</A></LI> </UL> This article mentioned having an issue despite being able to connect with ODBC. The solution for them was to try using he server/sdi vs the name in the tnsnames.ora file. <BR /> <UL> <LI><A href="https://social.msdn.microsoft.com/Forums/vstudio/en-US/452f4eb5-f86e-4c02-8826-69b01f3e6bb5/ora12154-tnscould-not-resovle-the-connect-identifier-specified?forum=vssetup" target="test_blank">https://social.msdn.microsoft.com/Forums/vstudio/en-US/452f4eb5-f86e-4c02-8826-69b01f3e6bb5/ora12154-tnscould-not-resovle-the-connect-identifier-specified?forum=vssetup</A></LI> </UL> This article mentioned a lot of items to check. One of the last comments was around ensuring that the TNS_ADMIN variable exists for both the user and the system variables, it resolved the issue for this user in the article<BR /> <UL> <LI><A href="https://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error" target="test_blank">https://stackoverflow.com/questions/206055/oracle-ora-12154-tns-could-not-resolve-service-name-error</A></LI> </UL> This article did a great job explaining other things to investigate, and breaking down the possible causes of the error as well as items to check. <BR /> <UL> <LI><A href="https://www.tekstream.com/oracle-error-messages/ora-12154-tns-could-not-resolve-service-name/" target="test_blank">https://www.tekstream.com/oracle-error-messages/ora-12154-tns-could-not-resolve-service-name/</A></LI> </UL> <BR />Hopefully one of these articles help your case. Please let me know if you continue to have issues.<BR /><BR />------------------------------<BR />Regards, <BR /><BR />David Flores<BR />Sr. Product Consultant<BR />blue prism<BR />------------------------------<BR /> Tue, 23 Jul 2019 05:08:00 GMT https://community.blueprism.com/t5/Digital-Exchange/Getting-Access-denied-error-while-trying-to-connect-in-Data/m-p/49150#M30 david.flores 2019-07-23T05:08:00Z