C# .NET - jet ole db

Asked By john son
18-Jan-10 03:54 AM
Hi all,
 In window application,when i try to make connection on access ,Jet ole db not registered in the local machine error occurs....
In web application,this error doesn't arise..........
My environment is vista,visual studio 2005
Is any soln?

Thanks in advance

re  re

18-Jan-10 04:03 AM

There could be many reason for this

1) You are using 64 bit version and there are no 64 bit drivers for oledb

2) the appropriate dlls might not have registered in the machine

3) As you said its working in web but not windows, your IIS might be running under 32 bit but your wiondows on 64 bit

check this http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/45aa44dd-0e6f-42e5-a9d6-9be5c5c8fcd1 which gives more info on the above said and other issues as well..

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/45aa44dd-0e6f-42e5-a9d6-9be5c5c8fcd1 

Here you need latest oleDB Provider  Here you need latest oleDB Provider

18-Jan-10 05:10 AM

Please get the latest oleDB provider from here

http://support.microsoft.com/default.aspx/kb/239114 

Use regsvr32 to register them. 

if you want some examples regarding it use http://support.microsoft.com/kb/278604.

 How to keep a Jet 4.0 database in top working condition:

http://support.microsoft.com/kb/303528

jet ole db  jet ole db

21-Jan-10 03:10 AM
Hi all,
           Thanks for all ur replies...The thread given was useful..by changing target cpu to x86,i resolved that prob...


Thanks all
cheers!!  cheers!!
21-Jan-10 03:11 AM
end of post
Create New Account
help
error database not connected when enter new data in access database Hi, , Good Morning every body . . In my asp.net project, i can login, edit, change password but when enter a new data in ms access then display msg database not connected . . kindly give me proper solution ASAP. . Note:i give full access from security 2 10600 Are you sure you want to permanently delete the selected relationship from your database?@92 10601 A relationship already exists.@Do you want to edit the existing relationship? To 10606 You can't display queries or linked tables in the Relationships window for this database.@The database ' | ' was created in an earlier version of Microsoft Access.If you want to convert this database to the current version of Microsoft Access, use the Convert Database command on the Tools menu (Database Utilities submenu). 10607 The relationship has been created as
NET? (I) How do I send email message from ASP.NET? (A)What are different IIS isolation levels? (A)ASP used STA threading model, what is the threading model used for you explain collation sequence in sql server? (A)How do we define collation sequence for database and tables? (A)Can we change the order in a select query with a specified ways of hosting a WCF service? (I) How do we host a WCF service in IIS? (I) what are the advantages of hosting WCF Services in IIS as compared to self-hosting? (I) what are the major differences between services and Web which crystal report uses? (B) Can you explain reporting services architecture? (B) We have two IIS application ‘Reports’ and ‘Reportserver’ what do they do ? (A) Can you explain Report definition language RecordSet looks like a single table. If a RecordSet is to contain data from multiple database tables, it must use a JOIN query, which assembles the data from the various database tables into a single result table. In contrast, a dataset is a collection of one called data tables; specifically, they are DataTable objects. If a dataset contains data from multiple database tables, it will typically contain multiple DataTable objects. That is, each DataTable object typically corresponds
net ADO is designed primarily for connected access ADO.net the disconnected access to the database is used In ADO you communicate with the database by making calls to an OLE DB provider. In ADO.NET you communicate with the database through a data adapter (an OleDbDataAdapter, SqlDataAdapter, OdbcDataAdapter, or OracleDataAdapter object), which makes calls to or the APIs provided by the underlying data source. In ADO you cant update the database from the recordset. ADO.NET the data adapter allows you to control how the changes to the dataset are transmitted to the database. On order to get assembly info which namespace we should import? System.Reflection Namespace How tab”) This will fill the dataset with the records starting at 5 to 15 .NET Database interview questions How do you call and execute a Stored Procedure in.NET? Give an Cookie state View state. Explain differences between ADO and DAO. dao- can access only access database ado- can access any databases How many types of cookies are there? 2 types, persistant supported on Windows XP and Windows 2000. Windows 98 / ME cannot be used for development. IIS is not supported on Windows XP Home Edition, and so cannot be used to host
Session State in a SQL Server Database Please, I'm using StateServer with SQL Server. I discovered that when assigning a value cannot be used effectively in Web farm scenarios Let me discuss these problems in a bit of detail so that you can appreciate your choice of a session store. Session variables memory of a machine dedicated to storing session variables (state server) In an SQL Server database The first mode is the default. Modes 2 and 3 are often called "out-of architecture can very easily access the session variables because they are stores in an independent database. Reliability: Because the data is physically persisted in a database, it is is more reliable than the other options. It has the ability to survive file. Notes: In Web farm scenarios, the application path of the Web site in the IIS metabase should be identical in all the Web servers in the Web farm. Session_End event SQL Server: Temporary storage: In this case, the session state is stored in the "tempdb" database of SQL Server. The tool creates a database called ASPState and adds certain stored procedures for managing session to it. The tool also
computer, too, but much of its benefits would be lost. However, as we discuss a bit later in the chapter, SharePoint can provide some benefits on a peer-to-peer network application servers to provide web content and MOSS services, such as search and indexing ■ A database server running Microsoft SQL Server (optional) ■ A server supporting IIS and MOSS ■ A medium MOSS server farm consists of the following: ■ An MOSS application server One or more front-end servers to provide IIS and MOSS services, such as indexing and Excel calculation ■ A front-end web server ■ A database server running Microsoft SQL Server (optional) ■ A large MOSS server farm consists of the following Multiple load-balanced front-end web servers providing IIS and MOSS services ■ Multiple applications servers supporting specific MOSS applications or services ■ At least two clustered database servers running Microsoft SQL Server MOSS requires that each of the web servers in the These services are required to support Web Parts and Web Parts pages. Install and Configure IIS When Windows Server 2003 is installed, IIS is not installed nor enabled automatically. Therefore, you