| Software > Ado Data RDS > Windows 2003 Se... |
|
| << Topic |
< Post |
Post 1 of 5 Topic 224 of 305
|
Post > |
Topic >> |
Windows 2003 Server, MDAC 2.8 and RDS
by =?Utf-8?B?cmthaW5l?= <rkaine@[EMAIL PROTECTED]
>
Dec 8, 2004 at 02:15 PM
|
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?????


|
5 Posts in Topic:
|
=?Utf-8?B?cmthaW5l?= < |
2004-12-08 14:15:04 |
|
"Jim Rodgers" & |
2004-12-09 00:32:42 |
|
=?Utf-8?B?cmthaW5l?= < |
2004-12-09 05:17:02 |
|
=?Utf-8?B?cmthaW5l?= < |
2004-12-09 12:45:44 |
|
"Jim Rodgers" & |
2004-12-10 12:34:14 |
|
Post A Reply:

|