I've had very good success with i-net software's OPTA driver.
...Mike
----- Original Message -----
From: "Frank W. Hill" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 12:30 PM
Subject: Looking for good JDBC-ODBC Drivers
> Hello all,
>
> I am working on an application that will have around 100 to 125 concurrent
> web based connections to MS SQL Server 7.0. The java servlet/html form
> application will allow data entry and edits to the database from remote
> sites while the corporate staff will access it via an MS Access front end
> (to be developed by my clients internal staff).
>
> I have been developing against an Access 97 database as the selection of
SQL
> Server 7.0 was just made. When I try the following:
>
> String SQLString = "SELECT INTO mytable (Field1, Field2, Field3, Field4)
> VALUES (?, ?, ?, ?);
> PreparedStatement ps = dbConnection.prepareStatement(SQLString);
> ps.setString(1, stringVariable);
> ps.setDate(2, java.sql.DateVariable);
> ps.setTime(3, java.sql.TimeVariable);
> ps.setDouble(4, doubleVariable);
> int NumberOfRecordsInserted = ps.executeUpdate();
> ps.close();
>
> the freebie JDBC-ODBC Bridge from Sun crashes javaw.exe on my server (JRun
> 2.3.3 an JRun 3.0). Anyway, I believe that is what is happening after
> checking the web for clues. The stdout.log tells me that I have a syntax
> error in the query, but I just don't see it. I have run similar, though
> less complex, queries without error. Those applications did not maintain
a
> connection pool and were limited to one user at a time.
>
> So, I downloaded aveConnect from Atinav and after installing it, my server
> has become so unstable that I have elected to wipe it and start over. I
may
> have made an error installing it, so if you folks tell me that aveConnect
is
> the greatest thing since slice bread, I'm willing to give it another go.
>
> Now, after that long diatribe, what I'd like help with is the selection of
a
> "GOOD" and "AFFORDABLE" JDBC driver for MS SQL Server 7.0 and, optionally,
> for MS Access 97/2000 also. A point in the right direction to get clear
> installation and configuration help would also be appreciated.
>
> Thanks in advance.
> Frank Hill
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
