[NCLUG] Apache/Linux & M$ SQL Server 2000

[Chris Wolney]

MS SQL2000 will allow ODBC connections to the databases.  Would the
development tools in question use a DSN to connect to the database, or do
they appear to allow a DSN-less connection method like OLEDB?  That would be
ideal from a performance standpoint.  I know when I was using ODBC via DSN's
to run some web apps against a SQL server, and later converted all of my
connection strings to use the OLEDB method, performance (not to mention
stability) went up noticeably.  Such a thing may only be available on MS
tools (I am using ASP)...

-Chris

----- Original Message -----
From: "Eric Brunson" <brunson at level3.net>
To: <nclug at nclug.org>
Sent: Wednesday, September 26, 2001 11:17 AM
Subject: Re: [NCLUG] Apache/Linux & M$ SQL Server 2000


>
> There are several ODBC packages for perl and python, I'd suggest
> starting there.  M$ SQL Server *does* still support ODBC, doesn't it?
> Or have that changed to some sort of MSDBC "standard"?
>
> * Rich Young (rich at ExperiencePlus.Com) [010926 11:09]:
> > Hi all,
> > I know this is a bit off topic, but I'm hoping somebody here will be
> > able to help me.  We run a split architecture here, with Apache/Linux
> > handling web server duties, and WinNT 4.0/SBS running Exchange and SQL
> > Server 7.  We have a critical database running on SQL 7 that I would
like to
> > someday integrate with our web site.  I know that there are a couple
> > open-source, Linux-friendly tools that will allow me to bridge the OS
> > barrier to do this, but we are considering upgrading to Win2k server and
SBS
> > 2k.  If we do this, we can't keep SQL 7 -- M$ tells me that the upgrade
> > installation will overwrite SQL 7, no choice in the matter.
> >
> > So now the question:  Is there anything out there that will allow perl,
> > python, you-name-it to connect to SQL Server 2000 from a linux
environment
> > for web development porpoises?  If so, anybody have any experience with
it?
> > If not, is there a better forum for this question that y'all might
suggest?
> > Any & all help is proactively appreciated....
> >
> > Oh, yeah - for typical reasons, nuking the microsoft box is not an
option
> > :^(
> >
> > --Rich Young (rich at ExperiencePlus.com)
> > Web & Database Admin
> > ExperiencePlus! Specialty Tours, Inc.
> > http://www.ExperiencePlus.com
> > _______________________________________________
> > NCLUG mailing list
> > NCLUG at nclug.org
> > http://www.nclug.org/mailman/listinfo/nclug
>
>
> --
>  Eric Brunson   brunson at level3.net   page-eric at level3.net
> tcA thgirypoC muinelliM latigiD eht detaloiv tsuj evah uoY
> _______________________________________________
> NCLUG mailing list
> NCLUG at nclug.org
> http://www.nclug.org/mailman/listinfo/nclug
>
>