[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Opta2000 and SQL Server named instances

Posted on 2006-04-18
5
Medium Priority
?
1,150 Views
Last Modified: 2008-03-04
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.UnknownHostException: <servername>

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.

<servername>\\<named_instance>
<servername>/<named_instance>:1433

We're using Opta2000.jar as jdbc-driver. This is not the latest driver. Any ideas what I could do or try?
0
Comment
Question by:grexx
  • 3
  • 2
5 Comments
 
LVL 11

Expert Comment

by:fargo
ID: 16476935
make a ping to the hostname or the ip address to see if it is reachable
0
 
LVL 1

Author Comment

by:grexx
ID: 16477234
I've made a connection to the database using a udl-test-connection. The connection works. A ping works as well.
0
 
LVL 11

Accepted Solution

by:
fargo earned 2000 total points
ID: 16477357
according to this..your syntax is correct
http://www.cc-group.de/products/jdbc/mssql/manual.asp#Syntax

may be it's a driver issue. May be you should get the latest driver and try.
0
 
LVL 1

Author Comment

by:grexx
ID: 16478668
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!
0
 
LVL 1

Author Comment

by:grexx
ID: 16709790
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.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

826 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question