You might want to try the MS drivers even though they claim not to support SQL7. I've had a system installed for about a year using the MS drivers on SQL7 with no problems, although the application and queries are pretty simple.
Greg Trasuk, President StratusCom Manufacturing Systems Inc. - We use information technology to solve business problems on your plant floor. http://stratuscom.ca >-----Original Message----- >From: Jeffrey Polaski [mailto:[EMAIL PROTECTED]] >Sent: August 28, 2002 17:06 >To: 'Tomcat Users List' >Subject: Open source ODBC driver for SQL Server 7 > > >I've searched the group, but I was unable to find anything >relevant to SQL >Server 7 and free/open source JDBBC drivers. So, can anyone recommend a >decent open source JDBC driver for use with MS SQL Server 7? >I'd like a type >3 or 4 driver (as a JDBC-ODBC bridge doesn't seem to be too >stable). I'd >consider connection pooling with a JDBC-ODBC bridge if it's >stable and not >too slow. > >We can pay for drivers if we have to, but our budget is pretty >slim this >year so I'm trying to do this on the cheap, if possible. We're running >Tomcat 4.04 on NT. Eventually we'll upgrade to SQL Server 200 >and I can use >the MS drivers, but that's will have to wait about a year or >so. For now I >just need a basic, stable driver to connect to SQL Server 7. > >Thanks in advance for your help, > > > Jeff Polaski > Webmaster > Research & Graduate Studies > University California, Irvine > > >-----Original Message----- >From: Larry Meadors [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, August 20, 2002 5:37 AM >To: [EMAIL PROTECTED] >Subject: Re: Tomcat Crashes > > >It is the JDBC-ODBC stuff. Unless there is NO OTHER POSSIBLE WAY to >connect to your database, do not ever use the JDBC-ODBC bridge >except to >convert your data to another format. > >It looks from the error that you are using M$ SQL Server. M$ has jdbc >drivers for SQL2000, but not for earlier versions - there are open >source ones though. > >If you are not constrained to use SQL Server, get MySQL (it is >free) and >convert your data. M$ products (in general) are not very >"java-friendly". > >Larry > >>>> [EMAIL PROTECTED] 08/20/02 06:26 AM >>> >Hi > >I am currently running Tomcat 4.0.4 Server on a >Windows 2000 Server (v5.0.2195) with MS SQL >Server 2000 (v8.00.194) and J2SDK 1.4.0. I am also >using JDBC-ODBC bridge to access the database. After >conducting a few tests on my application, I notice >that sometimes Tomcat crashes. When I check the >server, the Tomcat console is missing. I receive the >following log file as shown belo > >Can anyone help me with this problem > >Thanks >Kingston Sew > >An unexpected exception has been detected in native >code outside the VM. >Unexpected Signal : EXCEPTION_ACCESS_VIOLATION >occurred at PC=0x41166ABA >Function=SQLGetData+0x15 >Library=C:\WINNT\System32\SQLSRV32.dll > > > >-- >To unsubscribe, e-mail: ><mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: ><mailto:[EMAIL PROTECTED]> > >-- >To unsubscribe, e-mail: ><mailto:tomcat-user->[EMAIL PROTECTED]> >For >additional commands, >e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
