Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL linked server with oledb
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00633116
Message ID:
00815848
Views:
14
here are the two error messages I got (sorry, but they're in french)

Test #1
exec sp_addlinkedserver @server = 'test', 
	@srvproduct = 'VFP',
	@provider = 'VFPOLEDB.1', 
	@datasrc = 'C:\Temp', 
	@provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE'

select * from test...livre

Serveur : Msg 7403, Niveau 16, État 1, Ligne 1
Impossible de créer l'entrée de Registre pour le fournisseur OLE DB 'VFPOLEDB.1'.
Test #2
exec sp_addlinkedserver @server = 'test1', 
	@srvproduct = 'VFP-ODBC',
	@provider = 'MSDASQL', 
	@provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=; 
		Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No; 
		Exclusive=No; SourceType=DBF;SourceDB=C:\Temp'

select * from test1...livre

Serveur : Msg 7314, Niveau 16, État 1, Ligne 1
Le fournisseur OLE DB 'test1' ne contient pas la table 'livre'. La table n'existe pas ou l'utilisateur en cours ne possède pas d'autorisations sur cette table.
in the test #2, the file livre.dbf is located in the C:\TEMP directory and there is no special athorisation to access it

>Hi Marc,
>
>All you have to do is to install VFP OLE DB provder or VFP ODBC driver depending on which one you want to use. Which of two code samples did you ran and what error did you get?
>
>
>>I tried this code on my SQL Server, but I still get errors. I think my ODBC is not correctly configured... How should I configure it?
>>
>>Thanks
>>
>>>>What is the correct syntax for adding a linked server into SQL2000 which is a fox free table directory
>>>>
>>>>how do you call these 2 extended procs?
>>>>sp_addlinkedserver
>>>>sp_addlinkedsrvlogin
>>>>
>>>>tia
>>>
>>>
-- Using OLEDB provider for VFP
>>>sp_addlinkedserver @server = 'test',
>>>	@srvproduct = 'VFP',
>>>	@provider = 'VFPOLEDB.1',
>>>	@datasrc = 'H:\Temp',
>>>	@provstr = 'Mode=Share Deny None;Password="";Collating Sequence=MACHINE'
>>>-- Using OLEDB provider for ODBC
>>>sp_addlinkedserver @server = 'test1',
>>>	@srvproduct = 'VFP-ODBC',
>>>	@provider = 'MSDASQL',
>>>	@provstr = 'DRIVER=Microsoft Visual FoxPro Driver;UID=;
>>>		Deleted=Yes; Null=Yes; Collate=Machine;BackgroundFetch=No;
>>>		Exclusive=No; SourceType=DBF;SourceDB=h:\Temp'
>>>
Be advised that in my tests the linked server to VFP free tables that uses OLEDB provider for ODBC was considerably faster.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform