On my regular job, I have a task that would require accessing an MS Access database on IIS server.
Here's some simple list that I've do.
1. Make sure ODBC is supported on your install of php.
2. Make a data source name on Control Panel -> Administrative Tools -> Data Sources (ODBC) click the System DNS tab.
3. Point to the .mdb file location
4. Use php ODBC functions
Here are some equivalent functions if you have an existing code in php that uses mysql, you just rename some mysql functions to odbc.
mysql_connect / mysql_pconnect = odbc_connect / odbc_pconnect
mysql_query = odbc_execute
mysql_fetch_array = odbc_fetch_array
mysq_free_result = odbc_free_result
Be sure to check the php manual for proper arguments.
Netscape has been my first browser when I first experienced the web, it was a beautiful experience. Until I start developing HTML sites back then Internet Explorer has a good support for lazy HTML coders. Then suddenly Netscape sucks.
So I switch to Internet Explorer as it is freely comes with every windows installation and back then the rendering of HTML was faster than Netscape. After a wink of an eye Internet Explorer rules the market then came bugs and security issues specially if you use the Internet on e-commerce. You'll see people complaining their credit card or e-wallet accounts get hacked in every part of the online forums when do made purchases online.
Then came Mozilla a w3c compliant browser, then a much more strip down version called Firefox. Until now I use it as a browser. I heard that AOL wants to revived Netscape back again to it's glory days. I was happy with Firefox so I did'nt bother.
Then came the news last December 28, 2007, on every tech email that I've been subscribe to pointing to the Netscape Blog, it is official that Netscape will end it's support on Feb 2008. Even though I didnt use it anymore I was sadden about the news, I dont know maybe first love never dies, hahaha.
I think a wrong marketing approach has been used by AOL that contributes to the death of Netscape.
I don't believed in Chinese zodiac, well it just happened some pesky rats eaten our fiber optic cable. Our office server have been off line almost 48 hours and no connection from the outside world, actually the third time happened last year. Do you know how it feels ? It feels unproductive, hahahaha.
Well many thanks to Dr. Tiglao of UP Computer Center, he facilitated effectively handling the situation, hes a gem in UP. Those who are saying bad things behind his back, why don't you tell in front of him. Better fuck off those criticizing his management of UP Computer Center, I think those people don't know anything about basic networking nor handling technology management. Those dumb wits disgust me.
It's been an ease using Windows XP as my development machine having the best of both worlds. I have the three major browsers on my personal computer. All of them is unique and each has a very special purpose in my web development career.
Let's start with Firefox, this I used for debugging javascript code, specially with these add ons FoxyProxy, Firebug and Web Developer. I used it as starting test on created pages.
Internet Explorer 7, IE has been the leading in terms of users. It would not be complete if I would not test it on these browser as many are using it. I just do a special stylesheet just for it. Kinda buggy CSS feature.
I am glad that there is Safari for windows under Beta Stage kinda more stable rather than the alfa release. If your client's target market is the US you need to test the page on Safari. Theres an upswing for the MAC users these days.
It took me quite a while to update my blog. Been very busy with my web development time in a team based on the United States. For the past several months I've been doing client sites not much on my owned sites. I've lost interest in Amazon affiliated sites since checked was lost on our postal service, it's so sad that I've lost almost $259 on a monthly checked. Since this December all earnings were converted to gift certificates but goods that I want have shipping restrictions. Hopefully I can sell some sites to a US citizen so that time spent on sites must not be a waste.
The past year 2007, I minimized my focus on tunneling and other software sniffing methods it is because I have a good connection on my home development machine. I was to revert because I have a problem with a series of IP addresses which I cannot access thru http and ftp. My technique then was I have paid shell account, well there are a lot of turn around.
I think the best FTP program that could work on a different proxy settings was SmartFtp, http://www.smartftp.com/ , this is a very fast software, I was to dump Filezilla because I become unhappy using it in different settings.
I also started using Opera for accessing web emails, paypal account, online shopping and online banking, information that needs to be secured because I use Firefox - addon extension FoxyProxy, I use it for accessing sites on a different proxy settings.
Happy New Year