2011-03-30 02:17:29 |
Mathieu Bastian |
description |
Hi,
I'm trying to use Import Database from a SQL Server 2005 but I get an exception. Input:
Driver: SQL Server
Host: 1.2.3.4
Port: 1433
Database: AdventureWorks
User Name: MyUserName
Password: *****
Looks like the connections string has a bad format.
Exception:
java.lang.RuntimeException: Failed to connect at jdbc:sqlserver://1.2.3.4:1433/AdventureWorks
At http://msdn.microsoft.com/en-us/library/ms378428(v=SQL.90).aspx I can see that the connectionstring properly should look something like this:
jdbc:sqlserver://1.2.3.4:1433;databaseName=AdventureWorks;user=MyUserName;password=*****;
Can anybody see what I'm doing wrong?
|
JDBC urls are not recognized by SQL-Server
Example:
jdbc:sqlserver://1.2.3.4:1433/AdventureWorks
How it should be
jdbc:sqlserver://1.2.3.4:1433;databaseName=AdventureWorks
See
http://msdn.microsoft.com/en-us/library/ms378428(v=SQL.90).aspx
http://www.petefreitag.com/articles/jdbc_urls/ |
|