Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2011-11-02 : 02:18:07
|
| hello all.I work with sql server 2008 and windows server 2008.I configure target in odbc properties to %SystemRoot%\SysWOW64\odbcad32.exe and add microsoft visual foxpro driver in UserDSN and select free table directory and select c:\temp for this driver.now run this query:insert into openrowset ('MSDASQL','Driver={Microsoft Visual FoxPro Driver}; SourceDB=C:\Temp;SourceType=DBF','select * from dskwor00')select * from testdskwor00 is located to c:\temp.this 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 2Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".What else should I do that does not make this error?pleas help me. lili@@ |
|
|
|
|
|
foxpro odbc driver in windows server 2008