Slow OLEDB Connection

From: Lance Barger <lance_at_parsecorp.com>
Date: 27 Aug 2004 09:29:42 -0700
Message-ID: <c0ba5d2b.0408270829.623e82de@posting.google.com>

I downloaded Oracle 10g on Monday and connected to it via OLEDB. The problem is that the connection takes around 30 sec. to open. I need to get this connection time to less than 1 sec. The test client and database are running on the same machine:

XP Pro
2.0 gig Processor
512 meg RAM

ConnectionString: "Provider=oraOLEDB.oracle;data source=OraVersi;User ID=system;Password=LithoPerf;"

tnsnames.ora:

ORAVERSI =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =

lance.conictechnologies.com)(PORT = 1521))

(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = OraVersi.conictechnologies.com)

    )
  )

Thanks in advance for any help

Lance Barger
Parsec Corporation
lanceb_at_parsecorp.com
303-423-4546 x 25 Received on Fri Aug 27 2004 - 11:29:42 CDT