Lianja Database and ODBC Connection

Printable View

2013-09-30, 10:18
CGibson

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
2013-09-30, 10:31
yvonne.milne

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
2013-09-30, 10:37
CGibson

Hi Yvonne,

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

Cory
2013-09-30, 10:46
yvonne.milne

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
2013-09-30, 11:27
CGibson

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
2013-09-30, 11:58
yvonne.milne

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
2013-10-01, 13:52
CGibson

Thank you Yvonne.

local worked great.