Can't Open Database from WebService

I have a project consisting of a Web application and a Web service. The Web
application calls the Web service to do some modifications in a database (
Microsoft Access ) When the OleDbConnection.Open function is called I receive
the followin message:

[SoapException: System.Web.Services.Protocols.SoapException: Server was
unable to process request. ---> System.Data.OleDb.OleDbException: Unspecified
error
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at NED.CablesDBUpdate.DeleteRow(DataSetNewCables dsNewCables) in
c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 258
at NED.CablesDBUpdate.DBHandler(DBActions Action, DataSetNewCables
dsNewCables) in c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 224
at NED.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables) in
c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 177
--- End of inner exception stack trace ---]

System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
NED.NEDService.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables)
in C:\Inetpub\wwwroot\NED\Web References\NEDService\Reference.cs:80
NED.PNG.QueryFrm.grdNewCables_DeleteCommand(Object source,
DataGridCommandEventArgs e) in C:\Inetpub\wwwroot\NED\PNG\QueryFrm.aspx.cs:948

System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs e)
System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs
e)
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source,
EventArgs e)
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()

The same behavior when I try to open a SQL database. When I call the same
function from the Web application everything works!!!!

Has anyone any idea what it may be wrong?

Thanks in advance for your help


--
DimX

Miha
Tue Dec 07 02:08:50 CST 2004

Assign NTFS privileges to aspnet local windows account on mdb file and its
folder (assuming windows xp)

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"DimX" <DimX@discussions.microsoft.com> wrote in message
news:436E8301-8A23-4922-A350-8F144EA5F433@microsoft.com...
>I have a project consisting of a Web application and a Web service. The Web
> application calls the Web service to do some modifications in a database (
> Microsoft Access ) When the OleDbConnection.Open function is called I
> receive
> the followin message:
>
> [SoapException: System.Web.Services.Protocols.SoapException: Server was
> unable to process request. ---> System.Data.OleDb.OleDbException:
> Unspecified
> error
> at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
> at System.Data.OleDb.OleDbConnection.InitializeProvider()
> at System.Data.OleDb.OleDbConnection.Open()
> at NED.CablesDBUpdate.DeleteRow(DataSetNewCables dsNewCables) in
> c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 258
> at NED.CablesDBUpdate.DBHandler(DBActions Action, DataSetNewCables
> dsNewCables) in c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line
> 224
> at NED.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables) in
> c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 177
> --- End of inner exception stack trace ---]
>
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> NED.NEDService.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables)
> in C:\Inetpub\wwwroot\NED\Web References\NEDService\Reference.cs:80
> NED.PNG.QueryFrm.grdNewCables_DeleteCommand(Object source,
> DataGridCommandEventArgs e) in
> C:\Inetpub\wwwroot\NED\PNG\QueryFrm.aspx.cs:948
>
> System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs
> e)
> System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source,
> EventArgs
> e)
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source,
> EventArgs e)
> System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
>
> System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> eventArgument)
> System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> sourceControl, String eventArgument)
> System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> System.Web.UI.Page.ProcessRequestMain()
>
> The same behavior when I try to open a SQL database. When I call the same
> function from the Web application everything works!!!!
>
> Has anyone any idea what it may be wrong?
>
> Thanks in advance for your help
>
>
> --
> DimX

DimX
Tue Dec 07 09:25:09 CST 2004

Hi Miha.
Thanks for your reply. What do you mean with NTFS previleges ? I have
assigned full previliges to the ASP.NET account to the specific file and
directory and it doesn't work. Have I to do something more ?

"Miha Markic [MVP C#]" wrote:

