I used ServerConsole.exe as a WCF host. I think that i should not have NAT issues, as i have implemented at least 5 WCF services and deployed them behind a firewall with no problems. I can only understand that, although ServerConsole.exe is a normal WCF host, it is governed by rules that
deny NAT access. I asked
why this happens. I only used it for testing purposes.
Then started ServerConsole.exe and used a port scanner to test if port 9009 "goes through", and it did...
To go further, i tried the tutorial for IIS (WCF IIS deployment) and on my machine everything was perfect.
When i deployed at another IIS (either in the local network or the Internet), i cannot login.
http://IP_Address/WcfQuickAppCS/TestAsa.aspx displays correctly.
Here is the error, any ideas?:
Thank you!
2008-03-06 |
17:21:55 |
|
IdeaBlade.Persistence.Rdb |
RdbQuerySqlFormatter::Fetch |
RdbKey: [default] Sql: select * from "dbo"."User" where ((1 = 0)) |
2008-03-06 |
17:21:55 |
|
IdeaBlade.Persistence.Server |
PersistenceServer::Fetch |
System.Data.OleDb.OleDbException: Invalid object name 'dbo.User'. at
System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr) at
System.Data.OleDb.OleDbDataReader.NextResult() at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior,
String method) at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior
behavior) at
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior) 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
IdeaBlade.Persistence.Rdb.RdbQuerySqlFormatter.Fetch(Type pEntityType, DataSet
pDataSet, IDbSelectCommandBuilder pDbCommandBuilder) at
IdeaBlade.Persistence.Rdb.RdbQuerySqlFormatter.Fetch(Type pEntityType, DataSet
pDataSet, ParameterizedSql pParamSql, Int32 pCommandTimeout) at
IdeaBlade.Persistence.Rdb.RdbQuery.Fetch(DataSet pDataSet, IDataSourceKey
pDataSourceKey) at
IdeaBlade.Persistence.Server.PersistenceServer.Fetch(IEntityQuery pQuery,
DataSet pDataSet, IDataSourceKey pDsKey) at
IdeaBlade.Persistence.Server.PersistenceServer.Fetch(SessionBundle
pSessionBundle, IEntityQuery pEntityQuery) |