Link to home
Start Free TrialLog in
Avatar of richd1234
richd1234

asked on

Where does sp_who2 get the hostname from on an MS Access ODBC connection?

I have written a small MS Access 2003 program that connects via ODBC to an MS SQL 2000 DB.  I have distributed the program to multiple users.  However, when I run sp_who2 in query analyzer to see who is running the program, the hostname is the same for every instance (it is the name of my PC, where the program was created).  Where is query analyzer pulling that info from and is there a way to change it?
Avatar of chapmandew
chapmandew
Flag of United States of America image

The machine name that the Access db is querying the database from.
Avatar of richd1234
richd1234

ASKER

That was my understanding, however, when I move the program from one machine to another, it seems to hang onto the name of the PC on which it was created.
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Got it...as it turns out, you have to use the Linked Table Manager and update all the linked tables from the new workstation.  Once that is done, the correct workstation will show up.  Thanks for everyone's input.
Great.
Excellent. Now please close the question.
No points assigned on this one?