Web Wiz Support and Community Forums : mysql server problems after Access conver https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 13:28:39 +0000 Fri, 11 Aug 2006 18:28:38 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20982 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[mysql server problems after Access conver : I have done a search on this on...]]> https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112476.html#112476 Author: WebWiz-Bruce
Subject: 20982
Posted: 11 August 2006 at 6:28pm

I have done a search on this on the mySQL site and it seems it is a bug in some versions of mySQL and myODBC.

If you have access to the server try updating the myODBC driver, if you still have the same issue, then  try upgrading the version of mySQL you have.
]]> Fri, 11 Aug 2006 18:28:38 +0000 https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112476.html#112476 <![CDATA[mysql server problems after Access conver : i have changed the codes correctly....]]> https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112473.html#112473 Author: semih1
Subject: 20982
Posted: 11 August 2006 at 5:55pm

i have changed the codes correctly.

But i have taken the same error:

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

Support Error Code:- err_mySQL_update_USR
File Name:- register.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

------------
another page :

for trying to open 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 can write database using the admin menu, for example i can change the categories name's etc.




Edited by semih1 - 11 August 2006 at 5:56pm]]> Fri, 11 Aug 2006 17:55:27 +0000 https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112473.html#112473 <![CDATA[mysql server problems after Access conver : It looks like you may not have...]]> https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112464.html#112464 Author: WebWiz-Bruce
Subject: 20982
Posted: 11 August 2006 at 4:50pm

It looks like you may not have copied the line correctly.]]> Fri, 11 Aug 2006 16:50:39 +0000 https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112464.html#112464 <![CDATA[mysql server problems after Access conver : i have changed but now i&#039;m...]]> https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112455.html#112455 Author: semih1
Subject: 20982
Posted: 11 August 2006 at 1:38pm

i have changed but now i'm taking this error for register.asp:

Microsoft VBScript runtime error '800a000d'

Type mismatch: '[string: "SELECT tblAuthor.Aut"]'

/forumy/register.asp, line 709


]]> Fri, 11 Aug 2006 13:38:56 +0000 https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112455.html#112455 <![CDATA[mysql server problems after Access conver : Try changing line 709 of the file...]]> https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112437.html#112437 Author: WebWiz-Bruce
Subject: 20982
Posted: 11 August 2006 at 9:34am

Try changing line 709 of the file register.asp to:-

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 " &_


]]> Fri, 11 Aug 2006 09:34:55 +0000 https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112437.html#112437 <![CDATA[mysql server problems after Access conver : i convert my access db to mysql....]]> https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112412.html#112412 Author: semih1
Subject: 20982
Posted: 10 August 2006 at 6:46pm

i convert my access db to mysql. the data have no problem.

when i try to post new message or open a new topic or while editing the profiles i see this error:

for example  while editing the member profiles:

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

Support Error Code:- err_mySQL_update_USR
File Name:- register.asp

Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

-----------------

all errors detalis are:
Error details:-
Microsoft OLE DB Provider for ODBC Drivers
[Microsoft][ODBC Driver Manager] Invalid string or buffer length

what can i do ? have you got an opinion?
]]> Thu, 10 Aug 2006 18:46:18 +0000 https://forums.webwiz.net/mysql-server-problems-after-access-conver_topic20982_post112412.html#112412