on 08-25-2014 9:23 PM
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
>>>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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
>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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.