Applies To
	Product(s):	AutoPLANT Piping
	Version(s):	08.11.09.140
	Environment:	Windows 7 64 bit
	Area:	General
	Subarea:
	Original Author:	Artiom Jakubovic, Bentley Technical Support Group

 

Problem Description

Upon ruining AutoPlant Project Administrator the following error message is shown:
Error opening RecordSet with SQL Select * from AT_PROJ

Possible reason of this are missing SQLite OBDC Drivers x86

Steps to Resolve

Firs of all check is if SQLite is installed. Go to Control Panel open Programs and Features and search for :

SQLite ODBC Driver (remove only) and SQLite ODBC Driver for win64 (remove only)

If one of drivers are missing install required driver from C:\BentleyDownloads\appd081109140en\SQLITE3_ODBC (this is default location where AutoPlant installation files are unpacked while ruining appd081109140en.exe)

In case both SQLite ODBC drivers are installed and still error is shown, uninstall both drivers and install them back using Local Administrator account. 

After installation check ODBC Data Source for 64bit and 32bit