Re: Interfacing Oracle and Visual Basic
Date: Sat, 25 Nov 2000 18:17:40 -0800
Message-ID: <3a20724f_at_post.newsfeeds.com>
- post for free via your newsreader at post.newsfeeds.com ***
There is another problem with ADO. If any data in your Oracle database is stored as Numeric data, ADO will NOT be able to interpret the data correctly. Data stored in my database as numeric data comes back as ZEROES in any txt or label box that has been linked to that data field.
When I change it over to character data, the problem goes away. But I have found out that you CANNOT store data in any kind of numeric format, and expect ADO to be able to use it. ALL data, that is to be used by ADO, and linked to text or label boxes MUST be stored in CHARACTER format, or VB will insert 0 into every text or label box liked to any numeric fields in Oracle
Charles Newman <newmanc6619_at_softhome.net> wrote in message
news:3a1f8ea6_at_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 | 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 ****
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
- Post for FREE via your newsreader at post.newsfeeds.com ****
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Newsfeeds.com - The #1 Usenet Newsgroup Service on The Planet! *** -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://www.newsfeeds.com   | 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 Sun Nov 26 2000 - 03:17:40 CET