Visual Integrator/MySQL database - no tables returned

[llthomps]

Hey everybody,

I'm working with a client who wishes to put up an online store using their MAS 200 data as the core. The first step, in my mind, is to get the data out of the ProvideX system into a usable web database system (so far I've tried with MySQL and PostgreSQL).

Visual Integrator, advertising the ability to import and export seamlessly with any ODBC-compliant data source, seemed like the perfect tool for this...or at least a very good place to start.

I'm able to create a MySQL-based DSN in the ODBC data sources application. That DSN works fine. I'm able to select that DSN in Visual Integrator, but when it loads the ODBC Table information, no tables are returned.

The remote MySQL server is 5.0, and is running on a Red Hat Linux machine.

I figured this issue would be common enough if it was impossible or hard to figure out, but I can't find anyone doing this online.

I'd like to proceed an troubleshoot in the right direction, so I don't completely foul up the clients server for the next week while I try every adjusting every factor that could be causing failure.

Can someone give me some direction on how to get this to work or let me know if it's impossible?

 

[BigLouie]

When I need to extract data from MAS I normally use SQL Specific Pass Through Queries in Access as it allows me to code in the log in. With queries run by code I can pull anything I want to when I want to.

VI is terrible as far as extracting data *ugh*. I have not worked with MySQL but if you can write pass through queries then you should be able to pull the data from MAS.

Please note the ODBC driver in MAS is READ ONLY. You have to use VI to write back.