MySQL Forums
Forum List  »  Newbie

Problem Access to MySQL with ASP
Posted by: Fred
Date: May 03, 2005 07:29AM

Hi guys, i'm new with mysql ;)

Here's my problem

I created a quiz with Smartlite WebQuiz Xp, this software is using ASP with Access to manage questions and answers from users.

I decided to switch from Access to MySQL but when i change the obdc connection to the mysql database i receive lots of errors like this one

Function IsPrivateQuiz()
OpenConnection True
sSQL = "SELECT COUNT(*) FROM AllowedUsers"
If iDBType = 1 Then sSQL = sSQL & " AND QuizID=" & iQuizID
rsQuiz.Open sSQL, cnnQuiz, 1
IsPrivateQuiz = rsQuiz(0) > 0
CloseConnection rsQuiz, cnnQuiz
End Function

In this fonction, i receive Type mismatch on this line : IsPrivateQuiz = rsQuiz(0) > 0

I converted the Database with the migration toolkit. Is it possible that some ASP properties or statements work only with Access and cannot work with MySQL ??

Thank you!

Options: ReplyQuote


Subject
Written By
Posted
Problem Access to MySQL with ASP
May 03, 2005 07:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.