ADO.NET - Error: E_UNEXPECTED(0x8000FFFF)

[SteveShanks]

Hi all

I have a vb.net 2003 app on v1.1 framework that runs on all computers except one. I get error E_UNEXPECTED(0x8000FFFF) No error information avilable when I try and open a connection to the Access 2000 database with OLEDB

e.g
-------------------------------------------
Dim dbConnection As OleDb.OleDbConnection
Dim strConnectionString As String = ""

strConnectionString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & strDBpath & ";Jet OLEDBatabase Password =;"

dbConnection = New OleDbConnection(strConnectionString)

dbConnection.Open()
-------------------------------------------

Then I get the error E_UNEXPECTED(0x8000FFFF)

This code works on all other machines and I can't find asolution to it anywhere!

Any help much apprieciated

Thanks
Steve

 

[PGoRule]

What location this error appears in the code?
Have you tried with Try-Catch blocks around the code?
Is this error happens frequenly, all the time or sometimes?

Sharing the best from my side...

--Prashant--

 

[SteveShanks]

Hi
The error occurs on this line
dbConnection.Open()

and happens everytime on this one particular machine, every other machine it is installed on works fine for all database access

My original code has Try-Catch blocks that catch the error ok

Thanks
Steve

 

[PGoRule]

Can you try the same by using ODBC for that machine?
Because there is no sure and perfect solution for this problem as the error is unexpected so no info is available on that part. It could be problem with Active Directory, Connection Pooling, TCP...
If you try implementing ODBC, atleast you will get some clue for it.

Sharing the best from my side...

--Prashant--

 

[SteveShanks]

Thanks, I will give it a go and see what happens with ODBC

Cheers
Steve

 

[chrissie1]

Could it be that the directory is readonly for that user and/or that machine?

Christiaan Baes
Belgium

"My new site" - Me

 

[SteveShanks]

An update...

It's still a problem.

I have tried the same code using ODBC and same problem. As for the direc tory permsissions, I am able to browse to that directory and copy/edit/delete files from it no problem

Any other thoughts?

I should have noted before that the first error that comes up but only once is:

REGDB_E_CLASSNOTREG(0x80040154)

Getting desperate now...

Many Thanks
Steve