Jon,
With JSP, simply use JDBC and JDBC drivers to establish database connections
and access data. Use connection pooling to manage the usage of your
connections. More information is available in the appropriate JDBC
discussion groups or from the javasoft website.
I am not sure if their is a JDBC driver for accessing SQL Server 7. It
wouldn't surprise me if there wasn't.
Dan
> ----------
> From: J�n Dal Kristbj�rnsson[SMTP:[EMAIL PROTECTED]]
> Reply To: J�n Dal Kristbj�rnsson
> Sent: Tuesday, November 02, 1999 9:56 AM
> To: [EMAIL PROTECTED]
> Subject: Database connections
>
> Hello everyone.
>
> I've been using ASP for quite a while now and I've been handling all
> database connections by connection strings, instead of going through a
> System DSN. I haven't learned much about JDBC yet and I'm curious to know
> what the fastest way is, in JSP, to create a database connection. I'm sure
> there are several ways to do that, but I need to do it in a manner which
> won't be much load on the webserver if hundreds, or even thousands of
> people
> are viewing my pages daily. Can anyone give me an idea of what to look for
> and where? Or better yet, does anyone have an actual source code example?
>
> Also, I'm running Microsoft's IIS server v4.0 and SQL server v7.0. Where
> can
> I find the drivers I need for JSP to make the fastest database connection?
>
> Thank you for your help.
>
> Jon Dal Kristbjornsson
> [EMAIL PROTECTED]
>
> ==========================================================================
> =
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
