>I'm not familiar with RevertToSelf(), can you tell me more about it?
You can use RevertToSelf() to revert back to the non-impersonated account that's running the current application.
For example, if you're running Web COnnection in COM mode you are usually impersonating some account that's configured in DCOMCNFG. By using RevertToSelf() you can revert back to the underlying system account that launched the request (usually IUSR_ in a Web application or the actual account that IIS logged in under). IIS impersonates this account and passes those credentials to your process via COM as the caller indirectly.
+++ RIck ---
>
>
>>Thanks! Actually, I already use the command "USE databasename" prior to any query.
>>
>>I was wondering if using RevertToSelf() would be a viable option.
>>
>>Bob
>>
>>>>I have an app that talks to SQL Server via the SQLEXEC() function. On my development PC I can talk to the SQL database directly no problem, use the code to run queries, etc.
>>>>
>>>>But when I run those same code/queries via Web Connection I get an error: Invalid Object Name 'tablename' where the tablename is the table I'm trying to query.
>>>>
>>>>I've gone into Enterprise manager, created a login for the IUSER_COMPUTERNAME account (with my computername), and given it all the possible permissions I can think of and still no go... :(
>>>>
>>>>Any ideas? I'm really frustrated. I know its some kind of permission thing, but I can't figure out what I am missing.
>>>>
>>>>Bob
>>>
>>>Bob,
>>>
>>>Make sure that your DSN has the corret database set as the default database or else you need to qualify your table name with the Database.DBO.TableName as in;
>>>
>>>SELECT * FROM DatabaseName.DBO.TableName ...