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
