Re: Connecting Oracle 8i from NT Client without ODBC

You can use a DSN-less connection with ADO:

Like this ( For Oracle using Microsoft OLE DB Provider for Oracle - whs1 is a tnsnames.ora entry)

 Set objDC = Server.CreateObject("ADODB.Connection")  objDC.Open "Provider=MSDAORA.1;Password=yourpass;User ID=youruser;Data Source=whs1;Persist Security Info=TRUE"

"Bertrand LEBIN" <blebin_at_free.fr> wrote:

>Hi
>
>Do you know how can we connect to an Oracle 8i Server Database
>with Visual Basic Code without declaring an ODBC connection ?
>
>
>If you have the native access writen in Visual Basic,
>I would appreciate
>
>Thanks
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Jun 26 2001 - 14:19:32 CDT