cancel
Showing results for 
Search instead for 
Did you mean: 

PI 7.31 SP12 upgrade - Connectivity with SQL server 2000

Former Member
0 Kudos

All,

We have upgraded our system from PI 7.11 to PI 7.31 sp12. PI connects to SQL server 2008 and SQL server 2000. As driver 4.0 does not support SQL server 2000, we have deployed driver 3.0 as well.

So we have two drivers installed Driver 3.0 for SQL server 2000 (sqljdbc.jar) and Driver 4.0 for SQL servers greater than 2000 (sqljdbc4.jar).

However we are getting error while attemping to connect to SQL server 2000.

Error:

============================================

image removed by Moderator

============================================

Please advice.

Thanks

Message was edited by: Kenny Scott

Accepted Solutions (1)

Accepted Solutions (1)

former_member184720
Active Contributor
0 Kudos

>>>So we have two drivers installed Driver 3.0 for SQL server 2000 (sqljdbc.jar) and Driver 4.0 for SQL servers greater than 2000 (sqljdbc4.jar).


AFAIK - the newer version always overwrite the old class drivers. I mean you can't have two different drivers simultaneously.(i might be wrong..it's just my assumption)


Some work arounds discussed here - Have a look at the below thread if it helps.

Former Member
0 Kudos

Hareesh,

We have had two drivers before the upgrade as well. Only 10% of our scenarios connect to SQL 2000 server and the rest SQL servers are higher than 2000 version.

Also when I try the following connection string:

I get this error:

Former Member
0 Kudos

Resolved.

Used sqljdbc4.jar for SQL servers 2005 onwards.

Though microsoft says JDBC driver 3.0 supports connection with 2000, we were getting errors.

As an alternative we used mssqlserver.jar, msbase.jar and msutils.jar to connect to SQL server 2000 and it works fine.

So we have more than one driver installed on pur PI system.

Thanks.

Answers (1)

Answers (1)

baskar_gopalakrishnan2
Active Contributor
0 Kudos

>However we are getting error while attemping to connect to SQL server 2000.

Jdbc driver requires jvm (java virtual machine).  You cannot have two jvms for each drivers version in PI side . I would say you can only have sqljdbc4 jar for your PI Version and uninstall the lower version and test it again.