That probably had something to do with your not having problems! I'd too much in the way of data (mostly only here for testing) on this box to back it all up and start again....
Oh, well. Another day, another pint - or three! Cheers Terry ----- Original Message ----- > 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]
