> DATASOURCE TYPE = ODBC > DRIVER TYPE = Microsoft SQL Server Driver > DATASOURCE NAME = mydatabase > DESCRIPTION = > SERVER =
SERVER = localhost or the IP address of the SQL database. Usually there is a port option to. Default is 1433 unless your SQL server was configured to something specific. You will also need to define a username/password for an account on the SQL server that has access to 'mydatabase'. Also, as good measure, make sure you have updated your MDAC on the CF machine. Trey Rouse Internet Project Supervisor Web Services - Rice University MS 119 - 713.348.4799 > -----Original Message----- > From: Mark Leder [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 11, 2002 12:22 PM > To: CF-Talk > Subject: Connecting CF5 to MS SQL > > 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 > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
