we recently shifted to powerbuilder 12.5 just to check if our application can run cooorectly under its platform (we used PB9.0).
in our application we connect to the database using JDBC driver, and we run the application from an external batch file. however we get the error "powerbuilder JDBC internal error" whenever we want to connect to the database in the code, but sometimes from the db profile we can connect normally..
so how can we connect using jdbc in the code?
asked 03 Apr '12, 03:58
I recently changed two PB12.5 apps from ODBC to JDBC connection. Below are the 2 powerscript code changes that I changed to do this. Let me know if this is helpful.
//SQLCA.DBMS = "ODBC"
SQLCA.DBMS = "JDBC"
//SQLCA.dbparm = "ConnectString='DSN=" + ls_server + ";UID=" + trim(sle_userid.text) + & ";PWD=" + string(ls_dbpassword) + "'"
SQLCA.dbparm = "URL='jdbc:sqlanywhere:DBN=" + ls_server + ";UID=" + trim(sle_userid.text) + ";PWD=" + string(ls_dbpassword) + ";ServerName=test_sqlanywhere12;ASTART=NO;Host=dhhbgbfhsql101:2638',Driver='sybase.jdbc4.sqlanywhere.IDriver'"