connection object question...

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

22 Jun 2006 08: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?

New Member
New Member

22 Jun 2006 09: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?
New Member
New Member

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


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:


New Member
New Member

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

SQLOLEDB (SQL Server native provider)
Microsoft.Jet.OLEDB.4.0 (Jet native provider)
MSDAORA (Oracle native provider)
MSDASQL (OLE DB Provider for ODBC)

hope this is useful.


Acceptable Use Policy