Re: freetds.org

Thu, 26 Apr 2001 14:15:41 -0700

Hi Johan,
 
I don't know if this is much help, but I'm using SQL Server 7 with no problems, however I'm using a JDBC driver called UNA2000.jar by I-net Software ( http://www.inetsoftware.de).
 
Their driver is available cost free for development, but limits you to 1 connection.
 
For what it's worth, here is my datasource XML:
 
<data-source
  class="com.evermind.sql.DriverManagerDataSource"
  name="mssql1"
  location="jdbc/HypersonicCoreDS"
  xa-location="jdbc/xa/HypersonicXADS"
  ejb-location="jdbc/HypersonicDS"
  connection-driver="com.inet.tds.TdsDriver"
  username="sa"
  password="password"
  url="jdbc:inetdae:1.1.1.1?database=db"
  inactivity-timeout="30"
 />
 
James
----- Original Message -----
Sent: Thursday, April 26, 2001 4:36 PM
Subject: freetds.org

Has anyone got their driver to work with ms sql server 7?
 
I just get an error message all the time :
 
java.sql.SQLException: The database driver (com.internetcds.jdbc.tds.Driver@ff3a
fe9f) returned refusing to connect to the URL jdbc:freetds:sqlserver://192.168.1
.123/
        at com.evermind.sql.DriverManagerDataSource.getConnection(Unknown Source
)
 
 
 
Does anyone know what I'm doing wrong?
 
I'll include my datasource.xml also...:
 
 <data-source
  class="com.evermind.sql.DriverManagerDataSource"
  name="MyDataSource"
  location="jdbc/BB"
  xa-location="jdbc/xa/BBXADS"
  ejb-location="jdbc/MyDataSource"
  connection-driver="com.internetcds.jdbc.tds.Driver"
  pooled-location="jdbc/MyPooledDS"
  username="my"
  password="password"
  url="jdbc:freetds:sqlserver://192.168.1.123/"
  max-connect-attempts="3"
  max-connections="1"
  connection-retry-interval="1"
  inactivity-timeout="30"
 
 />
 
 
thanks in advance.
 
 
Johan
 
 

Reply via email to