MySQL Serious Error : i have been getting these errors...

Thu, 09 Nov 2006 23:24:04 +0000

Author: balearicjobs
Subject: 21890
Posted: 09 November 2006 at 11:24pm

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!

Web Wiz Support and Community Forums : MySQL Serious Error

MySQL Serious Error : i have been getting these errors...