ASP.NET 2.0.50727.0

Hey can anyone help me - with my ISS. 6.0 with sql2005 and framework 2.0
I get this failure..

-- Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 20-12-2005
Time: 08:06:35
User: N/A
Computer: SCANFAKT
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 12/20/2005 8:06:35 AM
Event time (UTC): 12/20/2005 7:06:35 AM
Event ID: bc3fe26846134ede8a0f565efc92f677
Event sequence: 23
Event occurrence: 6
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1/ROOT-1-127795349069243641
Trust level: Full
Application Virtual Path: /
Application Path: c:\inetpub\wwwroot\
Machine name: SCANFAKT

Process information:
Process ID: 2380
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: OdbcException
Exception message: ERROR [42S00] [Microsoft Business Solutions
ApS][Microsoft Business Solutions-Navision ODBC Driver]Table does not exists

Request information:
Request URL: http://localhost/BonnierNavisionTestPage.aspx
Request path: /BonnierNavisionTestPage.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode
retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
behavior, String method, Boolean needReader, Object[] methodArguments,
SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Odbc.OdbcCommand.ExecuteReader()
at ASP.bonniernavisiontestpage_aspx.InitializeTable()
at ASP.bonniernavisiontestpage_aspx.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Obje ct sender,
EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

..

Re: ASP.NET 2.0.50727.0

In this page:
http://localhost/BonnierNavisionTestPage.aspx
you have some ADO.NET code that is attempting to query a database, and the
driver is reporting: Table does not exists

So verify that you are querying a table that exists in a schema that exists.

Cheers
Ken

