Jordan Redman, experience in patent law and primary legal councel.

Welcome to the company.

-Dan Tsosie

PDO tdslib driver:

This is the installation I recommended last. It was my most recent discovery and fixed all issues I had previously had except for one. Output variables are not to be binded to, and there is no support for multiple result sets, so it can be easy to get the error of all results were not exhausted.

In comparison with the previous driver, these are small fry.

PDO mssql through freetds as odbc driver:

This driver had many problems. Nulls would crash processing, strings above 255 characters would try to allocate 4gb ram, exceptions were not reported. This was the first segment we tackled and we worked around all these failings, but a permanent solution, never.

Solution 3:

A newcomer solution with much experience is now on the scene. Stay tuned for my analysis of its readyness

My first solution was to use FreeTDS, Linux ODBC and PDO ODBC. Out of a myriad voodoo style solutions, this one seemed the most straight forward. Unfortunately, there were issues. Exceptions never really worked right (caused the PHP module to die), NULL values were essentially unsupported, and if any string took more than 255 characters, PHP would demand 4GB of RAM.

Due to the short deadline of the project, crazed hacks were implemented, but I vowed to solve the issue properly at a later date.

So, after having long since conquered the beast, I present the ultimate guide, cradle to grave.

First step is a proper driver for MSSQL that works in Linux. The best and officially PHP supported is FreeTDS at http://www.freetds.org/

This guide assumes freetds-0.91.

Once you have it:

tar xzf freetds.tar.gz
cd freetds-0.91
./configure --with-tdsver=7.1 --enable-msdblib --with-gnu-ld && make
sudo make install
sudo /sbin/ldconfig

Once installed, you can do a basic connectivity test.

/usr/local/bin/tsql -S host -U username

You will be prompted for password. If you get a prompt, all is well.

Now for PHP, assuming PHP 5.3.8.

./configure line should have whatever your environment needs, but the key addition is the following:

--with-pdo-dblib=/usr/local

The libraries from FreeTDS by default go there in Centos, so that is where PHP needs to look.

Once PHP is all installed, we can do a basic test that things are working with a quick script.

<?php
$dbh= new PDO('dblib:host=hostserverhere;dbname=databasename;appname=MySweetApp', 'username', 'password');
$stmt = $dbh->prepare("SELECT SYSDATETIME()");
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row);
}
unset($dbh); unset($stmt);
?>

Run that and if you get output, congrats, you have succeeded.

That should be enough to get you started. Next edition, I share some PDO recipes to help the non-MSSQL familiar.

I removed that controller from device manager and then all was well. Next step is to setup the Saitek X52 Pro

http://www.sevenforums.com/software/3020-wmplayer-process-resurrects-itself-hogs-50-cpu.html

If you have a G15 keyboard and windows media player, go to windows sideshow in the control panel and disable wmplayer from it.

And the stock template needed these changes, as back to school ads were default present. Product management also made a lot more sense for bulk goods sellers. As I researched the various eCommerce solutions, I found few that catered to the type of products artists deal with, that is one of a kind products.

The closest I found was opencart. The result of my brief experience is now at the relaunched Richard Tsosie Gallery. The backend of this cart has my attention and I definitely am contemplating making a batch of changes to suite my needs and push upstream.

Level 2 was being forsaken by textmate and forced to use windows as a dev environment. Being trapped into any environment because of a tool was not good times. I tried many IDE’s but I preferred the quick simplicity of textmate. I also had a coworker who was big on the Vi. I started with just basic functions like syntax highlighting. Little did I know what would come.

Level 3 is comfort with VI and missing it when not available. Vi works on everything? How could it not be available you may ask? This is the distinction between IDE’s and Vi in my opinion. Vi is not an IDE. No one wants FireFox to act like Visual Studio. But thanks to the good people who created http://vimperator.org/vimperator there is a way to have command line functionality in firefox and vi flavor.

Mouse and Keyboard is leet for FPS, but most functions don’t need analog input and so you waste one hand using the mouse. Apply both hands to browsing and such and you have a very neutral resting position and skip the repeated movements from keyboard to mouse.
Include command line like syntax for debugging which I hope to investigate soon, I have a fun time ahead indeed. Can’t wait for what I find in level 4.

To fix, I found a new version of VimBall.tar.gz (think it was V28). I then extracted it to the vim main directory rather than my personal plugin directory. This seemed to fix it and all was well.

I used most but the SQL plugin. One lacking from the list is the command-t plugin. It requires you to install ruby and its dev headers, but in return you get a file finder almost better than TextMates. Folding I must learn and windows, but my coding speed with VI nav short cuts and block editting have been tremendous. Taking 3 lines and moving them down while indenting them without moving from the home row keys is pretty cool. I also think Its more comfortable since I was getting some RSD from moving to the mouse but without that motion, my hands feel much better.

I highly advise learning vi, even a little at a time. I thought I couldn’t live without TextMate. But now I know I can have the same level of editting (minus cool plugins) on any nix box by default. Much cooler than being stuck on an IDE Island.