I'm using EnviroInsite to connect to my EQuIS database. When I tried exporting to an Access database from EnviroInsite using the Generate Access report I get the following error.
dt_db.OpenConnection
The ConnectionString property has not been initialized.
at System.Data.Odbc.OdbcConnection.PermissionDemand()
at System.Data.Odbc.OdbcConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
If you're using MS Access 2013 then you'll need to install the MS Access 2010 Redistributable. You can get it from www.microsoft.com/en-us/download/details.aspx. This occurs because Access 2013 is not installed on your computer and EnviroInsite cannot find the Access program files that it relies on to work with Access databases.