W2K. Perl. Target: use JDBC connectionin Perl to connect to SQLServer. The Perl part is not yet of relevance here. I installed the JDBC.pm part. What I need to do is 1. Start the server. 2. Connect to the server.
In the pod: Add dbd_jdbc.jar and your database driver to your classpath. (my driver is inetuna 2000: SqlServer 7/2000). Start the server providing at least the required system properties on the command line. A sample bash script is included: export CLASSPATH=dbd_jdbc.jar:/oracle/jdbc/classes111.zip:$CLASSPATH DRIVERS=oracle.jdbc.driver.OracleDriver java -Djdbc.drivers=$DRIVERS -Ddbd.port=9001 -Ddbd.trace=tedious com.vizdom.dbd.jdbc.Server With my adjustments it looks like (on W2K): SET CLASSPATH=e:\temp\dbd_jdbc.jar;e:\iw-home\tools\java1.3\jre\lib\rt.jar;E:\iw-home\DATADEDEPLOY\lib\Una2000.jar; SET DRIVERS=com.inet.tds.TdsDriver e:\iw-home\tools\java1.3\jre\bin\java.exe -classpath $CLASSPATH -Djdbc.drivers=$DRIVERS -Ddbd.port=2345 -Ddbd.trace=tedious com.vizdom.dbd.jdbc.Server However starting the server gives error: Exception in thread "main" java.lang.NoClassDefFoundError: com/vizdom/dbd/jdbc/Server Can anyone point me in the right direction (my java knowledge is minimal). Has anyone succesfull connect in perl to SqlServer? With regards Marcel Somers [EMAIL PROTECTED]
