PHP MSSQL 2005 Problem – Solved

Trying to make a connection to a MS SQL Server 2005 database from PHP, I always got an error message using the mssql_connect saying:

Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: {servername}.

I tried several solutions like, updating the ntwdblib.dll (on windows; I had the same error on linux) library, configuring the tcp/ip properties on sqlexpress but nothing I still having the same error.

At the end I changed the ip address on the server name by the respective server name and finally worked!.

So instead of:


$server = 192.168.50.1;
$user = 'sa';
$password = 'sapassword';
$conn = mssql_connect($server, $user, $password);

Changed for:

$server = cmanonserver;

Transfer DVD to iPod Classic

After several attempts to transfer some of my concert dvds to my ipod, finally got them working, here is how:

I first update the ffmpeg packages from medibuntu, after this install dvd::rip package from multiverse, once I had dvd::rip opened a new project, and select the option to “Encode DVD on the fly” in order to save some space in my disc, here is an screenshot about the settings I used to encode:

dvd::rip encode options

Once I had the .avi file I execute the following command to convert the file to a .mov:

ffmpeg -i 24_1_001.avi -f mov -b 1800 -maxrate 2500 -vcodec xvid -qmin 3 -qmax 5 -s 640×360 -padtop 30 -padbottom 30 -acodec aac -ab 128 24_1_001.ipod.mov

The result is a good quality video to enjoy it in your ipod.

OpenSuse 10.3

This post is not a review of openSuse 10.3.

I downloaded the DVD for my AMD64 bits computer and it is one of the most buggy installation I’ve tried in the Linux world, I were not able to install it on my computer, all the times I tried it always get stuck installing the grub package, I checked the media to know if there was a problem with it, but the installer told it was ok, I tried to repair the install once it was started and when I chose the repair option and click next, the computer just restarted.

I will stick to Ubuntu and will wait patient for the next (Gutsy) release.

Eclipse

I’m trying to setup my development platform for PHP on Linux, I chose eclipse PDT, to complete this task with PDT version 1.0 need to download and install eclipse 3.3 RC1, to make it work per the module requirements, after a download of 250 mb approximately, it didn’t work.

I’m trying to install the old PHPEclipse plugin. Wish me good luck!

UPDATE: I just downloaded the old PHPEclipse plugin and it worked with the Eclipse 3.2.2 IDE.

UPDATE: I just noticed that for the new version of PDT tools you need to run Eclipse with Java 5 JDK.