Le Kevin dot com

photographic-poetic-musical horizon

Browsing Posts in Database

This is where the 32 bit odbc manager is: C:\Windows\SysWOW64\odbcad32.exe

SQL Server 2008 Proximity Search With The Geography Data Type by SQLDenis Permalink 11 Feb 2009 13:27 , Categories: Data Modelling & Design, Microsoft SQL Server Tags: geography, geomapping, spatial data, sql server 2008 George and I decided to show you how you can do simple radius searches based on Zip Codes, he did the […]

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

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 an architecture mismatch between the Driver and Application Run C:\Windows\SysWOW64\odbcad32.exe to setup DSN Restore & Backup IIS 7 > %windir%\system32\inetsrv\appcmd.exe add […]

PHP Framework PHP4 PHP5 MVC Multiple DB’s ORM DB Objects Templates Caching Validation Ajax Auth Module Modules EDP Akelos   – ash.MVC   – – – – – – CakePHP   – – CodeIgniter   – – – – – DIY   – – – – – – eZ Components   – – – – – – – Fusebox   – – […]