• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

JDBC Issue - Migrating from SQL2000 to SQL2005

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Hobbes
New Member Send Private Message
Posts: 3
New Member
8/30/2010 7:17 PM
Hey guys, been trolling these boards for a couple of days trying to find an answer my issue. We currently have process flow setup fine in SQL 2000 database. However we just added SQL 2005 database, and I'm having issues connecting to it. I read the guide in the other topic on this board how SQL2005 drivers does not work... so would sql 2000 drivers be able to connect to 2005?
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
8/30/2010 7:31 PM
Yes, you should use the SQL 2000 drivers.
David Williams
Hobbes
New Member Send Private Message
Posts: 3
New Member
8/30/2010 8:05 PM
Yeah, I'm using the SQL2000 driver/setting that works for 2000

Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver
URL = jdbc:microsoft:sqlserver://dev\sql2005:1433;DatabaseName=TEST

however I'm getting a "SQLException:[Microsoft][SQLServer 2000 Driver JDBC]The requested instance is either invalid or not running" whenever I change out the server/database name? Am I missing a step or something?
Marc Burnes
Basic Member Send Private Message
Posts: 14
Basic Member
8/31/2010 5:28 PM
Just a thought, does the database need to setup in 2000 compatibility mode? We had that issue with another product.
Hobbes
New Member Send Private Message
Posts: 3
New Member
8/31/2010 5:44 PM
I actually just figured out the issue. Apparently if you go to SQL Server Config Manager and take a look at the TCP/IP properties, I noticed I had 3 IP addresses listed. So instead of using Server name in the URL, just enter the IP address associated with 1433 and voila, process flow works again. Hopefully this will work for those of you that have similar issues as me. Thanks all for assistance!!