Re: Connecting CF5 to MS SQL
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
RE: Connecting CF5 to MS SQL
Thanks for your help - got it to work now. Thanks, Mark -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 11, 2002 2:44 PM To: CF-Talk Subject: Re: Connecting CF5 to MS SQL >DATASOURCE TYPE = ODBC >DRIVER TYPE = Microsoft SQL Server Driver >DATASOURCE NAME = mydatabase >DESCRIPTION = >SERVER = First, you'll need to put the server IP address or server name in the "SERVER =" value. Also, make sure you specify the username/password for access to the database. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
Re: Connecting CF5 to MS SQL
>DATASOURCE TYPE = ODBC >DRIVER TYPE = Microsoft SQL Server Driver >DATASOURCE NAME = mydatabase >DESCRIPTION = >SERVER = First, you'll need to put the server IP address or server name in the "SERVER =" value. Also, make sure you specify the username/password for access to the database. - Sean ~~ Sean Daniels Director, Engineering Marketplace Technologies, Inc (T): 207.363.7374 (C): 207.332.6340 (F): 240.269.6319 ~~ http://www.dealforce.com http://www.mergernetwork.com __ 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
RE: Connecting CF5 to MS SQL
> 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
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 __ 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
