Re: Visual Basic using Oracle

From: Dean <rilecode_at_chemist.com>
Date: Tue, 28 Sep 1999 10:37:21 -0700
Message-ID: <37F0FCD1.C6814346@chemist.com>

Search Microsoft's MSDN site http://msdn.microsoft.com another site on ADO is http://www.microsoft.com/data/techmat.htm.

I know there are examples in the techmat section. Some examples are written in SQL/Server but they can be easily translated into Oracle by the changing the connect string : e.g.

Set AdoConn = CreateObject("ADODB.Connection")
AdoConn.Provider = "MSDAORA"
AdoConn.ConnectionString = "Data Source=oracle_sid;User ID=scott;Password=tiger"

Set AdoRs = New ADODB.Recordset
AdoConn.Open
sql = "select * from emp"
Set AdoRs = AdoConn.Execute(sql)
AdoConn.Close
Set AdoRs = Nothing
Set AdoConn = Nothing

Rick

Kenneth C Stahl wrote:

> Do you know of any place where I could get a small (but complete) example
> program which uses ADO? If you have a URL that can point me in the right
> direction I'd appreciate it.
>
> Dean wrote:
> >
> > God, I wish I wasn't saying this, but Microsoft ADO works very well with
> > Oracle, they have alot of examples and it is even easier to learn than Oracle
> > objects for Ole.
> >
> > Rick
> >
> > Kenneth C Stahl wrote:
> >
> > > I'm in the process of learning Visual Basic and will need to access an
> > > Oracle database. Some questions:
> > >
> > > 1. Is ODBC the only choice?
> > > 2. Can I use regular sql statements to access a table via odbc?
> > > 3. Can someone post some URLs where I can find some small example programs
> > > that access Oracle? It would be especially helpful if they used the SCOTT
> > > tables since I already have them in my database.
Received on Tue Sep 28 1999 - 12:37:21 CDT