Thanks,

It's funny how great minds think alike.

I reinstalled MDAC (actually, I upgraded from 2.5 TO 2.6 SP1) and 
everything is working again.

It's just strange. It was working this morning and the only thing I changed
 
was to add a "Virtual Directory" in IIS. How could that possibly cause CF 
to lose connection to the datasources, and why was it still working from 
the ODBC Control Panel?

I'll probably never know.

Thanks for the help anyway,

Mike



At 1/3/2002 01:19 PM, you wrote:
>Hey - do you have more information?  What network libraries are you using
>for example.
>
>Mark
>
>-----Original Message-----
>From: WebMaster [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, January 03, 2002 11:11 AM
>To: CF-Talk
>Subject: SQL 2000 ODBC Error?
>
>
>All of a sudden our CF4.5 on Windows2000 started throwing this error when
>attempting to connect to SQL2000 datasources.
>
>
>ODBC Error Code = S1000 (General error)
>
>[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context
>
>
>Oracle, Access, and SAS datasources all work fine AND the SQL2000 DSN's
>work from the ODBC control panel, but not from the Cold Fusion control
>Panel.
>
>Anybody ever seen this before?
>
>Thanks,
>
>Mike
>_________________________
>_________________________
>____________________
>Get Your Own Dedicated Windows 2000 Server
>   PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
>   Instant Activation · $99/Month · Free Setup
>   http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
>
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to