db load fails with U00037182 Unable to set row versioning
Article ID: 207417
Updated On:
Products
Issue/Introduction
First time running db load utility throws error:
U00037182 Unable to set row versioning for read-committed and snapshot transactions due to multiple database connections.
Cause
This can be caused by the ODBC connection pointing to the incorrect database or READ_COMMITTED_SNAPSHOT being off.
Resolution
Note the "DSN" entry in the SQLDRIVERCONNECT setting of ucsrv.ini
Open Windows utility - ODBC Data Source Administrator (64-bit)
Go to "System DSN" tab
Click on the corresponding ODBC connection and choose "Configure..."
Click Next from the first screen, enter user and password info on second screen and hit Next
Make sure that the third screen setting "Change the default database to:" has the correct database chosen.
Also have a DBA doublecheck that the database has READ_COMMITTED_SNAPSHOT on on the same database.
Feedback
