September 27, 2011 at 12:42 am
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?
September 27, 2011 at 1:03 am
firstly ,make sure you have the full control permission of this folder
May 11, 2012 at 5:10 am
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
August 20, 2014 at 12:23 am
may be this link would helpful for you
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply