Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Object Name when a UDF is executed within a SQL SP
Message
From
13/12/2004 15:26:52
Michael Vassallo
Efi, Inc.
Pittsburgh, Pennsylvania, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Invalid Object Name when a UDF is executed within a SQL SP
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
00968894
Message ID:
00968894
Views:
188
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.

Any help with this is appreciated.

Thanks,

Mike
Next
Reply
Map
View

Click here to load this message in the networking platform