Error on connecting to database, after installing into a new machine

[bzac]

I have created a package and deployed into a zip drive for installing it into a windows 98SE machine using VB-Package & Deployement Wizard.
Program is in VB6 and database using access-Jet4-AD02.5

Installation works fine but after installing shows:-
"Error on connecting to database"
err.number - err #2147467259
err.source - "Microsoft Jet Database Engine"
.Sql State - 3044
.native error - 534774783

Please help me

 

[edderic]

To resolve this problem, do one of the following:



Install Visual Studio Service Pack 4.


For ADO (or the ADO Data Control), use the "Microsoft.Jet.OLEDB.4.0" provider.


For DAO, go to Project menu, and choose References to use the "Microsoft DAO 3.6 Object Library."


If you use the generic Data-Control, you need to open a DAO 3.6 recordset and then assign it to be the source of the Data Control as follows:


Option Explicit
Private daoDB36 As Database
Private rs As DAO.Recordset
Dim sPath As String

Private Sub Form_Load()
sPath = _
"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"
Set daoDB36 = DBEngine(0).OpenDatabase(sPath)
Set rs = daoDB36.OpenRecordset("Customers&quot
Set Data1.Recordset = rs
End Sub
This problem has been addressed by Visual Basic Service Pack 4. A new value (Access 2000) has been added for the Connect property that will allow the DAO Data Control to open Access 2000 databases.
Eric De Decker
vbg.be@vbgroup.nl

License And Copy Protection AxtiveX.

Download Demo version on my Site:

http://www.createsoftware2000.com