on 01-09-2015 5:19 AM
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 = "111.1.11.1.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.
Bhavesh,
A dsnless connection for Adapter Server Enterprise would be the following. I have not done a test with a cloud connection.
SQLCA.DBMS= "ODBC"
SQLCA.DBParm = "ConnectString='Driver={Adaptive Server Enterprise};app=<mypbappname>;server=<ase_server_ip_address>;port=xxxxx;db=<db_name>;uid=<uid>;pwd=<password>'"
Thanks,
Beverly
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You might get better response if you post this over in the PowerBuilder Developer Center.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.