Re: Trouble with ADO
- From: "Stephen Howe" <stephenPOINThoweATtns-globalPOINTcom>
- Date: Mon, 11 Jun 2007 12:40:17 +0100
We recently have a problem with some PCs and ADO : we can connect our
programs to databases (such as SqlServer) via ADO.Net or ODBC, but it
doesn't work via ADO
What do you mean by "doesnt work"?
Do you get an error message - if so what?
Which database are you trying to connect to?
Be advised that Microsoft have stopped distributing various OLE DB providers
with the latest version of MDAC.
So you will have to download the Jet driver separately if you wish to
connect to Access, Excel, text files and also the ODBC provider I believe.
!? PCs are under Windows 2000 or Windows XP (SP2). Our programs written in
C# or VB.Net which use ADO.Net work perfectly with the databases. But our
programs written in "old" VB6 can't connect to the same database on the
same computer (*) It's not the case for all the PCs, just for a small
minority... For these minority, the problem concerns third partie products
too... And with XP SP2, whe can't try to reinstall MDAC, because Windows
rejects the reinstall...
Yes, you cannot revert to earlier versions of MDAC. But you should be able
to install the latest which is MDAC 2.8.
Stephen Howe
.
- References:
- Trouble with ADO
- From: News
- Trouble with ADO
- Prev by Date: Re: Trouble using ADOX to create linked tables in jet database from an
- Next by Date: Re: Trouble using ADOX to create linked tables in jet database fro
- Previous by thread: Trouble with ADO
- Index(es):
Relevant Pages
|
|
