Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update dbf data with data from SQL server
Message
 
 
To
19/01/2009 10:52:57
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01374980
Message ID:
01375094
Views:
15
What's SQL Server version? I know that it works under SQL 2000. Don't remember if Itried with later versions.

>
>This is all quite frustrating.
>
>I've set up (yet another) linked server.
>
>
>
>/****** Object:  LinkedServer [DBF]    Script Date: 01/19/2009 16:46:26 ******/
>EXEC master.dbo.sp_addlinkedserver @server = N'DBF', @srvproduct=N'VFP', @provider=N'MSDASQL', @datasrc=N'DbfTest'
>
>
>
>
>That's the server, but when I query it or click Catalogs -> Refresh it says:
>
>
>OLE DB provider 'UNKNOWN' reported an error. One or more arguments were reported invalid by the provider. (Microsoft SQL Server, Error: 7399)
>
>
>What am I doing wrong?
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform