Jet 4.0 Driver - C# / C Sharp

Johnny

Hi all:

I am writing a little demo that imports data from Excel into CRM and am
trying to use the Microsoft.Jet.O LE DB4.0 provider, but I am getting an
error message:

Error: System.InvalidO perationExcepti on: The 'Microsoft.Jet. OLE DB.4.0'
provider is not registered on the local machine.

I got this error on both a Vista machine and a WS 2003 SP 2 x64 machine.

I have searched all over the Microsoft web site but have been unable to find
a download for this driver. I have found sites that have service packs for
Jet, but do I not first have to install the original driver itself before
trying to apply a service pack?

Does anyone know where I can find the driver?

Thanks.

--
John.

http://mscrmguy.blogspot.com/

Jun 25 '07 #1

Subscribe Reply

2332

Mark Rae

"Johnny" <js********@hot mial.comwrote in message
news:9F******** *************** ***********@mic rosoft.com...

Error: System.InvalidO perationExcepti on: The 'Microsoft.Jet. OLE DB.4.0'
provider is not registered on the local machine.

I got this error on both a Vista machine and a WS 2003 SP 2 x64 machine.

Presumably the Vista machine is also 64-bit Vista...?

Does anyone know where I can find the driver?

There aren't any 64-bit OleDb drivers for anything other than SQL Server.

You will need to force your app to compile to 32-bit (x86) code -
thereafter, everything should work as you expect...

Also, be aware that Jet has been deprecated for quite a while - there are no
plans to port it to 64-bit:
http://forums.microsoft.com/MSDN/Sho...64293&SiteID=1
--
http://www.markrae.net

Jun 25 '07 #2

Chris Nahr

On Mon, 25 Jun 2007 21:06:51 +0100, "Mark Rae"
<ma**@markNOSPA Mrae.netwrote:

>Also, be aware that Jet has been deprecated for quite a while - there are no
plans to port it to 64-bit:
http://forums.microsoft.com/MSDN/Sho...64293&SiteID=1

That's Microsoft doublespeak for "we can't figure out how to
coordinate our teams". The supposedly "deprecated " Jet engine is
still the default database engine for Access 2007! If they want
people to migrate to SQL someone should tell the Office team...
--
http://www.kynosarges.de

Jun 26 '07 #3

Mark Rae

"Chris Nahr" <di******@kynos arges.dewrote in message
news:jb******** *************** *********@4ax.c om...

The supposedly "deprecated " Jet engine

There's nothing supposed about it:
http://msdn2.microsoft.com/en-us/library/ms810810.aspx

Specifically: "Jet: Starting with version 2.6, MDAC no longer contains Jet
components. In other words, MDAC 2.6, 2.7, 2.8, and all future MDAC releases
do not contain Microsoft Jet, Microsoft Jet OLE DB Provider, or the ODBC
Desktop Database Drivers."

is still the default database engine for Access 2007!

No it isn't. Open up Access 2007 and create a new database - by default it
will be in the new (*.accdb) format.

http://office.microsoft.com/en-us/ac...678311033.aspx
--
http://www.markrae.net

Jun 26 '07 #4

Chris Nahr

On Tue, 26 Jun 2007 12:20:14 +0100, "Mark Rae"
<ma**@markNOSPA Mrae.netwrote:

>No it isn't. Open up Access 2007 and create a new database - by default it
will be in the new (*.accdb) format.

http://office.microsoft.com/en-us/ac...678311033.aspx

Which is still based on Jet, and likewise unavailable to 64-bit
applications. From the same page:

"In Office Access 2007, the Microsoft Jet database engine has been
customized for 2007 Microsoft Office system programs. This
Office-specific version of Jet, called the Access Database Engine,
enables integration with Microsoft Windows SharePoint Services 3.0 and
Microsoft Office Outlook 2007 and creation of multivalued lookup
fields and makes other improvements."

The new database engine for developers is supposed to be SQL Server
which _is_ available in 64-bit versions. Why doesn't the Office team
migrate to this format?
--
http://www.kynosarges.de

Jun 26 '07 #5

Mark Rae

"Chris Nahr" <di******@kynos arges.dewrote in message
news:cu******** *************** *********@4ax.c om...

>>No it isn't. Open up Access 2007 and create a new database - by default it
will be in the new (*.accdb) format.

http://office.microsoft.com/en-us/ac...678311033.aspx

Which is still based on Jet

It may be *based* on Jet, but it *isn't* Jet - Jet's gone...
--
http://www.markrae.net

Jun 26 '07 #6

Joel Lucsy

Mark Rae wrote:

"Chris Nahr" <di******@kynos arges.dewrote in message
news:cu******** *************** *********@4ax.c om...

>>No it isn't. Open up Access 2007 and create a new database - by
default it
will be in the new (*.accdb) format.

http://office.microsoft.com/en-us/ac...678311033.aspx

Which is still based on Jet

It may be *based* on Jet, but it *isn't* Jet - Jet's gone...

For those interested,
http://blogs.msdn.com/access/archive...13/480870.aspx

--
Joel Lucsy
"The dinosaurs became extinct because they didn't have a space program."
-- Larry Niven

Jun 26 '07 #7

Similar topics

4929

DB2 driver for windows

by: Philip | last post by:

Hi, i'am looking for a db2 driver for windows the DB2 servers runs on as400 if that makes any difference. Thanks, Philip

Python

2093

I am seeking info on Display Driver Management Layer (DDML)...

by: Jim Hubbard | last post by:

My own searches have proven to be of little help in understanding the implementation of this technology (available since Win98). Any information that you could share on Display Driver Management Layer (DDML) usage would be greatly appreciated. Jim Hubbard

.NET Framework

1221

delete service cause driver uninstalled

by: CS Loh | last post by:

Hi, I install a filter driver through INF file to a 3rd party audio device (with driver). The filter driver works well on the 3rd party driver. However upon uninstallation of the filter driver, it will eventually cause the audio driver get uninstalled as well. Here are the steps to uninstall the filter driver: 1. Disable the target audio device. 2. Delete the filter name from "Upperfilters" key of the audio device in

.NET Framework

3085

DB2 v 8.1 universal JDBC Driver Weird behavior in WSAD 5.1.x and WAS 5.0.2

by: Bing | last post by:

Hi, I am configuring the same DB2 v8.1 JDBC universal driver (db2jcc.jar and db2jcc_license_cisuz.jar) from DB2 SP5 fix pack under WSAD 5.1.x environment and WebSphere application Server 5.0.2 on Windows 2000 machines. I configured a connection pool data source using type 4 for a local test environment in WSAD 5.1.x, and a connection pool data source on the WebSphere Server too. Both data sources are accessing the same database.

DB2 Database

3766

Universal JDBC Driver ....

by: Raquel | last post by:

Read this about the Universal JDBC Driver.... "In a Type 2 mode, the Universal JDBC driver provides local application performance gains (because it avoids using TCP/IP protocol to communicate to the DB2 server). " Wht does it mean by "local" application performance? In type 2 mode, it is a pre-requisite that all the databases that the application running at the client need to be cataloged (through CCA or otherwise) on the client; Most...

DB2 Database

15405

Tomcat DB2 connection - No suitable driver

by: Andrew Johnson | last post by:

Hi, I am trying to make a UBD DB2 7.2 connection using the Java COM.ibm.db2.jdbc.app.DB2Driver via Tomcat 3.2.1 on Solaris (and also on an AIX system with 3.3.1). I am attempting this either via JSP or a servlet. I have a separate java application that I can run from the command line and as long as the user has the correct env variables:

DB2 Database

27060

java.sql.SQLException: No suitable driver when connecting to a DB2 database using driver COM.ibm.db2.jdbc.DB2XADataSource

by: Rakesh | last post by:

Hi, I want to get connection to a DB2 database using the driver COM.ibm.db2.jdbc.DB2XADataSource. I have also included 'db2java.zip' in the classpath. However I am getting the exception java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at Conn.main(Conn.java:44)

DB2 Database

13774

Is C# support load device driver?

by: Steve | last post by:

I wrote a simple virtual device driver int15.sys, Is C# support load the device driver from AP?

C# / C Sharp

5952

Listening for event call from device driver using WaitForMultipleObjects

by: bb | last post by:

I have a windows network device driver written in c++ and a user interface im porting to c#, my problem is i dont seem to be getting notified of the event calls from the driver to the c# app im using the following code in c# in the UI to create an event public static IntPtr OpenGrantedPacketEvent() { IntPtr objDriver = Driver.OpenDriver(); IntPtr objEvent = Win32.CreateEvent(IntPtr.Zero, false, false,

C# / C Sharp

12069

ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xffc Thread 0x228 DBC 0x437b94 Jet'. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr

by: bazzer | last post by:

hey, im trying to access a microsoft access database from an ASP.NET web application in visual basic 2003.NET. i get the following error when i try running it: Server Error in '/CinemaBookingSystem' Application. -------------------------------------------------------------------------------- ERROR General error Unable to open registry key 'Temporary (volatile) Jet DSN for process

ASP.NET

9685

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9536

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10245

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10021

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7559

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6802

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5458

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5582

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4131

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp