Category: Database

0

Microsoft Access Data Types

The following table shows the Microsoft Access data types, data types used to create tables, and ODBC SQL data types. Microsoft Access data type Data type (CREATETABLE) ODBC SQL data type BIGBINARY[1] LONGBINARY SQL_LONGVARBINARY...






0

Change or Alter multiple database table schema

Sometime as a database developer, we might come across changing the schema for the whole database This is one way to do it; by generating multiple queries in the query editor: SELECT ‘EXEC(”sp_changeobjectowner @objname...






0

Shrink log size in sql database

To shrink the file size I use the following script: Use DBName Go exec sp_dboption DBName, ‘trunc. log on chkpt.’, true checkpoint DBCC SHRINKFILE (N’DBNameFileName, 0); exec sp_dboption DBName, ‘trunc. log on chkpt.’, false






0

How to enable 32-bit web server on 64-bit IIS

C:\>cscript C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 C:\>cd windows\microsoft.net\framework\v2.0.50727 C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis.exe -i C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>NET STOP W3SVC /y & NET START W3SVC ERRORS: Microsoft OLE DB Provider for ODBC Drivers error ‘80004005’ [Microsoft][ODBC Driver Manager] The specified DSN contains...






0

PHP Frameworks

PHP Framework PHP4 PHP5 MVC Multiple DB’s ORM DB Objects Templates Caching Validation Ajax Auth Module Modules EDP Akelos   – ash.MVC   – – – – – – CakePHP   – – CodeIgniter   – – –...