Provider Could Not Be Found - ADODB - YIKES!!

[ChloeRadshaw]

I spent all of yesterday and the day before looking at someones machine without any succes -:(

Basically whenever they try to connect to a database (MS Access or Sybase) they get a "Provider could not be found"

This is almost certainly DLL Hell so what I have done so far is:
1) Copy my c:\program files\sybase (which contains all DLLs over)
2) Installed MDAC 2.6
3) Tried tried and prayed

I am now really desperate - Does anyone have suggestions about how to identify this?

I have turned on tracing in the ODBC administrator pannel with no joy whatssoever

Any ideas please

[Bob Phillips]

Have you tried connecting to the database from the ODBC panel?

Do you have any apps that can connect?

[ChloeRadshaw]

I have tried from the ODBC panel and it works fine - It just appears in Excel that I cannot connect to Access or Sybase databases.

Something is seriously up and I am completely stumped - I ve reinstalled MDAC 2.6 and restarted the machine multiple times.

Any ideas PLEASE?

[Bob Phillips]

If you can connect via the ODBC panel you should be able to connect via Excel.

Have you ever been able to connect to any data source from Excel VBA?

How are you doing it, what is the code like?

[ChloeRadshaw]

I think this is down to another application interfering with Excel :(

I can use the Excel spreadsheet, but the same spreadsheet with the same ODBC DSN's set up on another persons machine does not work.

I am using ODBC - My connection string looks like:


Any ideas

[Dr.K]

It looks like blank? :dunno


Good lord, I am stumped. I've rolled out ADO VBA apps to a ton of people here at work, and I've never run into this.

My best guess is to un-install and then re-install Office completely.


For your reference, here is one of my ADO to ODBC connection strings:
Set conDM = New ADODB.Connection

conDM.Open "Password=" & dmcPW _
& ";User ID=" & dmcUser _
& ";Data Source=DCMP;Persist Security Info=True"

[ChloeRadshaw]

I ve just reinstalled MS Office from scratch with no joy.

I Have completely run out of ideas!