[thelist] Pass ASP query sting to SQL statement

Groups at beachcomp.com Groups at beachcomp.com
Fri Aug 10 15:34:17 CDT 2007


I have 
<%
vidid = request.querystring("id")
MY_STRING = "Driver={Microsoft Access Driver (*.mdb)};DBQ= videos.mdb"
Server.ScriptTimeout = 180
Dim videos
Set videos = Server.CreateObject("ADODB.Recordset")
videos.ActiveConnection = MY_STRING
videos.Source = "SELECT * FROM videos where active=Yes and Id='vidid'"
videos.CursorType = 1
videos.CursorLocation = 1
videos.LockType = 1
videos.Open()
%>

But I get:

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

ODBC driver does not support the requested properties. 


Could anyone point me in the right direction?

 
Dave
 
 -----------------------------------
|Beach Computers                    |
|Affordable Hosting Solutions       |
|http://www.beachcomp.com           |
 ===================================
|Cheap Domain Warehouse             |
|Get Your Own Dot!                  |
|http://www.cheapdomainwarehouse.com|
 ---------------------------------- 

------------------------------------
Disclaimer and confidentiality note:

The contents of this communication are intended/meant only for addressee(s)
and may contain information that is privileged or otherwise confidential.
If you are not the intended recipient you are hereby notified that any
disclosure, copying, distribution or taking any action in reliance on the
contents of this information is strictly prohibited and may be unlawful.
The contents of this e-mail shall not be forwarded to any third party. If
you have received this electronic mail transmission in error, please delete
it from your system without copying or forwarding it, and notify the sender
of the error by reply email, so that the sender's address records
can be corrected.
Views and opinions are solely those of the sender unless clearly indicated
as being that of Beach Computers or any of it's affiliated companies.
Beach Computers cannot assure that the integrity of this communication has
been maintained or that it is free of errors, virus, interception or
interference.
-----Original Message-----
From: list-bounces at webdesign-l.com [mailto:list-bounces at webdesign-l.com] On
Behalf Of Lea de Groot
Sent: Thursday, August 09, 2007 2:21 AM
To: Web Design List
Subject: Re: [WD]: 'stuck' rss feed at google?

On Wed, 8 Aug 2007 08:52:22 -0500, Austin, Darrel wrote:
> It looks like we might just have to change the URL of our feeds. Which
> kind of sucks.

Just to make sure the 'dumb' questions have been asked... :)
I assume you have checked that Google is able to reach your feed file, 
and nothing has changed to stop it?
It definitely happens!

warmly,
Lea
-- 
Lea de Groot
Elysian Systems
Brisbane, Australia

+----------------------------------------------------------------------+
  more info about webdesign-l: http://webdesign-L.com/
               to unsubscribe: http://webdesign-L.com/mailman/listinfo/list
  If you had read the list policies: http://webdesign-L.com/policies/
 you'd know not to "top post": http://en.wikipedia.org/wiki/Top-posting
     That means that if this line here is in your reply, you lose.







More information about the thelist mailing list