Error in connecting to database. Please contact your system administrator!!!

Sep 8, 2009 at 2:56 PM

Deployed to it's own site on Windows 2003 server and am getting the following error: Error in connecting to database. Please contact your system administrator!!!

Any ideas?

Sep 14, 2009 at 10:38 AM

Found the following in the log file, which is caused by the fact that I am trying to run it on x64 and there is no x64 implementation of JET (aka Access) - see http://social.msdn.microsoft.com/Forums/en-US/netfx64bit/thread/4ff1791f-3bc8-4716-a15a-356206d750ba

Any idea how to force it to be x86?

Log:

14 September 2009 11:49:16 AM
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
System.InvalidOperationException: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at wpMain.Page_Load(Object sender, EventArgs e)

   at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper)
   at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
   at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.OleDb.OleDbConnection.Open()
   at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at wpMain.Page_Load(Object sender, EventArgs e)

DB Connectivity Error
Connection String --> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|gal_db.mdb;
Evnironment User --> NETWORK SERVICE

Coordinator
Nov 2, 2009 at 7:18 AM

May be you are not getting connected to DB. Try reinstallting .net Framework and MS Office on your server. This will automatically install driver for MS ACCESS. Do let me know if problem persists.

 

Dec 11, 2009 at 11:23 PM

Dear All,

I met the same problem, "Error in connecting to database. Please contact your system administrator!!!" 
I tried to reinstall .net, reset iis & MS Office application but problem still exist.
I did not find log file on gal folder.

Please advice me..

Thanks, IEY

Dec 14, 2009 at 5:10 AM

Reinstalling will not help as the issue is the server OS is x64 and the software ONLY works on x86.

Coordinator
Dec 14, 2009 at 4:59 PM

@irwan_ey: logs can be found in C drive of your server...secondly DB Connectivity problem existed in previous version of GALMOD but in current version its been fixed. You check web.config in GAL folder and match its DB name with the MS Access DB found in APP_Data folder. I hope this helps...

Coordinator
Dec 14, 2009 at 5:02 PM

@rmaclean: true...it was deployed on x86 machine and was not tested o x64 machines. upcoming version is expected to support 64-bit machines as well.

Dec 15, 2009 at 5:03 AM

Halo sohaibahmad,
Thanks a lot for your advice. Currently the error can be solved. I just extract the file and follow the document on another IIS server. Restart IIS and WEB GAL running well. Again, thanks for everything posting here. 

 

Coordinator
Jan 7, 2010 at 6:07 AM

GALMOD uses MS Access for storing dropdown list values inside it. MS JET driver is required to connect to MS ACCESS DB which is not supported on 64-bit machines by Microsoft. GALMOD's upcoming version is going to remove this dependency and is going to shift on MS SQL Server DB or XML file. This version will be available within a week.