Datasource setting when using jTDS 1.2 with CFMX 7 andSQL2000 (sp4)

[BenMarshall]

I am trying to get the jTDS 1.2 driver working on CFMX 7 and SQL 2000 (SP4).
Here is what I did:

- stopped CFMX service
- copied jTDS-1.2.jar to the c:/cfusionmx7/lib folder
- restarted CFMX service
- Entered the following DS stuff:
URL string: JDBC URL jdbc:jtds:sqlserver://127.0.0.1:1433/PEGASUS;
Driver Class: net.sourceforge.jtds.jdbc.Driver
Driver name: jtds-1.2.jar
user: sa
pasword: *******

And I am getting the following error:

Connection verification failed for data source: pegasus_jTDS
java.sql.SQLException: No suitable driver
The root cause was that: java.sql.SQLException: No suitable
driver[bullet][/bullet]

Can anyone please tell me what I am doing wrong here? Thanks very much for
your help.

[Mountain Lover]

I think your connection string is wrong:
jdbc:sqlserver://localhost:1433;database=PEGASUS
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[PaulH **AdobeCommunityExpert**]

BenMarshall wrote:

> URL string: JDBC URL jdbc:jtds:sqlserver://127.0.0.1:1433/PEGASUS;

jdbc:jtds:sqlserver://SERVERNAME:1433/DATABASE

> Driver Class: net.sourceforge.jtds.jdbc.Driver

net.sourceforge.jtds.jdbc.Driver

> Driver name: jtds-1.2.jar

net.sourceforge.jtds.jdbc.Driver

> Can anyone please tell me what I am doing wrong here? Thanks very much for
> your help.

other than the trailing ";" on the url & the driver name (which i think doesn't
matter) can't really see anything wrong. try removing the trailing ";". and are
you sure you stopped & restarted the cfserver service?

[BenMarshall]

This is the error I am now getting:

Connection verification failed for data source: pegasus_jTDS
java.sql.SQLException: Network error IOException: Connection refused: connect
The root cause was that: java.sql.SQLException: Network error IOException:
Connection refused: connect

Here are my current settings:

URL string: jdbc:jtds:sqlserver://AMD-Server1:1433/ablecommerce_PEGASUS
Driver class: net.sourceforge.jtds.jdbc.Driver
Driver name: jtds-1.2.jar

What oin earth am I doing wrong here. I have disabled firewall and anti-virus,
but I still get this error. Any help would be greatly appreciated. Thanks.

[PaulH **AdobeCommunityExpert**]

BenMarshall wrote:

> URL string: jdbc:jtds:sqlserver://AMD-Server1:1433/ablecommerce_PEGASUS
> Driver class: net.sourceforge.jtds.jdbc.Driver
> Driver name: jtds-1.2.jar

[url]http://jtds.sourceforge.net/faq.html#connectionRefused[/url]

can you reach AMD-Server1 from the cf box?

[BenMarshall]

*** IMPORTANT UPDATE ***

Solved my problem. Apparently, the problem was SQL Server 2000 SP4. The JDBC
drivers do NOT work with SP4. I uninstalled SQL Server 2000, then reinstalled
and applied only SP3a. Everythinng worked fine first time through with SP3a.

I also found THIS on the jTDS site (for those who are still having a problem
with this driver)...


Why do I get java.sql.SQLException: "Network error IOException: Connection
refused: connect" when trying to get a connection?

The "Connection refused" exception is thrown by jTDS when it is unable to
connect to the server. There may be a number of reasons why this could happen:

1. The server name is misspelled or the port number is incorrect.
2. SQL Server is not configured to use TCP/IP. Either enable TCP/IP from
SQL Server's Network Utility app or have jTDS connect via named pipes (see the
URL format for information on how to do this).
3. There is a firewall blocking port 1433 on the server.

To check whether TCP/IP is enabled and the port is not blocked you can use
"telnet <server_host> 1433". Until telnet doesn't connect, jTDS won't either.
If you can't figure out why, ask your network administrator for help.