DataLinq Support using ADODB

Owned by Georg Hentsch
Last updated: May 06, 2020
2 min read

The typical way to read Chameleon data using Ross XPression Datalinq is to read BLADE via the json, rss or xml DataLinq Sources. However, it's also possible to read Chameleon data directly using the ADODB DataLinq Source. Here are the steps.

1.Make sure you're running the 32 bit version of MySQL ODBC Connector since the 64 bit version isn't supported by ADODB. You can get to the MySQL Connector installers from http://dev.mysql.com/downloads/connector/odbc/

2. Use the 32 bit version of the ODBC Data Source Administrator to define your data source located at C:\Windows\SysWOW64\odbcad32.exe

3. Add your MySQL database from the System DSN tab using the MySQL Unicode driver.

4. Give it any name but for these steps call it superticker. You'll need database credentials to fully complete this step. BTW the default Flow credentials for read-only access is webuser/bl$oftDB1234 so it's best to use those credentials instead of root.

 

5. In DataLinq, add a new ADODB DataLinq Source

6. In the Connection tab, use the Connection String DSN=superticker;

7. Go the the Advanced tab and choose Recording Limiting of Database supports LIMIT clause.

8. In the Fixed Tables tab, define a query into Chameleon's database. I didn't have any luck defining Fixed Tables other than an SQL Query so this may be a requirement. Not a problem though because this gives you much better control of the data in your result set.

9., You can test your query using the Browse button in Datalinq.

10. From here, just use DataLinq in XPression as usual.