Hi ALL i am trying pass the data to establish connection with the Database i have store all data in different variables like Hostname, UserId , password etc when i tried to run that connect to database activity getting error data is not in correct string format. any help will be great

@mint Check this for new format "PASSWORD=" + password + ";USER ID=" + userid + ";DATA SOURCE=""(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = " + host + ")(PORT = " + port + ")))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = " + servername + ")))""" Hope this helps Cheer…

can you help me to modify this I tried getting error @vinitha_yachamaneni “USER ID=TestDATA;DATA SOURCE=”(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Test)(PORT = 1234)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = minto.com )))“;PASSWORD=Passkey” above is the string b…

@mint Please show the actual connection string without variables Then we can give you astring eith variables in it Cheers

[image] mint: “USER ID=TestDATA;DATA SOURCE=”(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Test)(PORT = 1234)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = minto.com )))“;PASSWORD=Passkey” “USER ID=TestDATA;DATA SOURCE=”(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROT…

@mint As per the data looks like some inverted comma are missing can you check Cheers

@Anil_G “USER ID=Mintoo;DATA SOURCE=”(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Mintoo)(PORT = Mintoo)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = Mintoo)))“;PASSWORD=Mintoo” i just recreted using connect db activity for oracle db

@mint Try this "USER ID="+ userid + ";DATA SOURCE=""(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = "+ host + ")(PORT = "+Port + ")))(CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME ="+ servicename + ")))"":PASSWORD=" + password Cheers

can you try this one USER ID=Mintoo;DATA SOURCE=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Mintoo)(PORT = Mintoo)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = Mintoo));PASSWORD=Mintoo Cheers … @mint

@Anil_G getting ORA-01005 : null passord given logon denied BUT THE SAME password worked when hardcoded

@mint Please check if the variable is assigned with the value Also it would be a good idea to show a screenshot of the actual connection string And the one you used Or try to use a log message and log the connection string with variabes and see if it looks same as teh normal strong without varia…

“PASSWORD=Minto;USER ID=Minto;DATA SOURCE=”(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = Minto)(PORT = Minto)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = Minto)))“” plz help to convert this getting error as not defined @Anil_G the key value pair that has minto will be…

String passed not in correct format

Help Studio

Anil_G (Anil Gorthi) September 30, 2023, 1:54pm 21

@mint

Please check this from one of our very own forum contributors @ppr

Cheers

1 Like

Topic		Replies	Views
SQL Database ConnectionString - use variables for Username, Password, IP address, Port etc Activities database , activities , studio , variable , question , connection	6	4109	April 15, 2022
Error while running the activity "Connect to Database" - Connect to Database: ORA-00351: Network Library: Name-Value premature end of string Studio activities , studio	3	84	October 1, 2025
Database Connect - Oracle Client - String.Format Variables Coming Back Invalid Studio studio , question , activities_panel	2	1245	August 24, 2021
How can I manually connect to Oracle DB using variables Studio studio , question , tools	4	1017	March 27, 2023
How to connect to Oracle Database using string variable coming from context file Studio activities , studio , oracle-database	7	2778	March 1, 2022

String passed not in correct format

Related topics