Day: June 17, 2011

ALTER DATABASE <DB Name> SET Online ALTER DATABASE <DB Name> SET Offline

Creating USER DSN via Registry: [HKEY_CURRENT_USERSoftwareODBCODBC.INITEST-SQL-ODBC] "Driver"="C:\Windows\SysWOW64\sqlncli.dll" "Description"="TEST-SQL-ODBC" "Server"="SERVER01\SQLINSTANCE01" "Database"="TrackAsset" "LastUser"="sa" [HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources] "TEST-SQL-ODBC"="SQL Native Client" Verifying the creation by registry query: C:>reg query "HKEY_CURRENT_USERSoftwareODBCODBC.INITEST-SQL-ODBC" HKEY_CURRENT_USERSoftwareODBCODBC.INITEST-SQL-ODBC     Driver    REG_SZ    C:WindowsSysWOW64sqlncli.dll     Description    REG_SZ    TEST-SQL-ODBC     Server    REG_SZ    SERVER01SQLINSTANCE01     Database    REG_SZ    TrackAsset     LastUser    REG_SZ    sa1 C:>reg query "HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources" /v "TEST-SQL-ODBC" HKEY_CURRENT_USERSoftwareODBCODBC.INIODBC Data Sources     TEST-SQL-ODBC    REG_SZ    SQL Native Client C:>   Creating 32-bit SYSTEM DSN via Registry: [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INITEST-SQL-ODBC] "Driver"="C:\Windows\SysWOW64\sqlncli.dll" "Description"="TEST-SQL-ODBC" "Server"="SERVER01\SQLINSTANCE01" "Database"="TrackAsset" "LastUser"="sa" [HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INIODBC Data Sources] "TEST-SQL-ODBC"="SQL Native Client" Verifying the creation by registry query: C:>reg query "HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INITEST-SQL-ODBC" HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INITEST-SQL-ODBC     Driver    REG_SZ    C:WindowsSysWOW64sqlncli.dll     Description    REG_SZ    […]

ERROR#0: ————————— Microsoft SQL Server DSN Configuration ————————— IMADirectory is not an existing data source name. ————————— OK   ————————— ————————— Driver’s ConfigDSN, ConfigDriver, or ConfigTranslator failed ————————— Errors Found: Invalid DSN ————————— OK   ————————— CAUSE: This error usually indicates that respective registry path for ODBC is no longer available (must have been previously existed). The general case for this is an admin/application renamed it’s registry path. TROUBLESHOOTING: Ensure that respective (HKLM-for System DSN;HKCU-for User DSN) registry entry exists for the reported DSN. System DSN: HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBC.INI<ODBC Name> User DSN: HKEY_CURRENT_USERSoftwareODBCODBC.INI<ODBC Name>   Also there should exist below entry which appears in […]