var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: ASP + MySQL ODBC error 80040e21..?
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...
After some fiddling... I got a new error...
Microsoft VBScript compilation error '800a03f2'
/inc/connect.asp, line 2
Dim oConn, rFSO, rFile, rPath, rRS, rSQL, catRS,
Nope, back to the original error.
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.
For what I understand, you are haveing problems running the query.
Look for the content in the sSQL variable, it should say something like:
Or something like that.
sSQL = "Select * From ...."
This what I'm looking for?
If Request("catid") <> "" Then
sSQL = "SELECT * FROM PhotoGallery WHERE PhotoCategory = " & catid & " ORDER BY PhotoDate"
sSQL = "SELECT * FROM PhotoGallery ORDER BY PhotoDate"
rRS.Open sSQL, oConn, 1
Last edited by Scytzo; 05-22-09 at
Look, if "PhotoCategory" is not a number type variable, try adding quotes to the query string (the single ones) as follows:
sSQL = "SELECT * FROM PhotoGallery WHERE PhotoCategory = '" & catid & "' ORDER BY PhotoDate"
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.