🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: borland.public.cppbuilder.database.multi-tier
4 messages
4 total messages Started by Todder Mon, 27 Nov 2000 00:00
AS/400 - DB2
#760
Author: Todder
Date: Mon, 27 Nov 2000 00:00
12 lines
924 bytes
We are looking for information regarding using C++ Builder with an
AS/400 DB2 database.

We currently have an application written with C++ Builder communicates
through the BDE to an interbase database.  What needs to be done to this
application to have it communicate with a DB2 database (exact same
structure) on the AS/400?

Any information would be appreciated.

Todd Brasseur
Compass Municipal Services Inc.
Re: AS/400 - DB2
#765
Author: Jerry Bloomfield (TeamB)
Date: Tue, 28 Nov 2000 00:00
24 lines
1572 bytes
On Mon, 27 Nov 2000 09:47:46 -0700, Todder <compass-cama@home.com> wrote:

>We are looking for information regarding using C++ Builder with an
>AS/400 DB2 database.
>
>We currently have an application written with C++ Builder communicates
>through the BDE to an interbase database.  What needs to be done to this
>application to have it communicate with a DB2 database (exact same
>structure) on the AS/400?
>
>Any information would be appreciated.

If you are using ODBC to connect to your Interbase database,  then you
should be able to drop the IBM CA/400 ODBC driver in using the same DSN and
get it to work with minimal massaging...

I know that we have an application which uses the ODBC API to talk to an
AS/400 DB2/400 table and it works quite well.

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)
Re: AS/400 - DB2
#768
Author: Todder
Date: Wed, 29 Nov 2000 00:00
34 lines
1861 bytes
Thanks for the information!!!

Now that I know it can be done.  Does anyone have any knowledge as to how
different in functionality and in syntax is DB2 to Interbase?

Todder


"Jerry Bloomfield (TeamB)" wrote:

> On Mon, 27 Nov 2000 09:47:46 -0700, Todder <compass-cama@home.com> wrote:
>
> >We are looking for information regarding using C++ Builder with an
> >AS/400 DB2 database.
> >
> >We currently have an application written with C++ Builder communicates
> >through the BDE to an interbase database.  What needs to be done to this
> >application to have it communicate with a DB2 database (exact same
> >structure) on the AS/400?
> >
> >Any information would be appreciated.
>
> If you are using ODBC to connect to your Interbase database,  then you
> should be able to drop the IBM CA/400 ODBC driver in using the same DSN and
> get it to work with minimal massaging...
>
> I know that we have an application which uses the ODBC API to talk to an
> AS/400 DB2/400 table and it works quite well.
>
> Jerry Bloomfield (TeamB)
> --
> http://www.teamb.com                                      JersWork@wwa.com
> Please do *NOT* send private e-mail without prior permission (my anti-spam
> filters will probably just delete it anyway <g>)
Re: AS/400 - DB2
#772
Author: Jerry Bloomfield (TeamB)
Date: Thu, 30 Nov 2000 00:00
15 lines
1311 bytes
On Wed, 29 Nov 2000 14:06:00 -0700, Todder <compass-cama@home.com> wrote:

>Thanks for the information!!!
>
>Now that I know it can be done.  Does anyone have any knowledge as to how
>different in functionality and in syntax is DB2 to Interbase?
I am afraid that it has been long enough ago since I have accessed DB2 that
I don't remember...  I do not remember it as being too much different than
most SQL-92 compliant databases...

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads