Error 0x800401F9 opening a OleDbConnection.open()

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, i've a little program in VB .NET that run fine in several desktop, but i
have others that don't work and get this exception, when execute a Open() in
a OleDBConnection to Access MDB.
The desktop have installed several version of MDAC: 7 sp1, 8, 8 sp1...
I don't find info about this error.
Can anybody help me please??
 
¤ Hi, i've a little program in VB .NET that run fine in several desktop, but i
¤ have others that don't work and get this exception, when execute a Open() in
¤ a OleDBConnection to Access MDB.
¤ The desktop have installed several version of MDAC: 7 sp1, 8, 8 sp1...
¤ I don't find info about this error.
¤ Can anybody help me please??

Can you post your connection string?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Yes of course:

BD = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\temp\datos.mdb)
 
¤ Yes of course:
¤
¤ BD = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data
¤ Source=C:\temp\datos.mdb)
¤

Other than the missing quote mark character, which I will assume is a typo, the connection string
looks OK. If this is working on other machines I would suspect there is a configuration problem.

Have you tried upgrading to the latest Jet database engine SP?

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Yes, the quote mark is copy/paste error...
Thanks for everything, i'm going to try the last jet engine.
 
I have tried upgrade to the last version of jet engine, but i get the same
error.
I have no idea, what can i do?
 
¤ I have tried upgrade to the last version of jet engine, but i get the same
¤ error.
¤ I have no idea, what can i do?
¤

Have you tried compacting and/or repairing the Access database?


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Yes, I have repaired the database. The user can open the database with
Access. He can modify data, modify desing. But the program can't open the
database.
It's very rare.
 
¤ Yes, I have repaired the database. The user can open the database with
¤ Access. He can modify data, modify desing. But the program can't open the
¤ database.
¤ It's very rare.
¤

It's possible that you may have a corrupt MDAC installation. See if the following helps:

http://www.macropool.com/en/download/mdac_xp_sp2.html

You can also use the Component Checker utility for MDAC to verify your installation.

http://www.microsoft.com/downloads/...F6-4A21-4B43-BF53-14332EF092C9&displaylang=en


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top