On 19 Feb 2002, Ray wrote:
> Native? > The odbc drivers that I have found are very expensive. > Datadirect $4000 for 2 cpu machine > openlinksw same thing > That was the only reason to try jdbc but I found easysoft bridge whice > is only $1500 for 25 users. > If you know of any others please let me know. To connect to an MSSQL server, there's always FreeTDS http://www.freetds.org/ Or you might be able to download Sybase 11.9.2 or Sybase 11.0.3.3 and possibly use its drivers to connect to the MSSQL server. Both servers speak the same wire-level protocol. They use different versions, but I know at least Sybase can downgrade its protocol level; perhaps so can MSSQL. I've never tried to connect to an MSSQL server with Sybase libraries, so I don't know for sure if it works. I do know that FreeTDS explicitly supports MSSQL, but the code isn't the cleanest in the world so I would prefer to use the Sybase libraries (although that said, we do use FreeTDS on all of our production systems, for very busy sites that make us millions of dollars). No matter which library you choose, use DBD::Sybase as the Perl module of choice. It will use either of those two libraries to make the connections. > On Tue, 2002-02-19 at 00:19, Matt Sergeant wrote: > > On 18 Feb 2002, Ray wrote: > > > > > Can I use the a jdbc driver and xsp to connect and query a microsoft sql > > > 2000 database? > > > > Yep. http://search.cpan.org/search?dist=DBD-JDBC > > > > Are you sure you really want to go via Java though when native would be > > that much faster? > > > > -- > > <!-- Matt --> > > <:->Get a smart net</:-> > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
