Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> DSN-Less Oracle help PLEASE!
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