Anyone has succeded connecting XI with MSSQL database?

[Former Member]

Hi guys, does anyone know whether adapter driver for MSSQL is a default adapter that has been installed in XI or not? If not, anyone know how to install this to XI? Thank you very much...

[MichalKrawczyk · Accepted solution]

Hi,

then you need to use this connection string:

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member]

Hi

You can connect to SQL server with existing JDBC adapter

However you need to deploy the driver for SQL server just as you deploy for Oracle

some drivers for SQL servers are:-

msbase.jar, mssqlserver.jar, msutil.jar

Follow this How to guide to understand how you deploy the driver

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Bipin