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
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
    Posts: 1127
    Veteran Member
    8/30/2010 7:31 PM
      Yes, you should use the SQL 2000 drivers.
      David Williams
      Hobbes
      New Member
      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
        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
          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!!