Opta2000 and SQL Server named instances
Posted on 2006-04-18
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:
The connection string is:
String conn_STRING = "jdbc:inetdae7:<servername>/<named_instance>?database=test";
I've tried several things, like using backslashes between servername and instance name, and using a port number or IP-address.
We're using Opta2000.jar as jdbc-driver. This is not the latest driver. Any ideas what I could do or try?