-
accessing MS Access using RDSServer.DataFactory object
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|