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 http://www.mysql.com/products/tools/migration-toolkit/ - 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 http://dev.mysql.com/downloads/connector/odbc/3.51.html - 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!
-------------
Thanks for your help!!!
Kind Regards
Rob,
http://www.balearic-jobs.com" rel="nofollow - Balearic Jobs
Helping young people find seasonal work in the Balearic Islands, including vacancie
|