Dave, I've found that installing he client utility improves my performance via ODBC. Is there a network library that's overwritten when you install it? That's always been my guess.
Mark -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 9:49 AM To: CF-Talk Subject: RE: How do I conect a web server to a sql server? > You need to install the SQL Server client network utility > on the Web/CF server. Set up an alias using TCP/IP in that > to the SQL Server IP Address. Then go into ColdFusion > Administrator, set up an ODBC datasource using SQL Server. > Enter the database name, the login and password and you can > then "talk" to the database using the datasource name. Actually, you don't have to install the SQL Server Client Network Utility. It's just an interface to functionality that's already there. You can do this from the ODBC Control Panel; just click on the "Client Configuration" button within the second page of the connection wizard. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
