Access 2003 connection in window 7 64 bit

Question

0.00/5 (No votes)

See more:

I have one application.which is made in vb.net using microsoft access 2003 database. i make setup and try to install it in window 7 64 bit .it install successful but database connection not occurred.
it given below error.

 Exception Text **************
System.Runtime.InteropServices.COMException (0x800A0E7A): Provider cannot be found. It may not be properly installed.
   at ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options)
   at JyothiInventory.MainForm.MainForm_Load(Object sender, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
JyothiInventory
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/Program%20Files%20(x86)/Diamond%20Computers/JyothiIMS/JyothiInventory.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Runtime.Remoting/2.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
ADODB
    Assembly Version: 7.0.3300.0
    Win32 Version: 7.10.2346
    CodeBase: file:///C:/Windows/assembly/GAC/ADODB/7.0.3300.0__b03f5f7f11d50a3a/ADODB.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.5420 (Win7SP1.050727-5400)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

there are any solution for it ?

Posted 10-Sep-13 23:04pm

Archit Patel

Updated 10-Sep-13 23:11pm

v4

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

E.F. Nijboer · Answer 1 · 2013-09-10T23:13:00

Solution 1

As the error says, you need the provider. Try installing this and have another try (it is the 2007 version but compatible with 2003):
http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734[^]

Good luck!

Posted 10-Sep-13 23:13pm

E.F. Nijboer

Comments

[no name] 11-Sep-13 5:32am

thank you for answer. but it's not working :-(

E.F. Nijboer 11-Sep-13 5:49am

Have you read the install instructions and changed the ConnectionString as explained?

[no name] 11-Sep-13 5:36am

i try to install application in window 7 64bit

murkalkiran · Answer 2 · 2013-09-10T23:39:00

Solution 2

Build u r application in platform target select X86 option

and copy crystal report s/w to system wow folder

Posted 10-Sep-13 23:39pm

murkalkiran

Comments

[no name] 11-Sep-13 5:41am

i have no source code at this time to build it.

murkalkiran · Answer 3 · 2013-09-11T00:41:00

1. Go to C:\WINDOWS\systemWOW folder.
2. Double click on the odbcad32.exe
3. Click on the add button. Select Microsoft.mdb file. Click on finish.
4. Give data source name. Click on select, browse the drive in which software has been installed and select database.
5. Click on advance button. Give login name and password. Click OK button.

try this steeps and let me kw

murkalkiran · Answer 4 · 2013-09-10T23:50:00

Solution 3

tel me
1> r u able to install the s/w?
2>r u using the crystal reports in u r s/w?