SQL server compatibily with XI 3.0

[Former Member]

Hi ,

I've a query regarding SQL server compatibility

1. Is SQL server 2000 (Version 8.00.760) is compatible with XI 3.0.

Can it directly be accessed using the JDBC Adapter?

If it can not be accessed directly, what needs to be done to access the above server with XI 3.0?

2. Can I directly access MS SQL Server Express 2005 using JDBC Adapter fron XI 3.0?

[Former Member · Accepted solution]

Hi,

You can access the SQL server 2000 (Version 8.00.760) or MS SQL Server Express 2005 using JDBC Adapter fron XI, just Ensure you get the appropriate JDBC drivers for SQL 2K5 and deploy them.

The deployment of drivers is based on Java Stack so..you can have compatibility to connect with these latest versions of SQL Servers, based on availability of related JDBC drivers.

Thanks

Swarup

[Former Member · Accepted solution]

Hi Swarup,

From where to get the JDBC drivers and what are the default JDBC drivers along with XI 3.0

[Former Member · Accepted solution]

HI,

You can try installing the driver from the MS downloads website:

http://www.microsoft.com/downloads/details.aspx?familyid=07287b11-0502-461a-b138-2aa54bfdc03a&displa...

also refer

How To Install and Configure External Drivers for JDBC & JMS Adapters

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/unkown/how%20to%20...

Thanks

Swarup

[Former Member]

Hi manas,

Default drivers and connections for SQL server

driver class name : com.microsoft.jdbc.sqlserver.SQLServerDriver

connection url : jdbc:microsoft:sqlServer://IPaddress;databaseName=demo;

jdbc:microsoft:sqlServer://192.168.0.3:1433;databaseName=Northwind;