Re: Oralce V7 and VB question

In article <966631672.27041.0.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> As long as the interface between the VB program and the Oracle
 database runs
> on top of sqlnet, an Unix database shouldn't be any problem. ODBC
 should be
> capable of doing this, Oracle Objects for Ole definitely is, I don't
 know
> too much about OleDB and ADO, hence the sentence I started with.

Any of Oracle's supported protocols-- ODBC, OLEDB, OO4O, JDBC, OCI, etc. directly or through higer-level API's (i.e. ADO) will work with a V7 database, at least all do now.

When v7 is eventually desupported, I suspect that these groups will stop testing with v7 databases, so problems will eventually crop up. I don't keep up on what versions are supported and when different versions are scheduled for de-support, so I won't speculate about time-frames. Even after v7 is desupported, I would expect that these protocols would still function correctly when connected to a v7 database for quite a while.

Justin Cave
Oracle ODBC Development

Opinions expressed herein are my own and may not reflect those of Oracle Corporation.

>
> You are aware V7 will be desupported in a few months time?
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Kim A. Sommer" <kasommer_at_my-deja.com> wrote in message
> news:8njutr$ehc$1_at_nnrp1.deja.com...
> > Hello,
> >
> > At my work we have an Ingres database for recording test and vendor
> > supplied data for a particular product. I'm sort of the product
> > overseer/manager/troubleshooter etc. Everything else about this and
> > other products are kept in a larger (supported) database. We are
> > looking to migrate. The supported DB is Oracle 7 on an HP (Unix)
> > server.
> >
> > The older application has a front end for our technicians to input
> > their test data. We know we have to build another client front-end
 but
> > one of the engineers claims he's over half-way building a Visual
 Basic
> > (I assume v6.0) client. One of the Oracle DB admins told me that VB
> > can only access Oracle via an NT machine (damn drive letters).
> >
> > So the question after all that is: Can VB access an Oracle 7 DB on
 an
> > HP unix server without any other software being added or interposed?
> > (I'm pretty sure SAMBA would be shot down at this point if it is an
> > option)
> >
> >
> > Please respond via email to kasommer_at_kiva.net or
> > sommer_kim_at_crane.navy.mil
> >
> >
> > Best regards,
> > Kim
> >
> >
> >
> > --
> > --------------
> > K. A. Sommer
> > Humans do it Better!! The Open Directory Project at dmoz.org
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Aug 19 2000 - 12:47:03 CDT