PDA

View Full Version : Can I access MySQL data from a Lianja app?



Question
2011-07-03, 06:21
Can I access MySQL data from a Lianja app?

lianjasupport
2011-07-03, 06:22
MySQL data access is due to be supported in the Lianja App Builder Professional Edition (LianjaPRO).

barrymavin
2012-02-28, 09:08
This is now supported as of beta6.

hectberlag@hotmail.com
2013-06-26, 18:27
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
2013-06-26, 19:42
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.

335

SLO36
2013-10-17, 11:22
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.

335

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
2013-10-18, 05:32
Hi,

MySQL documentation on setting up DSNs can be found here: http://dev.mysql.com/doc/refman/5.5/en/connector-odbc-configuration.html.

Regards,

Yvonne

Christina
2014-12-18, 12:51
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
2014-12-18, 13:18
Duplicate post - see http://www.lianja.com/community/showthread.php?1512-No-ODBC-connectivity-with-Windows-7-64-bits&p=11627&viewfull=1#post11627

HankFay
2014-12-18, 13:19
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