Information générale
Catégorie:
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 ...
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement