Access 2000 and ADO

[lambela8]

Hello,

I am using the ADO control, connecting with Jet 4.0 in Access database. Computers with office 2000 have no problems connecting. computers that either don't have Access or have Access 97 come up with this error:

2147467259 - Specified driver could not be loaded due to system error 1157 (Microsoft Acess Database)(.mdb). I use the MDAC_TYP.exe in my install. Any suggestions.



[This message has been edited by lambela8 (edited 11-09-1999).]

[Clunietp]

what version of the MDAC are you distributing? what does your connection string look like?

[lambela8]

I tried the connection of:

db.Open "Provider=MSDASQL;FILEDSN=CHECKREGISTER.DSN;Database=c:\sample.mdb" - where I would use a file dsn. This gave me the error I posted. I changed it to the following:

db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\sample.mdb"

and I get this error:
'Run time error 3106 - ADO could not find the specified provider'

Again - both of these work on my machine with no problems.

The MDAC version is 2.00. Do you think this is the problem? What version should I use?

[Clunietp]

Yes, use the second connection string that you specified. I believe MDAC version 2.1 installes the Jet 4.0 provider, you can get that from www.microsoft.com/data from the downloads section

HTH

Tom

[lambela8]

I did what you said and I still get the ADO could not find the specified provider. Obviously something is wrong. The MDAC 2.1 version does install Jet 4.0. On the computer that never has had Office, I get the message 'Active X can't create the component'

I noticed that in the package wizard it said for MDAC to install properly I need DCOM98, which is not on my computer, but is on the VB 6.0 CD. When I add this, I get the crazy dependency files missing dialog box. Any other ideas? The program is simply a form that connects to an Access 2000 database.

[Clunietp]

You said that it still says it could not find the specified provider, then you said that Active X Component could not create object? Which one is it? Both? What O/S is your target machine running? did you install DCOM98 on that machine? Your development machine should already have DCOM98 installed. You do not need to add a reference to it, just install it.

HTH

Tom

[lambela8]

OK sorry. The ADO could not find specified provider comes up on the computer that has Office 97 on it. The ActiveX can't create object is on the computer that has never had Office or Access or anything installed. Both computers on Windows 95.

Does Dcom98 install automatically like MDAC? I did run Dcom98 just in case and an error came up saying that a previous version of Dcom98 was installed and I would have to uninstall it first.

I know I sound ignorant about all of this, but I have never had this trouble before. Should I try using DAO and creating an Access 97 database instead?

[Clunietp]

Sounds like to me that the prob is that DCOM 98 isn't installing, therefore you cannot install ADO 2.1 to use the correct driver. I don't know why DCOM won't install, but check the MS Site for more info, then I think you'll be ok...

Sorry!

Tom