I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on the client machine.
It does not connect to the database from the client machine and displays the error "SORRY CANNOT CONNECT TO DATABASE", "COULD NOT INITIALISE JAVA VM!"
My db connectivity code in the application open event is as follows:
SQLCA.DBMS = "JDBC"
SQLCA.LogPass = "db2"
SQLCA.LogId = "db2"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Driver='com.ibm.db2.jcc.DB2Driver',URL='jdbc:db2://IP ADDRESS OF SERVer ,DBGetTime=1,DisableBind=1"
connect using SQLCA;
December 12, 2012 11:19 AM
December 13, 2012 6:12 AM