Connecting to a SQL Server instance using jdbc drivers, you need to append ‘;instance=INSTNAME’ to the connection string like the following:
jdbc:jtds:sqlserver://<SQLServer>:<PORT>/<DBName>;instance=<SQLInstanceName>
Example:
jdbc:jtds:sqlserver://localhost:1433/mydb;instance=SQLEXPRESS
No comments:
Post a Comment