Skip to Content

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.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Robert Nestor

    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

    (0) 
  2. Sen Hong

    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'”

    (0) 

Leave a Reply