DBF->MySQL

While working on a staging area for a warehouse, I ran across the need to capture a table schema from a DBF file.

If found this link http://ae.inc.ru/dbf2mysql.php

Problem:
While running the program I received this error

error connecting to database client does not support authentication protocol requested by server; consider upgrading MySQL client

Solution:
You simply need to (in mysql):

SET PASSWORD FOR username@’host’ = OLD_PASSWORD(‘password’);

Connecting to 32 bit / 64 bit data sources from Tomcat (Java).

Problem:

When running tomcat your receive the following error when connecting to an ODBC data source
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Solution:

There are *two* ODBC managers in 64 bit windows. 64 bit ODBC data sources are separate from 32 bit data sources.

The ODBC manager accessed from the Control Panel contains the *64 bit* ODBC data sources.

Launch C:\windows\syswow64\odbcad32.exe to configure the 32 bit ODBC data sources.

If your running a 64 bit app, you’ll have access to the 64 bit data sources. Likewise, if your running a 32 bit app you’ll have access to the 32 bit data sources.

For Java apps, you’ll need to invoke the app with the correct JVM (32 bit or 64 bit) to have access to the desired data sources (32 bit or 64 bit).

On Vista, the 32 bit JVM(s) can be found (by default) at C:\Program Files (x86)\Java\jre6\bin. The 64 bit JVM is at C:\Program Files\Java\jre6

Catalina.bat (used to start tomcat) looks to see if JRE_HOME is defined so make sure this is pointing to the correct JRE or update catalina.bat accordingly.