We hit this error about 2 weeks ago on SQL Server and it seems to be getting worse. We have a table that stores phone numbers wtns. We have a number of pages that query this table. I can sit and click a link that queries this table over and over and finally after about clicks, it will fail and repeatedly fail for about a minute with: Microsoft OLE DB Provider for ODBC Drivers error ''Unspecified error If our system is busy, I can get to the error much quicker. The strange thing is this table and these pages have not been modified, some of them haven't been touched in years so these queries worked just fine for that long until Dec 4th when the problems started nothing significant happened that day or prior to that either.
The stmt looks as expected and I can even run it manually and it works fine. Then I see a series of audit login audit logout pairs in the profiler but nothing else, where I would expect to see more Queries from that page on other tables. If I go to any of the 5 pages or so that has a similar query to this table, I can get the same error. No other table in our DB causes this problem.
Any ideas where to look? We've done alot recently to try and fix it: Reinstalled MDAC, reinstalled SQL Server SP, increased memory, shrunk the trans log, reindexed the table, changed the cursor around made it readonly as it initally wasn't , modified permissions.
Nothing seems to work. What to try? I have a DTS to transfer logins from one server to a another server. I have put the syslogins. Any help would be appreciated. Hi Everybody, Iam a sql server developer,iam on a migration project,iam encountering an error when iam editing the control flow task.
Thanks and Regards, sg. We have a system that has been running for years and some of the. The statement will execute 5x, then fail once, then run 2 more times and fail again. There isn't a problem with the SQL itself as the same Select stmt will fail or pass randomly. I can also take and execute the stmt manually and it will also pass. There are about 5 places it occurs in our pages. Here is on particular example.
I've haven't been able to find anything conclusive in the SQL Profiler either. Any ideas? Is this the correct version of MDAC? I tried to get the latest, but it was an earlier version. I can write to a certain table the only one which has a problem many times on the first run of the app since the database was created. However if I exit and reload the app, the error starts hapenning.
It does not go away until I delete the database and re-create it. The database has a password I've tried with and without this to no avail and the temp file is being stored on the Storage Card the PDA itself doesn't have enough memory. I have been extensively searching the net for existing solutions. This sounds reasonable and similair to my case.
I would like to change my code so it is not coming out of suspend mode instead of trying to find that hotfix but I don't know what suspend mode is. The code is being called from a button's handler. This sounds like it is coming out of suspend mode, doesn't it?
Has anyone else seen this? It has brought my project to a grinding halt and I can not see anything wrong with my code it's doing the same insert command I've done a million times before on other tables. Thanks in advance for any help! Hi, I tried to confiure sql reporting service on vista box but I got the following page. Request is not available in this context 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. HttpException: Request is not available in this context 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. I am sure I configure everything right under "Default Web Site". The same config is running perfectly under XP. Can anyone help please? Then I use a Data Flow task to copy the tables from one server to the other. Search related threads. Remove From My Forums. Asked by:. Archived Forums. Do not post in this forum Sign in to vote.
If we do IIS reset, it will start working again In many of the articles, it has been told that this is the common error we are getting if we are using Microsoft Jet OLEDb Request you to provide some guidance to move ahead on this issue I have checked permissions on various temp folders that JET supposedly uses, and permissions are fine.
Friday, August 20, AM. NET app. I've been able to work with Excel tasks fine one time after a reboot, then another time its all failing as I described. I encountered a similar issue, and the resolution was two-fold for me.
First, make sure certain dlls are properly registered on your dev machine:. If they are, please manually register them. Run each of the following commands from command prompt:. I kept changing the Excel Connection Manager object to point to the correct file, but the change would never "stick.
Right-click anywhere in the package designer and choose "Variables" based on the version. In the list of variables, check if there are any paths that are being used. If you find any, verify that they exist on your machine or change them to use your own local paths. After following these two suggestions, I was able to open the Excel file and choose the target sheet in the Excel Connection Manager window.
And, the SSIS package runs successfully in my local environment. I take it the path to the excel workbook is correct?
I also had problems when I had opened and saved the excel workbook I was using as my destination in excel. I think if you create the workbook from within SSIS it might use office web tools. Perhaps you could try to recreate the workbook within SSIS. Otherwise add Microsoft. And also check if you have Microsoft excel present in your server again not on your local machine.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
0コメント