RE: SQL2000 server not recognized by CF 4.5 - continued...
Dave, I do not know if your question was answered or not. What version of CFAS are you using? MS SQL Server is only supported on CF Pro and CF ENT. Thank You, Peter Peter J. MacDonald II Creative Computing, Inc. 100 Middle Street Lincoln, RI 02865 Phone: 401.727.0183 x123 Fax: 401.727.4998 Portable: 401.965.3661 E-MAIL: [EMAIL PROTECTED] Web Page: www.creatcomp.com -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 7:31 PM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 - continued... Hello everyone, i sent an email two days ago about not being able to get CF and SQL2000 to talk to each other. i followed the instructions everyone sent me including installing the latest MDAC and still, i couldn't get them to talk to each other. i did finally get them to talk by checking the use trusted connection checkbox, but someone at work told me that i hadn't fixed any problem, i'd just gone around it. of course, i really don't know what he means by that at all. As you might have guessed, i'm new to server admin. Also, i can't even get an access DB to be recognized. CF just tells me the datasource cannot be verified. i've added it in my ODBC panel under SystemDSN, but the problem persists with getting CF to talk to databases. if anyone can shed any light onto this problem i would greatly appreciate it. thanks in advance. d -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:25 PM To: CF-Talk Subject: Re: SQL2000 server not recognized by CF 4.5 On 4/23/01 1:52 PM David Baskin wrote: I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5
Has anyone heard if SQL2000 is actually slower than SQL 7.0? There's been some studies that have potentially indicated this, when run on NT 4. I suspect that SQL 2000 will probably run better with larger datasets on Windows 2000, though. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5
Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5
What I have heard from a number of very knowledgeable SQL Server DBAs is that SQL7 runs better on NT4 than SQL2000. If you're on Windows 2000, SQL2000 performs better than SQL7. Bob -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: April 27, 2001 12:39 PM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5
On all tests we've run over here, we've found SQL Server 2000 to be *significantly* faster than SQL 7.0, particularly with queries where optimization plays a larger role. SQL Server 2000 also holds the industry record for TPC-C performance, which is a pretty good indicator of real world performance (SQL 7 doesn't even place). See http://www.tpc.org/tpcc/results/tpcc_perf_results.asp for more info. Michael Caulfield -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:39 AM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5
The new version has made some significant improvements in performance, but watch out for some critical problems trying to manage a larger system. SQL2000 Enterprise Manager can take up to 10 minutes to list 500 databases on a 2-proc 1GHz system with 1GB of RAM and RAID5 U2W with 128MB of on-board SCSI RAM and 10,000 RPM drives. These little gothchas can be a annoying for the admin and often lead to folks reporting that things are slower. TPC's are one thing, but if it takes you 10 minutes to drop one table, you have a problem. Good Luck, - Steve -Original Message- From: Caulfield, Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 2:56 PM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 On all tests we've run over here, we've found SQL Server 2000 to be *significantly* faster than SQL 7.0, particularly with queries where optimization plays a larger role. SQL Server 2000 also holds the industry record for TPC-C performance, which is a pretty good indicator of real world performance (SQL 7 doesn't even place). See http://www.tpc.org/tpcc/results/tpcc_perf_results.asp for more info. Michael Caulfield -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:39 AM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL2000 server not recognized by CF 4.5
steve, there is a patch for that, if you can't find it (and who can find anything on M$ site??) email me off list --- Stephenie Hamilton [EMAIL PROTECTED] - Original Message - From: Steve Pierce [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, April 27, 2001 4:32 PM Subject: RE: SQL2000 server not recognized by CF 4.5 The new version has made some significant improvements in performance, but watch out for some critical problems trying to manage a larger system. SQL2000 Enterprise Manager can take up to 10 minutes to list 500 databases on a 2-proc 1GHz system with 1GB of RAM and RAID5 U2W with 128MB of on-board SCSI RAM and 10,000 RPM drives. These little gothchas can be a annoying for the admin and often lead to folks reporting that things are slower. TPC's are one thing, but if it takes you 10 minutes to drop one table, you have a problem. Good Luck, - Steve -Original Message- From: Caulfield, Michael [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 2:56 PM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 On all tests we've run over here, we've found SQL Server 2000 to be *significantly* faster than SQL 7.0, particularly with queries where optimization plays a larger role. SQL Server 2000 also holds the industry record for TPC-C performance, which is a pretty good indicator of real world performance (SQL 7 doesn't even place). See http://www.tpc.org/tpcc/results/tpcc_perf_results.asp for more info. Michael Caulfield -Original Message- From: Correa, Orlando (ITSC) [mailto:[EMAIL PROTECTED]] Sent: Friday, April 27, 2001 11:39 AM To: CF-Talk Subject: RE: SQL2000 server not recognized by CF 4.5 Has anyone heard if SQL2000 is actually slower than SQL 7.0? Orlando Correa IHS Web Team ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5 - continued...
Hello everyone, i sent an email two days ago about not being able to get CF and SQL2000 to talk to each other. i followed the instructions everyone sent me including installing the latest MDAC and still, i couldn't get them to talk to each other. i did finally get them to talk by checking the use trusted connection checkbox, but someone at work told me that i hadn't fixed any problem, i'd just gone around it. of course, i really don't know what he means by that at all. As you might have guessed, i'm new to server admin. Also, i can't even get an access DB to be recognized. CF just tells me the datasource cannot be verified. i've added it in my ODBC panel under SystemDSN, but the problem persists with getting CF to talk to databases. if anyone can shed any light onto this problem i would greatly appreciate it. thanks in advance. d -Original Message- From: Sean Daniels [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 12:25 PM To: CF-Talk Subject: Re: SQL2000 server not recognized by CF 4.5 On 4/23/01 1:52 PM David Baskin wrote: I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL2000 server not recognized by CF 4.5
try setting up a special username/password in SQL and enter those in the Advance settings in ADD ODBC datasources - CF Administrator Thanks, Michael Lugassy Interactive Music Ltd. http://www.imvamp.com [EMAIL PROTECTED] - Original Message - From: David Baskin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 7:52 PM Subject: SQL2000 server not recognized by CF 4.5 I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. d ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5
Under the SQL Server menu, look at both the Server Network Utility and Client Network Utility. These both need to be configured to use the same protocol(s), so the CF client can talk to the SQL Server. We configure ours to used TCP/IP only for both client and server. Bob -Original Message- From: David Baskin [mailto:[EMAIL PROTECTED]] Sent: April 23, 2001 1:53 PM To: CF-Talk Subject: SQL2000 server not recognized by CF 4.5 I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. d ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL2000 server not recognized by CF 4.5
Sometimes the default client configuration for the connection to the SQL Server is set to use NTBEUI instead TCPIP and you cannot establish the connection, go to Start/Programs/SQL Server/Client Configuration and there you can change this Regards - Original Message - From: David Baskin [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, April 23, 2001 10:52 AM Subject: SQL2000 server not recognized by CF 4.5 I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. d ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL2000 server not recognized by CF 4.5
On 4/23/01 1:52 PM David Baskin wrote: I'm hoping someone can help with a problem i cannot figure out. i have a new box with Win2K, CF 4.5, and SQL2000. Installed everything this weekend without problems, but now i cannot get SQL and CF to play together. i try to set up the ODBC and my connection fails every time. the base SQL server that shows up as default on the ODBC admin does not connect, nor does the one that i create. not sure how to trouble shoot this problem at all. any help is greatly appreciated. Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. - Sean ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL2000 server not recognized by CF 4.5
Have you reinstalled the MDAC since installing CF 4.5? If not, pop the windows 2K CD in and run the upgrade and this will fix the MDAC that gets broken when you install CF 4.5. If he's running SQL 2000, which requires MDAC 2.6, that's not a good idea, since the one on the Win2K CD is 2.5. You can download and install MDAC 2.6 separately from http://www.microsoft.com/data/. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists