How can I prevent ADO from creating multiple SPIDs?

Posted by stusmith on Stack Overflow See other posts from Stack Overflow or by stusmith
Published on 2010-05-19T10:54:44Z Indexed on 2010/05/19 11:00 UTC
Read the original article Hit count: 215

Filed under:

ado

|

spid

|

connection

|

threads

I'm working on an application that creates a single ADO connection and keeps it open for the lifetime of the application. I have connection pooling turned off.

(Please ignore the fact that this might not be best practice for the purposes of this question).

If I spawn a new thread and use the exact same ADO connection, it uses a new SPID behind the scenes.

Is there anyway to ensure an ADO connection always uses the same SPID, across all threads?

(For reference the application is VC++ using ADO via COM to SQL Server).

© Stack Overflow or respective owner

Related posts about ado

Asp.net ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
RIA Services vs ADO.NET Data Services

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently in the process of creating a Silverlight 3 data driven application. To access the database, 2 common approaches are used: RIA Services and ADO.NET Data Services. Does anyone have any guidance on when/why to choose each approach? Here is what I've gathered from my research / experience… >>> More
Bogus InvalidOperationException (in a DataServiceRequestException)

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having a hard time with ADO.NET Data Services (formerly code-named Astoria) as it gives me a bogus exception when I try to insert a new entity from the silverlight client and trying in a clean project (the same code) doesn't. In both cases, however, data is correctly inserted into the database… >>> More
What is ADO ?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
What is ADO? ADO is a Microsoft technologyADO stands for ActiveX Data ObjectsADO is a Microsoft Active-X componentADO is automatically installed with Microsoft IISADO is a programming interface to access data in a databaseAccessing a Database from an ASP Page The common way to access a database… >>> More

Related posts about spid

SQL Server 2005 Sleeping SPID blocking another SPID...

as seen on Stack Overflow - Search for 'Stack Overflow'
I find many sleeping process my SQL Server database and looks like one of those sleeping SPIDs is blocking another process, and that process is getting suspended too... Could some one please explain this... 1.) How can a sleeping process block another process? 2.) I see many sleeping process...is… >>> More
What is the relationship between a SPID and a Connection in SQL server?

as seen on Stack Overflow - Search for 'Stack Overflow'
Can a SPID be used by two connections, while both connections are open? If a connection is returned to a connection pool, will it hold on to the SPID? >>> More
Can't see progress of rolling back SPID with KILL WITH STATUSONLY

as seen on Server Fault - Search for 'Server Fault'
I have a SPID on SQL 2005 that shows in Activity Monitor as "ROLLBACK" mode (because a transaction log filled up, not because it was manually killed). I tried to see how much time it has left to roll back with a KILL 115 WITH STATUSONLY but it just said "Status report cannot be obtained. Rollback… >>> More
How can I prevent ADO from creating multiple SPIDs?

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm working on an application that creates a single ADO connection and keeps it open for the lifetime of the application. I have connection pooling turned off. (Please ignore the fact that this might not be best practice for the purposes of this question). If I spawn a new thread and use the exact… >>> More
Oracle Support Master Note for Troubleshooting Advanced Queuing and Oracle Streams Propagation Issues (Doc ID 233099.1)

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Master Note for Troubleshooting Advanced Queuing and Oracle Streams Propagation Issues (Doc ID 233099.1) Copyright (c) 2010, Oracle Corporation. All Rights Reserved. In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting Details 1… >>> More