ODBC driver problem occurs on table create

Hi all!

I get the following error when trying to create a table:
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).

I use the same connection for table updates and selects and never have a problem. This only happens on table create. It also only happens on one machine (Win2K with SQL server 2000 Enterprise Edition). I've run this app without getting this problem on at least ten other machines (mostly WinXP, but also a few Win2K).

Any ideas?

nscdDoes the account that you're using have permissions on that SQL Server to create new tables?|||Yes it does.

I've also changed it so that I connect using the sa account, but still get the same problem.

Cheers

nscd|||Hi all

Further investigation has revealed that my client's machine was fairly out of date and installing the latest MDAC patch from MS resolved the problem.

Cheers

nscd

ODBC Connection.

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
way that this problem can be solved.
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...&Product=sql2k
Steve
"Nexus Quest" <anonymous@.discussions.microsoft.com> wrote in message
news:2066301c459c0$68371610$a601280a@.phx.gbl...
> 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
> way that this problem can be solved.
|||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 -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

ODBC Connection.

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
way that this problem can be solved.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/defaul...9&Product=sql2k
Steve
"Nexus Quest" <anonymous@.discussions.microsoft.com> wrote in message
news:2066301c459c0$68371610$a601280a@.phx
.gbl...
> 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
> way that this problem can be solved.|||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 -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.sql

Occurs in a field

Hi,

How do find out how many times a character occurs in a field thru an expression? Like the occurs() function in FoxPro

Thanks

Any suggestions?