MySQL Forums
Forum List  »  Microsoft Access

Help needed with the auto reconnect option
Posted by: Frank Czygan
Date: October 31, 2011 11:47PM

Hi! I am connecting to my MySQL db from MS Access. Now I am trying to implement auto reconnect in my connection string for the dsn less connection. There must be an error in the string as the reconnect feature is not yet working (doesn't reconnect as it does when I check the corresponding box with the dsn connection).

Can somebody help me to amend the string? Thanks a lot for your help! FRANK

Constr = "DRIVER={MySQL ODBC 5.1 Driver};Server=" & Server & _
";port=" & Port & ";user=" & user & ";Password=" & pw & ";Database=" & Datenbank & "; Option=4194304;"

Options: ReplyQuote

Written By
Help needed with the auto reconnect option
October 31, 2011 11:47PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.