PDA

View Full Version : Lianja Database and ODBC Connection



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

yvonne.milne
2013-09-30, 11:31
Hi Cory,

Have a look here (http://www.lianja.com/doc/index.php/Lianja_ODBC_Manager) 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 (http://www.lianja.com/doc/index.php/Deploying_to_Local_Directory).

Regards,

Yvonne

CGibson
2013-09-30, 11:37
Hi Yvonne,

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

Cory

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

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

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

CGibson
2013-10-01, 14:52
Thank you Yvonne.

local worked great.