> Assign NTFS privileges to aspnet local windows account on mdb file and its
> folder (assuming windows xp)
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> SLODUG - Slovene Developer Users Group
> www.rthand.com
>
> "DimX" <DimX@discussions.microsoft.com> wrote in message
> news:436E8301-8A23-4922-A350-8F144EA5F433@microsoft.com...
> >I have a project consisting of a Web application and a Web service. The Web
> > application calls the Web service to do some modifications in a database (
> > Microsoft Access ) When the OleDbConnection.Open function is called I
> > receive
> > the followin message:
> >
> > [SoapException: System.Web.Services.Protocols.SoapException: Server was
> > unable to process request. ---> System.Data.OleDb.OleDbException:
> > Unspecified
> > error
> > at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
> > at System.Data.OleDb.OleDbConnection.InitializeProvider()
> > at System.Data.OleDb.OleDbConnection.Open()
> > at NED.CablesDBUpdate.DeleteRow(DataSetNewCables dsNewCables) in
> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 258
> > at NED.CablesDBUpdate.DBHandler(DBActions Action, DataSetNewCables
> > dsNewCables) in c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line
> > 224
> > at NED.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables) in
> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 177
> > --- End of inner exception stack trace ---]
> >
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters)
> > NED.NEDService.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables)
> > in C:\Inetpub\wwwroot\NED\Web References\NEDService\Reference.cs:80
> > NED.PNG.QueryFrm.grdNewCables_DeleteCommand(Object source,
> > DataGridCommandEventArgs e) in
> > C:\Inetpub\wwwroot\NED\PNG\QueryFrm.aspx.cs:948
> >
> > System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs
> > e)
> > System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source,
> > EventArgs
> > e)
> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> > System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source,
> > EventArgs e)
> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> > System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
> >
> > System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> > eventArgument)
> > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> > sourceControl, String eventArgument)
> > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> > System.Web.UI.Page.ProcessRequestMain()
> >
> > The same behavior when I try to open a SQL database. When I call the same
> > function from the Web application everything works!!!!
> >
> > Has anyone any idea what it may be wrong?
> >
> > Thanks in advance for your help
> >
> >
> > --
> > DimX
>
>
>

Miha
Tue Dec 07 13:47:53 CST 2004

Are you running on Windows 2003 perhaps?

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
SLODUG - Slovene Developer Users Group
www.rthand.com

"DimX" <DimX@discussions.microsoft.com> wrote in message
news:5DC4CA6A-9A64-487F-8C0D-C3150687D35D@microsoft.com...
> Hi Miha.
> Thanks for your reply. What do you mean with NTFS previleges ? I have
> assigned full previliges to the ASP.NET account to the specific file and
> directory and it doesn't work. Have I to do something more ?
>
> "Miha Markic [MVP C#]" wrote:
>
>> Assign NTFS privileges to aspnet local windows account on mdb file and
>> its
>> folder (assuming windows xp)
>>
>> --
>> Miha Markic [MVP C#] - RightHand .NET consulting & development
>> SLODUG - Slovene Developer Users Group
>> www.rthand.com
>>
>> "DimX" <DimX@discussions.microsoft.com> wrote in message
>> news:436E8301-8A23-4922-A350-8F144EA5F433@microsoft.com...
>> >I have a project consisting of a Web application and a Web service. The
>> >Web
>> > application calls the Web service to do some modifications in a
>> > database (
>> > Microsoft Access ) When the OleDbConnection.Open function is called I
>> > receive
>> > the followin message:
>> >
>> > [SoapException: System.Web.Services.Protocols.SoapException: Server was
>> > unable to process request. ---> System.Data.OleDb.OleDbException:
>> > Unspecified
>> > error
>> > at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
>> > at System.Data.OleDb.OleDbConnection.InitializeProvider()
>> > at System.Data.OleDb.OleDbConnection.Open()
>> > at NED.CablesDBUpdate.DeleteRow(DataSetNewCables dsNewCables) in
>> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 258
>> > at NED.CablesDBUpdate.DBHandler(DBActions Action, DataSetNewCables
>> > dsNewCables) in
>> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line
>> > 224
>> > at NED.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables) in
>> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 177
>> > --- End of inner exception stack trace ---]
>> >
>> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
>> > message, WebResponse response, Stream responseStream, Boolean
>> > asyncCall)
>> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
>> > methodName, Object[] parameters)
>> > NED.NEDService.CablesDBUpdate.DeleteCable(DataSetNewCables
>> > dsNewCables)
>> > in C:\Inetpub\wwwroot\NED\Web References\NEDService\Reference.cs:80
>> > NED.PNG.QueryFrm.grdNewCables_DeleteCommand(Object source,
>> > DataGridCommandEventArgs e) in
>> > C:\Inetpub\wwwroot\NED\PNG\QueryFrm.aspx.cs:948
>> >
>> > System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs
>> > e)
>> > System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source,
>> > EventArgs
>> > e)
>> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
>> > System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source,
>> > EventArgs e)
>> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
>> > System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
>> >
>> > System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
>> > eventArgument)
>> > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
>> > sourceControl, String eventArgument)
>> > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
>> > System.Web.UI.Page.ProcessRequestMain()
>> >
>> > The same behavior when I try to open a SQL database. When I call the
>> > same
>> > function from the Web application everything works!!!!
>> >
>> > Has anyone any idea what it may be wrong?
>> >
>> > Thanks in advance for your help
>> >
>> >
>> > --
>> > DimX
>>
>>
>>

