CRPkgPackage: Failed InitCRManager HR = 80040e14 m_cr7PrefsDB GetPreferences

0 Likes

Problem:

CRPkgPackage: Failed InitCRManager, HR = 80040e14 m_cr7PrefsDB GetPreferences when starting CodeReview

Resolution:

Please look at the Advanced Settings for your CodeReview7PrefsDB System DSN and see what the value is set to for ExtendedAnsiSQL.

If the value for ExtendedAnsiSQL is not 0 then please change it to 0, Click ok and then try to run CodeReview within .NET

This setting change is specific for this DSN connection and changing it will not effect anything else on your system.

Background:

In Jet 4.0 there is a new property called ExtendedAnsiSQL. The Jet OLEDB Provider version 4.0 turns on this new ANSI flag to enable new SQL syntax. Because the ExtendedAnsiSQL flag is turned on, Jet 4.0 uses the reserved words list defined by the SQL-92 standard. If the user tries to use a SQL-92 reserved word as an unquoted object name, an error is returned.

http://support.microsoft.com/default.aspx?scid=kb;en-us;238243

http://support.microsoft.com/default.aspx?scid=kb;EN-US;248738

Old KB# 11015
Comment List
Anonymous
Related Discussions
Recommended