Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Visual Basic using Oracle
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
![]() |
![]() |