How would I connect to a non-default instance of MS SQL server? I don’t see any fields in the GUI or database.conf.spec for that. With MS tools or ODBC settings, I’d just specify SERVER\INSTANCE but that doesn’t seem to work with DBX.
At the moment, you can specify the named instance in the database field as:
<instance>/<database>
eg.
someinstance/northwind
or in database.conf:
database = someinstance/northwind
Alternatively you can specify the TCP port the named instance is listening on.
[Thanks to Siegfried for the answer]
In my case when using the DBConnect 2.3.1 and MS Generic driver, I had to edit the JDBC URL format to omit the :<port>
tag, leaving it as:
jdbc:sqlserver://<host>;databaseName=<database>;selectMethod=cursor
You can do this within the connection screen. Then you can specify the Server field as <servername>\<instancename>
, as you normally would for named instances.
Removing the and changing the Host filed to use the typical MSSQL convention is what finally worked for me. Thank you!
Confirm that. If you remove port from JDBC URL. Its working
At the moment, you can specify the named instance in the database field as:
<instance>/<database>
eg.
someinstance/northwind
or in database.conf:
database = someinstance/northwind
Alternatively you can specify the TCP port the named instance is listening on.
[Thanks to Siegfried for the answer]
Thanks for the answer. This should be in the documentation