Re: sql script doesn't work using ADO in WinXP with AS400 CA v4r4
- From: "Roland" <rolandelNONSPAM@xxxxxxx>
- Date: Tue, 12 Apr 2005 14:35:13 +1000
Thanks:
The installation was installed by customer's IT person who installed it
remotely and I watched the whole process and the ODBC and OLE DB provider
was ticked. I will use BDE to have a try. I guess there is transalation
problem for ADO with CA v4r4 driver and M$ jet engine can translate it
properly.
Roland Zhang
Betsy <betsy.a.tainer@xxxxxxxxxxxxx> wrote in message
news:425af8c7$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> oh hey... done that, been there.
>
> I had that situation just last week.
>
> Someone on our helpdesk decided to be 'frugal' (forgive my spelling???)
when
> installing CA on the user's machine and did not 'check' the installation
of
> the ADO provider... it was simply a matter of reinstalling and making sure
> that the ADO provider is checked as part of the installation.
>
> PLEASE... do away with the ODBC connectivity to the as/400 you will be so
> HUGELY impressed with the ADO connectivity... it's fast on fast on fast...
> connection time in seconds vs minutes...
>
> As to your queries... you will need to use a little different syntax at
> times as IBM has their very own interpretation of the standards... and I
> think it will make a difference which 'add-ons' are installed on the
as/400
> in the way of interpreting your query as well... I always use the
'transfer
> from' tools provided (again, probably optional installation) as part of
the
> Client Access installation to verify at least the fields and basic joins
etc
> are correct... prior to moving my query into the Delphi world... then I
> have to struggle a little with quotations and . notation vs / notation
> etc...
>
> I've also found that I'm not constantly going to the users machines to
> update or recreate ODBC definitions with the ADO connection defined in the
> application as long as they have the provider is installed and MDAC is
> working properly the connection will be made... it will give you better
> control in the end.
>
> Let me know if that helps.
>
> b
> "Roland" <rolandelNONSPAM@xxxxxxx> wrote in message
> news:4255e538$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> > Hi:
> >
> > Does any one know ADO working properly in Windows XP connected to ODBC
> with
> > AS400 Client Access Driver v4r4?
> >
> > I tried using ADO to connect AS400 by linking Client Access ODBC driver,
> the
> > ADO connection is OK, but none of sql script working, it always got
error.
> > But we have MS Access in that machine, it can get data from AS400 by
> linking
> > Client Access ODBC driver. How can I convince our customer that it's
> driver
> > issue rather then application issue? Also if I try to use CA OLE DB to
> > connect AS400, it shows connection error, no provider available. So I
have
> > to choose ODBC.
> >
> > Could anyone help me to point out what problem there? Many thanks.
> >
> > --
> > Roland Zhang
> > Development
> > Compdata Technology Services
> >
> >
>
>
.
- Follow-Ups:
- References:
- Prev by Date: Re: copying records to another field
- Next by Date: Re: copying records to another field
- Previous by thread: Re: sql script doesn't work using ADO in WinXP with AS400 CA v4r4
- Next by thread: Re: sql script doesn't work using ADO in WinXP with AS400 CA v4r4
- Index(es):
Relevant Pages
|
