ORACLE & VB
From: Olivier Sanzot <olivier.sanzot_at_solvay.com>
Date: Thu, 27 Aug 1998 09:03:12 +0200
Message-ID: <35e5052a.0_at_nohsn014.noh.be.solvay.com>
Hello,
I'm trying to connect to an Oracle DB using ADO 2.0 and the OLEDB provider. It seems to work fine but I find it very very very slow. It take 17 seconds to connect, create a recordset and loop thru 6800 records.
Is it normal ?
Could someone mail me some connection string samples ? My connectionstring is a DSN using SQL Net. Is it a problem ? As you can see, lot's of questions.
Thanks in advance.
Olivier Received on Thu Aug 27 1998 - 09:03:12 CEST
Date: Thu, 27 Aug 1998 09:03:12 +0200
Message-ID: <35e5052a.0_at_nohsn014.noh.be.solvay.com>
Hello,
I'm trying to connect to an Oracle DB using ADO 2.0 and the OLEDB provider. It seems to work fine but I find it very very very slow. It take 17 seconds to connect, create a recordset and loop thru 6800 records.
Is it normal ?
Could someone mail me some connection string samples ? My connectionstring is a DSN using SQL Net. Is it a problem ? As you can see, lot's of questions.
Thanks in advance.
Olivier Received on Thu Aug 27 1998 - 09:03:12 CEST