Hi, I use hostmysite for SQL2000, Not sure if this will be useful but note the tcp/ip connection setup issues that need to be addressed that may bear on your question as well.. Instructions on how to configure the Enterprise Manager can be found at http://www.hostmysite.com/support/SQLServer/sql_support.hms. Please be sure your client is configured to use TCP / IP and not the default setting of named pipes (directions can be found at http://www.hostmysite.com/support/SQLServer/clientcfg.hms).
rgds Colm Colm Brazel MA CB Publications www.cbweb.net <http://www.cbweb.net> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: Douglas Humphris [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 11:35 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFMX - SQL2000 Paul, I am using CFMX with SQL2000 on Win2000 and have successfully connected using the SQL connector. However, I did have problems with this! AFAIK the only way to do this is to set up the datasource using the ODBC Administrator through Windows. Then, go into CF Admin and connect. MM know about this. HTH Douglas -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 09:55 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CFMX - SQL2000 I now have my development server up & running (again) Fresh install of Win2k server, Coldfusion MX, and SQL 2000 standard, using IIS. I am trying to connect via the SQL connection to the Northwind Database. I confess that I know little about SQL 2000 but I can't believe this is so difficult. I have connected ok to existing MS Access databases, and can connect to the Northwind database via ODBC socket connection by first creating an ODBC entry in the ODBC control panel on the server. Surely everything is therefore working ok ??? (but why do I need to do this and not use the SQL connection) I need to get this sorted so that I can justify/reccomend the move from cf4.5/access to cfmx/sql2000 to the city council education dept. I have the server setup for "multiple access methods" or something like that, everything seems to test out OK So, Why can't I connect with the SQL connection to an SQL database? (the default port 1433? is setup) I have read in other forums that Macromedia have a major problem with this. Is it true? Any help with this would be greatly appreciated. (Its lucky I have lots of long hair or i'd be bald by now ....) Regards - Paul. ************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify [EMAIL PROTECTED] The views expressed within this email are those of the individual, and not necessarily those of the organisation ************************************************************* -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.419 / Virus Database: 235 - Release Date: 11/13/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.419 / Virus Database: 235 - Release Date: 11/13/2002 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
