OLE DB Services and SQL Native Client

Is the option OLE DB Services = -4 still valid in the connection string with
the SQL Native Client ?Hello Michael,
The connection string in the SQL Native Client did not contain the OLE DB
Services option.
If you want to disable the resource pooling, please set the Pooling
property to false in the connection string.
SqlConnection.ConnectionString Property
http://msdn2.microsoft.com/en-us/li...t.sqlconnection
connectionstring(VS.80).aspx
This article described all the propertied you could use in the
ConnectionString.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I'm NOT using SqlConnection.
I'm using ADO (NOT ADO.NET) with Provider=SQLNCLI
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:S5EFMreZHHA.2372@.TK2MSFTNGHUB02.phx.gbl...
> Hello Michael,
> The connection string in the SQL Native Client did not contain the OLE DB
> Services option.
> If you want to disable the resource pooling, please set the Pooling
> property to false in the connection string.
> SqlConnection.ConnectionString Property
> [url]http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection[/ur
l]
> connectionstring(VS.80).aspx
> This article described all the propertied you could use in the
> ConnectionString.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Michael,
Thanks for the update.
Since the SQL Native Client works different with ADO, I am doult that ADO
did not fully compatitable with SQL Native Client. I will consult the
internal team to confirm whether we could use the Pooling setting in the
connnection string for ADO.
My suggestion is that you may considaring migrate your application from ADO
to ADO.NET if you do not have other concern. Please let me know whether you
have any concern about the ADO.NET. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||The application is HUGE and was developed using ADO which is why we can not
migrate.
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:nwGUjviZHHA.3800@.TK2MSFTNGHUB02.phx.gbl...
> Hello Michael,
> Thanks for the update.
> Since the SQL Native Client works different with ADO, I am doult that ADO
> did not fully compatitable with SQL Native Client. I will consult the
> internal team to confirm whether we could use the Pooling setting in the
> connnection string for ADO.
> My suggestion is that you may considaring migrate your application from
> ADO
> to ADO.NET if you do not have other concern. Please let me know whether
> you
> have any concern about the ADO.NET. Thank you!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Michael,
I did not get the reply from the internal right now.
Once I get the response, I will update you ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Michael,
According to the response from internal team, OLE DB SERVICES works for any
OLE DB Provider because it operates at the OLE DB service layer that is
used to instantiate a provider instance. i.e. it's not a provider-specific
setting. So you could still use the OLE DB SERVICES = -4 in ADO string.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Ah why do you keep polling like this? It just adds noise to the newsgroup.
We know you're there and want to help.
Thanks
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:kqiT3vGbHHA.3820@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello William,
I just want to check the status of the issue. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.