Hi there,
I have got a simple page that inserts a few fields into a My SQL table. I am using ASP (VBScript), MySQL 4.0.5 for Win32 and IIS 5 as a web server.
Everything works fine and fast the first time I submit the page but if I try to do it again it does not work anymore.
The same happens when I do a select from the same table; the first time it displays all correct records extremely fast, but then, it stops working. The only solution I have got is to shutdown and restart the server
I have tried to do several insert statements in MySQL directly from the prompt always succesfully so I exclude that the problem is caused by MySQL; I think MYODBC 2.50 is malfunctioning,
any idea?
Thank you
Qatqat
I have got a simple page that inserts a few fields into a My SQL table. I am using ASP (VBScript), MySQL 4.0.5 for Win32 and IIS 5 as a web server.
Everything works fine and fast the first time I submit the page but if I try to do it again it does not work anymore.
The same happens when I do a select from the same table; the first time it displays all correct records extremely fast, but then, it stops working. The only solution I have got is to shutdown and restart the server
I have tried to do several insert statements in MySQL directly from the prompt always succesfully so I exclude that the problem is caused by MySQL; I think MYODBC 2.50 is malfunctioning,
any idea?
Thank you
Qatqat