OLE DB provider not been registered error even though it is registered
I have a 32 bit Windows 7 machine. I am trying to access an excel sheet by creating linked server in SQL Server 2012. I am getting following error.
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
When I checked the control panel's Programs And Features, the Microsoft Access Database Engine 2010 is available.
What need to be corrected to overcme this error?
SQL
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 12.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
PROVIDERS
sql-server oledb
|
show 3 more comments
I have a 32 bit Windows 7 machine. I am trying to access an excel sheet by creating linked server in SQL Server 2012. I am getting following error.
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
When I checked the control panel's Programs And Features, the Microsoft Access Database Engine 2010 is available.
What need to be corrected to overcme this error?
SQL
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 12.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
PROVIDERS
sql-server oledb
1
Reinstall? microsoft.com/en-gb/download/details.aspx?id=13255
– Alex K.
Jul 22 '13 at 15:11
1
microsoft.com/en-us/download/…
– Aaron Bertrand
Jul 22 '13 at 15:35
1
You may also need to restart SQL Server to have it pick up those providers.
– Aaron Bertrand
Jul 22 '13 at 15:36
1
I guess your SQL Server is 64 bit, so you need to install the 64 bit ACE driver on to your SQL Server driver (if it exists)
– Nick.McDermaid
Mar 18 '15 at 7:37
1
@Nick.McDermaid is probably right. Your question was posed in a way where people are assuming your SQL Server is on the 32BIT Windows 7 machine. Asside from that, using a Linked Server to connect to an Excel file is going to cause nightmares for you down the road. You will be much better off if you create an SSIS package that imports the data into SQL on a regular basis.
– Jason Geiger
Jul 5 '18 at 19:40
|
show 3 more comments
I have a 32 bit Windows 7 machine. I am trying to access an excel sheet by creating linked server in SQL Server 2012. I am getting following error.
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
When I checked the control panel's Programs And Features, the Microsoft Access Database Engine 2010 is available.
What need to be corrected to overcme this error?
SQL
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 12.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
PROVIDERS
sql-server oledb
I have a 32 bit Windows 7 machine. I am trying to access an excel sheet by creating linked server in SQL Server 2012. I am getting following error.
Msg 7403, Level 16, State 1, Line 1
The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
When I checked the control panel's Programs And Features, the Microsoft Access Database Engine 2010 is available.
What need to be corrected to overcme this error?
SQL
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.12.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 12.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
PROVIDERS
sql-server oledb
sql-server oledb
edited Mar 18 '15 at 7:26
shA.t
13k43871
13k43871
asked Jul 22 '13 at 14:01
LijoLijo
10.9k55199337
10.9k55199337
1
Reinstall? microsoft.com/en-gb/download/details.aspx?id=13255
– Alex K.
Jul 22 '13 at 15:11
1
microsoft.com/en-us/download/…
– Aaron Bertrand
Jul 22 '13 at 15:35
1
You may also need to restart SQL Server to have it pick up those providers.
– Aaron Bertrand
Jul 22 '13 at 15:36
1
I guess your SQL Server is 64 bit, so you need to install the 64 bit ACE driver on to your SQL Server driver (if it exists)
– Nick.McDermaid
Mar 18 '15 at 7:37
1
@Nick.McDermaid is probably right. Your question was posed in a way where people are assuming your SQL Server is on the 32BIT Windows 7 machine. Asside from that, using a Linked Server to connect to an Excel file is going to cause nightmares for you down the road. You will be much better off if you create an SSIS package that imports the data into SQL on a regular basis.
– Jason Geiger
Jul 5 '18 at 19:40
|
show 3 more comments
1
Reinstall? microsoft.com/en-gb/download/details.aspx?id=13255
– Alex K.
Jul 22 '13 at 15:11
1
microsoft.com/en-us/download/…
– Aaron Bertrand
Jul 22 '13 at 15:35
1
You may also need to restart SQL Server to have it pick up those providers.
– Aaron Bertrand
Jul 22 '13 at 15:36
1
I guess your SQL Server is 64 bit, so you need to install the 64 bit ACE driver on to your SQL Server driver (if it exists)
– Nick.McDermaid
Mar 18 '15 at 7:37
1
@Nick.McDermaid is probably right. Your question was posed in a way where people are assuming your SQL Server is on the 32BIT Windows 7 machine. Asside from that, using a Linked Server to connect to an Excel file is going to cause nightmares for you down the road. You will be much better off if you create an SSIS package that imports the data into SQL on a regular basis.
– Jason Geiger
Jul 5 '18 at 19:40
1
1
Reinstall? microsoft.com/en-gb/download/details.aspx?id=13255
– Alex K.
Jul 22 '13 at 15:11
Reinstall? microsoft.com/en-gb/download/details.aspx?id=13255
– Alex K.
Jul 22 '13 at 15:11
1
1
microsoft.com/en-us/download/…
– Aaron Bertrand
Jul 22 '13 at 15:35
microsoft.com/en-us/download/…
– Aaron Bertrand
Jul 22 '13 at 15:35
1
1
You may also need to restart SQL Server to have it pick up those providers.
– Aaron Bertrand
Jul 22 '13 at 15:36
You may also need to restart SQL Server to have it pick up those providers.
– Aaron Bertrand
Jul 22 '13 at 15:36
1
1
I guess your SQL Server is 64 bit, so you need to install the 64 bit ACE driver on to your SQL Server driver (if it exists)
– Nick.McDermaid
Mar 18 '15 at 7:37
I guess your SQL Server is 64 bit, so you need to install the 64 bit ACE driver on to your SQL Server driver (if it exists)
– Nick.McDermaid
Mar 18 '15 at 7:37
1
1
@Nick.McDermaid is probably right. Your question was posed in a way where people are assuming your SQL Server is on the 32BIT Windows 7 machine. Asside from that, using a Linked Server to connect to an Excel file is going to cause nightmares for you down the road. You will be much better off if you create an SSIS package that imports the data into SQL on a regular basis.
– Jason Geiger
Jul 5 '18 at 19:40
@Nick.McDermaid is probably right. Your question was posed in a way where people are assuming your SQL Server is on the 32BIT Windows 7 machine. Asside from that, using a Linked Server to connect to an Excel file is going to cause nightmares for you down the road. You will be much better off if you create an SSIS package that imports the data into SQL on a regular basis.
– Jason Geiger
Jul 5 '18 at 19:40
|
show 3 more comments
1 Answer
1
active
oldest
votes
On the server you need to install the 64bit provider from redis according to the program you will use to invoke it, in this case SQL Server which is a 64bit executable, it does not matter which provider you have installed on the local computer which is executing SSMS .
Also consider that Office11 is the internal name for Office 2003, Office12 that for Office 2007 and Office14 that for Office 2010 so likely after you installed the redis package for Office 2010 you need to change your code as following:
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.14.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 14.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f17789546%2fole-db-provider-not-been-registered-error-even-though-it-is-registered%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
On the server you need to install the 64bit provider from redis according to the program you will use to invoke it, in this case SQL Server which is a 64bit executable, it does not matter which provider you have installed on the local computer which is executing SSMS .
Also consider that Office11 is the internal name for Office 2003, Office12 that for Office 2007 and Office14 that for Office 2010 so likely after you installed the redis package for Office 2010 you need to change your code as following:
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.14.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 14.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
add a comment |
On the server you need to install the 64bit provider from redis according to the program you will use to invoke it, in this case SQL Server which is a 64bit executable, it does not matter which provider you have installed on the local computer which is executing SSMS .
Also consider that Office11 is the internal name for Office 2003, Office12 that for Office 2007 and Office14 that for Office 2010 so likely after you installed the redis package for Office 2010 you need to change your code as following:
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.14.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 14.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
add a comment |
On the server you need to install the 64bit provider from redis according to the program you will use to invoke it, in this case SQL Server which is a 64bit executable, it does not matter which provider you have installed on the local computer which is executing SSMS .
Also consider that Office11 is the internal name for Office 2003, Office12 that for Office 2007 and Office14 that for Office 2010 so likely after you installed the redis package for Office 2010 you need to change your code as following:
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.14.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 14.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
On the server you need to install the 64bit provider from redis according to the program you will use to invoke it, in this case SQL Server which is a 64bit executable, it does not matter which provider you have installed on the local computer which is executing SSMS .
Also consider that Office11 is the internal name for Office 2003, Office12 that for Office 2007 and Office14 that for Office 2010 so likely after you installed the redis package for Office 2010 you need to change your code as following:
EXEC sp_addlinkedserver
@server = 'ExcelServer2',
@srvproduct = 'Excel',
@provider = 'Microsoft.ACE.OLEDB.14.0',
@datasrc = 'D:MyFTPJul19FAILEDDCSDIM.xlsx',
@provstr = 'Excel 14.0;IMEX=1;HDR=YES;'
SELECT * FROM ExcelServer2...DCSDIM
answered Oct 23 '18 at 15:03
P. LionP. Lion
258110
258110
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f17789546%2fole-db-provider-not-been-registered-error-even-though-it-is-registered%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Reinstall? microsoft.com/en-gb/download/details.aspx?id=13255
– Alex K.
Jul 22 '13 at 15:11
1
microsoft.com/en-us/download/…
– Aaron Bertrand
Jul 22 '13 at 15:35
1
You may also need to restart SQL Server to have it pick up those providers.
– Aaron Bertrand
Jul 22 '13 at 15:36
1
I guess your SQL Server is 64 bit, so you need to install the 64 bit ACE driver on to your SQL Server driver (if it exists)
– Nick.McDermaid
Mar 18 '15 at 7:37
1
@Nick.McDermaid is probably right. Your question was posed in a way where people are assuming your SQL Server is on the 32BIT Windows 7 machine. Asside from that, using a Linked Server to connect to an Excel file is going to cause nightmares for you down the road. You will be much better off if you create an SSIS package that imports the data into SQL on a regular basis.
– Jason Geiger
Jul 5 '18 at 19:40