Web Wiz Forums - Type mismatch

Print Page | Close Window

Type mismatch

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=31652
Printed Date: 28 March 2026 at 9:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Type mismatch

Posted By: lordtec
Subject: Type mismatch
Date Posted: 18 January 2020 at 12:14am

I have converted my database from MS Access 2000 to MySQL. I am now getting a type mismatch error.

Microsoft VBScript runtime error '800a000d'

Type mismatch

/forum/default.asp, line 1059

Here is the code

'Display some statistics for the members

If lngNoOfMembers > 0 Then

Response.Write("<br />" & strTxtWeHave & " " & FormatNumber(lngNoOfMembers, 0) & " " & strTxtForumMembers & _

"<br />" & strTxtTheNewestForumMember & " <a href=""member_profile.asp?PF=" & saryMemebrStats(1,0) & strQsSID2 & """>" & saryMemebrStats(0, 0) & "</a>")

End If

What could be the problem?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 18 January 2020 at 11:49am

It is unlikely that you can convert from Access to MySQL as the two databases are very different.

You should though be able to upsize the Access database to SQL Server.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting