Article View: borland.public.cppbuilder.database.ado
Article #4720Re: Interface not supported
From: Jean Michel
Date: Mon, 19 Nov 2001 16:22
Date: Mon, 19 Nov 2001 16:22
114 lines
3794 bytes
3794 bytes
Hi,
Thanks for helping...
Here is what we do (or try to) :
open a connection with the ADOConnection component :
ConnectionString field : DRIVER={microsoft access driver (*.mdb)};
DBQ=Mybase.mdb
Provider field : MSDASQL
Connected field : false
to perform a query, we use the ADOQuery component like this :
ADOQuery->SQL->Add ("select*...");
ADOQuery->Open();
while
etc...
It works on all the computers here.
But not at the customer's, who has a "client access odbc driver 32 bit" in
the odbc driver window, which we don't have.
(he is linked to a AS/400 where others databases are stored).
message : "interface not supported".
Installing mdac2.6 and restart computer->it works !
we are not even able to re-create the problem here (and our customer is in
avignon, and we are in saint etienne, if you know France (about 250 Km))
any hints ?
Thanks
Jean Michel
"Rick Golden" <GoldenRick@hotmail.com> a �crit dans le message news:
3bf9152d_2@dnews...
>
> First question Why are you using ODBC... there is a good MS-Access driver
> for ADO?
>
> Are you sure your not using the BDE?
>
>
>
> Jean Michel <jm@magcom.fr> wrote in message news:3bf8e250_2@dnews...
> > Hi,
> >
> > Thanks for the answer.
> >
> > We are using a Ms access database, on a odbc connection (classic ms
driver
> > declaration)
> >
> > How do you make a "silent" install of ado ? (refer to : so it should be
> > installed)
> >
> > The Drivers seem to be installed.
> >
> > an other driver is installed : client access odbc drivers 32 bit
> > on all the computers on which we get the "interface not supported"
> message.
> >
> > Has anyone ever have this problem ?
> >
> > Do you know how to install MDAC without restarting the computer ?
> > Or to test if the mdac is allright before installing it ?
> >
> > any other solution than installing MDAC ?
> >
> > Thanks
> >
> > Jean Michel
> >
> >
> > "Rick Golden" <GoldenRick@hotmail.com> a �crit dans le message news:
> > 3bf3d8d1_2@dnews...
> > > your application seems to use ADO
> > >
> > > so it should be installed??
> > >
> > > Quel BD utilisez vous?
> > > Quel service d'ADO ?????
> > >
> > > Il faut surement installer les pilotes que vous utilisez
> > >
> > > Bonne chance
> > >
> > >
> > >
> > > Jean Michel <jm@magcom.fr> wrote in message news:3bf3938d$1_2@dnews...
> > > > Hi everybody,
> > > >
> > > > We are developping a small application using c++builder.
> > > > Problem : on all the computers here, it works
> > > > at the customer's place, it doesn't. Message : Interface not
> supported.
> > > > after installing mdac2.6, it works
> > > >
> > > > any idea ?
> > > >
> > > > Thanks
> > > >
> > > > Jean Michel
> > > > (from France)
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID:
<3bf93204_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3bf3938d$1_2@dnews> <3bf3d8d1_2@dnews> <3bf8e250_2@dnews> <3bf9152d_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,628ecfdd5e95eb0f X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-11-19 08:35:09 PST From: "Jean Michel" <jm@magcom.fr> Newsgroups: borland.public.cppbuilder.database.ado References: <3bf3938d$1_2@dnews> <3bf3d8d1_2@dnews> <3bf8e250_2@dnews> <3bf9152d_2@dnews> Subject: Re: Interface not supported Date: Mon, 19 Nov 2001 17:22:48 +0100 Lines: 116 Organization: Magcom X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 NNTP-Posting-Host: 217.128.21.106 Message-ID: <3bf93204_1@dnews> X-Trace: dnews 1006187012 217.128.21.106 (19 Nov 2001 08:23:32 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews