I have an application that is a hodge podge of different connection types.
I
have installed it on a Windows 2003 Server, running MDAC 2.8.
I have merged handler.reg and handsafe.reg.
I have performed the following steps:
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataFactory\HandlerInfo\
HandlerRequired = 0 and DefaultHandler is "" (Null string).
"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W3SVC\Parameters\ADCLaunch"
has a key called RDSServer.Datafactory.
Virtual Web MSADC exists pointing to 'C:\Program Files\Common
Files\System\msadc'
Virtual Web 'MSADC' Properties
Execute Permissions: Scripts and Executables
Directory Security/IP Address and Domain Name Restrictions: "Access is
Granted" to all IP Addresses
At the moment because I am frustrated...
Permissions: Everyone (Full Control)
This is the object as defined in my .ASP page.
<OBJECT CLASSID="clsid:BD96C556-65A3-11D0-983A-00C04FC29E33"
ID="rdsCarrier">
<param name="SERVER"
value="http://<%=Request.ServerVariables("SERVER_NAME")%>">
<param name="CONNECT" value="<%=Application("RDS_Connection_String")%>">
<param name="FETCHOPTIONS" value=1>
<param name="EXECUTE" value=1>
</object>
I have tried all possible variations on FETCHOPTIONS (1,2,3) and
EXECUTE(1,2)
I then execute a SQL query...
rdsCarrier.SQL = "SELECT BLAH, BLAH FROM tblBLAH WHERE BLAH = BLAH"
rdsCarrier. Refresh
To this point everything seems ok.
When I try to do the following:
rdsCarrier.FilterColumn = strColumn;
I get an error telling me 'Operation can not be performed while async
operation is pending'.
If I put an alert ahead of this command to check rdsCarrier.ReadyState it
returns a '2' or 'adcReadyStateLoaded' which means: 'The current query is
still executing and no rows have been fetched. The DataControl object's
Recordset is not available for use.'
I have verified server and connect by hardcoding the data as well as
adding
Handler = MDSFMAP.Handler and numerous other configurations.
I am at a loss. What am I doing wrong?????
