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