Re: vb oracle dsn-less connection
From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sun, 12 Jan 2003 09:09:12 -0000
Message-ID: <3e2130b7$0$247$cc9e4d1f_at_news.dial.pipex.com>
Date: Sun, 12 Jan 2003 09:09:12 -0000
Message-ID: <3e2130b7$0$247$cc9e4d1f_at_news.dial.pipex.com>
using Oracle oledb provider and ADO your connection string should look like
strConnect="Provider=OraOLEDB.Oracle;User Id=<username>;Password=<password>;Data Source=<tnsnames alias>"
There are also examples in the oledb documentation.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "sachin_gujar" <member22292_at_dbforums.com> wrote in message news:2375417.1042268507_at_dbforums.com...Received on Sun Jan 12 2003 - 10:09:12 CET
>
> i want to set vb oracle dsn less connection using DAO or ADO please help
> me to do so
>
> --
> Posted via http://dbforums.com