VB 6 ADO distribution?

Question

I have created a program in Visual Basic that connects to a Microsoft Access Database using an ADO.

My problem is the compiled exe wont work on any computer that does not have VB installed on it. I've tried using the VB 6 package and deployment wizard that adds a bunch of dependence files with no luck. My program still crashed on non VB installed computers with the Run-time error '3706' Provider cannot be found. It may not be properly installed. What am i missing?

Answer 1

Make sure that ADO is actual part of the installation.



This includes *both* MS ActiveX Data Objects (ocx) and MDAC_Type.exe.



MS ADO (usually version 2.7 or 2.8 on Windows 200x, XP and Vista) should be included if you have the reference setup correctly. MDAC_Type is a separate part, required on PCs without the runtime libraries.



MDAC_Type download: http://support.microsoft.com/kb/q184265/

Answer 2

Follow this tutorial. It explains everything about connecting with database in Visual Basic 6.



http://www.freetutes.com/VisualBasic

Answer 3

opt for from the position = ''; Open the recordset with that string (construct it from the person enter) and show the ensuing information.