Databases
StackOverflow2013
Postsdbo
POSQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
    primarykey
    data
    text
    <p>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)</p> <p>I searched an found nothing simular to my issue; at least nothing I understood. Nothing mentioned how to add Jet db Provider.</p> <p>I ran a connection string to the Jet Database thru QA:</p> <pre><code>sp_addlinkedserver 'USGEScrub', 'Access', 'Microsoft.Jet.OLEDB.4.0', 'D:\Lead$\SupList\USGEScrub.mdb' </code></pre> <p>The connection string works till I try to access the data and then I get this the errorand of course if I click the links nothing shows up:</p> <pre><code>TITLE: Microsoft SQL Server Management Studio Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) </code></pre> <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;LinkId=20476" rel="nofollow">http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;LinkId=20476</a></p> <pre><code>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) </code></pre> <p>For help, click: <a href="http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;ProdVer=11.00.2100&amp;EvtSrc=MSSQLServer&amp;EvtID=7302&amp;LinkId=20476" rel="nofollow">http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&amp;ProdVer=11.00.2100&amp;EvtSrc=MSSQLServer&amp;EvtID=7302&amp;LinkId=20476</a></p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USCrazyd
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs your app 64-bit? There's no 64-bit provider for `Microsoft.Jet.OLEDB.4.0`
      singulars
      1. POSQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
      1. USRobert Harvey
    2. COWindows 7 is 64-bit; and probably SQL is 64-bit (Don't recall), but Access is 32-bit. By App what do you mean?
      singulars
      1. POSQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
      1. USCrazyd
    3. COThis is a programming Q&A website, so I assume you wrote an application? Otherwise, your question is probably better suited for http://superuser.com
      singulars
      1. POSQL Server 2012 - Cannot create an instance of OLE DB provider "Microsoft.Jet.OLEDB.4.0" (Microsoft SQL Server, Error: 7302)
      1. USRobert Harvey
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload