General information
Category:
West Wind Web Connection
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 ...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only