I'm not familiar with RevertToSelf(), can you tell me more about it?


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