[This topic is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
I have version 6.07 and have successfully connected to various SQL servers that we have.
I have a couple of SQL servers that have the instance name in it so with SQL Enterprise Manager it sees the SQL Server as \\SERVERNAME\INSTANCENAME
When in the SQL Connection box where it asks me the server name IF I type in just the server name it does not connect but you need the instance name as well yet when I try it it does'nt work.
Any ideas? Do you understand what I mean? I have attached a screenshot of the ODBC link in Windows to show the \\SERVER\INSTANCENAME
Nick,
In the Connection Properties for your SQL Server connection you find a Driver Properties category. In the list there is an "instanceName" property (for the MS JDBC driver) or "INSTANCE" proeprty for the jTDS driver. Try set the name there.
More information and assistance may be found via Google:
http://www.google.com/search?hl=en&q=jdbc+sql+server+instance+name&btnG=Google+Search
Best Regards
Roger
a
anonymous
said
almost 17 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: SQL Server Connections
That works a treat. Cheers.
a
anonymous
said
about 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: SQL Server Connections
Yesterday I posted connection problem in another thread, but then I found this one. I tried to set the connection property INSTANCE = XXX (where XXX is my instance name). With this I am able to connect perfectly.
Thanks Nick. It is important to note that still the Ping server option is not working, it shows connection error. But I am able to connect to the database.
Thanks again.
anonymous
[Attachment has been removed.]
I have version 6.07 and have successfully connected to various SQL servers that we have.
I have a couple of SQL servers that have the instance name in it so with SQL Enterprise Manager it sees the SQL Server as \\SERVERNAME\INSTANCENAME
When in the SQL Connection box where it asks me the server name IF I type in just the server name it does not connect but you need the instance name as well yet when I try it it does'nt work.
Any ideas? Do you understand what I mean? I have attached a screenshot of the ODBC link in Windows to show the \\SERVER\INSTANCENAME