Hi,
You seem to have posted this question in all the EJB groups expect maybe the
most appropriate one for this question :: The WebSphere one.
Ideally you should try out all your vendor specific quesiton on a vendor's
list instead of taxing a generic EJB list.
Point your news client at news://news.software.ibm.com and select the
websphere.application_server group. Do a search on "sql" and you will find
your question answered.
-- Aravind
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Arul
> Sent: Wednesday, 2 August 2000 02:25
> To: [EMAIL PROTECTED]
> Subject: Re: websphere with sql server
>
>
> 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".
>
>
===========================================================================
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".
