Hello Gaurav
I agree that SQL Server is not supported by WebSphere.And i am also very
clear that the drivers r not installed automatically.U have to select in the
admin console what Implemenation class u use.And i have only four
Implementation classes like
com.ibm.db2.jdbc.app.DB2Driver
oracle.jdbc.driver.OracleDriver
com.ibm.as400.access.AS400JDBCDriver
com.sybase.jdbc.SybDriver
i wanted to know when these Implentation classes r installed in my machine
and Where exactly.???
Also Gaurav... one documentation from IBM States that
"WebSphere Application Server 3.0 does not currently support SQL Server.
WebSphere Application Server 3.0 does work with Oracle and DB2.
You can access SQL Server (or any other database) from Servlets, JSPs,
Entity BMP or any Session beans through JDBC. However, you cannot use the
WebSphere Application Server connection manager to do so.
So from this point ,its clear that my Bean Managed Entity Beans can access
Sql Server thro Websphere but not Container managed Beans.
But another document from redbook states that
"To use the DB2 and Oracle JDBC drivers for servlets within WebSphere it is
necessary to include the driver classes in the WebSphere class path , and
add
c:\sqllib \java \db2java.zip (DB2)
c:\orant \Jdbc \lib \classes111.zip (Oracle)
to the Application Server Classpath Entry "
My Question is
Why should not i add my SQL Server Type IV Drivers to the class path so that
i can make CMP Beans also access WebSphere.Is it Possible and How???
Regards,
Arul
----- Original Message -----
From: "Gaurav SDC NOIDA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 02, 2000 11:43 AM
Subject: Re: websphere with sql server
> HI Arul
> Sql server is not supported by WebSphere.Only DB2 and oracle r supported.
> drivers r not installled automatically.
> U select the implementing class when u create jdbc driver in admin
console.
> If u want to use oracle ,select oracle.jdbc.driver.OracleDriver.
> U give the driver location when you install driver in topology tab of
admin
> console.(It was sqllib/java/db2java.zip in case of DB2).
> For oracle u will be reqd to give oracle driver location.
>
> That's it.
>
> Gaurav Tiwari
> ECode-1205
> HCL Perot Systems,Noida
> (Youngest CMM level 5 company)
> email- [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
> > -----Original Message-----
> > From: Arul [SMTP:[EMAIL PROTECTED]]
> > Sent: Tuesday, August 01, 2000 11:16 AM
> > To: [EMAIL PROTECTED]
> > Subject: websphere with sql server
> >
> > hello everybody
> > I tried to create a jdbc driver in the administrative console of a
> > websphere
> > advanced administrative console for DB2 , it worked fine.All i did was
> > just
> > click on the JDBC Drivers in the types tab and then create (correct me
if
> > am
> > wrong anywhere).When it asked me fo the implementation class,i just
> > selected
> > com.idm.db2.jdbc.app.DB2driver and then click on create.
> >
> > What i wanted to know is where r these drivers saved.I know that these
> > were
> > installed when i installed websphere and automatically configured.Is
there
> > any options that i can change these properties.
> >
> > Also if i want to connect sql server with websphere where should i
> > install
> > the driver and how to configure that driver with websphere
> >
> > Thanx in advance
> >
> > Arul
> >
> >
==========================================================================
> > =
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> > body
> > of the message "signoff EJB-INTEREST". For general help, send email to
> > [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
