Skip to Content.
Sympa Menu

freetds - Can't specify properties in URL when using the JDBC driver.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Tho Ha" <ethoha AT yahoo.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Can't specify properties in URL when using the JDBC driver.
  • Date: Fri, 18 May 2001 13:59:07 -0400


I'm using the freetds_jdbc.jar (1/25/00), and when I try to specify
properties in the URL, i.e.
//
String driver = "com.internetcds.jdbc.tds.Driver";
String server =
"jdbc:freetds:sqlserver://servername/database;CHARSET=UTF-8;TDS=7.0";
Class.forName(driver);
Connection con = DriverManager.getConnection (server, name, password);
//

I get this SQLException: Bad database name- database;CHARSET=UTF-8;TDS=7.0
0 connection are in use by this program

The instructions came from the README. So what am I doing wrong? If I
don't specify the properties, it works, except that it can't retrieve
NTEXT data, which is why I want to use TDS 7.0. Any help is appreciated.
Thanks.




Archive powered by MHonArc 2.6.24.

Top of Page