Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MGouders
Starting Member
30 Posts |
 Posted - 2009-10-06 : 20:27:39
|
| Hi,Does someone know where the information about an OLE DB provider is stored in the Windows Registry?The context of the question is OPENROWSET argument "provider_name".Excerpt from SQL Server 2005 Online Help:OPENROWSET ( { 'provider_name' Arguments' provider_name ' Is a character string that represents the friendly name (or PROGID) of the OLE DB provider as specified in the registry. Thanks |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2009-10-07 : 08:13:54
|
| check if you can find the provider name you need from here, to check which ones are available i usually just go to the data sources(ODBC) console under administrative toolshttp://www.connectionstrings.com/--------------------keeping it simple... |
 |
|
|
|
|
|
OLE DB Provider Information Stored in Registry