THe ideal driver for you would be fastforward so put a search on it and it 
comes with documentation and every thing is free , you will get all your 
answers there.

>From: "Åsa [JSP-list]" <jsplistan@h...>
>Reply-To: "Pro_JavaServer_Pages" <pro_jsp@p...>
>To: "Pro_JavaServer_Pages" <pro_jsp@p...>
>Subject: [pro_jsp] RE: Types?
>Date: Thu, 19 Oct 2000 15:27:58 CEST
>
>As I said: chines...
>How would then a dsnless connection look for a SQL-server? And did it
>require any kind of extra installation?
>
>sorry, but I'm a real newbie.
>
>:) Piglet
>
>
>>From: "J.T. Wenting" <jwenting@h...>
>>Reply-To: "Pro_JavaServer_Pages" <pro_jsp@p...>
>>To: "Pro_JavaServer_Pages" <pro_jsp@p...>
>>Subject: [pro_jsp] RE: Types?
>>Date: Thu, 19 Oct 2000 12:24:07 +0200
>>
>>There are 4 classes/types of JDBC drivers.
>>Type1 is the JDBC/ODBC bridge drivers
>>Type2 and 3 are drivers with native components
>>Type4 is pure java
>>
>> > -----Original Message-----
>> > From: sa [JSP-list] [mailto:jsplistan@h...]
>> > Sent: Thursday, October 19, 2000 12:59
>> > To: Pro_JavaServer_Pages
>> > Subject: [pro_jsp] Types?
>> >
>> >
>> > How I wish this wasn't chines to me, but it is - what is these
>> > types? do I
>> > need to install something on the server to make them work? I use
>> > SQL-server,
>> > which type should I use then?
>> >
>> > :) Piglet
>> >
>> >
>> > >From: "J.T. Wenting" <jwenting@h...>
>> > >Reply-To: "Pro_JavaServer_Pages" <pro_jsp@p...>
>> > >To: "Pro_JavaServer_Pages" <pro_jsp@p...>
>> > >Subject: [pro_jsp] Re: Database connection
>> > >Date: Thu, 19 Oct 2000 10:30:08 +0200
>> > >
>> > >You're not using the type4 driver, but the type3 driver. Type 4 would
>>be
>> > >jdbc:oracle:thin:@<database>:port. Type4 can be a bit slower,
>> > but does not
>> > >need Oracle client installed on the machine using it.
>> > >
>> > >
>> > > > -----Original Message-----
>> > > > From: java corba [mailto:extremejava@h...]
>> > > > Sent: Wednesday, October 18, 2000 23:09
>> > > > To: Pro_JavaServer_Pages
>> > > > Subject: [pro_jsp] Re: Database connection
>> > > >
>> > > >
>> > > > heres the code to connect to database without using dsn i am
>> > using type
>> > >4
>> > > > driver and oracle
>> > > >
>> > > > import java.sql.*;
>> > > >
>> > > > class Employee
>> > > > {
>> > > >   public static void main (String args [])
>> > > >        throws SQLException, ClassNotFoundException
>> > > >   {
>> > > >     // Load the Oracle JDBC driver
>> > > >     Class.forName ("oracle.jdbc.driver.OracleDriver");
>> > > >
>> > > >     // Connect to the database
>> > > >     // You can put a database name after the @ sign in the
>>connection
>> > >URL.
>> > > >     Connection conn 
>> > > >       DriverManager.getConnection ("jdbc:oracle:oci8:@", "scott",
>> > > > "tiger");
>> > > >
>> > > >     // Create a Statement
>> > > >     Statement stmt = conn.createStatement ();
>> > > >
>> > > >     // Select the ENAME column from the EMP table
>> > > >     ResultSet rset = stmt.executeQuery ("select ENAME from EMP");
>> > > >
>> > > >     // Iterate through the result and print the employee names
>> > > >     while (rset.next ())
>> > > >       System.out.println (rset.getString (1));
>> > > >   }
>> > > > }
>> > > >
>> > > >
>> > > >
>> > > >
>> >
>> >_________________________________________________________________________
>> > > > Get Your Private, Free E-mail from MSN Hotmail at
>> > >http://www.hotmail.com.
>> > > >
>> > > > Share information about yourself, create your own public profile at
>> > > > http://profiles.msn.com.
>> > > >
>> > > >
>> > > > ---
>> > > > NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
>> > > > Visit EarthWeb for the latest in IT Management, Software
>>Development,
>> > > > Web Development, Networking & Communications, and Hardware &
>>Systems.
>> > > > Click on http://www.earthweb.com for FREE articles, tutorials,
>> > > > and discussions from the experts.
>>jwenting@h...
>>$subst('Email.Unsub')
>> > > >
>> > >
>> > >
>> > >---
>> > >NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
>> > >Visit EarthWeb for the latest in IT Management, Software Development,
>> > >Web Development, Networking & Communications, and Hardware & Systems.
>> > >Click on http://www.earthweb.com for FREE articles, tutorials,
>> > >and discussions from the experts.
>> > >
>> >
>> >
>>_________________________________________________________________________
>> > Get Your Private, Free E-mail from MSN Hotmail at
>>http://www.hotmail.com.
>> >
>> > Share information about yourself, create your own public profile at
>> > http://profiles.msn.com.
>> >
>> >
>> > ---
>> > NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
>> > Visit EarthWeb for the latest in IT Management, Software Development,
>> > Web Development, Networking & Communications, and Hardware & Systems.
>> > Click on http://www.earthweb.com for FREE articles, tutorials,
>> > and discussions from the experts.
>> >
>>
>>
>>---
>>NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
>>Visit EarthWeb for the latest in IT Management, Software Development,
>>Web Development, Networking & Communications, and Hardware & Systems.
>>Click on http://www.earthweb.com for FREE articles, tutorials,
>>and discussions from the experts.
>>
>
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>
>---
>NEED TECHNICAL TIPS, TOOLS, AND INSIGHTS?  Is FREE okay?
>Visit EarthWeb for the latest in IT Management, Software Development,
>Web Development, Networking & Communications, and Hardware & Systems.
>Click on http://www.earthweb.com for FREE articles, tutorials,
>and discussions from the experts.
>

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.