Tuesday, October 26, 2010

How to Create a 32-bit ODBC Source in Windows 7/8/10 (Updated 2nd Jan 2017)

The VFP ODBC driver was included in MDAC 2.5 and earlier and preinstalled on Windows 2000 and earlier. In order to use it on Windows XP and later Windows versions, it has to be installed first. The Microsoft Visual FoxPro Driver 6.01.8629.01 is available for download at http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx.

2016
The VFP ODBC Driver can be installed under 64-bit Windows but 64-bit applications cannot access VFP ODBC driver because it comes only in 32-bit version. For 32-bit applications under 64-bit Windows there's ODBC Data Source Administrator for the 32-bit ODBC drivers %systemdrive%\Windows\SysWoW64\odbcad32.exe (usually C:\WINDOWS\SysWOW64\odbcad32.exe).

2017

Important to remember that 64bits applications need to access 64 bits ODBC drivers.

Sunday, October 24, 2010

How to Migrate Delphi 5 from 1 PC to Another

What do you do when your PC crashes and you have to migrate your Delphi 5 + all installed VCL components to another PC ?

One possible solution is to restore all your folders to the replacement PC and then reinstall Delphi 5 + all the updates. Tedious but definitely workable but what if you have misplaced your original Delphi Install Disk ?

This is what I attempted to do :-

1. Copy the Delphi 5 folder to the new PC (for Win7 PCs, administrator rights must be given to this folder)

2. Copy  VCL*50.bpl from WINSYS32 folder to the BIN folder on the target PC.

3. Launch D5 and all you will see is the Standard Tab with only the Frames Icon visible.

4. Click Component/Install Packages and manually add applet50.bpl and you will see that the Borland Control Applet has been installed. By doing so, you will still no additional tabs on icons but when you click File/New..., all the tabbed dialog box will now be complete :-)

5. Then add dcl3150.bpl (D1 compatibilty components) and voila dclstd50.bpl (Borland Standard Componets) is also automatically installed.

6. Repeat for all dcl*.bpl

More to come...

Installing Delphi 5 in Windows 7

Reinstall it in it's own directory that's not under Program Files. Writing there for non-admin users has been a no-no since WinXP (although not enforced there), and has been forbidden since the introduction of Vista.

Welcome to Delphi... Delphi... Delphi

I have been a Delphi Developer since Delphi 3 when I finally decided on Delphi in 1996 as my programming language of choice for the Windows 32 environment. So what have I created with Delphi ?

Would you believe that I had single-handedly created a full ERP2 system comprising ERP+CRM where ERP=Sales Distribution+MRP+ Procurement Management+Planning & Production +Finacial Management + Human Resources Management System.

Since 15th February 2009, we have visitors from more than 60 countries including Malaysia, United States, Brazil, Italy, Australia, India, Turkey, Russian Federation, Spain, Indonesia, Hungary, South Africa, Germany, Mexico, Argentina, Singapore, Saudi Arabia, Colombia, Czech Republic, Canada, France, Croatia,Thailand, Bulgaria, Slovenia, Hong Kong, Poland, Sri Lanka, Chile, Japan, Austria, Ukraine, Azerbaijan, Ireland, Tunisia, Greece, Taiwan, Egypt, Bolivia, Paraguay, Iran, Islamic Republic , Morocco, Angola, Belgium, Portugal, Norway, Venezuela, United Arab Emirates, Algeria, Korea, Republic Of, Slovakia, Georgia, Lebanon, Macedonia, Sweden, Philippines, Vietnam, Dominican Republic