elham_azizi_62 (9/27/2011)
hello all.I use this script for export query result to existing dbf file :
insert into openrowset ('MSDASQL','Driver=Microsoft Visual FoxPro Driver; SourceType=DBF; SourceDB=c:\Temp','select * from dskwor00')
select * from test
but get error:
OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".
I use windows server 2008 and sql server 2008.what Do I do for solve this error?
have a look at this link - basically the drivers are not pre-installed on 64 bit windows
MVDBA