Connecting to MS SQL Server using JDBC Connector

From one of the other forums:

---

Problem: Hi all, I am trying to use IDI as the cutom. agent for TIM to do provisioning to some tables on SQL Server 2000. However, I keep on receiving the error "connection is busy with results for another hstmt". I checked IDI forum and Rabbit hole and some body suggested to append selectMethod=cursor and it doesn't work for me. I am using Directory Integrator 6.0 FP2 running on W2k3. The SQL Server is also running on a W2k3 machine with SP4 installed. Any suggestions are welcomed. Thx!

FYI, attached my AL <test.xml>

---

Solution:

pls try using the JSQLConnect driver instead of the sun JDBCODBCDriver you are using currently. Bkgrnd of this problem: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/MARSinSQL05.asp Apparently, you can't have more than one active resultSets. This error usually crops up in multithreaded programs. btw, I can also assure you that, there are no unwanted resultSet kept open in the JDBCConector code ;).

You will not face this problem if you use the JSQLConnect driver. Download the JSQLConnect driver from the MSDN site and drop it into TDI60_HOME/jars directory.

here's a version of the JSQLConnect driver: The jdbc url should be: jdbc:JSQLConnect:///database=SYSTEMSTORE

Hope this helps.

Karthik.

---

-- YouKnowWho - 02 Dec 2005

• test.xml: Test.xml file

• JSQLConnect.jar: Its better to obtain the latest jar from MSDN