I'm a newbie when it comes to MS SQL. I have it working properly on my server, and have created a database, which is called "mydatabase".
I want to set up CF5 Admin on my workstation so that I can connect to this server SQL 2000 db (CF5 is working fine, I have a number of Access datasources already established, but on the local machine). I seem to be having trouble connecting - my thoughts are its something in specifying the server name. Here's what I have so far in the CF5 admin: DATASOURCE TYPE = ODBC DRIVER TYPE = Microsoft SQL Server Driver DATASOURCE NAME = mydatabase DESCRIPTION = SERVER = Any other suggestions to make the connection? Or to tune for best performance? My network is TCP/IP. Should I be using IP addresses? My server is INTRANET\Server1 My workstation is INTRANET\Workstation1 Thanks, Mark ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
