[jo90way]

When I connect to MSSQL using Visual Studio [Language c#]...I use this connection string :
String JO = "Data Source=PEARL\\JAGA_2;Database=WOLF;user id=sa ;password='starlet';Pooling=False";


When I connect to MSSQL using NETBEANs i use this connection-String :
Class.forName("com.microsoft.sqlserver.jdbc.SQLSer verDriver");
String connectionUrl = "jdbc:sqlserver://localhost:1433;" +
"databaseName=BOOM;user=sa;password='starlet'; ";


Here is the question .
How can NetBeans know which SqlServer instance to access ?
[since I did not specify it in the connection string]
[infact I wrote Data source:=PEARL\\JAGA_2 ONLY in connectionString for Visual Studio...not for NetBeans]



Regards



P.S.
Can anydody translate the connectiion String at the TOP[the one I wrote for Visual Studio] into a valid connection string that I can use in NetBeans ?
Thanks
jo90way is online now Report Post

[davidsalter]

You need to add an instanceName parameter.

e.g.

instanceName=JAGA_2

Full details at: Building the Connection URL