Re: ODBC/OLE DB Connection Pool

From: Kevin Joseph (kejoseph_at_hotmail.com)
Date: 11/25/04 

Date: 24 Nov 2004 20:46:45 -0800

Stuart,

You are correct about the perfmon counters part - what I meant was
that even when I had the connection string set for ODBC I could not
see those counters rise - which is why I then switched to OLE DB.

Anyway, I have read quite a bit about the latter section in your
e-mail (about IDataInititalize etc) but am not sure how to do that.
Pardon my lack of knowledge in this are but can I have a simple .exe
file running in the background performing this function.

Thanks a lot again for your reply ; really appreciate it.

PS: I have verified basic things like the reg entry etc and they are
good.

Kevin.

"Stuart Carnie" <StuartCarnie@newsgroup.nospam> wrote in message news:<uNafsbn0EHA.1152@TK2MSFTNGP14.phx.gbl>...
> OLE DB connection pooling is not the ODBC counter. You do not need to force
> OLE DB connection pooling with the OLE DB Services=-1 setting, as most
> providers already have this on. e.g., look the the SQLOLEDB class ID in the
> registry:
>
> HKCR\CLSID\{0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}, and you will see a DWORD
> key called OLE DB Services set to -1 (0xffffffff).
>
> To get OLE DB connection pooling to work, an instance of the OLE DB
> interface, IDataInitialize must be maintained. In the ADO world, this
> translates to - you must keep at least one ADO connection around. In the
> past, I have used the MDAC simple provider (since it is not a connection to
> any real db, but adequetly, it keeps IDataInitialize around).. The
> connection string for the Simple Provider is "Provider=MSDAOSP.1;Persist
> Security Info=false". Just create an ADO connection with this.
>
> Not sure how to translate this to ASP, since I don't know enough of whether
> you have some global place to create a persistent object. I always thought
> ASP / IIS did this for you.
>
> Cheers,
>
> Stu
>

Relevant Pages

  • Re: DDE Access to Word using mde
    ... OLE DB is the method that Word 2002/2003 use by default - in fact, given the code you are using, I am pretty sure that when your Access code opens the word document in Word 2002/2003, Word will be using OLE DB rather than DDE to open the data source. ... So either the OLE DB connection is handling your dates and memos just fine, or I'm wrong and DDE is being used. ... ODBC should get your dates OK, but you would need to use switches in the Word fields to format them correctly. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to use ODBC with a DB connection in ASP.NET
    ... How to let the DataGrid to use a connection that is pointed to an ODBC? ... > a database product that doesn't have an OLE DB driver? ... > .Net Developer ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Re: as as well as Maify relates, you can murmur the fur much more though
    ... The match in connection with the other hardware is the hospital that ... If you will beg Anne's node in search of counters, ...
    (sci.crypt)
  • Re: CONCAT_NULL_YIELDS_NULL in connect string
    ... > setting is off by default for ODBC connections but on for OLE DB ... CONCAT_NULL_YIELDS_NULL is on by default for connection both from OLE DB ... Note that there are certain features in SQL Server that you don't have ...
    (microsoft.public.data.oledb)
  • Re: "Select Table" dialog with no table selectable
    ... Ah, OK, your connection is using OLE DB. ... see if connecting using ODBC works. ... > string (the 12th argument passed to the OpenDataSource method): ...
    (microsoft.public.word.mailmerge.fields)