RE: it really tough

      Create a DSN in ODBC Data Sources in Control Panel using the Oracle
Driver

      dsn = "Oracle ODBC"
      
     ConnectString = "CONNECT=Ole DB;DSN=" & dsn & ";DBQ=" & database_name &
";UID=" & user & ";PASSWORD=" & password & ";"

Dim rs As ADODB.Recordset
rs.Open "SELECT * FROM " & tbl & " WHERE " & key & " = '" & key_value & "'",
ConnectString

Chris

> -----Original Message-----
> From:	kadakia rocky [SMTP:[email protected]]
> Sent:	28 January 2003 01:44
> To:	Oracle
> Subject:	[oracle] RE: it really tough
> 
> hi
> 
> thank you for replying
> 
> i konw that i have to use ODBC. i just know that how
> to make the connection using ODBC. but i don't know
> that how to find oracle servers in local network
> through visual basic.
> 
> so please help
> --- Chris Sol <[email protected]> wrote:
> > Hi
> > 
> > Use ODBC
> > 
> > Chris Sol
> > 
> > > -----Original Message-----
> > > From:	tejas [SMTP:[email protected]]
> > > Sent:	25 January 2003 04:40
> > > To:	Oracle
> > > Subject:	[oracle] it really tough
> > > 
> > > respected all
> > >    i am a programmer. write now i am working in
> > visaul basic as a 
> > > programming language and oracle as database. now i
> > want to detect all the 
> > > oracle servers in local network through visual
> > basic. the net8 facility of
> > > 
> > > oracle provides this detection. but i don't know
> > how to use this facility 
> > > in visual basic.
> > >    so please tell me how to use net8 facility or
> > oracle in visaul basic. 
> > > or is there any other way to detect oracle servers
> > in local network 
> > > through visual basic.
> > >    waiting for your reply
> > >    tejas kadakia
> > > ---
> > > Change your mail options at
> > http://p2p.wrox.com/manager.asp or 
> > > to unsubscribe send a blank email to
> > %%email.unsub%%.
> > >  
> >
> **************************************************************************
> **
> > The Genesis Housing Group - Email Disclaimer
> > --------------------------------------------
> > The information in this email and any attachments is
> > strictly
> > confidential and may be legally privileged.
> > It is intended solely for the use of the
> > addressee(s) only. Access to
> > this email by anyone else is unauthorised.  If you
> > have received this
> > email in error please notify the sender immediately
> > by return email or
> > telephone.  Please note that if you are not the
> > intended recipient, you
> > must not copy, distribute or otherwise act on any
> > part of this email or
> > it's attachments.
> > Although we have taken precautions to ensure that
> > this email and
> > attachments are free from any virus, we would advise
> > you that it is your
> > responsibility to ensure that this is true when
> > reading or actioning
> > this email.
> > 
> > ---
> > Change your mail options at
> > http://p2p.wrox.com/manager.asp or 
> > to unsubscribe send a blank email to
> %%email.unsub%%.
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
> 
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or 
> to unsubscribe send a blank email to %%email.unsub%%.
>  
****************************************************************************
The Genesis Housing Group - Email Disclaimer
--------------------------------------------
The information in this email and any attachments is strictly
confidential and may be legally privileged.
It is intended solely for the use of the addressee(s) only. Access to
this email by anyone else is unauthorised.  If you have received this
email in error please notify the sender immediately by return email or
telephone.  Please note that if you are not the intended recipient, you
must not copy, distribute or otherwise act on any part of this email or
it's attachments.
Although we have taken precautions to ensure that this email and
attachments are free from any virus, we would advise you that it is your
responsibility to ensure that this is true when reading or actioning
this email.

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].