How to fetch AutoANSIToOEM, RegisteredOrganzation, etc. in SQLServer?

31 Dec 2005 7:23 PM

Mark Findlay

I have both default instances and named instances of SQLServer.

My reporting program is able to read the AutoANSIToOEM,
RegisteredOrganization and UseIntlSettings properties from the registry
under the HKLM\SOFTWARE\MICROSOFT\MSSQLSERVER\Client\DB-Lib key - but only
for the DEFAULT instance.

Are these properties available for named SQL Server instances? If so, how do
I access them programmatically?

I am using SQLDMO but the Registry object does not contain these properties.

Thanks!

31 Dec 2005 8:24 PM

Tibor Karaszi

I don't find a RegisteredOrganization in the Client setting. Also, it seems strange to look for
Client settings in HKLM. These are per user settings, no? Anyhow, these settings are for a client
app, and hence shouldn't differ for different instances. And, DbLib is an ancient API, dead since
long ago. Perhaps you can describe for what purpose you are reading these settings, what you are
doing with the settings you read?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"Mark Findlay" <mfind***@speakeasy.org> wrote in message
news:unV%237%23jDGHA.2628@TK2MSFTNGP09.phx.gbl...
>I have both default instances and named instances of SQLServer.
>
> My reporting program is able to read the AutoANSIToOEM, RegisteredOrganization and UseIntlSettings
> properties from the registry under the HKLM\SOFTWARE\MICROSOFT\MSSQLSERVER\Client\DB-Lib key - but
> only for the DEFAULT instance.
>
> Are these properties available for named SQL Server instances? If so, how do I access them
> programmatically?
>
> I am using SQLDMO but the Registry object does not contain these properties.
>
> Thanks!