How to define a MSSql Datasource in Server Administrator that has an instance

dev google-group-archive
1

If I have the following, how do I define the Datasource Connection in
Server Admin.

Server: Server1
Database: Database1
Instance: Live

I’ve tried Server1 in the Host/Server field and Database1;instance=Live in
the Database field.

Dale

2

Hi,

select “Other JDBC Driver” and then enter
“com.microsoft.jdbc.sqlserver.SQLServerDriver” in the “Class” field.
Connection String should look
like: jdbc:sqlserver://SERVER\INSTANCE;DATABASENAME=database;sendStringParametersAsUnicode=true;SelectMethod=direct

Hope that helps.
MichaelAm Freitag, 5. Februar 2016 22:31:57 UTC+1 schrieb trivalle...@gmail.com:

If I have the following, how do I define the Datasource Connection in
Server Admin.

Server: Server1
Database: Database1
Instance: Live

I’ve tried Server1 in the Host/Server field and Database1;instance=Live in
the Database field.

Dale

3

Michael,

It worked perfectly.

Thank you,

DaleOn Tuesday, February 9, 2016 at 3:45:51 AM UTC-8, Michael Forell wrote:

Hi,

select “Other JDBC Driver” and then enter
“com.microsoft.jdbc.sqlserver.SQLServerDriver” in the “Class” field.
Connection String should look
like: jdbc:sqlserver://SERVER\INSTANCE;DATABASENAME=database;sendStringParametersAsUnicode=true;SelectMethod=direct

Hope that helps.
Michael

Am Freitag, 5. Februar 2016 22:31:57 UTC+1 schrieb trivalle...@gmail.com:

If I have the following, how do I define the Datasource Connection in
Server Admin.

Server: Server1
Database: Database1
Instance: Live

I’ve tried Server1 in the Host/Server field and Database1;instance=Live
in the Database field.

Dale