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;
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!