Problems with MySQL useing MyODBC and ASP on NT5

["Christian Rytter" <chris@xxxxxxxxxxx>]

Hello

I have installed the MySQL server on a Windows 2000 server, and set up passwords and usernames. And one database with 3 tables. Each tables uses auto increment fields. (these are marked as index fields as they should be).

And then i have inserted a few test records. When i do a standard query useing mysql promt, it looks fine.("SELECT * FROM tbl;") But when i do it in ASP useing a DSNless connection in ADODB it dosnt work. When i specify which fields it should return, it does the same. But when i remove the autoincrement id field, it works fine. ("SELECT name, desc FROM tbl;")

What could be wrong?

Venlig Hilsen / Best regards
Christian Rytter
AC Software
chris@xxxxxxxxxxx
http://www.ac-ware.com