Skip to Content
0
Former Member
Nov 24, 2009 at 08:08 AM

Cannot connect MS SQL Server2005 by using JDBC(JNDI) connection

33 Views

Hi all,

I met a problem when I was trying to create a JDBC(JNDI) connection in crystal report 2008, the following error dialog shows up, it said:

Database Connector Error: 'SQL Exceptions: [SQL State:] S1000 [Error Message:] [Microsoft][SQL Native Client]Connection is busy with results for another command'

here is the steps how to reproduce this problem:

1) create a DSN(Data source name) in ODBC Data Source Administrator dialog, suppose the DSN is test

(and the DSN test show it works well)

2) start up Crystal Report 2008, click New to create a new report, the Standard Report Creation Wizard show up

3) expand Create New Connection node, then double click JDBC(JNDI) note

4) the JDBC (JNDI) dialog shows up, chooose JDBC Connection in the dialog, and fill the empty fields with:

Connection URL: jdbc:odbc:test

Database Classname:sun.jdbc.odbc.JdbcOdbcDriver

5) click next, it comes to the next pannel, and fill the empty fields with:

Database: MyTestDB

UserID: sa

Password: sa

6) then click Finish buttion.

7) a new connection is created, but when I expand the new created connection, an error dialog shows up

Database Connector Error: 'SQL Exceptions: [SQL State:] S1000 [Error Message:] [Microsoft][SQL Native Client]Connection is busy with results for another command'

does anyone knows what's wrong with my setting? any help would be appreciated.

Best Regards

Tian-liang