Misledman
asked on
PDW....ADO 2.5... Error 13 Type Mismatch
I have a reference to ADO 2.5 in an ActiveX Dll project. The project works fine on my development machine. When I install it with the client program on another machine I get "Error 13 - Type Mismatch" on client startup (Form Load). I think it has something to do with ADO. For example, using Access 97, I do not have ADO 2.5 when I look at my available references. I only have ADO 2.1. My research has led me to believe that the problem is coming from trying to pass a recordset from the Dll to the Client UI (I'm trying to fill a combo in form load ie. Datasource = Recordset). Also, when I run the setup program on the target machine, I see it installing Data Access Components but it clearly says 2.1 as opposed to 2.5. Do I have to manually install ADO 2.5? Will installing IE 5 fix the problem? I'd really like to know the "whys" involved here. Thanks in advance.......
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually, I think I have a handle on it. Service pack 3 installs ADO 2.5. My target machines don't have it. PDW doesn't install ADO 2.5. It evidently installs ADO 2.1. I sure would like to to why (If I'm right). I'm currently trying to get the files on a CD so I can take it to the Target machine and install it there. I hope that solves it. However, if anyone knows how I can get the PDW to do it for me I would appreciate it and award the points. Such as, which files to include with PDW? The reference to ADO 2.5 in VB shows the file name to be "msado15". PDW shows me using MDAC_TYP.exe which is the program that installs ADO. Which files show I manually change/include?
ASKER
Thanks Tim. I was just gonna check where PDW gets MDAC_typ from and try that. If it works, I'll award you the points and I suspect it will. Looks to me like that installing ADO 2.5 would have handled that for me. May have to give Bill a reprimand. LOL
ASKER
That took a lot of doing but I think it will work. When ran SETUP with the proper MDAC_TYP.EXE it still did not take (On a win 95 system). I ran it manually and got an error. I ran it in safe mode, rebooted, and problem solved. That was on my laptop which has VB 6 on it but didn't have ADO 2.5. I'm sure it will work on my other target systems. Thanks..........
Go under Project reference. Look through the list. You should see Microsoft ActiveX Data Objects. There seem to be many version. Maybe, you are referencing either not all or the wrong one.
Another thing to try would be installing DCOM98.