Connect MII 12.0 to SQL server 2008

[Former Member]

Does anybody have a link to the thread about connecting MII 12.0 to sql server 2008? I can't seem to find the right combination of search terms to dig it up.I remember there were some driver version issues / overlapping class name. I found some documentation about upgrading netweaver to run on 2008 but we do not want to do that if possible. I am still looking but haven't found a relevant note yet if there is one

Regards,

Christian

[salvatore_castro · Accepted solution]

Christian,

I don't remember any issues but the driver is sqljdbc.jar and here's the data server summary:

DatePrefix '

DateSuffix '

DaysRetention 7

InternalDateFormat yyyy-MM-dd HH:mm:ss

JDBCDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

MaxRetryCount 5

PoolMax 10

PoolSize 1

RetryInterval 60000

ServerURL jdbc:sqlserver://<server>:<port>;databaseName=xMIIDemo

Timeout 20

UseCount 256

ValidationQuery SELECT GETDATE()

WaitTime 30

Hope this helps,

Sam

[salvatore_castro]

Christian,

I stand corrected....

[|]

Regards,

Sam

[Former Member]

The solution is that you have to use version 1.2 of the JDBC driver which can be downloaded here:

[Microsoft SQL Server 2005 JDBC Driver 1.2|http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=c47053eb-3b64-4794-950d-81e1ec91c1ba&displayLang=en]

2.0 will give a java version error.

I don't think there should be any issues in 12.1+ because the java version is 1.6+

Thanks for the help Sam.

Regards,

Christian