From: Walter T Rejuney Newsgroups: comp.databases.oracle.misc Subject: Re: Visual Basic connection to Oracle Personal 8i Date: Tue, 12 Dec 2000 08:17:25 -0500 Organization: xyzzy Lines: 23 Message-ID: <3A362565.F6299339@Unforgetable.com> References: NNTP-Posting-Host: 135.35.139.47 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.76 [en] (Win95; U) X-Accept-Language: en Jim wrote: > Hello everyone: > > I've just installed Oracle 8i Personal version and want to connect to the > database using Visual Basic. I've been trying to figure out the > documentation but my background is such that I don't seem to get it. Can > someone give me the steps I have to follow to use VB as a front end to the > data base? I've been trying different things but get errors such as: > > Test Connection failed because of an error in initializing provider. > ora-12154 . TNS:Could not resolve service name. > Error in initializing provider ora-12560. Etc.... > > I've been trying to use Net8 but no luck. > > Thanks for any help you can give me! What method of connection are you trying to use? ODBC? OLEDB? RDO? DAO? OO4O? All of them have separate techniques - although all of them depend on sucessfully creating a service name via Net8.