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