Printable View
I am trying to access a file on an AS400 using ODBC. I was trying to use DAO but someone showed me some code on using ADO. When I put the code into effect it crash and said:
User Defined type not Defined.
on the statement:
Dim objConn as New ADODB.Connection
Do I need to add a dll or something to use ADO in VB5?
Have you added a reference to Microsoft ActiveX Data Objects 2.5 Library?
I don't have the reference to Microsoft ActiveX Data Objects 2.5, just 2.0 and 2.1. Where can I get that reference, can I download it?
Version 2.5 is pretty common, but 2.6 is out now. You can install this from a file called mdac_typ.exe, and if you have a service pack for Visual Studio, then you'll probably find it there.
Go to here and search for mdac. This will give you links for either 2.52 or 2.61.
Ok that took care of that problem but now I'm getting an error:
Provider cannot be found.
on this line of code:
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;DSN="EPA"
What does this mean?
If you downloaded ver 2.6 of the MDAC it does not include the latest Jet stuff. MS in their ultimate wisdom took the Jet stuff out of MDAC after ver 2.5. Go back to the MS Data site and get the Jet 4.0 download...
http://www.microsoft.com/data/
As seems to be the case always in programming you fix one problem and another shows its ugly face. Now that the provider error is gone I'm now getting:
Could not find Installable ISAM.
what does it mean?
First of all your line
Has two things wrong...Quote:
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;DSN="EPA"
1. The quotes are wrong remove the one before EPA.
2. You are trying to use a connection string with provider and DSN at same time you only need one or the other...
VB Code:
or
VB Code:
The DSN knows the rest of the info needed.
Thanks All that helped I was really in a Bind.