You'll need the JDBC-ODBC bridge. It's not pretty...if you're doing anything serious, don't use it. Switch to PostgreSQL or MySQL or SQL Server instead. If you are using SQL Server, you can get a free JDBC Type 4 driver from Microsoft, but it is SQL Server version dependent, so your mileage may vary.
Yes, you can use regular SQL queries with the bridge. No to prepared statements. John > -----Original Message----- > From: Andoni [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 20, 2002 12:39 PM > To: Tomcat Users List > Subject: Tomcat with Access '97 & IIS > > > Hello, > > I am going to try to get a web app working with Access '97 & > IIS for the > first time. > > Does anyone know where I should start. Presumably using an > ODBC-JDBC bridge > driver?? > > Can I use regular SQL queries on this setup? How about > prepared statements? > > I usually only use Oracle so I'm a bit daunted by the > limitations this one > may pose. > > Thanks for any help. > > Andoni. > > PS: Tomcat is 4.0.4 (version changeable if necessary) > > A. > > > -- > To unsubscribe, e-mail: > <mailto:[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]>
