MySQL Serious Error

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   i have been getting these errors following an Access to MySQL transfer;

Firstly when I try and register a new account

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/asp/mb/register.asp, line 911
and when I try and post a new topic

Server Error in Forum Application
An error has occured while writing to the database.
Please contact the forum administrator.

Support Error Code:- err_mySQL_save_new_post_data
File Name:- new_post.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length
I used the Migration software from the MySQL site to transfer the MS Access database, following the instructions given in the help video that is on that website. 

I am using a MySQL 4.1 database and after doing a search on this forum I have already tried the following with no sucess;

I updated the MySQL Connector and ODBC to 3.51 and I added the following 

strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Group_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Real_name, " & strDbTable & "Author.User_code, " & strDbTable & "Author.Password, " & strDbTable & "Author.Salt, " & strDbTable & "Author.Author_email, " & strDbTable & "Author.Homepage, " & strDbTable & "Author.Location, " & strDbTable & "Author.MSN, " & strDbTable & "Author.Yahoo, " & strDbTable & "Author.ICQ, " & strDbTable & "Author.AIM, " & strDbTable & "Author.Occupation, " & strDbTable & "Author.Interests, " & strDbTable & "Author.DOB, " & strDbTable & "Author.Signature, " & strDbTable & "Author.No_of_posts, " & strDbTable & "Author.No_of_PM, " & strDbTable & "Author.Join_date, " & strDbTable & "Author.Avatar, " & strDbTable & "Author.Avatar_title, " & strDbTable & "Author.Last_visit, " & strDbTable & "Author.Time_offset, " & strDbTable & "Author.Time_offset_hours, " & strDbTable & "Author.Date_format, " & strDbTable & "Author.Show_email, " & strDbTable & "Author.Attach_signature, " & strDbTable & "Author.Active, " & strDbTable & "Author.Rich_editor, " & strDbTable & "Author.Reply_notify, " & strDbTable & "Author.PM_notify, " & strDbTable & "Author.Skype, " & strDbTable & "Author.Login_attempt, " & strDbTable & "Author.Banned, " & strDbTable & "Author.Info " &_
to line 709 of the register.asp.

Neither had any effect.

I would really appreciate any help on this problem!