Category: DataBase

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 […]

When you have any of your SQL DB table named with any of the SQL keyword, SQL will error as shown below.  In the example, I am using a table named User which is also a SQL keyword. Query: select * from dbo.User (nolock) where Name like ‘%test%’ Error: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword ‘User’. The trick to use the SQL reserved/keyword in your SQL names you need to enclose the name within either braces [] or double quotes “” as shown below. Query:  select * from dbo.[User] (nolock) where Name like ‘%test%’ select * from dbo.”User” (nolock) where Name like […]

Oracle 9,10g Sybase ASE 12,15 An Oracle instance consists of: A) Six processes: PMON Process Monitor, SMON System Monitor, DBWn Database Writer, LGWR Log Writer, ARCn Archiver, and CKPT Checkpoint. Additional processes on a 10g RAC system may include RECO Distributed Transaction Recovery, CJQn Job Coordinator Process, LCKn Shared Resource Locking, LMDn Global Lock Manager, LMON Lock Manager, LMS* Global Cache Service, MMAN Memory Manager, MMNL Metrics Monitor, session hitory, metrics computation, MMON Metrics Monitor, statistics, snapshots, and PSPn a PL-SQL plug in. B) Data files which contain the tables and other data objects, control files which contain configuration information, […]