Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update dbf data with data from SQL server
Message
From
19/01/2009 14:34:15
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01374980
Message ID:
01375203
Views:
6
Sorry, 2000 fully patched.


>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?
>>
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform