Results 1 to 14 of 14

Thread: Run-Time Error 3706...

  1. Feb 21st, 2002, 11:04 PM #1
    rjlohan
    rjlohan is offline

    Thread Starter
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205

    Exclamation Run-Time Error 3706...

    I am getting this error in an app using MDAC2.7.

    The detail from MSDN is this:

    Provider cannot be found. It may not be properly installed.
    What does this mean, and how do I solve it?
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    Reply With Quote Reply With Quote
  2. Feb 21st, 2002, 11:11 PM #2
    Nucleus
    Nucleus is offline
    Registered User Nucleus's Avatar
    Join Date
    Apr 2001
    Location
    So that's what you are up to ;)
    Posts
    2,530
    Good ol 3706 eh?

    You need to reformat your harddisk and go from there, if you still get an error, post again!
    Reply With Quote Reply With Quote
  3. Feb 21st, 2002, 11:18 PM #3
    gaffa
    Guest
    When you connect to to a DB using ADO, you specify the provider in the ConnectionString:
    VB Code:
    1. lobjConn.ConnectionString = "Provider=SQLOLEDB;Server=BERTHA;..."

    THe SQLOLEDB bit is the provider (which in this case is SQL Server running on the machine BERTHA). Check that string and see if it is OK.

    - gaffa
    Reply With Quote Reply With Quote
  4. Feb 22nd, 2002, 12:03 AM #4
    rjlohan
    rjlohan is offline

    Thread Starter
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205
    OK. Ta.
    Don't know why it wouldn't work though. It was but now it's not...
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    Reply With Quote Reply With Quote
  6. Feb 22nd, 2002, 12:56 AM #5
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    What OS r u using??
    Reply With Quote Reply With Quote
  7. Feb 22nd, 2002, 12:58 AM #6
    rjlohan
    rjlohan is offline

    Thread Starter
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205
    WINNT
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    Reply With Quote Reply With Quote
  8. Feb 22nd, 2002, 01:04 AM #7
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    Hangon you didnt have 2.5 correct?

    Well if you didnt the reason your getting that error is coz Mdac 2.6 and 2.7 dont contain Jet Components!
    What you need to do is go get jet4.0 and install it!

    get it here

    later
    b
    Reply With Quote Reply With Quote
  9. Feb 22nd, 2002, 01:05 AM #8
    rjlohan
    rjlohan is offline

    Thread Starter
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205
    Is Jet necessary for Access?
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    Reply With Quote Reply With Quote
  11. Feb 22nd, 2002, 01:11 AM #9
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    If you wanting to connect to it yes!
    hehehe
    Reply With Quote Reply With Quote
  12. Feb 22nd, 2002, 01:14 AM #10
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    Sorry i lied couldnt be bothered typing but figured i should!

    You could use ODBCDirect with DAO3.5 That way you could bypass Jet!
    Reply With Quote Reply With Quote
  13. Feb 24th, 2002, 04:26 PM #11
    rjlohan
    rjlohan is offline

    Thread Starter
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205
    What provider should I be using with MDAC2.7?

    Currently, my connection string contains this: Provider=MSDASQL.1;

    Is that OK?
    I'm getting that Jet thing now too...
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    Reply With Quote Reply With Quote
  14. Feb 24th, 2002, 04:46 PM #12
    rjlohan
    rjlohan is offline

    Thread Starter
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205
    Ok Beaker, I got that Jet update, but do I need to install that on all machines, or just distribute some component with the app?
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    Reply With Quote Reply With Quote
  15. Feb 24th, 2002, 09:07 PM #13
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    So it's working now??

    Since you dont have rights to install it on each pc and 2ndly you dont know if each pc needs it i would say just redistribute it with your setup prog. This way it will install it for you!

    Note: That if the pc has jet 4.0 dont install it! So you may need to run a checker first over the pc's which you can get from ms's website.
    Same link i think!

    later
    b
    Reply With Quote Reply With Quote
  16. Feb 24th, 2002, 09:11 PM #14
    rjlohan
    rjlohan is offline

    Thread Starter
    PowerPoster rjlohan's Avatar
    Join Date
    Sep 2001
    Location
    Sydney, Australia
    Posts
    3,205
    Don't know if it works yet... someone's filming something up the hall, so I can't get to the problem machine right now...
    -----------------------------------------
    -RJ
    [email protected]
    -----------------------------------------
    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