Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MYSQL_OPT_RECONNECT in VFP
Message
From
06/06/2012 03:29:53
Hee Lim Wang
Fantasy Software Enterprise
Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
MYSQL_OPT_RECONNECT in VFP
Miscellaneous
Thread ID:
01545432
Message ID:
01545432
Views:
69
Hi all
In MySQL 5+ auto-reconnect is disabled by default
I want to set auto reconnect in MySQL when server has gone away

example in MySQL reference manual is
my_bool reconnect = 1;
mysql_options(&mysql, MYSQL_OPT_RECONNECT, &reconnect);

how to write MYSQL_OPT_RECONNECT in VFP coding ?
will it prevent from server has gone away ?
Reply
Map
View

Click here to load this message in the networking platform