Hi Joe,
The record in the MP_SCHEMAVERSION was exactly as you specified (major, minor etc.). The ApplicationID string is also correctly.
I took a look at the currentlog.config file and it contains the below mentioned errors.
Is 'no sites found or couldn't connect to db' caused by the fact that it did not yet complete some process initiated by setup/default.aspx? Or does it mean it can't find the database?
I tried C:\mojoportal.fdb and also mojoportal (the defined alias), however no difference. My firebird dotnet provider works correctly, because I can connect to it/see al tables by an other .net tool making use of the firebird dotnet provider:
"data source=localhost;Database=C:\MOJOPORTAL.FDB;user id=SYSDBA;password=masterkey"
If the database connection isn't the problem maybe the 'Token unknown - line 1, char 76' tells something more?
Kind regards,
Bert
2007-08-02 20:04:34,671 [1432] ERROR mojoPortal.Web.Global [(null)] - no sites found or couldn't connect to db
2007-08-02 20:04:36,140 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:36,796 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,000 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,171 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,203 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,203 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,218 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,234 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,250 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,265 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,265 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,296 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,312 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,312 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,312 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,343 [1300] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()
2007-08-02 20:04:37,343 [1432] ERROR mojoPortal.Business.WebHelpers.CacheHelper [(null)] - Error trying to obtain siteSettings
FirebirdSql.Data.FirebirdClient.FbException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1 ---> Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 76
1
--- End of inner exception stack trace ---
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteReader(CommandBehavior behavior)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(FbConnection connection, FbTransaction transaction, CommandType commandType, String commandText, FbParameter[] commandParameters, FbConnectionOwnership connectionOwnership)
at mojoPortal.Data.FBSqlHelper.ExecuteReader(String connectionString, String commandText, FbParameter[] commandParameters)
at mojoPortal.Data.dbPortal.SiteSettings_GetSite(String HostName)
at mojoPortal.Business.SiteSettings..ctor(String hostName)
at mojoPortal.Business.WebHelpers.CacheHelper.LoadSiteSettings()