Results 1 to 2 of 2

Thread: ADO + COM

  1. Dec 5th, 2000, 03:51 AM #1
    Chris
    Chris is offline

    Thread Starter
    PowerPoster Chris's Avatar
    Join Date
    Jan 1999
    Location
    K-PAX
    Posts
    3,238

    Unhappy

    Can anybody help?
    I use the following syntax in my COM object to connect MS Access 2000 database
    Code:
    'conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyDB.mdb"
    Yet, I always encounter the following error
    Error: 430 No such interface supported

    But, When I try to connect a SQL database, everything is file. My question is, it is MTS does not support Acess database transaction?
    My Virtual Home - My Blog
    Reply With Quote Reply With Quote
  2. Dec 5th, 2000, 04:39 AM #2
    Chris
    Chris is offline

    Thread Starter
    PowerPoster Chris's Avatar
    Join Date
    Jan 1999
    Location
    K-PAX
    Posts
    3,238

    Unhappy System DSN

    I juz resolve this by create a System DSN. Why, for MS Access database we need to use the System DSN and can not direct use the Provider properties like

    Code:
    conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\MyDB.mdb"
    My Virtual Home - My Blog
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width