Information générale
Forum:
Microsoft SQL Server
Titre:
Having problem with oledb/linkedserver
I want to access VFP data from SQL-Server.
1)
declare @x int
EXEC @x = sp_addlinkedserver
@server = 'Test',
@srvproduct = '',
@provider = 'VFPOLEDB.1',
@datasrc = '\\mainserver\poy\Fox_2002\boNotify\Data'
print @x
Return 0
2) select * from sys.servers where name = 'Test'
Returns the row
3) SELECT *
FROM OPENQUERY(Test, 'SELECT * from company')
Get error:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB.1" for linked server "Test" reported an error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "VFPOLEDB.1" for linked server "Test"
4) I think I need to do a linked server login so I do:
declare @a int
EXEC @a = sp_addlinkedsrvlogin 'mark'
print @a
Returns 0
I get the same error message.
We use windows authentication for SQL Server
Any ideas?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement