I never got any responses on this, but ended up getting it working through
trial and error. Here is what I have found, in case others encounter this
issue:
1) Connecting from NT to a Solaris box: When using the native drivers, set
up a datasource using the client configuration assistant. In this case, I
called the alias W1. Using the "COM.ibm.db2.jdbc.app.DB2Driver" driver, my
connection string was simply "jdbc:db2:w1".
2) Connecting between two Solaris boxes: Again, using the native driver,
make sure that the Java listener is running on the Solaris box hosting the
database, and make sure you know on which port it is running. You can start
it by running the db2jstrt command. In my case, I started the database
using this command: "db2jstrt 6790". Then on my remote JRun server, I used
the "COM.ibm.db2.jdbc.net.DB2Driver" driver and this connection string:
"jdbc:db2://myservername:6790/mser" , where myservername was the server and
mser was the database to which I was connecting.
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
-----Original Message-----
From: Chris Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 5:26 PM
To: JRun-Talk
Subject: JRun DB2 connect string
Hello,
I'm pretty new to JRun and JDBC, and just joined this list. I am trying
to get a JDBC connection to a DB2 database using the native driver supplied
by IBM. I cannot seem to get the correct connect string, though. Does
anybody have this working correctly that can tell me what driver and connect
string you are using?
Chris Evans
[EMAIL PROTECTED]
http://www.fuseware.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
