Re: .1 in Providername

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/25/05 

Date: Thu, 24 Feb 2005 21:52:35 -0600

>when defining a connection-string I always get a .1 in the providername
>like SQLOLEDB.1. What does this .1 means? Has it something to do with
>threads?
No

>If I use multi_Threading I create a TADOConnection in every
>Datamodule.Create. Should I set the .x to a unique number?
No.

>BTW, is ADo
>with SQL-Server 7 thread-safe?
Yes

> I call CoInitialize in evry
>DataModule.Create and each thread has its own datamodule with its own
>TADOConnection but I get errors when two thread run at the same time.
>Any hints?
That is probably too late to be calling CoInitialize.
You should call Coinitialize before you create the datamodule. 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com