Day: February 22, 2011

Microsoft Open DataBase Connectivity (ODBC) is a standard application programming interface for connecting client applications to Windows-based database management systems. 64-bit versions of Windows maintain two sets of the System Data Source collection; one for 64-bit (“C:WindowsSystem32odbcad32.exe”) applications and one for 32-bit (“C:WindowsSysWOW64odbcad32.exe”) applications. To create a System Data Source that is accessible to both 64-bit and 32-bit applications, you must run a copy of the 32-bit ODBC Administrator (located in the WINDOWSSysWOW64 folder). To avoid connection problems, set up your 32-bit System Data Source exactly like your 64-bit System Data Source. Typical ODBC.INI file location is “C:WindowsODBC.INI”

How Sybase SQL Anywhere works? Most of the apps that embed the SQL Anywhere DBs use’s OEM Authenticated Edition, for complete list of editions refer to this page. Consists: The SQL Anywhere server : The network server, for managing databases using a client/server arrangement on networks The SQL Anywhere engine : The database engine, for managing databases on a single computer in a standalone mode Difference: The SQL Anywhere server and SQL Anywhere engine manage databases in exactly the same way and are completely compatible. However, the SQL Anywhere engine has no support for network communications. You can use SQL […]