Re: Sql Server 2000 slow ... If I close the connection (moving the Open/Close ...ADO) and the dll gives twice the performance. ... > Are there any known performance issues with .NET accessing Sql Server... (microsoft.public.dotnet.framework.performance)
Re: Cross Transactions between ADO & ADO.Net ... MARS session pool limited to one connection?).... > There is one thing that might help here, if you're using SQL Server.... We even call ADO code from ... >> the DTC cordinator from COM+ to handle the transactions between ADO.Net ... (microsoft.public.dotnet.framework.adonet)
Re: absolute newbie question - connecting to SQL server in ADO.net ... How do I get the above connection working?... > experience of ADO prior to this was in Access 2000. ... Have I wasted my money buying VB.net standard because it can't connect to ... > an SQL server 2000 server? ... (microsoft.public.dotnet.framework.adonet)
Re: Connection issues with ADO ... >With ADO 2.5 the default connection protocol was named pipes.... I can always use Named Pipes to connect to my local sql server.... (microsoft.public.vb.general.discussion)
Re: Error -2147168227 Cannot create new transaction because capacity was exceeded. ... I'm not using nested transactions.... I've got a wrapper class on the ADO connection... Prior to that I've just closed the ADO recordset object.... >> I have been unable to find info in the Knowledge base, ADO or SQL Server... (microsoft.public.data.ado)
