ODBC Error creating new datasource


 Product(s):ProjectWise Integration Server
 Version(s):08.11.11.574
 Area: Integration / Caching /Gateway
 Subarea: Installation
 Original Author:Molly Watts, Bentley Technical Support Group

Error or Warning Message

Error found in pwadmin.log

pwise.server - Error 241 "ODBC ERROR: 22007: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string." reported at func: dsqlOdbc_execDirect line: 1135

Explanation

User was not running a supported version of SQL Server, 2008 RTM instead of the required SQL 2008 R2

How to Avoid

  1. Verify the exact version of SQL server here

  2. Check the readme for the version of ProjectWise you have installed for the supported database versions

See Also

V8i Release Information