MS SQL Server - WSID value updates randomly

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

WSID value updates randomly

Don

2006-03-31, 7:24 am

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 gets updated.

Any ideas?

Thanks

Don

Sponsored Links