Click to See Complete Forum and Search --> : RDS Object question


vitsvg
June 12th, 2002, 03:56 PM
Hello there

I'm trying to user subj in Visual Interdev 6.0 like this:

<BODY onload = "Init()"> ...
<OBJECT ID="objData" WIDTH=1 HEIGHT=1 CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"></OBJECT>
</BODY>

1-st problem.

I've got error message:
An object has failed to load. The object will be displayed as text.

2-nd problem.

function Init() {
objData.Server = "http://vital";
objData.Connect = "PROVIDER=SQLOLEDB;DSN=VER2_CAD;UID=sa;";
objData.SQL = "select ... from ...";
objData.FetchOptions = 1;
objData.ExecuteOptions = 1;
objData.Refresh();
}

(I have ODBC alias VER2_CAD which is MS SQL database)
When I try to run it at IE6.0 and IIS5.0
I've got error message:

RDS Server Error: The server has denied access to default RDS Handler used to access this page. See the Server Administrator for more information about serve security settings.

Actually I was trying to use databound controls in ASP. But I stuck here now. By the way same script works at my friend PC (with IIS4.0).

So may be somebody had this problem?
I don't understand - should I change some security settings of IIE or MS SQL? Or may be connection string is wrong? May be I need to install some patches?