Installation Demo of WebSen System v.1.0.anna

March 23rd, 2012 by dr.emi

Popularity: 19% [?]

Database Configuration for MsSQL Server 2000 or higer in CakePHP 1.3.x or higher

March 11th, 2012 by dr.emi

I just found today, how to the best configuration for DBO Driver of MsSQL in CakePHP 1.3.7

First, I have try to make a connection to SQL Server 2000, 2005, and 2008. The result is always:

Warning (2): mssql_connect() [function.mssql-connect]: Unable to connect to server: 192.168.137.1\SQLEXPRESS,1433 [CORE\cake\libs\model\datasources\dbo\dbo_mssql.php, line 154]
Warning (2): mssql_select_db() expects parameter 2 to be resource, boolean given [CORE\cake\libs\model\datasources\dbo\dbo_mssql.php, line 159]

After done for googling in few day(s), I just found a bug based on error above, in

CORE\cake\libs\model\datasources\dbo\dbo_mssql.php, line 154

It looks likely, configuration is always overwrite into this line. But after read an article about port problem for mssql driver in cakephp (forgoten about where is the article link), I try to change it to port => ”

And the result is still not connected, although I have try too in native php. And it’s works with simple line:

$myServer = "192.168.137.1\SQLEXPRESS"; //I used sql server 2008
$myUser = "sa";
$myPass = "xxx";
$myDB = "mesin_finger"; 

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer"); 

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");

Next, trouble shoot continue to line before 154 in dbo_mssql.php: CORE\cake\libs\model\datasources\dbo\dbo_mssql.php

And the magic has come, after change $config['host'] to direct string ’192.168.137.1\SQLEXPRESS’, it’s WORK!
So, I just found the bug:

If I use $port as complete string in mssql_connect or mssql_pconnect, connection will not success, since in line 147 of dbo_mssql.php, I found this line:

} elseif ($config['port'] === null) {

It’s mean, we must set port configuration in database.php to null, NOT IN STRING value. The option is only null and numeric value.

Here are my database.php configuration:

var $attDbMsSqlServer = array(
                'driver' => 'mssql',
                'persistent' => false,
                'host' => '192.168.137.1\SQLEXPRESS',
                'login' => 'sa',
                'password' => 'xxx',
                'database' => 'mesin_finger',
                'prefix' => '',
                'encoding' => 'utf-8',
                'port' => null
        );

GOOD LUCK!!

Popularity: 20% [?]

Create a simple application to open an EXE file on the window with JAVA

March 27th, 2011 by dr.emi

Create a simple application to open an EXE file on the window with JAVA

We will learn about how to open EXE file with JAVA. We use netbeans as IDE. So, please create new JAVA Application project. And a small form.

read more

 

Popularity: 30% [?]

Interactive Ajax Data Management with Codeigniter

March 20th, 2011 by dr.emi

Interactive Ajax Data Management with Codeigniter

Hi there! this is super fast tutorial, when I was take a rest at the room. Oh god, where is my cofee and PUNK music. Aha!

This tutorial will show to you, how to create Interactive and very fast data management on one page together, without refreshing any page. One thing make this better “You are in codeigniter class of dr.emi” So, enjoy this tutorial.

read more

 

Popularity: 66% [?]

Membuat Manajemen Hak Akses User dengan Codeigniter

November 6th, 2010 by dr.emi

Membuat Manajemen Hak Akses User dengan Codeigniter malem eni gw akhirnya bisa juga nyolong2 waktu bwat nulis lagi. setelah skian lama pakum. ada tersirat, panggilan jiwa bwat nulis dan sharing lagi. setelah sekian lama males dan sibuk mncari napkah biar dapur ngebul terus. tapi setidaknya gw masih punya keinginan bwat sharing. pgimanepun, gw terlahir dari kalangan berpendidikan, orang tua gw guru smue. gw masih merasa terpanggil bwat sharing dan berbagi ilmu. tanpa banyak bacot, dan masih dalam bahasa gw yang acakadut ini, kite mulai dah tutorial pertama di bulan nopember ini. haahah!! LEGEK PISAN!!

read more

 

Popularity: 100% [?]

Web Base Controller System with NirCMD

February 28th, 2010 by dr.emi

Prikituw!!! gw awali selamat datang dr.emi wakakakakakaka .. slamat datang kok ama diri sndiri..

hehe, gw mang dah lama ga posting tutorial baru. berkutat ama urusan sendok ama piring di dapur. wkaakak..

tapi gw pernah janji kalo bakalan exist di blog legendaris ini. ya, dremi.INFO blog pertama gw mengudara sejak 2005, uset dah! emang radio apa… hahaaha

tapi sekalipun demikian, gw selalui ngikutin perkembangan pendidikan di tanah air. dan beberapa memang membuat gw geleng-geleng kepala. dari dulu ampe sekarang, tutorial yang gw jumpai, itu itu mulu. ayolah kawand, ciptakan sesuatu yang beda! biar popularitas kagak jadi tolak ukur sebuah blog. tapi kualitas nya juga donk!

read more

 

Popularity: 41% [?]

The Chain Tutorial from FuelYourCreativity

December 1st, 2009 by dr.emi

Chain Preview

This tutorial represents the second installment of a tutorial over at our friends PSDTUTSPLUS! In part one, we learned how to create this shiny chain from scratch in Photoshop. In this tutorial we’ll take that shiny new chain and weather, distress, and age it using layer styles, textures, and lighting effects to create our final result.

bonusiconAs a bonus, one lucky person will win a free Premium Membership to PSDTUTSPLUS by commenting on this tutorial!

So let’s get started!

Author: FuelYourCreativity.Com

read more

 

Popularity: 28% [?]

How to Check Username Availability using jQuery + PHP

November 3rd, 2009 by dr.emi

Hi! dude! how are you today ? I hope all of you will fine :)

Today is our nice day, it’s time to party. Let’s learn again about jQuery and PHP. How to create safety validation of username checker for your member register using jQuery and PHP ? Check it now!

read more

 

Popularity: 25% [?]

 
 
 
 
Category
stack

Switch to our mobile site