Wednesday 9 September 2009

Using Sql Server's Name Instance via JDBC

Very recently i had to use named instance of SQL Server 2000 via JDBC Drivers

After googling i found out the winner in the connection string is "instance=instancename"

Example String
JdbcURL=jdbc:sqlserver://servername:1433;instance=instancename;databaseName=dbname