FreeTDS Development Group

[Stefan Bodewig <bodewig AT bost.de>]

Mark Molenda <mark.molenda AT eds.com> wrote:

> 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: 

<snip/>

> DriverManager.getConnection("jdbc:freetds:goodhostnamehere","sa","password");

should be //goodhostnamehere/database instead of goodhostname if the
server is using the default port and //goodhostnamehere:port/database
otherwise. It is also strongly encouraged to use
jdbc:freetds:sqlserver as protocol specification, even though this is
the default.

HTH

        Stefan