OLE DB Error with using Linked Server on FlatFile

问题:

I have the following Flatfile:

Atlanta,GA,USA
Knoxville,TN,USA
MArietta,GA,USA
Edmonton,AB,CANADA

On SQL Server 2008 i execute:

EXEC sp_addlinkedserver TEXT_LS,            
'Jet 4.0',          
'Microsoft.Jet.OLEDB.4.0',   
'C:\Users\Developer\Desktop',      
NULL,       
'Text'      

When checking the linked server with:

EXEC sp_tables_ex TEXT_LS

I recieve the following Error:

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEXT_LS" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEXT_LS".

Got an idea how to solve it, or any resources i can look up? Thank you.

回答1:

Google helps to find this link.