SQL Server Connectionstring

Asked by Morten Ulrik Pedersen on 2011-03-29

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?

Question information

Language:
English Edit question
Status:
Answered
For:
Gephi Edit question
Assignee:
No assignee Edit question
Last query:
2011-03-29
Last reply:
2011-05-23

I think you are not doing anything wrong. I guess we are doing the JDBC url wrong for this driver. I actually didn't know JDBC urls are not standardized (http://www.petefreitag.com/articles/jdbc_urls/). Thanks for the report, we'll fix this bug asap.

The bug has been fixed, could you please try again?

Can you help with this problem?

Provide an answer of your own, or ask Morten Ulrik Pedersen for more information if necessary.

To post a message you must log in.