Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_ado_rds thread: RDS and Handlers Problem


Message #1 by "Simon Langham" <simon.langham@c...> on Fri, 9 Mar 2001 18:09:00
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




  Return to Index