Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Problème de connexion à Mysql
sp_NewPost Add Reply sp_NewTopic Add Topic
December 26, 2017
5:28 pm
Thierry Paulin
Guest
Guests

Using the last version of Mysql Connector fixed by problem.
Thing you for help and suggestions !

December 26, 2017
10:54 am
Henk Helmantel
Admin
Forum Posts: 1488
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Thierry,

Crashes or memory errors with the ODBC driver are an indication of a problem in the ODBC driver itself. Diafaan SMS Server is a Microsoft .NET program and it only uses managed code. This means that memory errors or crashes are very rare and should not happen unless there is a hardware problem or a bug in Microsoft .NET itself.

However, the ODBC drivers for MySQL are unmanaged code and if there is a bug in the ODBC driver then it can lead to the memory error that you see in the error message. It can be a stand-alone problem with the ODBC driver or a problem with the combination of the MySQL database version and the version of the ODBC driver.

The only solution for these kinds of problems is usually to install another version of the ODBC driver or, if that does not work, another version of the MySQL database. Sometimes, using a different connection string also prevents the problem but there is no general advice that I can give you for the connection string parameter that could cause a problem.

Regards, Henk

December 25, 2017
11:47 am
Thierry Paulin
Guest
Guests

Google translation:

I use the full version of diafaan. I can connect to my sql database by using the string connection but I can not pass the parameterization of the messageIn and MessageOut tables. I receive the following error message:

Driver = {MySQL ODBC 5.1 Driver}; Server = 127.0.0.1; charset = UTF8MB4; Database = mabase; User = root; Password =; Option = 3;

SELECT Id, MessageTo, MessageText, MessageFrom FROM messageOut WHERE Id = '0'

Attempt to read or write protected memory. This often indicates that another memory is damaged.

Has anyone ever met this problem and given me some solutions?

NB: I am on Windows 10 (64 bits)

Version of Diafaan: 4.1.1.0 (64 bits)

Bonjour à tous,

J'utilise la version full de diafaan. J'arrive bien à me connecté à ma base sql en utilisant le connexion string mais je n'arrive pas à passer l'étape du paramétrage des tables messageIn et MessageOut. Je reçois le message d'erreur suivant :

Driver={MySQL ODBC 5.1 Driver};Server=127.0.0.1;charset=UTF8MB4;Database=mabase;User=root; Password=;Option=3;

SELECT Id,MessageTo,MessageText,MessageFrom FROM messageOut WHERE Id='0'

Tentative de lecture ou d'écriture de mémoire protégée. Cela indique souvent qu'une autre mémoire est endommagée.

Quelqu'un a-t-il déjà rencontré ce problème et me donner des piste de solutions ???
NB : je suis sur Windows 10 (64 bits)
Version de Diafaan : 4.1.1.0 (64 bits)

Merci d'avance

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
34 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 672

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1141

Posts: 3899

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1488