Skip to Content
0
Former Member
Mar 29, 2010 at 04:28 AM

SQL 2008 Express connection to 11.5

28 Views

Is it even possible to make this connection with 2008? My connection summary is below. Do I need to do a driver update or do I have something incorrect in my data server connector?

Name Value

Connector IDBC

ConnectorType SQL

DatePrefix '

DateSuffix '

Description MSSQL Database

Enabled true

InitCommand

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

Name sandbox

PoolMax 100

PoolSize 1

ServerPackage com.lighthammer.Illuminator.connectors.IDBC

ServerURL jdbc:sqlserver://MII\SQLEXPRESS:1433;database=sandbox

Timeout 30

UseCount 256

UserName sa

ValidationQuery SELECT GETDATE()

WaitTime 30