I have a program written in VB6 on a NT 4.0 machine. It gets data from
2 different access databases, and writes some additional info to a 3rd
access database. I have the program running beautifully on my machine,
no problems. When I used the Package and Deployment wizard to create a
setup.exe file it works great. Will install on a users machine (with
NT 4.0) fine, but when you try to execute the program you get an
error "3706 Provider cannot be found and cannot be installed". I am
not a network guy or even a great programmer, and am really stumped.
Here is a section of my VB6 Program that access the database if this
helps at all:
Dim dbProj As ADODB.Connection
Set dbProj = New Connection
dbProj.CursorLocation = adUseClient
dbProj.Open "PROVIDER=Microsoft.Jet.OLEDB.3.51;Data Source=\\Pnrt001
Set rsproj = New Recordset
rsproj.Open "select Project_ID from Project where IsObsolete =
False", dbProj, adOpenStatic, adLockReadOnly
Set dataProjNum.RowSource = rsproj
dataProjNum.BoundColumn = "Project_ID"
dataProjNum.ListField = "Project_ID"
Sent via Deja.com