"DKjean" wrote in message
news:9B73317F-0C04-4BAB-869C-631B5679EA9D@microsoft.com...
: Hey can anyone help me - with my ISS. 6.0 with sql2005 and framework 2.0
: I get this failure..
:
: -- Event Type: Warning
: Event Source: ASP.NET 2.0.50727.0
: Event Category: Web Event
: Event ID: 1309
: Date: 20-12-2005
: Time: 08:06:35
: User: N/A
: Computer: SCANFAKT
: Description:
: Event code: 3005
: Event message: An unhandled exception has occurred.
: Event time: 12/20/2005 8:06:35 AM
: Event time (UTC): 12/20/2005 7:06:35 AM
: Event ID: bc3fe26846134ede8a0f565efc92f677
: Event sequence: 23
: Event occurrence: 6
: Event detail code: 0
:
: Application information:
: Application domain: /LM/W3SVC/1/ROOT-1-127795349069243641
: Trust level: Full
: Application Virtual Path: /
: Application Path: c:\inetpub\wwwroot\
: Machine name: SCANFAKT
:
: Process information:
: Process ID: 2380
: Process name: w3wp.exe
: Account name: NT AUTHORITY\NETWORK SERVICE
:
: Exception information:
: Exception type: OdbcException
: Exception message: ERROR [42S00] [Microsoft Business Solutions
: ApS][Microsoft Business Solutions-Navision ODBC Driver]Table does not
exists
:
: Request information:
: Request URL: http://localhost/BonnierNavisionTestPage.aspx
: Request path: /BonnierNavisionTestPage.aspx
: User host address: 127.0.0.1
: User:
: Is authenticated: False
: Authentication Type:
: Thread account name: NT AUTHORITY\NETWORK SERVICE
:
: Thread information:
: Thread ID: 1
: Thread account name: NT AUTHORITY\NETWORK SERVICE
: Is impersonating: False
: Stack trace: at
: System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode
: retcode)
: at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
: behavior, String method, Boolean needReader, Object[] methodArguments,
: SQL_API odbcApiMethod)
: at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
: behavior, String method, Boolean needReader)
: at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
: at System.Data.Odbc.OdbcCommand.ExecuteReader()
: at ASP.bonniernavisiontestpage_aspx.InitializeTable()
: at ASP.bonniernavisiontestpage_aspx.Page_Load(Object sender, EventArgs
e)
: at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
: o, Object t, EventArgs e)
: at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Obje ct
sender,
: EventArgs e)
: at System.Web.UI.Control.OnLoad(EventArgs e)
: at System.Web.UI.Control.LoadRecursive()
: at System.Web.UI.Page.ProcessRequestMain(Boolean
: includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
:
:
: Custom event details:
:
: For more information, see Help and Support Center at
: http://go.microsoft.com/fwlink/events.asp.
:
: .

Re: ASP.NET 2.0.50727.0

Yes thanks I know - but when I try ti Access from Excel to this database it
works fine. But not from my ISS - Can you help me - my sever is windows 2003
with sp1.
--
..


"Ken Schaefer" wrote:

> In this page:
> http://localhost/BonnierNavisionTestPage.aspx
> you have some ADO.NET code that is attempting to query a database, and the
> driver is reporting: Table does not exists
>
> So verify that you are querying a table that exists in a schema that exists.
>
> Cheers
> Ken
>
> "DKjean" wrote in message
> news:9B73317F-0C04-4BAB-869C-631B5679EA9D@microsoft.com...
> : Hey can anyone help me - with my ISS. 6.0 with sql2005 and framework 2.0
> : I get this failure..
> :
> : -- Event Type: Warning
> : Event Source: ASP.NET 2.0.50727.0
> : Event Category: Web Event
> : Event ID: 1309
> : Date: 20-12-2005
> : Time: 08:06:35
> : User: N/A
> : Computer: SCANFAKT
> : Description:
> : Event code: 3005
> : Event message: An unhandled exception has occurred.
> : Event time: 12/20/2005 8:06:35 AM
> : Event time (UTC): 12/20/2005 7:06:35 AM
> : Event ID: bc3fe26846134ede8a0f565efc92f677
> : Event sequence: 23
> : Event occurrence: 6
> : Event detail code: 0
> :
> : Application information:
> : Application domain: /LM/W3SVC/1/ROOT-1-127795349069243641
> : Trust level: Full
> : Application Virtual Path: /
> : Application Path: c:\inetpub\wwwroot\
> : Machine name: SCANFAKT
> :
> : Process information:
> : Process ID: 2380
> : Process name: w3wp.exe
> : Account name: NT AUTHORITY\NETWORK SERVICE
> :
> : Exception information:
> : Exception type: OdbcException
> : Exception message: ERROR [42S00] [Microsoft Business Solutions
> : ApS][Microsoft Business Solutions-Navision ODBC Driver]Table does not
> exists
> :
> : Request information:
> : Request URL: http://localhost/BonnierNavisionTestPage.aspx
> : Request path: /BonnierNavisionTestPage.aspx
> : User host address: 127.0.0.1
> : User:
> : Is authenticated: False
> : Authentication Type:
> : Thread account name: NT AUTHORITY\NETWORK SERVICE
> :
> : Thread information:
> : Thread ID: 1
> : Thread account name: NT AUTHORITY\NETWORK SERVICE
> : Is impersonating: False
> : Stack trace: at
> : System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode
> : retcode)
> : at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
> : behavior, String method, Boolean needReader, Object[] methodArguments,
> : SQL_API odbcApiMethod)
> : at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
> : behavior, String method, Boolean needReader)
> : at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior)
> : at System.Data.Odbc.OdbcCommand.ExecuteReader()
> : at ASP.bonniernavisiontestpage_aspx.InitializeTable()
> : at ASP.bonniernavisiontestpage_aspx.Page_Load(Object sender, EventArgs
> e)
> : at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
> : o, Object t, EventArgs e)
> : at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Obje ct
> sender,
> : EventArgs e)
> : at System.Web.UI.Control.OnLoad(EventArgs e)
> : at System.Web.UI.Control.LoadRecursive()
> : at System.Web.UI.Page.ProcessRequestMain(Boolean
> : includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> :
> :
> : Custom event details:
> :
> : For more information, see Help and Support Center at
> : http://go.microsoft.com/fwlink/events.asp.
> :
> : .
>
>
>

Re: ASP.NET 2.0.50727.0

Perhaps your ASP.NET page is running under a different user context to your
copy of Excel (By default ASP.NET pages on IIS6 run under the "Network
Service" account). Have you given Network Service permissions to the schema?

Cheers
Ken


"DKjean" wrote in message
news:129128A8-B359-4731-A86F-3B665D706F6E@microsoft.com...
: Yes thanks I know - but when I try ti Access from Excel to this database
it
: works fine. But not from my ISS - Can you help me - my sever is windows
2003
: with sp1.
: --
: .
:
:
: "Ken Schaefer" wrote:
:
: > In this page:
: > http://localhost/BonnierNavisionTestPage.aspx
: > you have some ADO.NET code that is attempting to query a database, and
the
: > driver is reporting: Table does not exists
: >
: > So verify that you are querying a table that exists in a schema that
exists.
: >
: > Cheers
: > Ken
: >
: > "DKjean" wrote in message
: > news:9B73317F-0C04-4BAB-869C-631B5679EA9D@microsoft.com...
: > : Hey can anyone help me - with my ISS. 6.0 with sql2005 and framework
2.0
: > : I get this failure..
: > :
: > : -- Event Type: Warning
: > : Event Source: ASP.NET 2.0.50727.0
: > : Event Category: Web Event
: > : Event ID: 1309
: > : Date: 20-12-2005
: > : Time: 08:06:35
: > : User: N/A
: > : Computer: SCANFAKT
: > : Description:
: > : Event code: 3005
: > : Event message: An unhandled exception has occurred.
: > : Event time: 12/20/2005 8:06:35 AM
: > : Event time (UTC): 12/20/2005 7:06:35 AM
: > : Event ID: bc3fe26846134ede8a0f565efc92f677
: > : Event sequence: 23
: > : Event occurrence: 6
: > : Event detail code: 0
: > :
: > : Application information:
: > : Application domain: /LM/W3SVC/1/ROOT-1-127795349069243641
: > : Trust level: Full
: > : Application Virtual Path: /
: > : Application Path: c:\inetpub\wwwroot\
: > : Machine name: SCANFAKT
: > :
: > : Process information:
: > : Process ID: 2380
: > : Process name: w3wp.exe
: > : Account name: NT AUTHORITY\NETWORK SERVICE
: > :
: > : Exception information:
: > : Exception type: OdbcException
: > : Exception message: ERROR [42S00] [Microsoft Business Solutions
: > : ApS][Microsoft Business Solutions-Navision ODBC Driver]Table does not
: > exists
: > :
: > : Request information:
: > : Request URL: http://localhost/BonnierNavisionTestPage.aspx
: > : Request path: /BonnierNavisionTestPage.aspx
: > : User host address: 127.0.0.1
: > : User:
: > : Is authenticated: False
: > : Authentication Type:
: > : Thread account name: NT AUTHORITY\NETWORK SERVICE
: > :
: > : Thread information:
: > : Thread ID: 1
: > : Thread account name: NT AUTHORITY\NETWORK SERVICE
: > : Is impersonating: False
: > : Stack trace: at
: > : System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle,
RetCode
: > : retcode)
: > : at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
: > : behavior, String method, Boolean needReader, Object[] methodArguments,
: > : SQL_API odbcApiMethod)
: > : at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBeha vior
: > : behavior, String method, Boolean needReader)
: > : at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior
behavior)
: > : at System.Data.Odbc.OdbcCommand.ExecuteReader()
: > : at ASP.bonniernavisiontestpage_aspx.InitializeTable()
: > : at ASP.bonniernavisiontestpage_aspx.Page_Load(Object sender,
EventArgs
: > e)
: > : at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object
: > : o, Object t, EventArgs e)
: > : at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Obje ct
: > sender,
: > : EventArgs e)
: > : at System.Web.UI.Control.OnLoad(EventArgs e)
: > : at System.Web.UI.Control.LoadRecursive()
: > : at System.Web.UI.Page.ProcessRequestMain(Boolean
: > : includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
: > :
: > :
: > : Custom event details:
: > :
: > : For more information, see Help and Support Center at
: > : http://go.microsoft.com/fwlink/events.asp.
: > :
: > : .
: >
: >
: >