Results 1 to 7 of 7

Thread: Lianja Database and ODBC Connection

  1. #1
    Senior Member
    Join Date
    Jul 2013
    Location
    Ontario, Canada
    Posts
    658

    Lianja Database and ODBC Connection

    Hello,

    I created a Lianja table called it bantam_stats.
    What is needed to properly create an ODBC connection?

    I'm using the 32 bit ODBC utility on a 64 bit system.
    DSN: Bantam
    Server: localhost
    User: ?
    Pass: ?
    Database: bantam_stats

    Testing seems to work alright until SQLDriverConnect is reached.
    Function: SQLDriverConnect(Bantam)
    Detail message: "Database 'bantam_stats' - The system cannot find the file specified."

    Also, when the time comes to deploy the app, does the database get included?

    Thanks,
    Cory

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

    Have a look here for information on setting up the DSN - you need to specify a Database, not a table. Did you create bantam_stats as a table within a database?

    The database needs to be deployed / included in the deployment package. There is information on deployment here.

    Regards,

    Yvonne

  3. #3
    Senior Member
    Join Date
    Jul 2013
    Location
    Ontario, Canada
    Posts
    658
    Hi Yvonne,

    bantam_stats is the database name.
    Currently the tables are teams and roster.

    Cory

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

    Have you deployed the database? The Lianja SQL Server accesses the data in the end user / runtime directory structure, just like the App Center - sorry if that wasn't clear. If you haven't deployed yet, please follow the instructions in my previous post. If you have and you still can't get a connection, let me know.

    Regards,

    Yvonne

  5. #5
    Senior Member
    Join Date
    Jul 2013
    Location
    Ontario, Canada
    Posts
    658
    Hi Yvonne,

    Does this mean that I have to deploy the database while trying to use the database in the app builder?
    Currently I am trying to create a virtual table in the app builder however I need a connection first.

    The data is located in the C:\Lianja\data folder.
    Do I still have to deploy the database to the cloudserver even though I am no where near ready for deployment testing?

    Cory

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

    To create a virtual table in the App Builder, you can use local as the connection string to base it on a table in the local Lianja database. To access Lianja databases and tables via the Lianja SQL Server from an ODBC Client application, they need to be deployed to the Lianja SQL Server data directory.

    Regards,

    Yvonne

  7. #7
    Senior Member
    Join Date
    Jul 2013
    Location
    Ontario, Canada
    Posts
    658
    Thank you Yvonne.

    local worked great.

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