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
Empty database structure in Insert Database Objects (MySql, ODBC) - Insert Database Objects does not bring the database structure visible. (MySql, Sakila)
Options
View
Go to last post Go to first unread
Previous Topic Next Topic
Pekka Pasanen  
#1 Posted : Tuesday, January 30, 2018 10:09:25 PM(UTC)
Pekka Pasanen

Rank: Member

Groups: Registered
Joined: 1/30/2018(UTC)
Posts: 11
Finland
Location: Lohja
Insert Database Objects does not bring the database structure visible. All works fine with DataSpy. This database (Sakila) is MySql example database. Is there a simple reason for this?
Pekka Pasanen attached the following image(s):
Kuva1.png
Kuva2.png
Kuva3.png
Back to top
AFC  
#2 Posted : Wednesday, January 31, 2018 9:18:34 AM(UTC)
AFC

Rank: Administration

Groups: Registered, Administrators
Joined: 9/15/2014(UTC)
Posts: 50
Austria

Was thanked: 8 time(s) in 8 post(s)
Hello Pekka!

Please can you try to "directly" insert the database objects (i.e. without using global resources)?

Additionally:
1) which version of MobileTogether (4.0?) and DatabaseSpy are you using?
2) are you using a 32 or 64bit version?
3) which MySQL version are you using?

Thanks and sorry for the inconvenience.

Altova MobileTogether Experts
Back to top
Pekka Pasanen  
#3 Posted : Wednesday, January 31, 2018 9:53:07 AM(UTC)
Pekka Pasanen

Rank: Member

Groups: Registered
Joined: 1/30/2018(UTC)
Posts: 11
Finland
Location: Lohja
Quick reply (I don’t have acces version numbers at the time)

1.-2.) All products are 64 bit and newly downloaded versions.

3.) It is not possible to direcly insert database components because MobileTogether doesn’t see user DSN’s or system DSN’s (bug too). Only way is to use file DSN. But it doesn’t work because MobileTogether mixes database username and password -> username becomes password and so connection is not possible. It was only way to get connection in the way that I created them in DataSpy trough global resources and used them in MobileTogether.

I think there is older version of connection handling in MobileTogether than in DataSpy (maybe some version control error).

I will send the version numbers later today.

Thank for hanling this case!

- Pekka
Back to top
AFC  
#4 Posted : Wednesday, January 31, 2018 11:14:58 AM(UTC)
AFC

Rank: Administration

Groups: Registered, Administrators
Joined: 9/15/2014(UTC)
Posts: 50
Austria

Was thanked: 8 time(s) in 8 post(s)
Hi Pekka!

we are not aware of a bug with system or user DSNs, so please can you verify if "%windir%\system32\odbcad32.exe" shows your DSN but MobileTogether doesn't!?

If this is the case, I would suggest to contact our Support team for detailed help.

PS: Regarding the combination of ODBC + Global Resource + MySQL, we found a bug and will try to fix it as soon as possible.

Best regard,
AFC
Back to top
Pekka Pasanen  
#5 Posted : Wednesday, January 31, 2018 12:41:56 PM(UTC)
Pekka Pasanen

Rank: Member

Groups: Registered
Joined: 1/30/2018(UTC)
Posts: 11
Finland
Location: Lohja
Hi AFC,

Here is screenshot where there is DataSpy capture on left, MobileTogether capture on right and under them is %windir%\system32\odbcad32.exe capture.

You are reacting fast, thank you for that!

Best regard,

Pekka
File Attachment(s):
MT.png (416kb) downloaded 19 time(s).
Back to top
AFC  
#6 Posted : Wednesday, January 31, 2018 1:25:28 PM(UTC)
AFC

Rank: Administration

Groups: Registered, Administrators
Joined: 9/15/2014(UTC)
Posts: 50
Austria

Was thanked: 8 time(s) in 8 post(s)
Hi Pekka,

please can you attach a screenhot of the MobileTogether ODBC connections dialog, where the whole MobileTogether Designer application is visible in the background?

Best regards,
AFC
Back to top
Pekka Pasanen  
#7 Posted : Wednesday, January 31, 2018 1:52:22 PM(UTC)
Pekka Pasanen

Rank: Member

Groups: Registered
Joined: 1/30/2018(UTC)
Posts: 11
Finland
Location: Lohja
Hi,

Here it is.

- Pekka
File Attachment(s):
MTcapture.PNG (499kb) downloaded 18 time(s).
Back to top
Pekka Pasanen  
#8 Posted : Wednesday, January 31, 2018 1:57:10 PM(UTC)
Pekka Pasanen

Rank: Member

Groups: Registered
Joined: 1/30/2018(UTC)
Posts: 11
Finland
Location: Lohja
And same window with DSN definitions.

- Pekka
File Attachment(s):
MTcapture with ODBC settings.PNG (549kb) downloaded 17 time(s).
Back to top
AFC  
#9 Posted : Wednesday, January 31, 2018 1:58:57 PM(UTC)
AFC

Rank: Administration

Groups: Registered, Administrators
Joined: 9/15/2014(UTC)
Posts: 50
Austria

Was thanked: 8 time(s) in 8 post(s)
Hi Pekka,

as assumed, this is the 32bit version of the MobileTogether Designer.
Please retry with 64bit.

Best regards,
AFC
Back to top
Pekka Pasanen  
#10 Posted : Wednesday, January 31, 2018 2:07:24 PM(UTC)
Pekka Pasanen

Rank: Member

Groups: Registered
Joined: 1/30/2018(UTC)
Posts: 11
Finland
Location: Lohja
Hi AFC,

Okay, I thought that i downloaded 64 bit version. Thank you.

Best regards,

- Pekka
Back to top
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.