We have a relatively simple ASP page which is talking to a SQL Server 2000 database. The web server and database server are both on a Windows 2000 box.

The page works fine all the time there is a user logged onto the server. However when there is nobody logged into the server we get an ODBC error message. 0x80040E1 Incorrect Syntax near ":"

The webserver is IIS 5 and the access to the web is set to anonymous logon using the iusr_... account. The database is set to SQL and Windows NT Authentication. The web page is access the database using a SQL username and password. The connection string is:

"Driver={SQL Server};Server=fred;Database=george;uid=user;pwd+p assword"

the error message is generated when we try and run the query against the database.

I have checked the IIS Out-of-Process Pooled Applications is set to This User and even set this to the local administrator account for the moment.

Please can anybody help?

Somebody from a different newsgroup spotted the problem. A different locale was being used when you are logged into the server than when you are not logged in. Adding session.lcid = 2057 (UK) forced the locale to be the same