JDBC files for SQL database

[Former Member]

Hello everyone,

I hv tried many JDBC files for SQL database . But am facing an error like "BAD MAJOR VERSION".  I am not understanding the issue. Please find the

attachment.

i need to get the SQL JDBC Driver (jar file) for  Linux 64 bit to connect to SQL Server 2005 which is compatible with JDK1.4.x.

Please help me in solving this issue..

Thanks and Regards ,

Vijay Vikram.

[baskar_gopalakrishnan2 · Accepted solution]

What is your PI version?

>i need to get the SQL JDBC Driver (jar file) for  Linux 64 bit to connect to SQL Server 2005 which is compatible with JDK1.4.x.

PI 7.1 and above versions will run in 64 bit operating system. That means you need to use jdk 1.5 plus version . That means you need jdbc drivers that run 1.5 version of jvm.  Hope that helps. 

If your version is 7.0 or XI 3.0 then you have to use jdk 1.4. That means you have to look for jdbc drivers that supports jdk 1.4 . Please search on microsoft jdbc download sites where they specify prerequisite for each jdbc driver  version.

[Former Member · Accepted solution]

Hi baskar,

My PI version is 7.0 , do i have to look for a file of LINUX compatible????

Thanks and Regards,

Vijay vikram

[baskar_gopalakrishnan2 · Accepted solution]

JDBC Drivers are fully dependent on JDK version. Since you use PI 7.0, you need to use jdbc drivers that support jdk 1.4 or less. Your Linux OS (64 bit) must be 32 bit compatible.  Again jdbc drivers are based on ms sql db servers. Just because you use PI 7.0, you need to go with jdk 1.4 that supports jdbc drivers and respective database servers.

[Former Member]

Hello!

For MS SQL, please use the "sqldriver12" driver file with a 1.4.2_X JDK version for PI. Also, please ensure that there are no other .JAR driver files within aii_af_jmsproviderlib.sda.

Best wishes,

Lucas Santos