Problem with DHTML and RDS

Kurt.W · September 26th, 2005, 02:16 AM

Hi,

  I am currently developing a hta application to read data from an internal MS SQL server (not running IIS) with the data binding and RDS object.

  I have tried to create a dsn file at my local machine and also the server. However, I failed to get it work, the hta application disply
nothing.

  Could anyone tell me how can I make it work? Or RDS could only work on web server only? My HTML code is something look like the following. Thanks you.

Kurt.W

<HTML>
.
.
.
<OBJECT classid="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
    ID=dsoComposer HEIGHT=0 WIDTH=0>
    <PARAM NAME="Server" VALUE="myDBServer">
    <PARAM NAME="Connect" VALUE="dsn=read;uid=read;pwd=">
    <PARAM NAME="SQL" VALUE="select col1 from table1">
</OBJECT>
.
.
.
<SPAN DATASRC=#dsoComposer DATAFLD=col1></SPAN>
.
.
.
</HTML>

joefawcett · September 28th, 2005, 09:41 AM

I used to use RDS quite a bit on a company intranet, it's a bit passÃ© now but can be made to work.
One aspect that has tightened up in the last few years is security, now servers won't accept RDS connections unless specifically configured to. See this link to make sure your server is set up correctly.

http://msdn.microsoft.com/library/de...asp?frame=true

One way to test is to use scripting and try the folloing in your browser to see whether it's your DSN that's a problem:

Code:

<OBJECT ID="RDS1" WIDTH=1 HEIGHT=1
CLASSID="CLSID:BD96C556-65A3-11D0-983A-00C04FC29E36">
</OBJECT>
<script>
  function testRDS()
  {
    var oDF = document.getElementById("RDS1").CreateObject("RDSServer.DataFactory", <server name here>);
    var sConn = "Provider='sqloledb';Initial Catalog='<database name here>'; User ID='read'; Password="    
    var sSql = "<some select statement here>";
    var oRS = oDF.Query(sConn, sSql);
    alert(oRS.Fields(0).value);
    oRS.Close();  
  }
</script>

Make sure that errors are notified in you page by checking the box in Tools|Internet options|Advanced.
I would have thought that the DSN would need to be on the server, a system one not a user one.

--

Joe (Microsoft MVP - XML)

Kurt.W · September 28th, 2005, 08:26 PM

Quote:

quote:Originally posted by joefawcett
I used to use RDS quite a bit on a company intranet, it's a bit pass?now but can be made to work.
One aspect that has tightened up in the last few years is security, now servers won't accept RDS connections unless specifically configured to. See this link to make sure your server is set up correctly.

http://msdn.microsoft.com/library/de...asp?frame=true

One way to test is to use scripting and try the folloing in your browser to see whether it's your DSN that's a problem:
...
Make sure that errors are notified in you page by checking the box in Tools|Internet options|Advanced.
I would have thought that the DSN would need to be on the server, a system one not a user one.

--

Joe (Microsoft MVP - XML)

Yes, it is a bit pass.

Actually, i want to develope an hta application to get / update data
in an access DB and also read data from an internal MS SQL Server without setting a webserver.

Could you suggest a better alternative other than RDS? XML? :)

Abd thanks you for your reply. I have tried your code and an error like "cannot create business object" raised. Is there any additional setting have to be made for the DB server?

Thanks you.

Kurt.W

joefawcett · September 29th, 2005, 08:19 AM

Read the link about security, you will have to modify the settings on the host machine.

It's a pity that the machine is not a web server because nowadays you would use a web service for this sort of thing.

Why not just connect directly to SQL via ADO? The processing will be done on the server anyway so you're not gaining much by using RDS which is more suitable for something like an Access database.

--

Joe

Kurt.W · September 29th, 2005, 08:11 PM

Quote:

quote:Originally posted by joefawcett
Read the link about security, you will have to modify the settings on the host machine.

It's a pity that the machine is not a web server because nowadays you would use a web service for this sort of thing.

I seek. Thanks you.

Quote:

quote:Originally posted by joefawcett
Why not just connect directly to SQL via ADO? The processing will be done on the server anyway so you're not gaining much by using RDS which is more suitable for something like an Access database.

It is beacause I want to try out the Data Binding of DHTML.
However, RDS seem to be the only way to access SQL DB and access DB
if I want to use Data Binding.