I am trying to connect to mysql db through asp with code that is to upload a file from a computer. I get this error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

ODBC driver does not support the requested properties.

/uploadexmple.asp, line 44

I am using code from http://www.asp101.com/articles/jacob/scriptupload.asp . An asp file upload program written by jacob Gilley. Heres where mine goes wrong:

ElseIf Uploader.Form("saveto") = "database" Then

            ' Open the table you are saving the file to
            dim rs
            Set RS = Server.CreateObject("ADODB.Recordset")
            RS.open "lecnotes", "Driver={Mysql}; Server=mysql1.webhost.ie; Database=paulmc; UID=paul; PWD=1981 ",2,2
            RS.AddNew ' create a new record

            RS("filename") = file.filename ##[b]THE ERROR OCCURS HERE LINE44
            RS("filesize")= File.FileSize
            RS("contenttype") = File.ContentType

            ' Save the file to the database
            File.SaveToDatabase RS("filedata")

            ' Commit the changes and close
            RS.Update
            RS.Close
        End If

lecnotes is the name of the table where i'll store the file and it has properties:



     Field Type Attributes Null Default Extra Action
filename varchar(20)
filesize varchar(20)
contenttype varchar(40)
filedata blob BINARY

any help appreciated...

Try downloading first MyODBC driver from MySQL website, then
create a DSN through from that driver. It works for me, when I access MySQL database through ASP scripts. Hope this helps.
JOHN

hai,

pls try to download the following file from www.mysql.com "mysql-connector-odbc-3.51.12-win32" if download completed then install it. finally u create a DSN for ur database and u can try to connect the mysql db with the asp and vb.

pls try this.

all the best