grexx
asked on
Opta2000 and SQL Server named instances
I'm setting up a webserver connection to a SQL Server 2000 named instance. Normally we set this up without using named instances, just having one instance installed. Using this setup, everything always worked without a problem. Now we have to set this up at a company that only uses named instances. For some reason, we cannot make a connection to the database. We get the error:
java.net.UnknownHostExcept ion: <servername>
The connection string is:
String conn_STRING = "jdbc:inetdae7:<servername >/<named_i nstance>?d atabase=te st";
I've tried several things, like using backslashes between servername and instance name, and using a port number or IP-address.
<servername>\\<named_insta nce>
<servername>/<named_instan ce>:1433
We're using Opta2000.jar as jdbc-driver. This is not the latest driver. Any ideas what I could do or try?
java.net.UnknownHostExcept
The connection string is:
String conn_STRING = "jdbc:inetdae7:<servername
I've tried several things, like using backslashes between servername and instance name, and using a port number or IP-address.
<servername>\\<named_insta
<servername>/<named_instan
We're using Opta2000.jar as jdbc-driver. This is not the latest driver. Any ideas what I could do or try?
make a ping to the hostname or the ip address to see if it is reachable
ASKER
I've made a connection to the database using a udl-test-connection. The connection works. A ping works as well.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've installed JTDS, and that seems to work. We have to test it a bit more, but it seems to do everything we need. And it's free!
ASKER
I mailed to the support desk of Opta2000, and they mailed me a new version of the driver. I didn't use it in the end because I already solved it using jTDS, but I suppose that would have worked as well.