Top

8.6.6.Using OpenLink ODBC, Progress & Microsoft Access

The Mysterious "Admin" Account & Disabling the JET Scrollable Cursor (Dynaset) Facility

Please ensure that you have the following OpenLink Settings enabled :

Client

  • OpenLink ODBC DSN "no login dialog box" check box is checked

  • OPENLINK.INI settings \Local Machine\Software\ODBC\OPENLINK.INI\Communications ShowErrors Key is also set to "No" , this ensures that OpenLink Specific error messages aren't shown.

Server

  • Ensure the following Mapping Rule exists as the first line of the [Mapping Rules] section of yor "Session Rules Book" :

[Mapping Rules]
;*:*:blank:*:*:*:rw = reject You should specify a username and password
*:*:Admin:*:*:*:rw = reject User Admin Account Does Not Exist In Your Progress Database

The above alleviates the need to depend of JetTryAuth or TryJetAuth.

Prev Up Next
8.6.5.Distributed Databases, Array Fields, Database Triggers Home 8.6.7.Key Microsoft Access Jet Engines Setting That Can Affect Your OpenLink ODBC Experience