Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Visual Basic using Oracle

Re: Visual Basic using Oracle

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 28 Sep 1999 14:17:50 -0400
Message-ID: <37F1064E.D9798987@Unforgettable.com>


Thanks. Hopefully all of this will get me started.

Dean wrote:
>
> 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:
>
Received on Tue Sep 28 1999 - 13:17:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US