Can I access MySQL data from a Lianja app?

[Question]

Can I access MySQL data from a Lianja app?

[lianjasupport]

MySQL data access is due to be supported in the Lianja App Builder Professional Edition (LianjaPRO).

[barrymavin]

This is now supported as of beta6.

[hectberlag@hotmail.com]

Can somebody explain how to connect a mysql db runing on localhost by xampp because, i havent been able to import my tables it always show me a ODBC connection to "myDNS" failed i have imported vfp db but not other., thanks

[lianjasupport]

To test the connection select the "ODBC" tab in the "Console" workspace. You may not have the DSN configured correctly. See attached. Also search the forums for details of using Virtual Tables.

[SLO36]

To test the connection select the "ODBC" tab in the "Console" workspace. You may not have the DSN configured correctly. See attached. Also search the forums for details of using Virtual Tables.

I am a NOCODER user evaluating Lianja. Our students are conversant with Mysql.

I am having trouble with the conn string.
Where do I find my DNS?
Mysql db is in localhost:8889 and user is root.

Thank you

[yvonne.milne]

Hi,

MySQL documentation on setting up DSNs can be found here: http://dev.mysql.com/doc/refman/5.5/...iguration.html.

Regards,

Yvonne

[Christina]

Hi,
I have the same problem.
I'm using Windows trial version to test Lianja App.
Unfortunately i can't access any ODBC connection ? Alows tells me Connection failed, even if my ODBC Manager (of Windows) is working fine.

How to connect by ODBC to PostgresSQL or other ODBC driver ?

[yvonne.milne]

Duplicate post - see http://www.lianja.com/community/show...ll=1#post11627

[HankFay]

Hi Christina,

1) on a 64-bit windows system, use the correct ODBC manager (in the %windir%\syswow64 directory, the exe is odbcad32.exe).
2) you have to install the ODBC drivers (the 32-bit versions, using the 32-bit ODBC manager).
3) create System DSN's.

hth,

Hank