all groups > sql server odbc > june 2004 >
You're in the

sql server odbc

group:

ODBC Connection.



ODBC Connection. Nexus Quest
6/24/2004 12:53:59 AM
sql server odbc: There is a problem with my ODBC connection. Usually after
about 30 mins, a connection time out occurs and the error
message displayed is as foolows:

Connection failed:
SQLState: 'S1000'
SQL Server Error: 0
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI
context

I'm currently using Microsoft Windows Server 2003 for
Small Business Servers as my back-end server while my
client is using Microsoft Office Access 2003.

This problem does not occur in certain computers,
regardless of the authenticated users.

Normally what i would do when this problem occurs, will
be to log off and re login to windows. However this is
quite time consuming and i was wondering if there is any
Re: ODBC Connection. Steve Thompson
6/24/2004 9:29:30 AM
If you have not seen this troubleshooting page, you'll want to give this a
read:

How to troubleshoot the "Cannot generate SSPI context" error message
http://support.microsoft.com/default.aspx?scid=kb;en-us;811889&Product=sql2k

Steve
[quoted text, click to view]

Re: ODBC Connection. SqlJunkies User
7/12/2004 9:02:35 AM
I am having the same problem with ODBC timing out after 30 minutes. Did you find a way to correct the problem?

---
Posted using Wimdows.net NntpNews Component -

AddThis Social Bookmark Button