Got this error after setting up mysql

[Mr.X]

Got this error after setting up mysql

[code:1]System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]Column count doesn't match value count at row 1
at System.Data.Odbc.OdbcConnection.HandleError(Handle Ref hrHandle, SQL_HANDLE hType, RETCODE retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(C ommandBehavior behavior, String method)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()[/code:1]

Does anyone know who to fix this? thanks.

[doe90]

hmmmm

did you do every thing on the PDF?
http://142.179.148.248/myrunuo.pdf
http://142.179.148.248/myrunuo.zip

[Mr.X]

hmm.. my pdf didnt come with that last page for some reason. that must be why.

[Mr.X]

trying to install iis and i download and installed that app. Then I go to add remove windows componets like the pdf says but its not listed. is xp differnt maybe? iis shoud be there right?

[doe90]

when you look to the left og add/remove programs there's four buttons you want the fourth one

[Mr.X]

4th one down from the left is set program access and defaults or do you mean once I'm inside add windows components the 4th one down from that is IE and I can't open the details of that.

[doe90]

Zulu sould be able to tell you..

[Mr.X]

Also I would like to add that this error only happens when I'm loged in. when no one is loged in it runs smooth.

[doe90]

Did You do what's on the pic?


http://www.mysql.com/downloads/api-myodbc-3.51.html
http://www.mysql.com/downloads/mysql-4.0.html

[Mr.X]

yep already downloaded mysql, set the root account, and made the tabels. the only thing i havnt done was move that ultima.dll to the bin folder because it was already in there and I could not get the iis set up.