I want to connect to CLoud db using powerbuilder.
I am using transaction object .dbms = “odbc” for connection.
If I create DSN then its working fine.
But I want to connect to Cloud database without DSN Creation.
Can you please let me know what will be the connection string and transaction object’s property I will have to set so I can connect to multiple database on cloud?
Here is my sample code
db_para = “126.96.36.199.100:2638;dbn=sample_db;uid=dba;pwd=sql”
//Set Database connection parameters
tr_sqlca.DBMS = “odbc”
tr_sqlca.AutoCommit = False
tr_sqlca.DBPARM = db_para
connect using tr_sqlca;
I am getting dialogbox to select DSN.
If I use SYC as dbms then getting message like “error loading client library DLLs. “
I can connect to cloud database using command prompt but not through powerbuilder.