Comment 0 for bug 745414

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?