Skip to Content
Former Member
Former Member
January 30, 2015 Less than a 1 minute read

How to connect to cloud database using powerbuilder?

Follow RSS feed
0 Likes 2,261 Views 3 Comments

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.

Assigned tags

Related Blog Posts

    Related Questions

      3 Comments
      You must be Logged on to comment or reply to a post.
      • Former Member

        Hi Bhavesh:

        Passinng in the “DRIVER” argument in the connection
        string – the ASE ODBC driver must still be present on the system.

        “DRIVER=Adaptive Server Enterprise;UID=dba;PWD=sql;ENG=MyEngine;…”

        Can you give it a try and let me know if it works.?

        Cheers…Bob

      • Former Member

        Hi Bhavesh,

        The following connection string succeeds with my local ASE server. Please try it with your cloud ASE server.

        // Profile ase126_odbc

        SQLCA.DBMS = “ODBC”

        SQLCA.AutoCommit = False

        SQLCA.DBParm = “ConnectString=’Driver={Adaptive Server Enterprise};Srvr=PEKN50822184A;Uid=sa;Pwd=XXXXXX'”