I"m having trouble querying my Access database when using the DataFactory object. Here's the code:
'''''''''''''''
<!-- RDS Data Space Object -->
<OBJECT CLASSID="CLSID:BD96C556-65A3-11D0-983A-00C04FC29E36" ID="ADS" WIDTH="1" HEIGHT="1">
</OBJECT>


<SCRIPT LANGUAGE=vbscript>
'Create and Set the Datafactory Object and the Connection String, also
'hide the RDS object

dim Connection_String
Set ADF = ADS.CreateObject("RDSServer.DataFactory", "http://www.mywebserver.com")

Connection_String = "FILEDSN=d:\dsn\visitors_dsn.dsn;uid=webserver;pwd =visitordb;"
..
</script>
...
sql = "select * from visitors where user_name = '" + user_name + "'";

ADF.Query("FILEDSN=./dsn/visitors_dsn.dsn"&";uid=webserver;pwd=visitordb;", sql);
'''''''''''''''

I get the error at the Query line. I'm using the same connection string for this connection that I use for my server side connection, which works fine. Any suggestions? I'm running XP Pro w/ Access 2002.