>Hi all, I am using odbc and a connection string to access remote data, but have a fixed remoteDb user. My application framework (Promatrix) has a user object and will like to sync. the db user with the app user so I can see in the dbserver who exactly is doing what, since with this generic use, I have to give full access and see only one user with multiple sessions, how do I pass the user and pass strings to the connection string ?
I do not see why you would need to pass the user's password to the database, but you can use the User ID from the app to update an "UPDATED_BY" field in the remote tables. I have such a field in all my remote tables. If you have this in your remote tables, you can include this field in your remote views. When a record is added or edited, just replace this field value with the UserID and it will be posted back to the database when you TABLEUPDATE(). If you explain what kind of auditing you want to do, maybe you can get a better solution.
Mark McCasland
Midlothian, TX USA