Get error, When I create view to read Foxpro DBF file for manage table in SQL Server

0
votes

I try to read Foxpro DBF files with Microsoft SQL Server 2012 i use this query

CREATE VIEW DBF_out
AS
SELECT * FROM OPENROWSET('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceDB=C:\Data;SourceType=DBF','SELECT * FROM out')

Then i get error below

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, Procedure DBF_out, Line 3 Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

Previously i execute this

sp_configure 'show advanced options' 1  reconfigure go

sp_configure 'Ad Hoc Distributed Queries',1 RECONFIGURE

how to fix this issue?

1
sql-servervisual-foxpro

1 Answers

0
votes

You have to enclose driver name in curly brackets, like this:

Driver={Microsoft Visual FoxPro Driver}

Source: connectionstrings.com

This driver may not work in 64bit environments however.