https://communities.sas.com/t5/SAS-Procedures/accessing-standby-database/m-p/43830#M11490 I am trying to access standby database <BR /> <BR /> proc sql<BR /> create table xyz as select * from connection to oledb<BR /> ( provider= "dd" properties=("user id" passwprd ...)<BR /> (select.....)<BR /> from dddd<BR /> left join x on ...<BR /> ..<BR /> disconnect from oledb;<BR /> quit;<BR /> I am getting errors states: having read only access<BR /> any ideas to solve this problem <BR /> can creating view help? or any other alternative. Thu, 21 Jan 2010 02:20:08 GMT deleted_user 2010-01-21T02:20:08Z https://communities.sas.com/t5/SAS-Procedures/accessing-standby-database/m-p/43830#M11490 I am trying to access standby database <BR /> <BR /> proc sql<BR /> create table xyz as select * from connection to oledb<BR /> ( provider= "dd" properties=("user id" passwprd ...)<BR /> (select.....)<BR /> from dddd<BR /> left join x on ...<BR /> ..<BR /> disconnect from oledb;<BR /> quit;<BR /> I am getting errors states: having read only access<BR /> any ideas to solve this problem <BR /> can creating view help? or any other alternative. Thu, 21 Jan 2010 02:20:08 GMT https://communities.sas.com/t5/SAS-Procedures/accessing-standby-database/m-p/43830#M11490 deleted_user 2010-01-21T02:20:08Z https://communities.sas.com/t5/SAS-Procedures/accessing-standby-database/m-p/43831#M11491 A complete log would help, and a definition on what a "standby" database is.<BR /> /Linus Thu, 21 Jan 2010 07:41:48 GMT https://communities.sas.com/t5/SAS-Procedures/accessing-standby-database/m-p/43831#M11491 LinusH 2010-01-21T07:41:48Z