| View previous topic :: View next topic |
| Author |
Message |
Stefan Westner
Guest
|
 Posted: Thu Feb 24, 2005 10:53 am Post subject: .1 in Providername |
 |
|
Hello,
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? If I use multi_Threading I create a TADOConnection in every
Datamodule.Create. Should I set the .x to a unique number? BTW, is ADo
with SQL-Server 7 thread-safe? 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?
Thanks
Stefan Westner
|
|
| Back to top |
|
 |
Stefan Westner
Guest
|
| Posted: Fri Feb 25, 2005 3:11 pm Post subject: Re: .1 in Providername |
|
|
Brian Bushay TeamB wrote:
| Quote: | 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
Hello Brin, |
what does the .1 ... then mean then instead?
Thanks
Stefan
|
|
| Back to top |
|
|
Dennis Passmore
Guest
|
| Posted: Fri Feb 25, 2005 6:17 pm Post subject: Re: Re: .1 in Providername |
|
|
The ".1" is actually a part of the actual 'ProgID' value in the registry for that
provider. Just do a search in regedit for 'SQLOLEDB.1'
Dennis Passmore
Ultimate Software, Inc.
|
|
| Back to top |
|
|
Stefan Westner
Guest
|
| Posted: Fri Feb 25, 2005 9:59 pm Post subject: Re: .1 in Providername |
|
|
Hello Dennis,
thanks. Further question: if I build the connection-string dynamically
in my datamodule I have to set the provider. If I want to use
SQL-Server I set SQLOLEDB. Do I need to add the .1 and is the .1 the
same on every computer or could this vary and if this could vary is it
a problem to set it to the wrong value or where should I get the right
value?
Stefan
Dennis Passmore wrote:
| Quote: | The ".1" is actually a part of the actual 'ProgID' value in the
registry for that provider. Just do a search in regedit for
'SQLOLEDB.1'
Dennis Passmore
Ultimate Software, Inc.
|
|
|
| Back to top |
|
|
Viatcheslav V. Vassiliev
Guest
|
| Posted: Fri Feb 25, 2005 10:14 pm Post subject: Re: .1 in Providername |
|
|
..1 is version number. SQLOLEDB uses latest version of provider, SQLOLEDB.1 -
version 1 (it is not related to MDAC version). Because for Yukon (MS SQL
Server 2005) there will be new OLEDB provider (SQLNCLI), it seems that .1
will be the last version for SQLOLEDB. It is better to show on MS Office -
Word.Application.11 is for Office 2003, just Word.Application - for latest
installed Word, i.e. if you have Office 2000, you will be able to create
object Word.Application but not Word.Application.11.
Both SQLOLEDB and SQLOLEDB.1 are ProgID, so setting wrong number (value that
is not in HKCRSQLOLEDB.X in registry) will not work.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Stefan Westner" <s (AT) westner (DOT) de> сообщил/сообщила в новостях следующее:
news:421f9fc9$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Hello Dennis,
thanks. Further question: if I build the connection-string dynamically
in my datamodule I have to set the provider. If I want to use
SQL-Server I set SQLOLEDB. Do I need to add the .1 and is the .1 the
same on every computer or could this vary and if this could vary is it
a problem to set it to the wrong value or where should I get the right
value?
Stefan
Dennis Passmore wrote:
The ".1" is actually a part of the actual 'ProgID' value in the
registry for that provider. Just do a search in regedit for
'SQLOLEDB.1'
Dennis Passmore
Ultimate Software, Inc.
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
