Manual Steps - Manual Steps - Perceptive Content - Perceptive Content Database Upgrade Package for SQL Server - Perceptive-Content/Perceptive-Content-Database-Upgrade-Package-for-SQL-Server/Foundation-26.1/Perceptive-Content-Database-Upgrade-Package-for-SQL-Server-Reference-Guide/Prerequisites/Database-Settings-for-Filtered-Indexes/ODBC-Driver-DSN-Settings/Manual-Steps - Foundation 26.1 - Foundation 26.1

Perceptive Content Database Upgrade Package for SQL Server Reference Guide

Platform
Perceptive Content
Product
Perceptive Content Database Upgrade Package for SQL Server
Release
Foundation 26.1
License
ft:lastPublication
2026-04-16T22:28:17.811000
ft:locale
en-US
Execute the following steps within the System DSN tab of the ODBC Data Source Administrator on the Perceptive Conten"Enable Quoted Identifiers" t application server(s).
Note: If you are running 32-bit and 64-bit agents on the same machine, you must configure the 32-bit and 64-bit ODBC datasources with the same name.
  1. Ensure the following options are checked/enabled in the Advanced tab of the Perceptive Content ODBC SQL Server Wire Protocol Driver.
    • "Enable Quoted Identifiers"
    • “AnsiNPW” (This should already be enabled by default)
  2. Restart the Perceptive Content services so that all database connections are re-established with these options enabled.