Re: Interfacing Oracle and Visual Basic

From: Charles Newman <newmanc_at_hotmail.com>
Date: Mon, 13 Nov 2000 08:07:46 GMT
Message-ID: <8uo7gh$ae5$1@nnrp1.deja.com>

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. Received on Mon Nov 13 2000 - 02:07:46 CST