LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  How to connect / configure my sql database ?

    Employee
    Posted 10-09-2015 01:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: udaylavastorm

    Hi,

    i am new to this lava storm. can you explain me how to connect my sql database to the lae? and where to i download and configure the odbc drives if its needed?


  • 2.  RE: How to connect / configure my sql database ?

    Employee
    Posted 10-13-2015 12:39

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sozdemir

    Hi,

    In the start menu search bar, type "odbc" and then you need a few pieces from your DBAs such as server name and database name. After that, you can just follow the below image:
    Capture.jpg


  • 3.  RE: How to connect / configure my sql database ?

    Employee
    Posted 10-13-2015 23:59

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: udaylavastorm

    i configured odbc with my sql db and i tested it and it is successfully connecting. but i can not able to connect to that from LAE.....i am gettting error.


  • 4.  RE: How to connect / configure my sql database ?

    Employee
    Posted 10-14-2015 00:01

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: udaylavastorm

    see the attached error for your reference....


    lae error.jpg


  • 5.  RE: How to connect / configure my sql database ?

    Employee
    Posted 10-14-2015 00:03

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: udaylavastorm

    Originally posted by: udaylavastorm
					

    see the attached error for your reference....


    
lae error.jpg

    see the below attached configurations....
    lae error1.jpg


  • 6.  RE: How to connect / configure my sql database ?

    Employee
    Posted 10-15-2015 00:07

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: udaylavastorm

    any suggestions ?


  • 7.  RE: How to connect / configure my sql database ?

    Employee
    Posted 10-15-2015 06:40

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: sozdemir

    You mentioned that it was MYSQL database so you may have to download MYSQL ODBC driver.

    Have you tested your ODBC connection?