"jacky" <lojiancn@hotmail.com.(donotspam)> wrote in message
news:D9400131-BF04-44F2-99F2-01E99A7E08A3@microsoft.com...
>I forgot to put:
> SQL Server 2000 SP4 running on Windows 2003 Server.
> --
> I like computer!!!
>
>
> "??" wrote:
>
>> I am doing a replication program for replicating SQL SERVER 2000's data
>> to an
>> ODBC subscriber in pull mode using Microsft SQLDistribution ActiveX
>> Control,
>> my code is like
>> /* initialization some properties of the SQLDistribution object */
>> hr = ::CoCreateInstance(CLSID_SQLDistribution, NULL,
>> CLSCTX_INPROC_SERVER,
>> IID_ISQLDistribution, (LPVOID *) &pSQLDistribution);
>> pSQLDistribution->put_Publisher(bstrPublisher);
>> .....
>>
>> /*then ,loop to calling Run method, until recived exit signal*/
>> while ( !bToExit )
>> {
>> pSQLDistribution->Initialize();
>> pSQLDistribution->Run();
>> pSQLDistribution->Terminate();
>> Sleep(3000);
>> }
>>
>> for clarity, i have ignored error-detect codes.
>>
>>
>> The program is functioning successfully, but I notice many memory leaks.
>> I am sure the leaking is not caused by other code in my program because I
>> do
>> only run the codes in the loop.
>>
>> Has anyone had known this program or any advice, please feel free to tell
>> me.
>> Many Thanks!
>>
>> Jacky.
>>