VB Aplication Working on WinXP but not Win2000

[ptiernan]

Hi

Please help I have developed an small application in VB6 that connects to an Access 97 DB using

cn = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=post_code.mdb"
strSQL = ("SELECT * FROM T_Post_Code WHERE POSTCODE='" & str4 & "'")
rs.Open strSQL, cn

In VB6 I package my application and have tested it on Win XP and it works fine but when I install the application on a Win 2000 PC I get the error.

Run-time Error '3706' Provider cannot be found. It may not be properly installed.

I am new to VB and don’t know how to install the provider on the Win 2000 machine.

Any help would be greatly appreciated.

Much Thanks
Paul Tiernan

 

[SonOfEmidec1100]

Have you installed W2000 sp4, if not I would try this as the first step. You could also try installing the latest MDAC version 2.8

 

[ptiernan]

I have installed Win 2000 sp4 and MDAC v 2.8 and this did not work.

I got it fixed my changing
Provider=Microsoft.Jet.OLEDB.3.51
to
Provider=Microsoft.Jet.OLEDB.4.0

and also Installed MDAC v 2.5 (with Jet drivers) and this worked.

Much Thanks
Paul Tiernan