Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Openquery in stored proc
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Openquery in stored proc
Miscellaneous
Thread ID:
00849081
Message ID:
00849081
Views:
68
Hi all,

I am using a linked server on my SQL server2000 to access free DBF tables. I configured the free server in the Enterprise Manager and I have no trouble accessing DBF tables in the Query Analyser, it work fine.

I tried to integrate acces to this linked server with a stored procedure, but when I analyse my syntax, I receive the error message #7405 (something about heterogeneous request). I don't understand why it work in QA and no in the stores procs

thanks
Next
Reply
Map
View

Click here to load this message in the networking platform