Well..Basically what you need to have is a JDBC driver for the specific
DBMS, SQL Server 2000 in your case. There are different drivers (that fall
into one of the four JDBC driver categories) available from different
vendors for SQL Server. For example in one of my application I have used
JTurbo driver that is available for download in evaluation version at
http://www.JTurbo.com/.
In order to use it you simply need to make use of JDBC framework (open
connection by providing Driver and URL information or make use of DataSource
in case you are using Application server connection pools). However as
Jeetendra suggested let us know the details (in terms of either you are
using direct JDBC connection or making use of application server connection
pooling facility) if you are still having problems . Because I have also
successfully used the SUN JDBC-ODBC bridge driver in number of
applications.
Thanks
Zahid.
----- Original Message -----
From: Jeetendra <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 12, 2001 6:11 PM
Subject: Re: How to use SQL Server 2000 as Datasource for J2SDKEE 1.3?
> Yes it has worked for me - although not J2SDKEE 1.3 . Please let us know
the
> details so we could help.
>
> Jeetendra Dassani
> Lead Systems Engineer
> Tata Infotech Limited
> SEEPZ, Andheri (E)
> Mumbai.
> Email : [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> Telephone: 8291261 X 2775/2465
>
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Stefan Haubold
> Sent: Wednesday, September 12, 2001 6:04 PM
> To: [EMAIL PROTECTED]
> Subject: How to use SQL Server 2000 as Datasource for J2SDKEE 1.3?
>
>
> Hi,
>
> I want to use a SQL Server 2000 Database instead of Cloudscape with the
> Java 2 SDK Enterprise Edition 1.3 (Beta2). My first approach was using
> the JdbcOdbcDriver from Sun. I tried to configure the J2SDKEE1.3 to use
> this driver. It didn't work. Has anybody got this to work?
>
> Best Regards,
>
> Stefan
>
>
===========================================================================
> 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".
