DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 6 of 6

Thread: Distribution problems

  1. #1
    cheryl Guest

    Distribution problems


    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

  2. #2
    Phil Weber Guest

    Re: Distribution problems

    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



  3. #3
    cheryl Guest

    Re: Distribution problems


    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


  4. #4
    Phil Weber Guest

    Re: Distribution problems

    > What next?

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



  5. #5
    cheryl Guest

    Re: Distribution problems


    "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)?


  6. #6
    Phil Weber Guest

    Re: Distribution problems

    > 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



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center