msdfmap - ; (1) First take the access of the connect...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
;[connect name] will modify the connection if ADC.connect="name" ;[connect default] will modify the connection if name is not found ;[sql name] will modify the Sql if ADC.sql="name(args)" ;[sql default] will modify the Sql if name is not found ;Override strings: Connect, UserId, Password, Sql. ;Only the Sql strings support parameters using "?" ;The override strings must not equal "" or they are ignored ;A Sql entry must exist in each sql section or the section is ignored ;An Access entry must exist in each connect section or the section is ignored ;Access=NoAccess ;Access=ReadOnly ;Access=ReadWrite ;[userlist name] allows specific users to have special access ;The Access is computed as follows:
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ; (1) First take the access of the connect section. ; (2) If a user entry is found, it will override. ; [connect default] ;If we want to disable unknown connect values, we set Access to NoAccess Access=NoAccess A [sql default] ;If we want to disable unknown sql values, we set Sql to an invalid query. Sql=" " S [connect CustomerDatabase] Access=ReadWrite Connect="DSN=AdvWorks" C [sql CustomerById] Sql="SELECT * FROM Customers WHERE CustomerID = ?" S [connect AuthorDatabase] Access=ReadOnly Connect="DSN=MyLibraryInfo;UID=MyUserID;PWD=MyPassword" C [userlist AuthorDatabase] Administrator=ReadWrite A [sql AuthorById] Sql="SELECT * FROM Authors WHERE au_id = ?"...
View Full Document

This note was uploaded on 11/28/2011 for the course GEOL 101 taught by Professor Jeeze during the Spring '08 term at San Diego State.

Ask a homework question - tutors are online