Maybe I wasn't clear enough, but I ment the free driver from freetds.org.
That one I had some problems with to get to work, later I figured out that
it had to do with the URL I sent...
You had to specify the db-name when connecting, it was not enough to log in
and then get redirected to the database ( as with
com.jnetdirect.jsql.JSQLDriver ).
My next questions on this subject are of course:
Has anyone tested this driver? And what were the results of those tests?
I'm currently not developing a J2EE app, so I don't need ejb or entity
beans, and therefore I haven't tested that.
Johan
----- Original Message -----
From: "Hani Suleiman" <[EMAIL PROTECTED]>
To: "Orion-Interest" <[EMAIL PROTECTED]>
Sent: Thursday, April 26, 2001 6:23 PM
Subject: Re: freetds.org
> Yes, I have the driver from www.inetsoftware.de working flawlessly. Just
> stay away from the jdbc-odbc driver and you should be fine.
>
> Hani
>
> On Thu, 26 Apr 2001, Johan Fredriksson wrote:
>
> > 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
> >
> >
> >
>
