General discussion

  • Creator
    Topic
  • #2082102

    VB60 – ACCESS 2000 – PROVIDER

    Locked

    by rraney ·

    I am trying to use an Access 2000 database with VB60.
    Public TheConnection as ADODB.Connection
    Set TheConnection = New ADODB.Connection
    TheConnection.CursorLocation = adUseClient
    TheConnection.Open “PROVIDER=Microsoft.Jet.OLEDB.4.0; Data Source = ;”

    Error 3706
    ADO could not find the Specified Provider

All Comments

  • Author
    Replies
    • #3896511

      VB60 – ACCESS 2000 – PROVIDER

      by rweight ·

      In reply to VB60 – ACCESS 2000 – PROVIDER

      I don’t know if you’ve already done this, but to use the OLEDB4.0 provider, you must install MDAC release 2.1 or later. VB 6.0 SP3 included MDAC 2.0, but you need 2.1. You can download MDAC 2.1 from the Microsoft data site – http://www.microsoft.com/Data/MDAC21info/manifest_intro.htm

      You can also use the MDAC 2.1 stack when using Access 97 databases as well.

    • #3896483

      VB60 – ACCESS 2000 – PROVIDER

      by whitney597 ·

      In reply to VB60 – ACCESS 2000 – PROVIDER

      Try this as your connection string:

      DRIVER=Microsoft Access Driver (*.mdb)
      UID=admin
      UserCommitSync=Yes
      Threads=3
      SafeTransactions=0
      PageTimeout=5
      MaxScanRows=8
      MaxBufferSize=2048
      FIL=MS Access
      DriverId=281
      DefaultDir= DBQ=

      You will need to insert the semicolons between items.

    • #3781382

      VB60 – ACCESS 2000 – PROVIDER

      by ckobman ·

      In reply to VB60 – ACCESS 2000 – PROVIDER

      The solution is kind of simple.
      For some reason you have to add another period at the end of the provider string.

      correct “PROVIDER=Microsoft.Jet.OLEDB.4.0.”

      wrong “PROVIDER=Microsoft.Jet.OLEDB.4.0”

      Chad Kobman
      ckobman@yahoo.com

    • #3735011

      VB60 – ACCESS 2000 – PROVIDER

      by rraney ·

      In reply to VB60 – ACCESS 2000 – PROVIDER

      This question was auto closed due to inactivity

Viewing 3 reply threads