while our new app is being developed by our provider
we are adjusting our legacy about to retire as much as possible.
I am getting error "odbc too many connections " from MySQL server
why is this?
Maybe is because in each piece of source we open a connection execute a command and close the connection?
Should I have one only connection all the session?
Each time I need to add/update or delete I follow the same steps
con1 = SQLCONNECT("connex","root","root")
R2 = SQLEXEC(con1,v2)
Works just fine until the " TOO MANY CONNECTIONS " error message.
What is your advice here?