Skip to Content
avatar image
Former Member

How to connect to cloud database using powerbuilder?

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 15, 2015 at 05:41 PM

    You might get better response if you post this over in the PowerBuilder Developer Center.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 15, 2015 at 07:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded