Can't Open Database from WebService

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 said:
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
Click to expand...
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Are you running on Windows 2003 perhaps?

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

DimX said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Windows XP

Miha Markic said:
Are you running on Windows 2003 perhaps?

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

DimX said:
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 said:
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

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top