Re: VB6 connection with Oracle9i using ODBC

From: Al Reid (areidjr_at_reidDASHhome.com)
Date: 03/04/04 

Date: Thu, 4 Mar 2004 07:04:17 -0500

On the Server:
Oracle Service and Listener Service Running

On the Client Machine:
MDAC installed
Oracle Client Tools Installed
NET*8 Configuration completed and/or TNSNames.ora properly defined

Once that is complete, there should be no problem connecting with either ODBC or OLEDB providers. 

--
Al Reid
"It ain't what you don't know that gets you into trouble. It's what you know
for sure that just ain't so."  --- Mark Twain
"syed nizami" <s_azam_nizami@indiatimes.com> wrote in message news:#gFZkfWAEHA.1792@TK2MSFTNGP12.phx.gbl...
>
>
> Can anyone please tell me how to connect to oracle9i database using ODBC
> in Windows 2003 server. i've tried both through system DSN & user DSN
> with ORAOLDB
> provider but the connection failed when i tested it. (it gives
> connection error)
> After running TNS Listener for Oracle 9i, i run
> OracleServiceREO(database) from services.
>
> the connection settings that i gave r
> name : new
> details :
> TNS Listener : REO (name of TNS
> user_id : system
>
> then i click on test connection & type the password & click ok, it then
> shows an error message saying that connection failed.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages