[View_Open_Error] [MSSQL_ODBC_Error1] We randomly get this warning messages since we have change our database from TOPSPEED to ODBC, we are using MySQL xampp as our database. How can we get rid of these messages? Thanks.

@1kbyte Thanks, the codes from the thread you have shared works. However, there are some scenario that the connection was not revived. If it is disconnected while on a browse form, it is perfectly working but on update form, the connection completely dies. While we are looking for a solution we have…

ClarionHub

MySQL warning messages

questions

1kbyte March 9, 2019, 5:06am 5

See:

Handling disconnect / disconnection from SQL / ie: file error halts questions

There were some questions in Skype about handling disconnections from SQL back ends. While Clarion expects a database connection to stick around forever, this is not typical - and it certainly isnt how SQL back ends achieve their best performance. Anyhow, disconnects happen, so how do you catch and cure them in your app without having the app close / halt? While this isnt perfect, it’s something pratik and I tossed back and forth some years ago and had reasonable success with this code. Note: …

1 Like

show post in topic

Home
Categories
Guidelines
Terms of Service
Privacy Policy

Powered by Discourse, best viewed with JavaScript enabled