[KLUG Members] Spoofing ODBC connections

[Adam Williams]

>Is there anyway of making a MYODBC for MYSQL look like
>a MS SQL driver to an application.. I have an
>application with has a proprietary executable that
>converts the DB4 files to SQL tables... unfortunately

The ODBC-ODBC bridge *MIGHT* do it.

>it is only supported in MS SQL, DB2, & Oracle (Windows
>only for DB2 and Oracle) I was just wondering if I
>could get the MYODBC Driver to act similar enough to
>spoof the app to convert the files to tables?

All three of those are truly relational, while MySQL is only barely 
quasi-relational.  Your going to probably run into all kinds of SQL 
statements and features that MySQL doesn't have a clue about.

You'll almost certainly have to create the schema by hand.

If you see references to triggers, etc... in the schema then your just 
stuck,  the app probably isn't going to work with MySQL.

Tools such as those by EMS will probably be able to help you move the 
data.