Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
pcis-taylor  
#1 Posted : Wednesday, July 30, 2014 10:24:53 PM(UTC)
pcis-taylor

Rank: Newbie

Groups: Registered
Joined: 7/29/2014(UTC)
Posts: 6
Canada

I have gone through the designer tutorial videos and have a simple tip calculator thing that saves it's entries in a MySQL database I have on a different machine. This works fine after I installed the MySQL ODBC drivers.

If I test it on a device through Designer, it also works fine.

I can deploy the project to the Server without error. If I run it from my installed MobileTogether Server (which is on the same machine), it does not work. Specifically I see this in the logs:

Database: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Executed on server: Load database 'Dsn=Seymour TipCalculator;PWD=*****;Uid=*****'. Retrieval from Database resulted in an error.

There doesn't appear to be a driver selection option in the server anywhere and I am sure the driver is correctly installed as designer works fine.

The same error happens if I attempt to 'Use Server for Workflow Simulation'.

What have I overlooked?
bbv  
#2 Posted : Thursday, July 31, 2014 2:24:05 AM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 498

Was thanked: 88 time(s) in 88 post(s)
You have to consider that MobileTogether Server is installed as a Windows Service, and therefore by default doesn't run under your Windows account.

I can think of three options to resolve your issue:

* Most probably your Data source name is defined as User DSN. Use Windows Control Panel to move/recreate it as System DSN, redo connection in MobileTogether Designer if necessary, and then redeploy.

* Second possibility is to assign MobileTogether Server service to your Windows User Account. After installation of MobileTogether Server use Windows Services app to assign your user account.

* Use Global Resources mechanism in MobileTogether to have a different connection or even different database to be used on Server and in Designer. See documentation for details, though please note that documentation is also in beta phase - if something is unclear let us know.


Altova MobileTogether Experts
pcis-taylor  
#3 Posted : Thursday, July 31, 2014 7:06:50 PM(UTC)
pcis-taylor

Rank: Newbie

Groups: Registered
Joined: 7/29/2014(UTC)
Posts: 6
Canada

Option 1 there did it. Designer installed the connection info as a User DSN. I created an identically named System DSN and it worked.

What is your timeline for ceasing to use the OS level DSNs and start compiling/building the connection information into the deployable packages? Obviously this approach won't work with a server running on any other operating system.

Thanks again for your help.
bbv  
#4 Posted : Friday, August 1, 2014 10:41:16 AM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 498

Was thanked: 88 time(s) in 88 post(s)
Quote:
Obviously this approach won't work with a server running on any other operating system


This approach applies to ODBC only, which is only supported on Windows machines. After lengthy research we have not been able to find a reliable ODBC implementation on any other operating system.

You can use a JDBC connection as the one which works on all operating systems, though depending on driver quality it might be slower than ODBC.
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.