Showing posts with label underwindows. Show all posts
Showing posts with label underwindows. Show all posts

Wednesday, March 21, 2012

ODBC Connection failed

I am having an issue connecting to a SQL server under
windows Xp and office 2003. This is the error it gives.
****
Connection Failed
SQL State : 'HY000'
SQL Server error : 0
[Microsoft][ODBC SQL server driver]Cannot generate SSPI
content
****
Connecting to the same Database on the SQL server works
perfect on a Windows 2000 machine, running Office XP.
Any Ideas?
Thanks,
AndyWinXP Pro to SQL Server 2000 on Win2000 server: I'm having this problem also
, after about an hour. It works fine for that long then fails.
Connection failed:
SQLState 'HY000
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver] Cannot generate SSPI context
Logout and back in has no effect, only rebooting clears the problem which th
en works fine for another hour or so. Not much time to get any serious codin
g and testing done.