Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Object Name when a UDF is executed within a SQL
Message
 
 
To
13/12/2004 15:26:52
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
00968894
Message ID:
00968922
Views:
9
>When a SQLEXEC() is called from our FoxPro 8.0 app which calls a SQL Server SP, an "Invalid Object Name" error is thrown from SQL Server when the SP attempts to execute a UDF, the Invalid Object Name being the UDF name.
>
>When the same SP is ran in SQL Query Anlyzer with the same parameters passed, there is no problem.
>


Mike,

Are you sure that sproc is run from SPT in the correct database ?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform