Dak te uiti 6 posturi mai sus ai sa observi ca erorile nu sunt de securitate ! Am drepturi depline .... serverul este pe o masina virtuala creata de mine !

 Deci , revin cu intrebarea :: am un fisier import.dbf in c:\Temp si vreau sa l import intr o BD Teste in SQL Server 2005 !! AM rulat ::

sp_configure 'show advanced options', 1;
GO
reconfigure;
go
sp_configure 'Ad Hoc Distributed Queries',1;
go
reconfigure;
go

SELECT * FROM OPENROWSET(
   'MSDASQL',
   'Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\Temp\',
   'Select * from import');

 
si am obtinut ::

Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "(null)".

 
Imi poate spune cineva unde gresesc ?? Nu a mai fakut nimeni un astfel de import ??

 
Merci !