2. ASPRunnerPro General questions
  3. Using MySQL
This topic is locked

Using MySQL

 		8/8/2003 4:34:18 PM
ASPRunnerPro General questions
author

Hello,
I'm trying to setup ASPRunner with MySQL. I'm using the following connection string (My ISP does not support myODBC):

strConnection = "Driver={MySQL};Server=MYSERVER;DATABASE=MYDATABASE;UID=USERNAME;PWD=PASSWOR

D"
When I try to view data I get the following error:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/asprunner/statecodes_list.asp, line 352
I can add records with no problem.
Any help would be great.
admin 8/8/2003

Hi,
try to put these three lines right before you open recordset.

setupRs.CursorType = 0

setupRs.CursorLocation = 3

setupRs.LockType = 1
setupRs.open strSQL,dbConnection


This section of code can be found around line 352 in statecodes_list.asp file.
Sergey Kornilov
500058 8/8/2003

I added the following to correct the errors:
setupRs.CursorType = 0

setupRs.CursorLocation = 3

setupRs.LockType = 1
Will this cause any other problems?
admin 8/10/2003

It should work fine on other pages - just make sure you have added those three lines before opening recordset. You need to do the same on the edit page also.
Sergey Kornilov
500059 8/11/2003

Can we get these additional lines added to the wizard?
admin 8/11/2003

Hi,
if you like to make these changes permanent - go to the folder where ASPRunner installed ( usually C:\Program Files\ASPRunner\source ) and apply the same changes to edit.asp and list.asp. This will affect all ASP files generated after that.
Best regards,

Sergey Kornilov