FreeTDS Development Group

["Molenda, Mark P" <mark.molenda AT eds.com>]

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')