I can't recall if I also installed the new jdbc drivers as well( I probably did), in my case I installed SS 2000 AFTER sp2 upgrade, it works fine..
-----Original Message----- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 16:57 To: [EMAIL PROTECTED] Subject: [ cf-dev ] XP SP2, CFMX6.1 standalone and SQL Server. Be warned! I accepted to make the SP2 upgrade on my machine (where I have CFMX6.1 standalone and SQLS2K). Prior to the 'upgrade', I had no problems accessing SQLServer from CF. After the 'upgrade', it would not connect, giving an error from the SQLServer JDBC driver, stating that the 'instance is either invalid or not running'. Which, of course, was wrong - it was running and it was valid (at least to SQLS Enterprise Manager, and also to the XP ODBC sources setup, which verified an ODBC connection). Yes, I know 6.1 doesn't use ODBC, just thought I'd test it that way. The drivers (updated or whatever) had no problems with MySQL. Not having time to b***er about, with a job I just had to do, I unistalled the SP2, more in hope than anticipation, but it did actually return things to the way they were! Evidently there is some sort of driver update in that SP2 that doesn't fit. No idea what, haven't had time to investigate. Just thought you'd all like to know that little piece of news, in case anyone else was tempted. Cheers Terry -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
