Monday, February 20, 2012

Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC

I have J2EE web application, that uses Datasources, which works fine with SQL
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with the same code running locally on Windows XP Professional against
MSDE version of SQL Server 2000.
Is MSDE version of SQL server supported by Microsoft SQL Server 2000 driver
forJDBC?
The release notes says:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP2:
? SQL Server 2000 Standard and Enterprise Editions*
? SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
higher*
? SQL Server 2000 Enterprise Edition (64-bit)*
Do you have specifics on the issues? For instance, could it be your Windows
Firewall? If it is on, it must be configured to allow traffic (locally) on
ports 1433 (TCP) and 1434 (UDP). I don't know any specifics about the JDBC
drivers, other than make sure that you have the same SQL Server SP
(preferably SP3/SP3a) and check your MDAC version against the other
machine's.
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:A3942A4E-398A-48FA-B363-A4D392E2ECBB@.microsoft.com...
>I have J2EE web application, that uses Datasources, which works fine with
>SQL
> Server 2000 Developer Edition running on Windows 2000 Server but I am
> having
> issues with the same code running locally on Windows XP Professional
> against
> MSDE version of SQL Server 2000.
> Is MSDE version of SQL server supported by Microsoft SQL Server 2000
> driver
> forJDBC?
> The release notes says:
> The following versions of SQL Server will be supported for use with the
> SQL
> Server 2000 Driver for JDBC SP2:
> . SQL Server 2000 Standard and Enterprise Editions*
> . SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
> higher*
> . SQL Server 2000 Enterprise Edition (64-bit)*

No comments:

Post a Comment