I have a server woth mySQL running and i get data from the database with PHP scripts with HTTP request, i made a tool with visual basic to populate the database. It access by ODBC.
This is the problem:
Sometimes when i try to write in the database some data with my Visual Basic Tool, the DTb answer to me with an error , saying it can't write, if i try to write more than one time it can write....
I'd like to know what's the problem because it happens sometimes and not everytime i try to write.
I thought it cold be a problem of multiple access to the database, one try to read via HTTP from the table when my tool try to write... but i think it's too unlucky to make a theory.
Thanks
This is the problem:
Sometimes when i try to write in the database some data with my Visual Basic Tool, the DTb answer to me with an error , saying it can't write, if i try to write more than one time it can write....
I'd like to know what's the problem because it happens sometimes and not everytime i try to write.
I thought it cold be a problem of multiple access to the database, one try to read via HTTP from the table when my tool try to write... but i think it's too unlucky to make a theory.
Thanks