Microsoft SQL Server Express Edition

Microsoft Product Page:  http://www.microsoft.com/express/Database/ Available free for both development and deployment. Available with a graphical management tool, reporting capabilities, full-text search, and spatial support. Ideal for building Web sites and apps, small scale LOB solutions or for redistribution with ISV applications. Custom Installation Instructions: http://www.microsoft.com/express/support/SQLServerExpress.aspx Supported Operating Systems Windows® Server 2003 Service Pack 2 Windows® Server 2008 Windows® Vista Windows® Server 2008 R2 Windows® 7 Windows® Vista Service Pack 1 Windows® XP Service Pack 2 Windows® XP Service Pack 3 Physical Limitations 32-Bit Systems: Computer with Intel or compatible 1GHz or faster processor (2 GHz or faster is recommended. Only […]

Read more

Open DataBase Connectivity (ODBC)

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”

Read more

Managing apps involving Sybase SQL Anywhere DBs

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

Read more