Distribution problems

[cheryl]

My app works fine when installed on my own pc but on any other gets an error
-2147220991 'Connection Error'.

I'm on vb6.0, using Access 97, ADO 2.1. For the provider I've tried using
Jet 3.51 OLE DB, Jet 4.0 OLE DB and OLE DB Provider for ODBD Drivers in data
environments and typed in code; again all methods work on my pc.

On the 'other' pc I've installed mdac_typ.exe, jet35sp3.exe, jet40sp3.exe
(if it seems like I'm grasping for straws well.....) none of which allowed
me to connect to the database on the network.

Private Sub Class_Initialize()
On Error GoTo ConnectError

Set cn = New ADODB.Connection
cn.ConnectionString = deCatConnect.CatConnection
cn.Open
Exit Sub
ConnectError:
Err.Raise vbObjectError + 512 + 1, "cEventTypes", "Connection Error!!"
End Sub

Provider in the data environment when OLE DB was used:

Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=MS
Access 97 Database;DBQ=\\machinename\catdb.mdb;DefaultDir=\\machinename;DriverId=281;FIL=MS
Access;FILEDSN=C:\Program Files\Common Files\ODBC\Data Sources\MS Access
97 Database (not sharable).dsn;MaxBufferSize=2048;PageTimeout=5;UID=admin;"

Any advice would be appreciated.

cheryl

[Phil Weber]

Cheryl: If the target PC is running Windows 9x, you must install DCOM9x
before you can successfully install MDAC_TYP.EXE. You can download the
latest versions of DCOM95 and 98 from
http://www.microsoft.com/com/resources/downloads.asp . For information on
the differences between these two files, see the following article in the
Microsoft Knowledge Base:

INFO: Differences Between DCOM95 and DCOM98
( http://support.microsoft.com/support.../q198/6/00.asp )

---
Phil Weber

[cheryl]

Phil:
I installed DCOM98.exe as suggested but got same error; even tried all 3
providers (Jet 3.51, Jet 4.0 and OLEDB for ODBC drivers). This was all done
after reinstalling MDAC_TYP.EXE version 2.0. Reinstalled MDAC.TYP.EXE version
2.1, again tried all 3 providers and still got the same error.

What next?????

Thanks
cheryl

[Phil Weber]

> What next?

Cheryl: Call MS tech support?
---
Phil Weber

[cheryl]

"Phil Weber" <pweber@teleport.com> wrote:
> > What next?
>
>Cheryl: Call MS tech support?
>---
>Phil Weber
>
>

Phil: Before I do that, I want to try a different approach, as if I was
starting over.

If I'm using vb6.0, Access 97, ADO 2.1, win98, what (under normal circumstances)
would I need to install on the client's pc (including versions please)?

[Phil Weber]

> If I'm using VB6, Access 97, ADO 2.1, Win98, what
> (under normal circumstances) would I need to install
> on the client's PC (including versions please)?

Cheryl: I really don't know, offhand. I generally rely on a reputable setup
program (Visual Studio Installer, InstallShield Express, Wise InstallMaker,
etc.) to determine my apps' dependencies.
---
Phil Weber