Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help on connection to Oracle with Microsoft ODBC (VB 6.0)
You're better off using Oracle's ODBC drivers than Microsoft's. You
already have Oracle client software installed so you should also have
the ODBC driver installed as well. Try setting up an Oracle ODBC DSN
instead.
HTH,
Brian
Mohammad wrote:
>
> Hello
>
> I need help!!!!
>
> The Problem:
>
> I am trying to setup an ODBC DSN to an Oracle 9i server that resides
> at
> Stanford U across The Internet. I have everything set up to the best
> of my
> knowledge correctly but when I attempt to connect via the ODBC DSN via
> 32-bit ODBC Test app (or any other app that supports ODBC connections
> for
> that matter) I get the following.
>
> "Error Number : -2147467259","Error Description : [Microsoft][ODBC
> driver for Oracle][Oracle]ORA-12154: TNS:could not resolve service
> name"
>
> Oh yes, I should tell you that SQL Plus 9.0.1.0.0 connects to the
> server fine.
> Also TNSPING.EXE finds the server fine.
>
> Thanks again. Could you please send me sample code of VB for ODBC
> connection to Oracle DB or give me information about oracle client
> setting that maybe I forgot that. Also, please email me directly at
> this address as well as posting inthe group.
>
> Thanks,
> Mohammad
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Thu Sep 18 2003 - 16:02:01 CDT