I'm trying to set up an RDS connection that uses handlers for the
connection information. The connection works and the ActiveX grid
populates when I use a DSNless connection string embedded in the page.
myConn = "PROVIDER=MSDASQL;driver={Microsoft ODBC for
Oracle};SERVER=ServerName;UID=uid;PWD=pwd"
strSQL = Select * from subject_table
rdsOne.SQL = strSQL
rdsOne.connect = myConn
rdsOne.Refresh
When I switch to using a handler the grid remains blank.
strSQL = Select * from subject_table
rdsOne.SQL = strSQL
rdsOne.handler = "MSDFMAP.Handler,dfmap.ini"
rdsOne.connect = "data source=RDSConn"
rdsOne.Refresh
The dfmap.ini contains
[connect RDSConn]
Access=ReadOnly
Connect="PROVIDER=MSDASQL;driver={Microsoft ODBC for
Oracle};SERVER=serverName;UID=uid;PWD=pwd;"
Looking at the page on the server (win2k) logged in as the Admin works.
Are there some file security settngs I need? Any other suggestions?
Thanks,
Simon