> 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 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
