Is This Content Helpful?
We're glad to know this article was helpful.
Instructions provided describe how to use Java Database Connectivity (JDBC) authentication with a Microsoft SQL server database.
Verify that the following software products are installed before following these instructions:
- ArcIMS 9.x
- SQL Server 2000/2005
Note: For more information on the service restrictions defined in this example, see the ArcIMS Help documentation under "Enabling authentication with a JDBC-based ACL" or "ACL attribute reference".E. Give an existing or new SQLServer user access permissions to the new database and the tables. The sa (system administrator) user will be used in this article.
Note: The original 'Esrimap_prop' file settings are stored in the backup file 'Esrimap_prop_original'.D. Edit or confirm, in the new 'Esrimap_prop' file, the following attributes and values:
Note: Some attributes may need to be made active by removing the # commenting symbol.
Code: authenticate=True authMethods=Basic authenticateWithSessions=True useJdbc=True jdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver jdbcUrl=jdbc:odbc:ArcIMS_ACL jdbcUser=<user> jdbcPassword=<password> jdbcPermTable=acl_permissions jdbcUserTable=acl_users jdbcUidColumn=userid
Note: The jdbcDriver value 'sun.jdbc.odbc.JdbcOdbcDriver' references the Java class containing the JDBC-ODBC Bridge functionality. It is included with the JRE/JDK. The jdbcUrl value 'jdbc:odbc:ArcIMS_ACL' is standard syntax for referencing the ODBC system DSN that the JDBC-ODBC Bridge is using.
Note: Note that a jdbc user and password are not required when using an Access database. See the ArcIMS Help documentation under "Enabling authentication with a JDBC-based ACL" for more details on attributes and values.
Note: It is possible to use a third-party JDBC driver. For example, Oracle or Microsoft JDBC drivers can connect directly to the RDBMS. These drivers often can be found at the corresponding software manufacturers' support sites. When using these drivers, ensure that the driver is available in the servlet engine's common library directory. For example, Tomcat maintains the common library directory in $CATALINA_HOME/common/lib. In most cases, copy one or more JAR files associated with the JDBC driver to this directory.E. Save the Esrimap_prop file.
Note: If using IIS as the Web server, it may be necessary to configure IIS for authentication. For more information, refer to step 8 in the ArcIMS Help topic, "Enabling authentication with a JDBC-based ACL".