Use these settings to associate ODBC-style DSN names with JDBC connection settings.
These settings allow you to configure an ODBC auto-increment, lookup, or submit in IBM® FileNet® eForms Designer which can be supported via JDBC in IBM FileNet eForms for P8. The driver and url (connection string) settings are required. The user and password settings are optional.
<?xml version="1.0" encoding="utf-8"?> <preferences> <sql> <connection dsn="ED-SQL2000" driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" user="sa" password="Passw0rd" url="jdbc:microsoft:sqlserver://ed-SQL2000; DatabaseName=SQLAutomation"> </connection> </sql> </preferences>