Tuesday, March 20, 2012

Connection options from *nix to SQL Server 2000

Hi All,
There is a possibility that we may need to move our existing W2K servers and
our custom application over to *nix.
I am interested to know what are the options available to us if we stick
with SQL Server 2000 Enterprise as the database on a W2K or W2003 OS.
Is JDBC the way to go? Is there a better option? Likewise we currently use
ATL to access SQL from our application, would an alternative solution offer
the same level of performance and stability?
Any help would be very much appreciated.
Thanks in advance.
Phil
Phil:
I think you have to basic options for a Java app on UNIX to SQL Server
2000 -- stick w/ JDBC or use a ODBC driver for UNIX, like the one Data
Direct sells.
-shelby
Shelby Goerlitz
Microsoft SQL Server
"philwhite3" <philwhite3@.supanet.com> wrote in message
news:eFNVmSchEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> There is a possibility that we may need to move our existing W2K servers
and
> our custom application over to *nix.
> I am interested to know what are the options available to us if we stick
> with SQL Server 2000 Enterprise as the database on a W2K or W2003 OS.
> Is JDBC the way to go? Is there a better option? Likewise we currently use
> ATL to access SQL from our application, would an alternative solution
offer
> the same level of performance and stability?
> Any help would be very much appreciated.
> Thanks in advance.
> Phil
>

No comments:

Post a Comment