Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!news.webusenet.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.server Subject: Re: ADO connection to Oracle gets a listener error, but only on the first few attempts Date: Fri, 06 Jun 2003 19:28:42 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon.nl References: X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@supernews.com Lines: 18 Xref: core-easynews comp.databases.oracle.server:188897 X-Received-Date: Fri, 06 Jun 2003 10:27:51 MST (news.easynews.com) On 6 Jun 2003 08:40:40 -0700, mark_freeman@asc.aon.com (Mark Freeman) wrote: >The code that makes the connection (in the interests of security, >actual strings have been replaced with pound signs): > > Dim cnnOracle As ADODB.Connection > Set cnnOracle = New ADODB.Connection > cnnOracle.Open "Provider=msdaora;Data Source=##;User >Id=##;Password=##;" Basically making it's inclusion COMPLETELY useless as the problem is in the DATA source element. Sybrand Bakker, Senior Oracle DBA To reply remove -verwijderdit from my e-mail address