Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linked Server OLE/DB Provider Error
Message
From
12/12/2006 16:39:01
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
12/12/2006 16:31:03
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01176976
Message ID:
01176980
Views:
7
>I created a linked server in SQL Server that points to a VFP database container using the latest OLEDB Provider for VFP.
>
>When I am on the SQL Server machine I can execute a stored procedure that selects info from the VFP database. But when I issue a call using SQL Passthrough on a different machine, I get the following error:
>
>
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Invalid path or file name.]
>
>
>Any ideas what might be causing this.

The filenames passed to a SQL server need to be valid as seen from the server - that's where the code executes. Try to pass an UNC.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform