ds.xyz.connection.type = sqlserver

Use this to create a database source which connects to a MS Sql Server type of database.

 

Class

Database

Property

ds.xyz.connection.type = sqlserver

Formal specification

ds.xyz.connection.type = sqlserver

Required

no

Default

no

Version

1.13

Comment



Example



datasource.names = xyz ds.xyz.connection.type=sqlserver ds.xyz.connection.url=jdbc:jtds:sqlserver://192.168.1.1:1433;databasename=jiradb99  ds.xyz.connection.password=apassword  ds.xyz.connection.username=auserid



Reference

gd.query.ds 
col.xyz.query.ds 
datasource.names 
ds.xyz.connection.type = mysql 
ds.xyz.connection.type = postgres 
ds.xyz.connection.type = oracle