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

Home -> Community -> Usenet -> c.d.o.misc -> DSN-Less Oracle help PLEASE!

DSN-Less Oracle help PLEASE!

From: Darrin Smith <darren_smith_at_sabre.com>
Date: 1998/03/25
Message-ID: <6fbsma$2686@hector.sabre.com>#1/1

First off, thanks for reading.

Now, I have an Oracle database that I need to connect to. It is located on a Unix box (I'm using NT 4.0), and I can get to it only by its TCP\IP address name "somename.group.com" For discussion purposes, lets say the database name is MyDB. I'll be using Visual Basic 5.0 as the development tool.

I'm used to going into ODBC32, setting up a DNS entry for MyDB, and using that name in my connect string. How in the world do you connect without a DNS name and especially over TCP\IP?

All I can get from checking out Microsoft is that I need something like this:

sConnect = "Driver={Microsoft ODBC Driver for Oracle}; CONNECTSTRING=???????;Uid=MyId;Pwd=MyPwd"

So what goes into the ???????? and how do I set up the ??????? to use it?

Thanks.

Darrin

-- 
Legal Warning: Anyone sending me unsolicited/commercial/junk/spam 
e-mail WILL be charged a US$500 proof-reading fee.  Do NOT send 
unsolicited advertisements and do NOT add my e-mail address to your 
list(s):
"By US Code Title 47, Sec.227(a)(2)(B), a computer/modem/printer meets
the definition of a telephone fax machine.  By Sec.227(b)(1)(C), it is
unlawful to send any unsolicited advertisement to such equipment.  By
Sec. 227(b)(3)(C), a violation of the aforementioned Section is
punishable by action to recover actual monetary loss, or $500,
whichever is greater, for each violation."
Received on Wed Mar 25 1998 - 00:00:00 CST

Original text of this message

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