Re: Interfacing Oracle and Visual Basic

From: Charles Newman <newmanc_at_hotmail.com>
Date: Fri, 17 Nov 2000 08:42:23 GMT
Message-ID: <8v2r1e$27k$1@nnrp1.deja.com>

In article <8up4bo$1h4$1_at_nnrp1.deja.com>, srramaraj_at_my-deja.com wrote:
> In article <8uo7gh$ae5$1_at_nnrp1.deja.com>,
> Charles Newman <newmanc_at_hotmail.com> wrote:
>
> ORADC1.DatabaseName will be the name of ur oracle service as defined
in
> the TNSNAMES.ora, If you are not working on a personal server.
> Otherwise it should be empty i.e. ""

I put the service name in, and it still gave me an error, so I have to leave it empty.

I am doing:

po8.world =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )

    )
    (CONNECT_DATA = (SID = ORCL)
    )
  )

But when I put in "po8" into the "Database Name" field, it gives me an error. I get an error message from Oracle listener that the service name cannot be found, but "po8" works OK in the "Connect" field, when I log on from SQL Plus.

But now I have another problem, when I go to write a data record, I get "Invalid Fieldname" Error, I am doing

ORADC1.RecordSet.AddNew

....Insert data into record fields

ORADC1.RecordSet.Update

Oracle gives me back the "Invalid Fieldname" error. I have checked, and I have all the fieldnames defined correctly to all text and label fields that reference thed database, yet I still get this error.

>
> hope this helps you
>
> > In article <IQBP5.1928$Mf4.330090_at_news.shore.net>,
> > "Snezana Sonje" <sonje1_at_shore.net> wrote:
> > > Here is what you need:
> > > ORADC1.Connect = "scott / tiger"
> > > ORADC1.DatabaseName = "mydata"
> > > ORADC1.RecordSource = " select * from dual"
> > > ORADC1.Refresh
> >
> > I figured out what was wrong with your instructions,
> >
> > ORADC1.DatabaseName need to be left blank. You will get an error
saying
> > that Oracle cannot resolve the service name, if you do not leave it
> > blank.
> >
> > >
> > > Charles Newman wrote in message <8t8hf3$prg$1_at_nnrp1.deja.com>...
> > > >
> > > >
> > > >
> > > > What do I need to key for for the "database name" and
"connect"
> > > >fields of an Oracle Data Control in Visual Basic. I want Visual
Basic
6
> > > >to connect to an Oracle 8i database.
> > > > For those of you who are seeing this post a second time, I do
> > > >apologize, but my first attempt at posting this seems to have
gotten
> > > >lost or something.
> > > >
> > > >
> > > >Sent via Deja.com http://www.deja.com/
> > > >Before you buy.
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 17 2000 - 02:42:23 CST