RE: SQL2000 server not recognized by CF 4.5 - continued...

2001-05-01 Thread Peter J. MacDonald
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

RE: SQL2000 server not recognized by CF 4.5

2001-04-28 Thread Dave Watts
> 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.co

Re: SQL2000 server not recognized by CF 4.5

2001-04-27 Thread cf-talk
gt; 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

RE: SQL2000 server not recognized by CF 4.5

2001-04-27 Thread Steve Pierce
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 opt

RE: SQL2000 server not recognized by CF 4.5

2001-04-27 Thread Caulfield, Michael
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

RE: SQL2000 server not recognized by CF 4.5

2001-04-27 Thread Bob Silverberg
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 officia

RE: SQL2000 server not recognized by CF 4.5

2001-04-27 Thread Correa, Orlando (ITSC)
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

RE: SQL2000 server not recognized by CF 4.5 - continued...

2001-04-25 Thread David Baskin
-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

Re: SQL2000 server not recognized by CF 4.5

2001-04-24 Thread Michael Lugassy
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]> T

RE: SQL2000 server not recognized by CF 4.5

2001-04-23 Thread Dave Watts
> 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.

Re: SQL2000 server not recognized by CF 4.5

2001-04-23 Thread Sean Daniels
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 co

Re: SQL2000 server not recognized by CF 4.5

2001-04-23 Thread Jose Alberto Guerra Ugalde
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"

RE: SQL2000 server not recognized by CF 4.5

2001-04-23 Thread Bob Silverberg
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-