Re: Interfacing Oracle and Visual Basic

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

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. Received on Mon Nov 13 2000 - 10:20:18 CST