Results 1 to 10 of 10

Thread: Can I access MySQL data from a Lianja app?

  1. #1
    Member
    Join Date
    Feb 2012
    Posts
    82

    Can I access MySQL data from a Lianja app?

    Can I access MySQL data from a Lianja app?

  2. #2
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    MySQL data access is due to be supported in the Lianja App Builder Professional Edition (LianjaPRO).

  3. #3
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,771
    This is now supported as of beta6.

  4. #4
    Junior Member
    Join Date
    Jun 2013
    Posts
    1
    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

  5. #5
    Lianja Support Team lianjasupport's Avatar
    Join Date
    Feb 2012
    Location
    Boston USA, Wokingham UK
    Posts
    1,268
    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.

    Name:  Screen Shot 2013-06-27 at 6.38.04 AM.jpg
Views: 730
Size:  85.9 KB

  6. #6
    Junior Member
    Join Date
    Oct 2013
    Posts
    1
    Quote Originally Posted by lianjasupport View Post
    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.

    Name:  Screen Shot 2013-06-27 at 6.38.04 AM.jpg
Views: 730
Size:  85.9 KB
    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

  7. #7
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379
    Hi,

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

    Regards,

    Yvonne

  8. #8
    Junior Member
    Join Date
    Dec 2014
    Posts
    3
    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 ?

  9. #9
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,379

  10. #10
    Lianja MVP
    Join Date
    Feb 2012
    Location
    Berea, KY, USA
    Posts
    1,948
    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

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us