Error in connection string of Oracle manageddata access

Help Activities
, , ,
1

Could you please tell me how to correct the connection string in Oracle.manageddataaccess.Client “PERSIST SECURITY INFO=True;DATA SOURCE=”(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = abd001.tlm.net)(PORT = 1532)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = WTST.tlm.net)))“;PASSWORD=”+str_password+“;USER ID=”+str_user.it shows bc30198:‘)’ expected.Could you please correct it?

2

The correct connection string will be automatically generated after you tested successfully your connection using the Connection wizard for the Oracle.manageddataaccess.Client.

3

but i can’t use variable.I have to enter the password directly in connection string.when I use variable it shows error in db connection activity

4

It appears that there is a syntax error in the connection string, likely caused by a mismatch in the quotes used. To fix this, try changing the double quotes to single quotes and use double quotes for string concatenation.

Here’s the modified connection string:

"PERSIST SECURITY INFO=True;DATA SOURCE=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = abd001.tlm.net)(PORT = 1532)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = WTST.tlm.net)));PASSWORD=" + str_password + ";USER ID=" + str_user

Please note that I removed the double quotes around the connection string and updated it with proper syntax.

Also check this article ')' expected - Visual Basic | Microsoft Learn

5

Thanks for help

1 Like
6

Can I use securestring in it? i mean can I used the password which is stored in orchestrator?

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.