Remote Data Services

[12457854]

I'm trying to use the RDS and when I read the documentation provided by microsoft I had some problems and questions.
The data is placed in an Access database and when I try to display it using the RDS it does not work.
Here is the code I got from microsoft:

<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33" ID="RDSDC1">
<PARAM NAME="SQL" VALUE="SELECT Author, ID FROM Authors">
<PARAM NAME="CONNECT" VALUE="DSN=Pubs;">
<PARAM NAME="SERVER" VALUE=

http://Bookweb/>

</OBJECT>

<TABLE id=Tasks DataSrc=#RDSDC1 WIDTH=100% BORDER=1 style="display: none">
<THEAD ALIGN=left>
<TR>
<TH><em>ID</TH>
<TH><em>Author</TH>
</TR>
</THEAD>
<TR>
<TD><DIV DATAFLD=ID></DIV></TD>
<TD><DIV DATAFLD=Author></DIV></TD>
</TR>
</TABLE>


I do not know where to indicate the path to my .mdb file and what the following two lines mean:
<PARAM NAME="CONNECT" VALUE="DSN=Pubs;">
<PARAM NAME="SERVER" VALUE=

http://Bookweb/>

What's DSN=Pubs; and the server. Does using this method require any software installed on the server?

Maybe I'm on the wrong way and this is not how I can display data from an Access database on a webpage?

Any help would be appretiated.

Please send your replies to edik_g@freenet.am

Thank you.

Regards,
Ed.

 

[BobRodes]

Please see FAQ222-2244 for the many good reasons NOT to post your email on tek-tips.

Now, DSN means data source name. Pubs is a sample publishing database that comes with SQL server, analogouse to Northwind in Access. No guarantees, but I would try putting the mdb file in place of pubs. As for the Server parameter, try putting your URL there. Using this method requires IIS on the server; that's what RDS is designed for.

Try these, and write back if you're still having trouble.