Run-Time Error 3706...

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

The detail from MSDN is this:

Quote:

---

Provider cannot be found. It may not be properly installed.

---

What does this mean, and how do I solve it?

Good ol 3706 eh?

You need to reformat your harddisk and go from there, if you still get an error, post again!

When you connect to to a DB using ADO, you specify the provider in the ConnectionString:

VB Code:

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

OK. Ta.
Don't know why it wouldn't work though. It was but now it's not...:(

What OS r u using??

WINNT

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:)

Is Jet necessary for Access?

If you wanting to connect to it yes!
hehehe
;)

Sorry i lied couldnt be bothered typing but figured i should!

You could use ODBCDirect with DAO3.5 That way you could bypass Jet!

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...

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?

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:)

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...