Please help!!! - Error in ADODB.DLL

  • Thread starter Thread starter David Schwartz
  • Start date Start date
D

David Schwartz

I have a user who is getting "Error -2147220999 - Error in the DLL" on the
line Data_Conn.Open below. I assume this error has something to do with
ADODB.DLL, but this DLL seems fine on the user's pc. The DLL is in the
folder with the EXE. Any ideas what may be causing this?

Thanks!



Public Data_Conn As ADODB.Connection

Data_Conn = New ADODB.Connection

Data_Conn.ConnectionString = MyConnectionString

Data_Conn.Open()
 
David Schwartz said:
I have a user who is getting "Error -2147220999 - Error in the DLL" on the
line Data_Conn.Open below. I assume this error has something to do with
ADODB.DLL, but this DLL seems fine on the user's pc. The DLL is in the
folder with the EXE. Any ideas what may be causing this?
Click to expand...

Why not turn to ASP.NET?
 
David,
What is "ADODB.DLL"? to the best of my knowledge it is not part of ADO or
ADO.NET per se.

If you are referring to the ADODB Interop assembly, that should be installed
in the GAC when you install the .NET framework, which means it does not
belong in the folder with the EXE.

As Herfried asked, why not use ADO.NET?

Hope this helps
Jay
 
My project has a reference to ADODB.DLL (ADO 2.5) and this file gets
installed by InstallShield into my application folder.

I haven't upgraded to ADO.NET for a few reasons:

1) My app has a ton of database code that I don't want to mess with.
2) All of the database code is working perfectly - if it ain't broke,
don't fix it!
3) Only 1 out of 5000 users is experiencing this problem with
ADODB.DLL.

What might cause this error?
 
David,
My project has a reference to ADODB.DLL (ADO 2.5) and this file gets
installed by InstallShield into my application folder.
Click to expand...
Sounds like a bug in InstallShield! As ADODB has a PIA registered in the
GAC, there should not be an IA in your application folder!

Is there a reason you are using ADO 2.5 over version ADO 2.7. ADO 2.7 is the
version that .NET expects.

In either case: When I set a reference to either ADO 2.5 or ADO 2.7 in
VS.NET 2003 I actually get a reference to the PIA in the GAC. Seeing as this
PIA is preinstalled with the Framework, any install program I write does not
need to bother with ADODB.DLL.

PIA = Primary Interop Assembly
IA = Interop Assembly

Hope this helps
Jay
 
Back
Top