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: Amit <jindal_at_roguewave.com>
Date: Tue, 22 Apr 2003 15:19:36 -0600
Message-ID: <b84f51$skj$1@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 - 16:19:36 CDT

Original text of this message

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