ASP + MySQL ODBC error 80040e21..?

Scytzo · #1 (**permalink**) 05-21-09, 19:35

Alright, so I got this website today to 'fix' from my boss, and I have no experience in ASP or MySQL. Hell, I've just started to learn PHP...

So, here's the Error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/invCategories.asp, line 6

And the line it's referring to:

oRS.Open sSQL, oConn, 1

I can supply the entire document code if necessary...

Thanks for any help in advance...

Scytzo · #2 (**permalink**) 05-21-09, 20:19

After some fiddling... I got a new error...

Code:

Microsoft VBScript compilation  error '800a03f2'

Expected identifier

/inc/connect.asp, line 2

Dim oConn, rFSO, rFile, rPath, rRS, rSQL, catRS,
------------------------------------------------^

Scytzo · #3 (**permalink**) 05-21-09, 20:23

Nope, back to the original error.

Scytzo · #4 (**permalink**) 05-22-09, 12:49

So, upon much investigation, I have found out that every time the document refers to the "oRS" (whatever that is) it errors out. Any help with this?

I'm getting different error on each page, but always referring to a line of code with "oRS" in it....

Again, any help would be much appreciated.

Rappa21 · #5 (**permalink**) 05-22-09, 13:02

For what I understand, you are haveing problems running the query.

Look for the content in the sSQL variable, it should say something like:

Code:

sSQL = "Select * From ...."

Or something like that.

Scytzo · #6 (**permalink**) 05-22-09, 13:26

Code:

If Request("catid") <> "" Then
	  sSQL = "SELECT * FROM PhotoGallery WHERE PhotoCategory = " & catid & " ORDER BY PhotoDate"
	 Else
	  sSQL = "SELECT * FROM PhotoGallery ORDER BY PhotoDate"
	 End If
	 rRS.Open sSQL, oConn, 1

This what I'm looking for?

Rappa21 · #7 (**permalink**) 05-22-09, 16:05

Look, if "PhotoCategory" is not a number type variable, try adding quotes to the query string (the single ones) as follows:

Code:

sSQL = "SELECT * FROM PhotoGallery WHERE PhotoCategory = '" & catid & "' ORDER BY PhotoDate"

Good luck

gvee · #8 (**permalink**) 05-29-09, 09:08

Ever heard of SQL Injection?

I'd definately give it a google if I were you and then once you understand the risks, look at using parameterized stored procedures instead of building up a string to execute.

Internet Services

Web Development

Digital Marketing

Consumer Tech