WSID only sometimes gets updated

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello, I have an Access 2003 application using SQL authentication to access
SQL Server 2000. I connect though linked tables and ADO. I'm trying to set
the Workstation parameter to the current user. It doesn't seem to update
correctly. I've gotten a value to go into the setting but then it seems to
stick. I'll update the connectionstring to have a different name for the
Workstation ID (WSID) but the value that shows in the process section
doesn't change. I then noticied that after a dozen times trying the value
finally updated.

Any ideas?

Thanks

Don


.

Relevant Pages

  • Re: Connect to Desktop SQL Server 2000 from Pocket PC
    ... SSPI is in fact supported, but you have to provide user ID and password ... This might be useful if SQL authentication is disabled on a server. ... > Xref: cpmsftngxa10.phx.gbl ... >> I need to connect from a program in the Pocket PC to SQL Server in my ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Reason: Not associated with a trusted SQL Server connection.
    ... Are you sure SQL Server is set up to use both SQL Authentication and Windows ... "John Beschler" wrote in message ... > I don't think it's a problem with the IUSR account because ASP runs fine. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Windows Service Login Failed when accessing SQL.
    ... SQL Authentication should work since you specify the login ID and password ... connect to the SQL Server DB successfully. ... > Windows Service Login Failed when accessing SQL. ...
    (microsoft.public.dotnet.distributed_apps)
  • Problem Connecting to another SQL DB using SQL Security
    ... I am attempting to create a Data Source connection to a SQL Server DB using ... SQL Authentication so that I can create DataViews and cannot (I get "Server ...
    (microsoft.public.sharepoint.windowsservices)
  • Authentication to server with SSL through firewall
    ... Every SQL Server will have SSL certificate ... SQL authentication with encryption requested in connection string. ...
    (microsoft.public.sqlserver.security)