You need to enter the servername..
At 01:21 PM 7/11/02 -0400, you wrote: >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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists