Re: freetds.org
Ok, thanks.,.. - Original Message - From: Paul Kofon [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Sent: Thursday, April 26, 2001 5:51 PM Subject: Re: freetds.org Hi, The database driver for MSSQL from freetds.org is, according to the documention, work in progress more or less. I had been looking for a cheap/free driver for MSSQL. When I found it, I thought my search was over. But I wrong, since I just couldn't use it. I kept getting SQLExceptions (which were to be expected according to the documentation because most things are not implemented yet). Finally, I had to stop using it. Currently, I use two drivers and they both work flawlessly for my apps: one from http://www.inetsoftware.de and the other from http://www.j-netdirect.com. Though they cost money. Regards, Paul From: Johan Fredriksson [EMAIL PROTECTED] Reply-To: Orion-Interest [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Subject: freetds.org Date: Thu, 26 Apr 2001 17:36:15 +0200 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Re: freetds.org
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
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
Re: freetds.org
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-sourceclass="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 - From: Johan Fredriksson To: Orion-Interest 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@ff3afe9f) 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-sourceclass="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
Re: freetds.org
Hi, The database driver for MSSQL from freetds.org is, according to the documention, work in progress more or less. I had been looking for a cheap/free driver for MSSQL. When I found it, I thought my search was over. But I wrong, since I just couldn't use it. I kept getting SQLExceptions (which were to be expected according to the documentation because most things are not implemented yet). Finally, I had to stop using it. Currently, I use two drivers and they both work flawlessly for my apps: one from http://www.inetsoftware.de and the other from http://www.j-netdirect.com. Though they cost money. Regards, Paul From: Johan Fredriksson [EMAIL PROTECTED] Reply-To: Orion-Interest [EMAIL PROTECTED] To: Orion-Interest [EMAIL PROTECTED] Subject: freetds.org Date: Thu, 26 Apr 2001 17:36:15 +0200 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
