Article View: borland.public.cppbuilder.database.ado
Article #4727Re: ADO Performance problems
From: Matt Jacobs
Date: Wed, 21 Nov 2001 07:41
Date: Wed, 21 Nov 2001 07:41
12 lines
1349 bytes
1349 bytes
Are you trying to access multiple recordsets simultaneously in SQL Server? If so, you know about SQL Server's one open cursor per connection restriction, correct? Since SQL Server does not allow multiple open recordsets, ADO opens a new connection per recordset for you automatically. Perhaps this is the problem? -- My reply-to address is purposely mangled to thwart auto-reply bots. Please remove the two leading underscores if you wish to reply via e-mail.
Technical Details
Message-ID:
<3bfb5993.2222512@forums.inprise.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!195.238.2.15!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3bf579f2$1_1@dnews> <3bf5d57f.325120468@newsgroups.borland.com> <3bfae5f4$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,9defb43ff18ceee2 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-11-20 23:47:01 PST From: mattja@ix.netcom.com (Matt Jacobs) Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: ADO Performance problems Date: Wed, 21 Nov 2001 07:41:50 GMT Reply-To: __mattja@ix.netcom.com Message-ID: <3bfb5993.2222512@forums.inprise.com> References: <3bf579f2$1_1@dnews> <3bf5d57f.325120468@newsgroups.borland.com> <3bfae5f4$1_2@dnews> X-Newsreader: Forte Free Agent 1.21/32.243 NNTP-Posting-Host: 24.254.59.80 X-Trace: dnews 1006328390 24.254.59.80 (20 Nov 2001 23:39:50 -0800) Lines: 12 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!195.238.2.15!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews