oledb/ado/odbc Re: Accessing different databases from visual basic

microsoft oledb data access layer could take care of the access to heterogeneous db communication(oracle, sqlserver, sybbase,db2, etc). use ado object model to process the data in the sql level or gui part. create different dsn in odbc to access different db, and refer them in your ado
object.

store proceudures need to be setup in each database platform for reading, updating, inserting, etc. ask dba help if available. It will process your data request in a orderly fashion.

oo4o is oracle provider for microsoft vc or vb

These are general areas you might want to look into.

hope helps

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<f8vbst8okj2j6enbn4qd8k759quqvdpsst_at_4ax.com>...
> On 11 Oct 2001 07:49:33 -0700, mahua_at_saisoft.com (Mahua) wrote:
>
> >We are thinking of creating a program in Visual Basic which will have
> >to access 3 different databases. It will read from db1 in sql server
> >and have to write to both db2 (sql server) and db3 (Oracle).
> >
> >We were thinking of storing the fields in variables and then updating
> >the other two databases with these variables.
> >
> >Is there a better way to do this?
> >
> >Thanks
> >Mahua
>
>
> Without *any* doubt.
> The only problem is you don't provide any details, so no one can
> provide any sensible advice.
> Why do you think you can't have the complete data model in *one*
> database in the first place? What kind of reasons do you have for
> that? I'm almost sure this is going to end up in a nightmare,
> especially as your fragile VB client is going to do it.
>
>
> Regards
>
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Oct 12 2001 - 10:03:14 CDT