User avatar
johan
GpsGate
Posts: 14620
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

FIX: Franson NMEA Service or IIS crashes.

Fri Mar 31, 2017 3:11 pm

Note: for an updated version of this and other articles, we recommend you to check our knowledge base here

SYMPTOM

Franson NMEA Service or IIS crashes frequently.

CAUSE

You most likely installed an unsupported version of MySQL ODBC.

SOLUTION

1 Install Microsoft Visual C++ 2010 Redistributable
https://www.microsoft.com/en-us/download/details.aspx?id=14632

2 Download MySQL Connector ODBC 5.3.4 installer from: https://downloads.mysql.com/archives/c-odbc/
(5.3.6 and 5.3.7 does NOT work)

3 Stop GpsGateServer application pool in IIS Manager, and stop Franson NMEA Service

4 It is recommended to remove GpsGateServer data source in ODBC Data Source Administrator
if you are using older driver version than MySQL Connector ODBC 5.3.X. (You will need to recreate the datasource later.)

5 If you are using MySQL Connector ODBC 5.3.6 or later, you have to uninstall it first.

6 Install MySQL Connector ODBC 5.3.4

7 If you removed the the GpsGateServer data source in step 4, you need to recreate GpsGateServer datasource
in ODBC Data Source Administrator. (Make sure you pick MySQL ODBC 5.3 Unicode driver when creating a new datasource.)

8 Start GpsGateServer application pool in IIS Manager and start Franson NMEA Service
Regards,
Johan

GpsGate Support

ClausAnd
Posts: 136
Joined: Tue Jul 05, 2011 12:09 am
Location: Denmark

Re: FIX: Franson NMEA Service crashes.

Fri Mar 31, 2017 8:38 pm

any change support for newer / more recent versions of MySQL (server)?

User avatar
johan
GpsGate
Posts: 14620
Joined: Wed Aug 04, 2004 10:40 pm
Location: Sweden
Contact: Website

Re: FIX: Franson NMEA Service crashes.

Fri Mar 31, 2017 8:44 pm

This is about the MySQL ODBC driver. Not the MySQL server.
Regards,
Johan

GpsGate Support

ClausAnd
Posts: 136
Joined: Tue Jul 05, 2011 12:09 am
Location: Denmark

Re: FIX: Franson NMEA Service crashes.

Sat Apr 01, 2017 1:27 pm

so you consider it 'safe' to upgrade server to 5.7.17?

Return to “GpsGate Server - How to setup and use”