Posted by: Erwin Fransiscus on: March 15, 2009
Yesterday, I got a project to handle with MySQL and Visual Foxpro. I’m used to MySQL, and so does with Visual Foxpro. The trouble is that I’ve never work on both of them in the same time. Usually I’m using Foxpro integrated DBMS when using Visual Foxpro, and MySQL used to be a DBMS when I’m using PHP, C#, or ASP.Net.
I got a little problem on connecting those software, but after multiple tries, it did works.
How that happen? here’s the simple tutorial:
Note : I’m using Microsoft Windows XP SP 3, Visual Foxpro 9, and WAMP server 1.7.3, I’m working on a single desktop pc. I’m sorry i didn’t include the images example on doing this, hope with just the texts you would understand how it works.
First, create a database on MySQL. The database is quite important, because when you install and configure ODBC, there’s an option of which databases you want to use. I’m also using PHPmyadmin for the GUI of the database application. here’s for example.
> CREATE DATABASE dbfarmasi
> CREATE TABLE `dbfarmasi`.`tb_brg` (`kdbrg` CHAR( 6 ) NOT NULL ,`nmbrg` VARCHAR( 50 ) NOT NULL , PRIMARY KEY ( `kdbrg` )) ENGINE = INNODB
> INSERT INTO `dbfarmasi`.`tb_brg` (`kdbrg` ,`nmbrg`) VALUES ( ‘00001′, ‘First item’ );
> INSERT INTO `dbfarmasi`.`tb_brg` (`kdbrg` ,`nmbrg`) VALUES ( ‘00002′, ‘Second item’ );
i’m named the database “dbfarmasi” and the table “tb_brg”. So here, we got a database and a table, rock!
Then you download a software called MySQL ODBC Connector. I’m using mysql-connector-odbc-3.51.25-win32.exe, which is free, and can be downloaded by visit mysql site. You can try to google it.
Install. After installation has done, you should go to “Control Panel” > “Administrative Tools” > “Data Sources (ODBC)”. And then there’s pop-up window of ODBC. In “User DSN” tab, right side, press “Add” button”, and select “MySQL ODBC 3.51 Driver” as the data source, and “Finish”.
Another windows will appear, it is a configuration window for ODBC. Try this :
Data source name : koneksi
Description : connect foxpro and mysql
Server : localhost
User : root
Database : dbfarmasi
The DSN name is up to you, so does the description.
The default Server is localhost, ’cause I’m not using remote database.
Default user name is root, as the first super user name in mysql.
I’m using no password on mysql (it is set to none by default when you’re install WAMP)
and the database I’m using is dbfarmasi, as i’ve created before.
Ta-da. The connection has been made.
Now, for the visual foxpro. here is a simple one :
Create a project, whatever the name is, save it. on “Project Manager” window, choose “Code” tab.
Press “New” on Program.
Here is the code:
PUBLIC P1
STORE SQLCONNECT(’koneksi’, ‘root’) TO P1
close and save it to name : ”setdatabase“
now, back to “Project Manager” window, choose “Document” tab, press “New” button to create a new form, and pick the “New Form”, not the “Form Wizard” thing.
After that, an empty form will appear. create a two Textboxs.
named the first textbox to : txtkdbrg and the second textbox to : txtnmbrg.
Add a grid to form. named it as gridContainer.
Now double-click the form, select the object form1 and the procedure init, and add this code:
DO setdatabase
thisform.gridContainer.RecordSource=”"
SQLEXEC(P1,”select * from tb_brg”,”tb_brg”)
IF NOT USED(”tb_brg”)
USE tb_brg ALIAS tb_brg
ENDIF
SELECT tb_brg
thisform.gridContainer.RecordSource=”tb_brg”
Save the form and run it. TA-DA. It works, its connected. The content of table “tb_brg” is showed by the form by the gridContainer.
It means that the ODBC works. Here the connection thing :
do setdatabase
SQLEXEC(P1,”select * from tb_brg”,”tb_brg”)
means :
run program code “setdatabase” (which we’ve created before, for connection)
select P1 as ODBC connection DNS, (connection name variable in setdatabase (replace SQLCONNECT(bla bla bla))
“select * from tb_brg”, the sql query, select all from table tb_brg
“tb_brg”, is a cursor in visual foxpro, that used for alias.
So, with SQLEXEC([connection name],”[sql query]“,[cursor name]), you can do sql command: SELECT. Don’t forget to add cursorname/alias when you’re using SELECT.
You don’t have to add cursorname if you’re using INSERT or DELETE query.
example :
SQLEXEC(P1,”insert into tb_brg (kdbrg,nmbrg) values (’”+thisform.txtkdbrg.value+”‘,’”+thisform.txtnmbrg.value+”‘)”)
means you insert value from textbox (txtkdbrg and txtnmbrg).
for delete command example :
SQLEXEC(P1,”delete from tb_brg where kdbrg =’”+thisform.txtkdbrg.Value+”‘”)
Once again, i’m sorry i’m not using images for this tutorial.
Hope you understand what i meant in this simple tutorial, and hope it help you.
Posted by: Erwin Fransiscus on: February 23, 2009
You’re waiting for Dota Ai+ 6.59b ?
I found this link for map download..
Just try it.. good luck
Posted by: Erwin Fransiscus on: February 23, 2009
If you want to download Google’s new web browser “Chrome”, you’ll need to download a small 474 KB installer from its official website and then it’ll download the required files of approx. 7 MB from Google server.
Its annoying and painful when you want to install Chrome in more than one computer. You’ll have to download the required setup files in each system.
Now no need to worry, Google is providing a standalone installer which doesn’t require net connection while installing the browser. So you can download it once and then install it in as many systems as you want without any problem.
Download Full Standalone Offline Installer for Latest Google Chrome
http://dl.google.com/chrome/install/154.36/chrome_installer.exe
There is also another benefit in downloading this standalone installer. It doesn’t contain the Google Update EXE file.
Posted by: Erwin Fransiscus on: February 6, 2009
Posted by: Erwin Fransiscus on: February 1, 2009
This page was taken from :
http://www.devilsworkshop.org/download-complete-microsoft-net-framework-35-setup/
I’ve also downloaded this file from the page, and it works..

Many new windows applications requires latest version of Microsoft .NET framework which is version 3.5 at the time of of writing of this post.
If you go to Microsoft download center, then by default you will get live installer of approximately 2-3 MB’s while complete .NET framework requires 50-200 MB. Actually on the same page they are links to complete setup but they are placed in a way that anyone can hardly notice them. Seems like Microsoft wants you to download live installer but there are problem with live installer…
So here I am giving you links to complete Microsoft .NET Framework 3.0 & 3.5 setups which are gathered from Microsoft pages (links: v3.5 & v3.0)
# Microsoft .NET Framework 3.5 Setup
# Microsoft .NET Framework 3.0 Setup
Do not worry about authenticity of above links as they are from Microsoft’s server only!
Posted by: Erwin Fransiscus on: February 1, 2009
Here is an website that helps us understand about Semantic Web & RDFa with a video, it is simple and clear. http://rdfa.info/wiki/Introduction.
Introduction to Semantic Web
This is a short 5 minute introduction to why the Semantic Web is important. Voiced and animated by Manu Sporny.
Teaches you the basics of RDFa in 8 minutes, aimed at more advanced web designers.
Animated and voiced by Manu Sporny.
Thank’s to him, for his video which is great.
There’s also an introduction to RDFa from XML.com, you can download it here :
Posted by: Erwin Fransiscus on: January 24, 2009

Session 3 Ep 1 : The Second Coming
http://rapidshare.com/files/147894328/heroes.s03e01.hdtv.avi.part1.rar
http://rapidshare.com/files/147894515/heroes.s03e01.hdtv.avi.part2.rar
http://rapidshare.com/files/147895558/heroes.s03e01.hdtv.avi.part3.rar
http://rapidshare.com/files/147898387/heroes.s03e01.hdtv.avi.part4.rar
Session 3 Ep 2 : The Butterfly Effect
http://rapidshare.com/files/147904083/heroes.s03e02.hdtv.avi.part1.rar
http://rapidshare.com/files/147906191/heroes.s03e02.hdtv.avi.part2.rar
http://rapidshare.com/files/147907455/heroes.s03e02.hdtv.avi.part3.rar
http://rapidshare.com/files/147908320/heroes.s03e02.hdtv.avi.part4.rar
Session 3 Ep 3 : One of Us, One of Them
http://rapidshare.com/files/149721894/heroes.s03e03.hdtv.avi.part1.rar
http://rapidshare.com/files/149754029/heroes.s03e03.hdtv.avi.part2.rar
http://rapidshare.com/files/149821008/heroes.s03e03.hdtv.avi.part3.rar
http://rapidshare.com/files/149839526/heroes.s03e03.hdtv.avi.part4.rar
Session 3 Ep 4 : I am Become Death
http://rapidshare.com/files/151762804/heroes.s03e04.hdtv.avi.part1.rar
http://rapidshare.com/files/151797279/heroes.s03e04.hdtv.avi.part2.rar
http://rapidshare.com/files/151830290/heroes.s03e04.hdtv.avi.part3.rar
http://rapidshare.com/files/151860429/heroes.s03e04.hdtv.avi.part4.rar
Session 3 Ep 5 : Angels and Monsters
http://rapidshare.com/files/153983100/heroes.s03e05.hdtv.avi.part1.rar
http://rapidshare.com/files/154017759/heroes.s03e05.hdtv.avi.part2.rar
http://rapidshare.com/files/154051375/heroes.s03e05.hdtv.avi.part3.rar
http://rapidshare.com/files/154078684/heroes.s03e05.hdtv.avi.part4.rar
Session 3 Ep 6 : Dying of the Light
http://rapidshare.com/files/156342827/heroes.s0306.hdtv.avi.part1.rar
http://rapidshare.com/files/156343661/heroes.s0306.hdtv.avi.part2.rar
http://rapidshare.com/files/156345105/heroes.s0306.hdtv.avi.part3.rar
http://rapidshare.com/files/156346883/heroes.s0306.hdtv.avi.part4.rar
Session 3 Ep 7: Eris Quod Sum
http://rapidshare.com/files/158387101/heroes.s0307.hdtv.avi.part1.rar
http://rapidshare.com/files/158418924/heroes.s0307.hdtv.avi.part2.rar
http://rapidshare.com/files/158452657/heroes.s0307.hdtv.avi.part3.rar
http://rapidshare.com/files/158484187/heroes.s0307.hdtv.avi.part4.rar
Session 3 Ep 8: Villains
http://rapidshare.com/files/162991734/heroes.s0308.hdtv.avi.part1.rar
http://rapidshare.com/files/162991949/heroes.s0308.hdtv.avi.part2.rar
http://rapidshare.com/files/162991875/heroes.s0308.hdtv.avi.part3.rar
http://rapidshare.com/files/162991555/heroes.s0308.hdtv.avi.part4.rar
Session 3 Ep 9: It’s Coming
http://rapidshare.com/files/165249211/heroes.s03e09.hdtv.avi.part1.rar
http://rapidshare.com/files/165249066/heroes.s03e09.hdtv.avi.part2.rar
http://rapidshare.com/files/165249162/heroes.s03e09.hdtv.avi.part3.rar
http://rapidshare.com/files/165248888/heroes.s03e09.hdtv.avi.part4.rar
Session 3 Ep 10: The Eclipse 1
http://rapidshare.com/files/167208574/heroes.s03e10.hdtv.avi.part1.rar
http://rapidshare.com/files/167208591/heroes.s03e10.hdtv.avi.part2.rar
http://rapidshare.com/files/167211321/heroes.s03e10.hdtv.avi.part3.rar
http://rapidshare.com/files/167211923/heroes.s03e10.hdtv.avi.part4.rar
Session 3 Ep 11: The Eclipse 2
http://rapidshare.com/files/169644316/heroes.s03e11.hdtv.avi.part1.rar
http://rapidshare.com/files/169674229/heroes.s03e11.hdtv.avi.part2.rar
http://rapidshare.com/files/169699166/heroes.s03e11.hdtv.avi.part3.rar
http://rapidshare.com/files/169607195/heroes.s03e11.hdtv.avi.part4.rar
Session 3 Ep 12: Our Father
http://rapidshare.com/files/172278589/heroes.s03e12.hdtv.avi.part1.rar
http://rapidshare.com/files/172278636/heroes.s03e12.hdtv.avi.part2.rar
http://rapidshare.com/files/172280957/heroes.s03e12.hdtv.avi.part3.rar
http://rapidshare.com/files/172280627/heroes.s03e12.hdtv.avi.part4.rar
Session 3 Ep 13: Duality
http://rapidshare.com/files/173936589/heroes.s03e13.hdtv.avi.part1.rar
http://rapidshare.com/files/173969409/heroes.s03e13.hdtv.avi.part2.rar
http://rapidshare.com/files/174002434/heroes.s03e13.hdtv.avi.part3.rar
http://rapidshare.com/files/174032665/heroes.s03e13.hdtv.avi.part4.rar
Posted by: Erwin Fransiscus on: January 24, 2009

Episode 12: BulletProof
http://rapidshare.com/files/187974139/SV.812.2L.by.Scorpio_1.DarkVille.Com.Mx.part1.rar
http://rapidshare.com/files/187973908/SV.812.2L.by.Scorpio_1.DarkVille.Com.Mx.part2.rar
Episode 11: Legion
http://rapidshare.com/files/185013667/smallville_s08e11.part1.rar
http://rapidshare.com/files/185033748/smallville_s08e11.part2.rar
http://rapidshare.com/files/185054068/smallville_s08e11.part3.rar
http://rapidshare.com/files/185066272/smallville_s08e11.part4.rar
Episode 10: Bridge
http://rapidshare.com/files/169241256/Smallville.S08E10.HDTV.XviD-NoTV.part1.rar http://rapidshare.com/files/169241828/Smallville.S08E10.HDTV.XviD-NoTV.part2.rar http://rapidshare.com/files/169241830/Smallville.S08E10.HDTV.XviD-NoTV.part3.rar http://rapidshare.com/files/169243500/Smallville.S08E10.HDTV.XviD-NoTV.part4.rar
Episode 9: Abyss
http://rapidshare.com/files/163568314/Smallville.S08E09.HDTV.XviD-NoTV.part1.rar
http://rapidshare.com/files/163568276/Smallville.S08E09.HDTV.XviD-NoTV.part2.rar
Episode 8: Bloodline
http://rapidshare.com/files/161374936/SV.808.darkville.com.mx.by.Killer.part1.rar
http://rapidshare.com/files/161375023/SV.808.darkville.com.mx.by.Killer.part2.rar
http://rapidshare.com/files/161375131/SV.808.darkville.com.mx.by.Killer.part3.rar
http://rapidshare.com/files/161375054/SV.808.darkville.com.mx.by.Killer.part4.rar
Episode 7: Identity
http://rapidshare.com/files/159345243/smllvll0807-notv.part1.rar
http://rapidshare.com/files/159345469/smllvll0807-notv.part2.rar
Episode 6
rey
http://rapidshare.com/files/156967699/hio-sv.806.notv.part1.rar
http://rapidshare.com/files/156967709/hio-sv.806.notv.part2.rar
http://rapidshare.com/files/156967701/hio-sv.806.notv.part3.rar
http://rapidshare.com/files/156967659/hio-sv.806.notv.part4.rar
Episode 5: Commited
http://rapidshare.com/files/154760522/Sm4ville_805-NoTV.part3.rar
http://rapidshare.com/files/154760527/Sm4ville_805-NoTV.part2.rar
http://rapidshare.com/files/154760528/Sm4ville_805-NoTV.part1.rar
http://rapidshare.com/files/154760536/Sm4ville_805-NoTV.part4.rar
Episode 4: Instinct
http://rapidshare.com/files/152603991/S804.part1.rar
http://rapidshare.com/files/152611596/S804.part2.rar
http://rapidshare.com/files/152619188/S804.part3.rar
http://rapidshare.com/files/152624880/S804.part4.rar
Episode 3: Toxic
http://rapidshare.com/files/150429887/smallville.S08E03.hdtv.xvid.notv.part1.rar
http://rapidshare.com/files/150435103/smallville.S08E03.hdtv.xvid.notv.part2.rar
http://rapidshare.com/files/150439941/smallville.S08E03.hdtv.xvid.notv.part3.rar
http://rapidshare.com/files/150445297/smallville.S08E03.hdtv.xvid.notv.part4.rar
Episode 2: Plastique
http://rapidshare.com/files/148472435/hio-sv.802.prop.notv.part1.rar
http://rapidshare.com/files/148471264/hio-sv.802.prop.notv.part2.rar
http://rapidshare.com/files/148471598/hio-sv.802.prop.notv.part3.rar
http://rapidshare.com/files/148471945/hio-sv.802.prop.notv.part4.rar
Episode 1: Odyssey
http://rapidshare.com/files/146475132/smallville.s08e01.hdtv.xvid-dot.part1.rar
http://rapidshare.com/files/146475319/smallville.s08e01.hdtv.xvid-dot.part2.rar
http://rapidshare.com/files/146476233/smallville.s08e01.hdtv.xvid-dot.part3.rar
http://rapidshare.com/files/146475349/smallville.s08e01.hdtv.xvid-dot.part4.rar
Posted by: Erwin Fransiscus on: January 24, 2009

Prison Break Season 4 Episode 16
http://rapidshare.com/files/176197381/prison.break.4.16.hdtv.avi.part1.rar
http://rapidshare.com/files/176224934/prison.break.4.16.hdtv.avi.part2.rar
http://rapidshare.com/files/176248509/prison.break.4.16.hdtv.avi.part3.rar
http://rapidshare.com/files/176266945/prison.break.4.16.hdtv.avi.part4.rar
Prison Break Season 4 Episode 15
http://rapidshare.com/files/174061377/prison.break.4.15.hdtv.avi.part1.rar
http://rapidshare.com/files/174158550/prison.break.4.15.hdtv.avi.part2.rar
http://rapidshare.com/files/174182659/prison.break.4.15.hdtv.avi.part3.rar
http://rapidshare.com/files/174209302/prison.break.4.15.hdtv.avi.part4.rar
Prison Break Season 4 Episode 14
http://rapidshare.com/files/172276648/prison.break.4.14.hdtv.avi.part1.rar
http://rapidshare.com/files/172276927/prison.break.4.14.hdtv.avi.part2.rar
http://rapidshare.com/files/172277100/prison.break.4.14.hdtv.avi.part3.rar
http://rapidshare.com/files/172276788/prison.break.4.14.hdtv.avi.part4.rar
Prison Break Season 4 Episode 13
http://rapidshare.com/files/169732209/prison.break.4.13.hdtv.avi.part1.rar
http://rapidshare.com/files/169732294/prison.break.4.13.hdtv.avi.part2.rar
http://rapidshare.com/files/169732341/prison.break.4.13.hdtv.avi.part3.rar
http://rapidshare.com/files/169732155/prison.break.4.13.hdtv.avi.part4.rar
Prison Break Season 4 Episode 12
http://rapidshare.com/files/167467904/prison.break.4.12.hdtv.avi.part1.rar
http://rapidshare.com/files/167467857/prison.break.4.12.hdtv.avi.part2.rar
http://rapidshare.com/files/167467892/prison.break.4.12.hdtv.avi.part3.rar
http://rapidshare.com/files/167467589/prison.break.4.12.hdtv.avi.part4.rar
Prison Break Season 4 Episode 11
http://rapidshare.com/files/165082840/prison.break.4.11.hdtv.avi.part1.rar
http://rapidshare.com/files/165117188/prison.break.4.11.hdtv.avi.part2.rar
http://rapidshare.com/files/165146520/prison.break.4.11.hdtv.avi.part3.rar
http://rapidshare.com/files/165171144/prison.break.4.11.hdtv.avi.part4.rar
Prison Break Season 4 Episode 10
http://rapidshare.com/files/162958870/prison.break.4.10.hdtv.avi.part1.rar
http://rapidshare.com/files/162960217/prison.break.4.10.hdtv.avi.part2.rar
http://rapidshare.com/files/162963719/prison.break.4.10.hdtv.avi.part3.rar
http://rapidshare.com/files/162963418/prison.break.4.10.hdtv.avi.part4.rar
Prison Break Season 4 Episode 9
http://rapidshare.com/files/160561382/prison.break.4.09.hdtv.avi.part1.rar
http://rapidshare.com/files/160561439/prison.break.4.09.hdtv.avi.part2.rar
http://rapidshare.com/files/160561453/prison.break.4.09.hdtv.avi.part3.rar
http://rapidshare.com/files/160561191/prison.break.4.09.hdtv.avi.part4.rar
Prison Break Season 4 Episode 8
http://rapidshare.com/files/156348986/prison.break.4.08.avi.part1.rar
http://rapidshare.com/files/156351456/prison.break.4.08.avi.part2.rar
http://rapidshare.com/files/156351285/prison.break.4.08.avi.part3.rar
http://rapidshare.com/files/156351198/prison.break.4.08.avi.part4.rar
Prison Break Season 4 Episode 7
http://rapidshare.com/files/151656631/prison.break.4.07.avi.part1.rar
http://rapidshare.com/files/151658359/prison.break.4.07.avi.part2.rar
http://rapidshare.com/files/151660140/prison.break.4.07.avi.part3.rar
http://rapidshare.com/files/151662011/prison.break.4.07.avi.part4.rar
Prison Break Season 4 Episode 6
http://rapidshare.com/files/149617740/prison.break.4.06.avi.part1.rar
http://rapidshare.com/files/149640057/prison.break.4.06.avi.part2.rar
http://rapidshare.com/files/149665623/prison.break.4.06.avi.part3.rar
http://rapidshare.com/files/149693633/prison.break.4.06.avi.part4.rar
Prison Break Season 4 Episode 5
http://rapidshare.com/files/147898771/prison.break.4.05.avi.part1.rar
http://rapidshare.com/files/147898916/prison.break.4.05.avi.part2.rar
http://rapidshare.com/files/147904131/prison.break.4.05.avi.part3.rar
http://rapidshare.com/files/147905030/prison.break.4.05.avi.part4.rar
Prison Break Season 4 Episode 4
http://rapidshare.com/files/145928434/prison.break.4.04.avi.part1.rar
http://rapidshare.com/files/145928280/prison.break.4.04.avi.part2.rar
http://rapidshare.com/files/145928306/prison.break.4.04.avi.part3.rar
http://rapidshare.com/files/145928334/prison.break.4.04.avi.part4.rar
Prison Break Season 4 Episode 3
http://rapidshare.com/files/144016798/prison.break.403.hdtv.part1.rar
http://rapidshare.com/files/144017613/prison.break.403.hdtv.part2.rar
http://rapidshare.com/files/144016372/prison.break.403.hdtv.part3.rar
http://rapidshare.com/files/144016406/prison.break.403.hdtv.part4.rar
Prison Break Season 4 Episode 2
http://rapidshare.com/files/142251725/prison.break.402.hdtv.part1.rar
http://rapidshare.com/files/142252667/prison.break.402.hdtv.part2.rar
http://rapidshare.com/files/142252916/prison.break.402.hdtv.part3.rar
http://rapidshare.com/files/142253184/prison.break.402.hdtv.part4.rar
http://rapidshare.com/files/142246492/prison.break.402.hdtv.part5.rar
Prison Break Season 4 Episode 1
http://rapidshare.com/files/142252507/prison.break.401.hdtv.part1.rar
http://rapidshare.com/files/142253511/prison.break.401.hdtv.part2.rar
http://rapidshare.com/files/142254482/prison.break.401.hdtv.part3.rar
http://rapidshare.com/files/142261756/prison.break.401.hdtv.part4.rar
I’ve found this link from http://antonie.wordpress.com/, great thanks for him :)