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!
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.