- open the import function
The exec sp_configure 'show advanced options, 1;
Reconfigure.
The exec sp_configure 'Ad Hoc Distributed Queries', 1;
Reconfigure.
- allows in use in the process of ACE. The OLEDB. 12
The EXEC master. The dbo. Sp_MSset_oledb_prop N 'Microsoft. ACE. The OLEDB. 12.0', N 'AllowInProcess' 1;
- allows dynamic parameter
The EXEC master. The dbo. Sp_MSset_oledb_prop N 'Microsoft. ACE. The OLEDB. 12.0', N 'DynamicParameters' 1;
SELECT * FROM
OPENROWSET (' 12.0 'Microsoft. ACE. The OLEDB.
, 'dBase III; HDR=NO. IMEX=2; The DATABASE=C:/zqzhsyxxwh. DBF ',
"SELECT top 1 a FROM XMBS");

After execution error: has not been registered OLE DB access interface "Microsoft. ACE. The OLEDB. 12.0, to Microsoft. Jet. The OLEDB. 4.0 so:
Because OLE DB access interface '. Microsoft Jet. The OLEDB. 4.0 'unit configured to in single-threaded mode, so the access interface cannot be used for distributed query,
Tried many ways to online, still not solved, urgent urgent,

CodePudding user response:

You install:
http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe

This have no?

CodePudding user response:

reference 1st floor yenange response:

you install:
http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe

This have no?

Ok, I am a 64 - bit,

CodePudding user response:

Well not yet?

CodePudding user response:

Change a try the opendatesource

CodePudding user response:

reference 4 floor baidu_36457652 response:

change try the opendatesource

It's no use,

CodePudding user response:

No one else wants to try?

CodePudding user response:

The

refer to the original poster islyb response:

- open the import functionThe exec sp_configure 'show advanced options, 1;
Reconfigure.
The exec sp_configure 'Ad Hoc Distributed Queries', 1;
Reconfigure.
- allows in use in the process of ACE. The OLEDB. 12
The EXEC master. The dbo. Sp_MSset_oledb_prop N 'Microsoft. ACE. The OLEDB. 12.0', N 'AllowInProcess' 1;
- allows dynamic parameter
The EXEC master. The dbo. Sp_MSset_oledb_prop N 'Microsoft. ACE. The OLEDB. 12.0', N 'DynamicParameters' 1;
SELECT * FROM
OPENROWSET (' 12.0 'Microsoft. ACE. The OLEDB.
, 'dBase III; HDR=NO. IMEX=2; The DATABASE=C:/zqzhsyxxwh. DBF ',
"SELECT top 1 a FROM XMBS");

After execution error: has not been registered OLE DB access interface "Microsoft. ACE. The OLEDB. 12.0, to Microsoft. Jet. The OLEDB. 4.0 so:
Because OLE DB access interface '. Microsoft Jet. The OLEDB. 4.0 'unit configured to in single-threaded mode, so the access interface cannot be used for distributed query,
Tried many ways to online, still not solved, urgent urgent,

You is 64, is filled with AccessDatabaseEngine_X64. Exe? Then look at access interface there are?

CodePudding user response:

I also am this problem, the whole for a long time, haven't finished, the building Lord done