467,167 Members | 969 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,167 developers. It's quick & easy.

Unspecified error when trying to Fill oleDB Dataset from MS Access

I'm using a third party hosting service. I presently have a Web Service on
this hosting service's server that loads and executes a native mode DLL.
This demonstrates that the hosting service has given me proper access to the
temporary directory c:/Windows/Microsoft.NET/Framework/V1.1.4322/Temporary
ASP.NET Files/root/...."

I believe it also demonstrates that I have access to c:/documents and
settings/xyz/aspnet/local settings/

Recently I have created a new project in the same account in a different sub
directory on the same hosting service -- same server.
I have my web.config file configured to impersonate me.

My ASP.NET application works on my development machine. However I'm getting
the following when I create a new project on my hosting service's machine.
This is happening in response to the fill method of my dataset. When I
remove that it works (but of course I see no data)!

I know I have my Microsoft Access Data file positioned correctly because I
see a different error message when I remove the impersonation from my
web.config. It provides the full path of my mdb file and tells me I don't
have access to it.

What could this be? With this error message, it is kinda difficult to google
for it. I used FTP copy my MDB file to the directory where my ASP.NET source
code is.

Thanks,
Siegfried

Unspecified error
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
keyword_job_search.JobSearchResults.Page_Load(Obje ct sender, EventArgs e)
in c:\documents and
settings\administrator\vswebcache\www.heintze.com\keyword-job-search\keyword
-job-search.aspx.cs:29
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

Nov 19 '05 #1
  • viewed: 2939
Share:
1 Reply
Hi,

Check out whether this is the issue:
http://msmvps.com/rakeshrajan/archiv.../04/56461.aspx

--
HTH,
Rakesh Rajan
MVP, MCSD
http://www.msmvps.com/rakeshrajan/

"Siegfried Heintze" wrote:
I'm using a third party hosting service. I presently have a Web Service on
this hosting service's server that loads and executes a native mode DLL.
This demonstrates that the hosting service has given me proper access to the
temporary directory c:/Windows/Microsoft.NET/Framework/V1.1.4322/Temporary
ASP.NET Files/root/...."

I believe it also demonstrates that I have access to c:/documents and
settings/xyz/aspnet/local settings/

Recently I have created a new project in the same account in a different sub
directory on the same hosting service -- same server.
I have my web.config file configured to impersonate me.

My ASP.NET application works on my development machine. However I'm getting
the following when I create a new project on my hosting service's machine.
This is happening in response to the fill method of my dataset. When I
remove that it works (but of course I see no data)!

I know I have my Microsoft Access Data file positioned correctly because I
see a different error message when I remove the impersonation from my
web.config. It provides the full path of my mdb file and tells me I don't
have access to it.

What could this be? With this error message, it is kinda difficult to google
for it. I used FTP copy my MDB file to the directory where my ASP.NET source
code is.

Thanks,
Siegfried

Unspecified error
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unspecified error

Source Error:

An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80004005): Unspecified error]
System.Data.OleDb.OleDbConnection.ProcessResults(I nt32 hr) +20
System.Data.OleDb.OleDbConnection.InitializeProvid er() +57
System.Data.OleDb.OleDbConnection.Open() +203
System.Data.Common.DbDataAdapter.QuietOpen(IDbConn ection connection,
ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
keyword_job_search.JobSearchResults.Page_Load(Obje ct sender, EventArgs e)
in c:\documents and
settings\administrator\vswebcache\www.heintze.com\keyword-job-search\keyword
-job-search.aspx.cs:29
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Troy | last post: by
7 posts views Thread by Jim McGivney | last post: by
reply views Thread by Siegfried Heintze | last post: by
5 posts views Thread by Omer | last post: by
2 posts views Thread by slinky | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.