Re: Interfacing Oracle and Visual Basic

I think it is NEVER a good idea to use DataControls. Use your own Connection and you can control everything you want to do with your Data.

Jochen

Jochen Pege <pege_at_kespretlang.de> schrieb in im Newsbeitrag: 8vd8os$ten$1_at_news10.roka.net...
> Try to use an ADO Conncetion. After you established the connection you can
> use the normal methods (.addnew,....) or, and this would be the faster way
> you can you simple SQL Statements.
>
>
> Charles Newman <newmanc_at_hotmail.com> schrieb in im Newsbeitrag:
> 8vbolc$m1m$1_at_nnrp1.deja.com...
> > In article <8vb263$c5o$1_at_news10.roka.net>,
> > "Jochen Pege" <pege_at_kespretlang.de> wrote:
> > > I dont know if this would solve your problem but mybe.
> > > First do not use VB Data Controls they are not very flexible for
> > > manipuliating your Data.
> >
> > I have been using VB's built in control specifically for Oracle
> > databases. It is the only way, in version 8, to access an oracle
> > database. I dont know of any other way to access an Oracle database from
> > VB. I am using personal Oracle 8i (8.1.5).
> > How else can I access Oracle 8i from VB 6?
> >
> > > and second, the cause for the Errormessage maybe depends on your
 Oracle
> > > Table. If there is no Primary Key or at least one field with an index,
 it is
> > > impossible for VB to add/update any data.
> >
> > The table does have a primary key, so that cannot be the problem.
> >
> > >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Tue Nov 28 2000 - 12:35:01 CET