Tjyylli

Why did Israel vote against lifting the American embargo on Cuba?

Will I be more secure with my own router behind my ISP's router?

Is a self contained air-bullet cartridge feasible?

In search of the origins of term censor, I hit a dead end stuck with the greek term, to censor, λογοκρίνω

What is a good proxy for government quality?

Does using the Inspiration rules for character defects encourage My Guy Syndrome?

How would it unbalance gameplay to rule that Weapon Master allows for picking a fighting style?

France's Public Holidays' Puzzle

What does the black goddess statue do and what is it?

What were wait-states, and why was it only an issue for PCs?

What's called a person who works as someone who puts products on shelves in stores?

"Working on a knee"

Marquee sign letters

Putting Ant-Man on house arrest

Married in secret, can marital status in passport be changed at a later date?

What is the definining line between a helicopter and a drone a person can ride in?

Will I lose my paid in full property

TV series episode where humans nuke aliens before decrypting their message that states they come in peace

Could a cockatrice have parasitic embryos?

What's parked in Mil Moscow helicopter plant?

When I export an AI 300x60 art board it saves with bigger dimensions

How was Lagrange appointed professor of mathematics so early?

Where to find documentation for `whois` command options?

How would you suggest I follow up with coworkers about our deadline that's today?

SQL Server 2012 Connecting to MS Access 2003

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

3

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something.

I just installed SQL Server 2012 to test differences and make sure it is ok for my Work. I may not be a pro at SQL, but I don't see how to add a Link to Jet database on my server. I have imported Jet Databases, but when going thru the GUI to Link a JET Database I see no Provider for JET. I am running Access 2003 (I don't like the 2008+ GUI)

I searched an found nothing similar to my issue; at least nothing I understood. Nothing mentioned how to add Jet db Provider.

I ran a connection string to the Jet Database thru QA:

sp_addlinkedserver 'USGEScrub', 'Access', 'Microsoft.Jet.OLEDB.4.0',  

'D:Lead$SupListUSGEScrub.mdb' 

The connection string works till I try to access the data and then I get this the error and of course if I click the links nothing shows up:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlinkProdName=Microsoft%20SQL%20Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked
server "USGEScrub". (Microsoft SQL Server, Error: 7302)

For help, click: http://go.microsoft.com/fwlinkProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=7302&LinkId=20476

microsoft-access sql-server

share|improve this question

edited Aug 13 '13 at 7:05

Journeyman Geek♦

113k44219373

asked Jun 25 '12 at 21:26

CrazydCrazyd

29412

bumped to the homepage by Community♦ 11 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

3

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something.

I just installed SQL Server 2012 to test differences and make sure it is ok for my Work. I may not be a pro at SQL, but I don't see how to add a Link to Jet database on my server. I have imported Jet Databases, but when going thru the GUI to Link a JET Database I see no Provider for JET. I am running Access 2003 (I don't like the 2008+ GUI)

I searched an found nothing similar to my issue; at least nothing I understood. Nothing mentioned how to add Jet db Provider.

I ran a connection string to the Jet Database thru QA:

sp_addlinkedserver 'USGEScrub', 'Access', 'Microsoft.Jet.OLEDB.4.0',  

'D:Lead$SupListUSGEScrub.mdb' 

The connection string works till I try to access the data and then I get this the error and of course if I click the links nothing shows up:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlinkProdName=Microsoft%20SQL%20Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked
server "USGEScrub". (Microsoft SQL Server, Error: 7302)

For help, click: http://go.microsoft.com/fwlinkProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=7302&LinkId=20476

microsoft-access sql-server

share|improve this question

edited Aug 13 '13 at 7:05

Journeyman Geek♦

113k44219373

asked Jun 25 '12 at 21:26

CrazydCrazyd

29412

bumped to the homepage by Community♦ 11 hours ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something.

I just installed SQL Server 2012 to test differences and make sure it is ok for my Work. I may not be a pro at SQL, but I don't see how to add a Link to Jet database on my server. I have imported Jet Databases, but when going thru the GUI to Link a JET Database I see no Provider for JET. I am running Access 2003 (I don't like the 2008+ GUI)

I searched an found nothing similar to my issue; at least nothing I understood. Nothing mentioned how to add Jet db Provider.

I ran a connection string to the Jet Database thru QA:

sp_addlinkedserver 'USGEScrub', 'Access', 'Microsoft.Jet.OLEDB.4.0',  

'D:Lead$SupListUSGEScrub.mdb' 

The connection string works till I try to access the data and then I get this the error and of course if I click the links nothing shows up:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlinkProdName=Microsoft%20SQL%20Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked
server "USGEScrub". (Microsoft SQL Server, Error: 7302)

For help, click: http://go.microsoft.com/fwlinkProdName=Microsoft%20SQL%20Server&ProdVer=11.00.2100&EvtSrc=MSSQLServer&EvtID=7302&LinkId=20476

microsoft-access sql-server

share|improve this question

edited Aug 13 '13 at 7:05

Journeyman Geek♦

113k44219373

asked Jun 25 '12 at 21:26

CrazydCrazyd

29412

sp_addlinkedserver 'USGEScrub', 'Access', 'Microsoft.Jet.OLEDB.4.0',  

'D:Lead$SupListUSGEScrub.mdb' 

share|improve this question

edited Aug 13 '13 at 7:05

Journeyman Geek♦

113k44219373

asked Jun 25 '12 at 21:26

CrazydCrazyd

29412

share|improve this question

edited Aug 13 '13 at 7:05

Journeyman Geek♦

113k44219373

asked Jun 25 '12 at 21:26

CrazydCrazyd

29412

edited Aug 13 '13 at 7:05

Journeyman Geek♦

113k44219373

edited Aug 13 '13 at 7:05

Journeyman Geek♦

113k44219373

asked Jun 25 '12 at 21:26

CrazydCrazyd

29412

asked Jun 25 '12 at 21:26

CrazydCrazyd

29412

1 Answer
1

active

oldest

votes

0

looks like it might be to do with the drivers.

Here is Microsoft's take on the issue: http://support.microsoft.com/kb/2555855

share|improve this answer

answered Jun 28 '12 at 18:19

SeanCSeanC

3,35421426

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});


}
});

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f441500%2fsql-server-2012-connecting-to-ms-access-2003%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

looks like it might be to do with the drivers.

Here is Microsoft's take on the issue: http://support.microsoft.com/kb/2555855

share|improve this answer

answered Jun 28 '12 at 18:19

SeanCSeanC

3,35421426

add a comment | 

0

looks like it might be to do with the drivers.

Here is Microsoft's take on the issue: http://support.microsoft.com/kb/2555855

share|improve this answer

answered Jun 28 '12 at 18:19

SeanCSeanC

3,35421426

add a comment | 

looks like it might be to do with the drivers.

Here is Microsoft's take on the issue: http://support.microsoft.com/kb/2555855

share|improve this answer

answered Jun 28 '12 at 18:19

SeanCSeanC

3,35421426

share|improve this answer

answered Jun 28 '12 at 18:19

SeanCSeanC

3,35421426

answered Jun 28 '12 at 18:19

SeanCSeanC

3,35421426

answered Jun 28 '12 at 18:19

SeanCSeanC

3,35421426