Re: ADO connection to Oracle gets a listener error, but only on the first few attempts

Home -> Community -> Usenet -> c.d.o.server -> Re: ADO connection to Oracle gets a listener error, but only on the first few attempts

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 06 Jun 2003 19:28:42 +0200
Message-ID: <toj1evgvlr0pvl9m047n35tgqtc8gc680r@4ax.com>

On 6 Jun 2003 08:40:40 -0700, mark_freeman_at_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 Received on Fri Jun 06 2003 - 12:28:42 CDT