Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: odbc driver parameters

Re: odbc driver parameters

From: ed zappulla <ed.zappullaNOSPAN_at_novatran.com>
Date: Tue, 22 Apr 2003 23:57:45 GMT
Message-ID: <ZFkpa.36086$ey1.3258925@newsread1.prod.itd.earthlink.net>


Thanks. I'll try it. I also found that DBQ=<tns> will work.

know of any way to get rid of using tnsnames.ora with ODBC?

"Amit" <jindal_at_roguewave.com> wrote in message news:b84f51$skj$1_at_tux.cvo.roguewave.com...
> You might need to add:
> CONNECTSTRING=orcl (or whatever your Oracle connect string is)
>
> "Driver={Oracle ODBC Driver};CONNECTSTRING=orcl;uid=scott;pwd=tiger;"
>
> It should then read the settings from tnsnames.ora
>
> -----------------------------------------------------------------
> Amit Jindal, Development Engineer
>
> Want ease of development or performance? Why not get both!
> http://www.roguewave.com/products/sourcepro/db/
>
> Turbo charge any C/C++ apps - without changing code!
> http://www.roguewave.com/ATSevan01
>
> [Disclaimer: All views expressed here are my personal views
> and they can be incorrect at times]
> -----------------------------------------------------------------
>
> "ed zappulla" <ed.zappullaNOSPAN_at_novatran.com> wrote in message
> news:5wcoa.31961$4P1.2882724_at_newsread2.prod.itd.earthlink.net...
> Does anyone know the connect string to send into the Oracle 8.1.6 ODBC
> driver so that I can make a DSN-less connection? all works well when i
send
> in DSN=foo and have foo setup in ODBC manager, which i want to eliminate
> using. Some how I have to sepc the machine, sid and port. Here's what I
> use SqlDriverConnect()
>
> "DRIVER={Oracle ODBC Driver};UID=foo;PWD=BAR;SERVER=somehost"
>
>
>
Received on Tue Apr 22 2003 - 18:57:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US