Re: Interfacing Oracle and Visual Basic

From: Charles Newman <newmanc6619_at_softhome.net>
Date: Sat, 25 Nov 2000 02:06:54 -0800
Message-ID: <3a1f8ea6@post.newsfeeds.com>

• post for free via your newsreader at post.newsfeeds.com ***

Jochen Pege <pege_at_kespretlang.de> wrote in message news: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.
>
>

   There is a problem with ADO. You can use multiple tables with one data control. If you leave the RecordSource property blank, within the control, you will get an an error "No RecordSource Set", if even if your program sets the RecordSource property.

   Then I get an error "Cannot bind to Field", where the text and/or label items define the data source used, becuase ADO does NOT support multiple tables. They only way to use ADO, is to use one data control for each table you plan to use.

     Simply put, ADO does NOT support databases with multiple tables, PERIOD!!!!
     If anybody out there is going to use ADO, instead of the Oracle Data Control, you will have to use a seperate ADO control for each table of your database, otherwise, it will not work.

> 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.
>
>

• Post for FREE via your newsreader at post.newsfeeds.com ****

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
*** Newsfeeds.com - The #1 Usenet Newsgroup Service on The Planet! ***
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
  http://www.newsfeeds.com%c2%a0%c2%a0%c2     |         http://www.newsfeeds.com
                                 |
* Anonymous posting server!      | * Totally Uncensored!
* SUPER Servers!                 | * Over 80,000 Newsgroups!
* BINARIES ONLY Servers!         | * 16 seperate Newsgroup Servers!
* SPAM FILTERED Server!          | * Instant access!
* ADULT ONLY Server!             | * Multiple OC 3's and OC 12's!
* MP3 ONLY Server!               | * 99% Article Completion!
* MULTIMEDIA ONLY Server!        | * Months of Retention!
* 7 UNCENSORED Newsgroup Servers | * Lightning FAST downloads!
                                 |
  http://www.newsfeeds.com       |         http://www.newsfeeds.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
        **** Point your newsreader to post.newsfeeds.com ****

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Received on Sat Nov 25 2000 - 04:06:54 CST