JDBC is not connectinf when SQL instance name contains "\"

[thelordoftherings]

Hello,

I am using Datadirect driver in order to connect to our SQL Server. When connecting to standard addresses everything is working OK. SQL Server enables to create an instance on this address as well: <server1>\<INSTANCE> (In my case <INSTANCE> = SAP).
The problem is that when I open a connection with this connection String:
jdbc:datadirect:sqlserver://<server1>\SAP:7660

I receive an error:
java.sql.SQLException: [DataDirect][SQLServer JDBC Driver][DataDirect][SQLServer JDBC Driver]The requested instance is either invalid or not running.

But the instance is up an running. Any idea why?

 

[sedj]

Have you tried :

jdbc:datadirect:sqlserver://<server1>/SAP:7660

or :

jdbc:datadirect:sqlserver://<server1>\\SAP:7660

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[thelordoftherings]

No I haven't but now that you brought it up I tried:

On jdbc:datadirect:sqlserver://<server1>/SAP:7660 I receive the same error as before.

On jdbc:datadirect:sqlserver://<server1>\\SAP:7660 I receive: Error establishing socket. Unknown host...

 

[thelordoftherings]

Sorry the other way around:
On "\\" I receive the same error as before and on "/" I receive an Unknown host.

 

[sedj]

I see that the driver you are using is "paid for" software.

I would contact your vendor and ask for support ...

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[thelordoftherings]

Found the solution: The server name need not be in it's fully qualified name, e.g. this won't work: servername.companyname.com and this is how I configured it.
While it is wotrking when "\" doesn't exist it is not working when "\" exists.