-
RDS Object question
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?
