connection object question...

Last Post 22 Jun 2006 08:43 AM by sqladmin. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
sqladmin
New Member
New Member

--
22 Jun 2006 07:36 AM
i'm looking over some dts documentation...

i'm looking at the connection object, and noticed
it's listing the following as a "provider":

Provider: {0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

i don't know what this is... i don't see it in any of the
sysdts* tables under the msdb database.

this is supposed to be the connection object, but i don't
see where this value was pulled from. can this be right?

is there another way to see there a programatic way
to see the particulers behind the connection object?

thoughts?
sqladmin
New Member
New Member

--
22 Jun 2006 08:43 AM
you mean under the dts designer? of course... i can get the properties that
way, but i was hoping to obtain this information through a query.

do you happen to know of another way?
sqladmin
New Member
New Member

--
22 Jun 2006 09:43 AM
turns out this value is simply the Class ID from the registry to represent
Microsoft OLEDB Driver for SQL Server

CLSID\{0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

this is also the GUID that the dts designer is referencing
when it gives you the list of the connection drivers.

incidentally all connection drivers have a CLSID reference number
in the registery. i believe oracles driver id is the following:

{0C7FF16C-38E3-11D0-97AB-00C04FC2AD98}

sqladmin
New Member
New Member

--
22 Jun 2006 09:50 AM
CLSID's for some of the common Microsoft providers are:

SQLOLEDB (SQL Server native provider)
HKEY_CLASSES_ROOT\CLSID\{0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}
Microsoft.Jet.OLEDB.4.0 (Jet native provider)
HKEY_CLASSES_ROOT\CLSID\{dee35070-506b-11cf-b1aa-00aa00b8de95}
MSDAORA (Oracle native provider)
HKEY_CLASSES_ROOT\CLSID\{e8cc4cbe-fdff-11d0-b865-00a0c9081c1d}
MSDASQL (OLE DB Provider for ODBC)
HKEY_CLASSES_ROOT\CLSID\{c8b522cb-5cf3-11ce-ade5-00aa0044773d}


hope this is useful.

cheers


Acceptable Use Policy
---