Skip to Content.
Sympa Menu

freetds - RE: jdbc driver

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Molenda, Mark P" <mark.molenda AT eds.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: RE: jdbc driver
  • Date: Thu, 18 Jan 2001 11:48:23 -0500


Thanks for the help, it seems to work and I'll do some more testing. -Mark

-----Original Message-----
From: Thomas Pridham [mailto:TPridham AT CMCTPA.COM]
Sent: Thursday, January 18, 2001 11:23 AM
To: TDS Development Group
Subject: [freetds] RE: jdbc driver


Here is a URL to try...

DriverManager.getConnection("jdbc:freetds:sqlserver://localhost:1433/yourDBn
ame", "sa", "password")

Looks like the problem is with the url...hope this helps.


-----Original Message-----
From: Mark Molenda [mailto:mark.molenda AT eds.com]
Sent: Thursday, January 18, 2001 10:55 AM
To: TDS Development Group
Subject: [freetds] jdbc driver


When I go to run a select on a SQL Server 6.5 I get the following message:

"SQLException: java.sql.SQLException: No suitable driver"


My code is as follows:
try
{
Class.forName("com.internetcds.jdbc.tds.Driver");
}catch(Exception ex)
{
System.out.println("Can't find Database driver class: " + ex);
return;
}
try
{
String query2 = "select last_update from contact" ;
Connection con2 =
DriverManager.getConnection("jdbc:freetds:goodhostnamehere","sa","password")
;



Statement stmt2 = con2.createStatement();
ResultSet rs2 = stmt2.executeQuery(query2);

etc...etc...

Does anyone out there have a fix for this?

---
You are currently subscribed to freetds as: [tpridham AT cmctpa.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')

---
You are currently subscribed to freetds as: [mark.molenda AT eds.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')




Archive powered by MHonArc 2.6.24.

Top of Page