From: guptap@synygy.com (Prabuddha)
Newsgroups: comp.databases.oracle.misc
Subject: ODBC connection without Service name
Date: 12 Dec 2001 12:52:25 -0800
Organization: http://groups.google.com/
Lines: 7
Message-ID: <567752f5.0112121252.fbeeab3@posting.google.com>
NNTP-Posting-Host: 207.106.136.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1008190345 3386 127.0.0.1 (12 Dec 2001 20:52:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 12 Dec 2001 20:52:25 GMT


I want to connect Oracle without installing oracle client on every
client machine.Is there a way to give host, port and SID all in the
ODBC connection string.something like this-

Driver={Oracle ODBC Driver};DBQ=host:port:sid;Uid=user;Pwd=password;

I am using Oracle ODBC Driver.