Tools: pb90
Database: sybase12.5
1, copy C: \ sybase \ jConnect - 5 _5 \ classes \ jconn2 jar to a local directory, JDBC driver
2, pb9.0 operation, open the tools - & gt; System options, select Java page, add in the classpaths just paste jconn2. The full path and name of the jar file, such as: d: \ mypro \ jconn2 jar,
3, restart the pb90, note: after the step 2 set must restart pb to make the Settings to take effect,
Four, open the tools - & gt; The database profiles, select the JDB JDBC, create a JDBC connection,
Fill in com in connection driver name of the page. The sybase. Jdbc2. JDBC. SybDriver,
Put the JDBC url: sybase: Tds: 10000/mydatabase 172.17.193.172:
(127.0.0.1 for your database in the computer's IP address, shall be your database instance name) at the DB1
After 5, fill in the login id and password can connect,
6, according to the need for other Settings,
Below is a link syntax
//Profile jdbcsybase
The SQLCA. DBMS="JDBC"
The SQLCA. LogPass="sa"
The SQLCA. LogId="password"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm="Driver='com. Sybase. Jdbc2. JDBC. SybDriver', URL='JDBC: sybase: Tds: 172.17.193.172:10000/mydatabase'"
Purpose is, when it was released from the sybase database client installation
The question now is, when the development there is no problem, but is released, can not make, how to make when released?
CodePudding user response:
http://wenku.baidu.com/view/7808d611a21614791711283c.html should be okCodePudding user response:
http://wenku.baidu.com/view/7808d611a21614791711283c.html should almostThis I also reference, also with the environment variable, or no
CodePudding user response:
A JDBC connection three methods of SYBASEhttp://blog.csdn.net/yjq8116/article/details/257554