Object or Provider is not able to perform the requested operation

Question

I am trying to run the classic asp application which uses RDS (Remote data service) on Windows Server 2008

<object id="RDS_ACCOUNTS" CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
 height=1 width=1 VIEWASTEXT>

Following is the code written in window_load() event

RDS_ACCOUNTS.ExecuteOptions = 1
RDS_ACCOUNTS.FetchOptions = 1
RDS_ACCOUNTS.Server = "<%=strServer%>"
RDS_ACCOUNTS.Connect =Connect
RDS_ACCOUNTS.SQL = "SELECT ACCOUNT_TYPE_ID, CLIENT_ID, ACCOUNT_TYPE_DESC 
   FROM TBL_AP_CHART_ACCOUNT_TYPE 
   WHERE CLIENT_ID=<% = Session("ClientID")%> 
   ORDER BY ACCOUNT_TYPE_DESC "
RDS_ACCOUNTS.Refresh
Dim AccountRst
Set AccountRst = RDS_ACCOUNTS.Recordset

Here connect variable have its value from RDSConn.inc file which have the value

Handler=MSDFMAP.Handler;Data Source=AMTAPP;

This handler picks value from msdfmap.ini file located in C:\Windows folder which contains the OLEDB Connection Stringor DSN Name. But when i run this code it gives me exception

Object or Provider is not able to perform the requested operation on RDS_ACCOUNTS.Refresh method.

Visit this link, it may help: https://www.webwiz.co.uk/kb/asp-tutorials/access-database-errors.htm — Bhupendra Shukla, Apr 01 '15 at 10:28
Could be a permissions issue? Does the user that the website runs under have RDS permissions? — Stephen Angell, Apr 08 '15 at 08:02
Does it work properly if you set the `RDS_ACCOUNTS.Connect` directly equal to the OLEDB string, rather than using `MSDFMAP.Handler`? — transistor1, Apr 08 '15 at 18:28
it comes from the application and this page is the part of that application. you can use "http://url" in the place of "<%=strServer%> and on the place of whole sql query you can write any simple select query. — RemS, Apr 09 '15 at 10:08
but should it be `RDS_ACCOUNTS.Server = strServer` not `RDS_ACCOUNTS.Server = "<%=strServer%>"`? — oracle certified professional, Apr 10 '15 at 07:13
Does a more trivial request work ? (i.e. playing with constant values) — Amessihel, Apr 10 '15 at 16:40
But it works on different server...@oraclecertifiedprofessional — RemS, Apr 13 '15 at 03:57
@oraclecertifiedprofessional No the OP is passing the `<%= strServer %>` as a server-side variable to the `RDS_ACCOUNTS.Server` which is running in client side VBScript. — user692942, Aug 17 '15 at 11:08
Almost feels like this is what the code should look like RDS_ACCOUNTS.ExecuteOptions = 1 RDS_ACCOUNTS.FetchOptions = 1 RDS_ACCOUNTS.Server = strServer RDS_ACCOUNTS.Connect =Connect RDS_ACCOUNTS.SQL = "SELECT ACCOUNT_TYPE_ID, CLIENT_ID, ACCOUNT_TYPE_DESC FROM TBL_AP_CHART_ACCOUNT_TYPE WHERE CLIENT_ID=" & Session("ClientID") & " ORDER BY ACCOUNT_TYPE_DESC " RDS_ACCOUNTS.Refresh Dim AccountRst Set AccountRst = RDS_ACCOUNTS.Recordset — ullfindsmit, Jun 02 '23 at 22:49

Object or Provider is not able to perform the requested operation

0 Answers0