DimX
Wed Dec 08 03:19:01 CST 2004

Windows XP

"Miha Markic [MVP C#]" wrote:

> Are you running on Windows 2003 perhaps?
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> SLODUG - Slovene Developer Users Group
> www.rthand.com
>
> "DimX" <DimX@discussions.microsoft.com> wrote in message
> news:5DC4CA6A-9A64-487F-8C0D-C3150687D35D@microsoft.com...
> > Hi Miha.
> > Thanks for your reply. What do you mean with NTFS previleges ? I have
> > assigned full previliges to the ASP.NET account to the specific file and
> > directory and it doesn't work. Have I to do something more ?
> >
> > "Miha Markic [MVP C#]" wrote:
> >
> >> Assign NTFS privileges to aspnet local windows account on mdb file and
> >> its
> >> folder (assuming windows xp)
> >>
> >> --
> >> Miha Markic [MVP C#] - RightHand .NET consulting & development
> >> SLODUG - Slovene Developer Users Group
> >> www.rthand.com
> >>
> >> "DimX" <DimX@discussions.microsoft.com> wrote in message
> >> news:436E8301-8A23-4922-A350-8F144EA5F433@microsoft.com...
> >> >I have a project consisting of a Web application and a Web service. The
> >> >Web
> >> > application calls the Web service to do some modifications in a
> >> > database (
> >> > Microsoft Access ) When the OleDbConnection.Open function is called I
> >> > receive
> >> > the followin message:
> >> >
> >> > [SoapException: System.Web.Services.Protocols.SoapException: Server was
> >> > unable to process request. ---> System.Data.OleDb.OleDbException:
> >> > Unspecified
> >> > error
> >> > at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
> >> > at System.Data.OleDb.OleDbConnection.InitializeProvider()
> >> > at System.Data.OleDb.OleDbConnection.Open()
> >> > at NED.CablesDBUpdate.DeleteRow(DataSetNewCables dsNewCables) in
> >> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 258
> >> > at NED.CablesDBUpdate.DBHandler(DBActions Action, DataSetNewCables
> >> > dsNewCables) in
> >> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line
> >> > 224
> >> > at NED.CablesDBUpdate.DeleteCable(DataSetNewCables dsNewCables) in
> >> > c:\inetpub\wwwroot\nedservice\cablesdbupdate.asmx.cs:line 177
> >> > --- End of inner exception stack trace ---]
> >> >
> >> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> >> > message, WebResponse response, Stream responseStream, Boolean
> >> > asyncCall)
> >> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> >> > methodName, Object[] parameters)
> >> > NED.NEDService.CablesDBUpdate.DeleteCable(DataSetNewCables
> >> > dsNewCables)
> >> > in C:\Inetpub\wwwroot\NED\Web References\NEDService\Reference.cs:80
> >> > NED.PNG.QueryFrm.grdNewCables_DeleteCommand(Object source,
> >> > DataGridCommandEventArgs e) in
> >> > C:\Inetpub\wwwroot\NED\PNG\QueryFrm.aspx.cs:948
> >> >
> >> > System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs
> >> > e)
> >> > System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source,
> >> > EventArgs
> >> > e)
> >> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> >> > System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source,
> >> > EventArgs e)
> >> > System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
> >> > System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
> >> >
> >> > System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
> >> > eventArgument)
> >> > System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
> >> > sourceControl, String eventArgument)
> >> > System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
> >> > System.Web.UI.Page.ProcessRequestMain()
> >> >
> >> > The same behavior when I try to open a SQL database. When I call the
> >> > same
> >> > function from the Web application everything works!!!!
> >> >
> >> > Has anyone any idea what it may be wrong?
> >> >
> >> > Thanks in advance for your help
> >> >
> >> >
> >> > --
> >> > DimX
> >>
> >>
> >>
>
>
>