The Data Provider Or Other Service Returned An E_FAIL Status!?!?! WT-???

Oct 24, 2006

I'm running sql server ver 7.0 SP4.

I have an access project (.adp) that runs a view which is nothing more
than a select statement. Access locks up solid when I try to run this
query - with NO error messages what-so-ever.

If I sign onto the server, and run the view from enterprise manager - I
get:
"the data provider or other service returned an E_FAIL status" !?!?!
There is NO ERROR number, or further explanation of the message!!

Now - this query DID work last week - all of a sudden I get this error
- I've:
1) repaired / compacted this database
2) rebooted the server
3) spent several hours searching websites & groups for an explanation
a) I don't care how useless some people think enterprise manager is -
at least it gave me SOME kind of error; where access just locks up!
b) There are no issues with null values, or problem date fields
anywhere in these tables.
4) tried MANY variations on the query, and am now more confused than
ever.
5) I've RUN THIS QUERY IN AN ACCESS MDB WITH LINKS TO THE SQL SERVER -
AND IT WORKS!?!?!?!?

The query I'm using follows; if I remove ONE field from the select
statement - this query RUNS!!!
It doesn't matter what field I remove! It's as if, I can only have so
many fields in the select statement!?!?!?
This is clearly ridiculous since the query ran fine last week with the
same number of fields, not that
that should have anything to do with this, as sql shouldn't care how
many fields I request.
I'm not actually requesting any fields in the last table - but if I
remove this table it works!? If I leave this table, and select fields
from it, but remove another table - again it works!

So my questions:
1) What [T-] is going on here?
2) Why would an mdb be able to run a query that an adp can not!?!?
3) When will microsoft ever release a product that provides useful
error messages?

I really don't expect an answer to #3, because I know the answer is
NEVER - microsoft doesn't want to make solving problems easy.

Here's the query I'm using:

SELECT codes.proj_id, answers.report_date,
answers.release_date, answers.notes,
answers.answer_date, answers.answer_person,
answers.answer, answers.answer_status,
answers.answer_person2, codes.cust_id
FROM dbo.codes LEFT OUTER JOIN
dbo.demos ON
dbo.codes.code = dbo.demos.code LEFT OUTER JOIN
dbo.answers ON dbo.codes.code = dbo.answers.code

any help appreciated - TIA
Bob

View 2 Replies

Data Provider Or Other Service Returned An E_Fail Status In Sql Server 2005

May 15, 2007

after converting database from sql server 2000 to sql server 2005. my program on vb6 is facing runtime error. i.e.data provider or other service returned an E_Fail status .

how can i get rid this problem

View 2 Replies View Related

SQL Server 2005 && Data Provider Or Other Service Returned An E_FAIL Status

Apr 22, 2007

Dear all,

I am running an Access adp application with SQL Server 2005 as back end database. I run a query by using Management Studio query window, and it returned correct results with some columns containing NULL value. But when I run this query through MS Access client side, popup an error "Data provider or other service returned an E_FAIL status" and crash the Access application. I moved the database back to SQL Server 2000, and it runs perfect on both client side and server side returning the correct result. This query is important for the application. Please help!!!!

Query as followed:

SELECT TOP (100) PERCENT dbo.VWINFO312FYTRStreamEnrolments.StudentID, dbo.RequiredStreams.StreamType,
dbo.VWINFO312FYTRStreams.StreamCode + CAST(dbo.VWINFO312FYTRStreams.StreamNo AS varchar) AS FullStreamCode,
dbo.DaysOfWeek.DayCode, dbo.VWINFO312FYTRClasses.StartTime, dbo.VWINFO312FYTRClasses.EndTime, dbo.VWINFO312FYTRClasses.Room,
dbo.Tutors.TutorName, dbo.Tutors.PhoneExtn, dbo.Tutors.OfficeHours, dbo.DaysOfWeek.DaySequence, dbo.RequiredStreams.StreamOrder
FROM dbo.RequiredStreams INNER JOIN
dbo.VWINFO312FYTRStreams ON dbo.RequiredStreams.PaperID = dbo.VWINFO312FYTRStreams.PaperID AND
dbo.RequiredStreams.StreamCode = dbo.VWINFO312FYTRStreams.StreamCode INNER JOIN
dbo.VWINFO312FYTRStreamEnrolments ON dbo.VWINFO312FYTRStreams.PaperID = dbo.VWINFO312FYTRStreamEnrolments.PaperID AND
dbo.VWINFO312FYTRStreams.StreamCode = dbo.VWINFO312FYTRStreamEnrolments.StreamCode AND
dbo.VWINFO312FYTRStreams.StreamNo = dbo.VWINFO312FYTRStreamEnrolments.StreamNo LEFT OUTER JOIN
dbo.DaysOfWeek INNER JOIN
dbo.VWINFO312FYTRClasses ON dbo.DaysOfWeek.DayCode = dbo.VWINFO312FYTRClasses.DayofWeek ON
dbo.VWINFO312FYTRStreams.PaperID = dbo.VWINFO312FYTRClasses.PaperID AND
dbo.VWINFO312FYTRStreams.StreamCode = dbo.VWINFO312FYTRClasses.StreamCode AND
dbo.VWINFO312FYTRStreams.StreamNo = dbo.VWINFO312FYTRClasses.StreamNo LEFT OUTER JOIN
dbo.Tutors ON dbo.VWINFO312FYTRClasses.ResponsibleTutor = dbo.Tutors.TutorID

View 4 Replies View Related

Data Provider Or Other Service Returned An E_Fail Status In Sql Server 2005

May 17, 2007

Main_Module.STRCNNN1 = "driver={SQL Server};server=" & Main_Module.Server_Name & ";" & _
"uid=SA;pwd=;database=" & Main_Module.Common_Database
error msg is

runtime error

data provider or other service returned an E_Fail status in sql server 2005

when i am fetching record from view using order by clause in select statement then error is coming

as

select * from vew_emp where grade='C' order empno

at the first time it fetching record with order by

but when i am using recordset.Requiry

it cud not fetch the record

i think when the recordset is open with the record of view

i am deleting ,inserting record in the view base table then the main recordset is not working

without using order by it is running and working well
plz reply me quickly

View 3 Replies View Related

Runtime Error Data Provider Or Other Service Provided An Efail Status

Jul 20, 2005

Anyone knows what would cause this?When Enterprise Manager is used to open a tableRuntime error data provider or other service provided an efail status

View 1 Replies View Related

Data Conversion Failed. The Data Conversion For Column Value Returned Status Value 4 And Status Text Text Was Truncated Or On

Jan 7, 2008

Hi Experts,

I am extracting data from SQL Server 2005 to flat file destination. I am using SQL Command to specify the data selection query. One of my query uses Replicate function to derive a column value. When I execute this package it fails with the error "Data conversion failed. The data conversion for column "value" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page".

The reason for the problem is that, it is taking the InputColumnWidth of the flat file destination as 8000 and I specified the OutputColumnWidth as 4.

If I change the OutputColumnWidth to 8000, it is working without any error but resulting in the column width of 8000.

I tried using DerivedColumn Transformation's Type cast and DataConversion Transformation but still I am getting the same error in the respective Transformation components.

Can anyone suggest how to solve this issue.

View 11 Replies View Related

Data Access :: Recordset Returned By Query Have A Status Of Closed?

Oct 8, 2015

I'm running the following SQL query from LabVIEW, a graphical programming language, using the built in capabilities it has for database connectivity:

    DECLARE @currentID int
    SET @currentID = (SELECT MIN(ExperimentID) FROM Jobs_t WHERE JobStatus = 'ToRun');
    UPDATE [dbo].[Jobs_t]
    SET [JobStatus] = 'Pending'
    WHERE ExperimentID = @currentID;
    SELECT @currentID AS result
<main.img>

This is the analogous code to main() is a C-like language. The first block, which has the "Connection Information" wire going into it, opens a .udl file and creates an ADO.NET _Connection reference, which is later used to invoke methods for the query.

<execute query.img>

This is the inside of the second block, the one with "EXE" and the pink wire going into it. The boxes with the gray border operate much like "switch" statements. The wire going into the "?" terminal on these boxes determines which case gets executed. The yellow boxes with white rectangels dropping down are invoke nodes and property nodes; they accept a reference to an object and allow you to invoke methods and read/write properties of that object. You can see the _Recordset object here as well. <fetch recordset.img>

Here's the next block to be executed, the one whose icon reads "FETCH ALL". We see that the first thing to execute on the far left grabs some properties of the recordset, and returns them in a "struct" (the pink wire that goes into the box that reads "state"). This is where the code fails. The recordset opened in the previous VI (virtual instrument) has a status of "closed", and the purple variant (seen under "Read all the data available") comes back empty.

The rest of the code is fairly irrelevant, as it's just converting the received variant into usable data, and freeing the recordset reference opened previously. My question is, why would the status from the query of the recordset be "closed"? I realize that recordsets are "closed" when the query returns no rows, but executing that query in SSMS returns good data. Also, executing the LabVIEW code does the UPDATE in the query, so I know that's not broken either.

View 3 Replies View Related

Data Conversion Failed From String To Numeric Returned Status Value 6 In Ssis

Sep 6, 2007

Hi i am working on sending data from a dat file to table in sql server Database and i am using the Data conversion transformation in ssis to convert string of fixed length into numeric (11,5) which is the datatype for the price field in the table and its returning an error saying that status vale 6 and error text as Conersion Failed sue to overflow of specific type ... Can anyone let me know how to overcome this error.

View 6 Replies View Related

How To Figure Out If The Dataset Returned Any Data Or Not While Rendering The Report Through The SSRS Web Service

Jan 12, 2007

In one of my projects, i have been using the SSRS web service to render a report as pdf and then manually emailing it out.

I need to know whether the data set for the report returned any data or not (so that i can avoid emailing the report with a blank report body).

Ofcource this can be done by executing the same query (same as the query for the report) from C# code and checking the count of the resultset, before calling the SSRS Render method. But it might not be an efficient method.

Was wondering the the SSRS Web Service provides an property or method that can let me figure out whether the resultset was empty or not (after the report execution).

Thanks.

View 1 Replies View Related

Returned Status Value 2 Error

Jan 14, 2006

Could someone please explain why I get the following errors ?

I have them in 15 out of 20 packages and its always the same, I have tried, removing the columns from the data source but it just seems to jump then to another column.

I have also tried redirecting the errors to a differnet error database but ALL the rows just seem to be errors then

In event viewer I get no further information simply

Event Type: Error
Event Source: SQLISPackage
Event Category: None
Event ID: 12291
Date:  14/01/2006
Time:  14:57:56
User:
Computer:
Description:
Package "Policy_PC" failed.

[Flat File Source [1]] Error: Data conversion failed. The data conversion for column "Column 42" returned status value 2 and status text "The value could not be converted because of a potential loss of data.".

[Flat File Source [1]] Error: The "output column "Column 42" (176)" failed because error code 0xC0209084 occurred, and the error row disposition on "output column "Column 42" (176)" specifies failure on error. An error occurred on the specified object of the specified component.

[DTS.Pipeline] Error: The PrimeOutput method on component "Flat File Source" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.

Any input at all is welcome, Im still a newbie at this

View 4 Replies View Related

Transact SQL :: Records Returned To Same Status

Jul 23, 2015

In my database I have an Audit table, that keeps track of teams worked upon the same record in a workflow.I need to find out how many records have been returned to the first team for correction ?The column 'Status' is numbered from 1 to 6 and Column 'EditTime' saves the time when record has been edited.how many records have been returned for correction and identify those records.

View 9 Replies View Related

DTS Error ? No Query Specification Returned By Transform Status

Mar 3, 2004

I'm getting this error in a simple DTS package.

No query specification returned by transform status.

Any ideas what's causing this ?

DTS is simply running a query (which returns data via preview)
and insert results into a table.

Thanks
Mark

View 1 Replies View Related

Provider 'MSOLAP.2' ICommandPrepare::Prepare Returned 0x80004005

Jun 9, 2008

Hi,I have a stored procedure that makes an MDX query for me, on SQL 2000, service pack 3 it works fine, but on service pack 4 it stops working with the error:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'MSOLAP.2' reported an error. The provider did not give any information about the error.OLE DB error trace [OLE/DB Provider 'MSOLAP.2' ICommandPrepare::Prepare returned 0x80004005: The provider did not give any information about the error.].and i'f i call @@Error I get the error number 7399.Any ideas as to what might be going on? The stored procedure which worked prior to service pack 4 is as follows:CREATE PROCEDURE MDXTester
(
@CustId Varchar(4)
)
AS
IF NOT EXISTS(SELECT * FROM master..sysservers where srvname = 'CZVCube')
BEGIN
EXEC sp_addlinkedserver 'CZVCube',
'',
'MSOLAP.2',
'10.0.41.128',
'CZV'
END

DECLARE @OPENQUERY nvarchar(4000), @MDX nvarchar(4000), @LinkedServer nvarchar(4000)
SET @LinkedServer = 'CZVCube'
SET @OPENQUERY = 'SELECT * FROM OPENQUERY('+ @LinkedServer + ','''
SET @MDX = 'WITH
MEMBER [Measures].[YTD NV] AS ''''Sum(YTD(),[Net Value])''''
MEMBER [Measures].[YTD Prev] AS ''''Sum(YTD(),([Measures].[Net value], ParallelPeriod([Fiscal year], 1, [FiscalYear].CurrentMember)))''''
MEMBER [Measures].[YTD Change] AS ''''[Measures].[YTD NV] - [Measures].[YTD Prev]'''', FORMAT_STRING = ''''###,###.00''''
MEMBER [Measures].[YTD Change Perc] AS ''''[Measures].[YTD Change] / [Measures].[YTD Prev]'''', FORMAT_STRING = ''''###,##0.0%''''
MEMBER [Measures].[Monthly Change] AS ''''[Net Value] - ([Net Value],FiscalYear.PrevMember)'''', FORMAT_STRING = ''''###,###.00''''
MEMBER [Measures].[Monthly Change Perc] AS ''''([Monthly Change] / ([Net Value],FiscalYear.PrevMember))'''', FORMAT_STRING = ''''###,##0.0%''''
MEMBER [Measures].[Annual Change] AS ''''[Net Value] - ([Measures].[Net value], ParallelPeriod([Fiscal year], 1, [FiscalYear].CurrentMember))'''', FORMAT_STRING = ''''###,###.00''''
MEMBER [Measures].[Annual Change Perc] AS ''''([Annual Change] / ([Measures].[Net value], ParallelPeriod([Fiscal year], 1, [FiscalYear].CurrentMember)))'''', FORMAT_STRING = ''''###,##0.0%''''
MEMBER [Measures].[12 mth mov av] AS ''''Avg([FiscalYear].CurrentMember.Lag(11):[FiscalYear].CurrentMember, [Measures].[Net Value])''''
SELECT {[Measures].[Net Value] , [Measures].[YTD NV], [Measures].[YTD Prev],[Measures].[Monthly Change], [Measures].[Monthly Change Perc], [Measures].[Annual Change], [Measures].[Annual Change Perc], [Measures].[YTD Change], [Measures].[YTD Change Per
c], [Measures].[12 mth mov av]} ON COLUMNS,
LastPeriods(12, [FiscalYear].[Apr 08]) ON ROWS
FROM CZV
where [C_CRMID].[' + @CustId + ']'
EXEC(@OPENQUERY + @MDX + ''')')

View 1 Replies View Related

OLE/DB Provider Returned Message: Deferred Prepare Could Not Be Completed

Apr 11, 2006

I have 2 SQL servers. And in the first one I have added the second SQL as a Link Server. When I run an SQL statement on the linked server I get the following message.
Server: Msg 7202, Level 11, State 1, Line 1Could not find server 'PROD' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.[OLE/DB provider returned message: Deferred prepare could not be completed.]
The SQL statement that I am runnins is
Select * from openquery(PROD,'Select * from PROD.GMS.dbo.qryDispCL')
But when I run only the SQL statement "Select * from PROD.GMS.dbo.qryDispCL" it works perfect. But I need to have the first statement running.
Please help. Your valuable feedback is greatly appriciated.

View 1 Replies View Related

Error: A Rowset Based On The SQL Command Was Not Returned By The OLE DB Provider.

May 14, 2007

I have a dataflow task. On which I have OLEDB as my source. I connect to my database and execute a stored proc. the stored proc results in a result set with only one row and two columns. First Column is an integer and the second row is a varchar(max) with xml script in it. Not that it should matter because it is in varchar(max).

Anyway, it give me an error

[OLE DB Source [321]] Error: A rowset based on the SQL command was not returned by the OLE DB provider.

What am I doing wrong?

Can I not have a stroed proc that returns a result set as my data source?

View 4 Replies View Related

The OLE DB Provider SQLNCLI For Linked Server SQLSERVER Returned A NON-CLUSTERED..

Apr 11, 2008

Hi

i am try to execute a command " SELECT * FROM [SQLSERVER].[DATABASENAME].[DBO].[TABLE] ".. but i am receiving a error message

Msg 7319, Level 16, State 1, Line 19

The OLE DB provider "SQLNCLI" for linked server "SQLSERVER" returned a "NON-CLUSTERED and NOT INTEGRATED" index "MSmerge_index_1348915877" with the incorrect bookmark ordinal 0.

but when i try to check the linked server it's shows me the linked is okay.. The following command i use to check wethare the link is fine or not..

CREATE TABLE #foo

(

pingResult SYSNAME NULL

);

INSERT #foo

EXEC master..xp_cmdshell

'ping SQLSERVER;

IF EXISTS

(

SELECT 1

FROM #foo

WHERE pingResult LIKE '%TTL%'

)

BEGIN

PRINT 'Feel free to use linked server.';

END

ELSE

BEGIN

PRINT 'Linked server not available.';

END

DROP TABLE #foo;

and Following result i receive..

(13 row(s) affected)

Feel free to use linked server.

Can any One tells me where i m making mistake or how can i resolve this problem

View 5 Replies View Related

Data Returned From .WriteXML Is Different Than What Is Returned In Query Analyzer.

Jun 20, 2006

I have a strange problem. I have some code that executes a sql query. If I run the query in SQL server query analyzer, I get a set of data returned for me as expected. This is the query listed on lines 3 and 4. I just manually type it into query analyzer.
Yet when I run the same query in my code, the result set is slightly different because it is missing some data. I am confused as to what is going on here. Basically to examine the sql result set returned, I write it out to an XML file. (See line 16).
Why the data returned is different, I have no idea. Also writing it out to an XML file is the only way I can look at the data. Otherwise looking at it in the debugger is impossible, with the hundreds of tree nodes returned.
If someone is able to help me figure this out, I would appreciate it.
1. public DataSet GetMarketList(string region, string marketRegion)2. {3. string sql = @"SELECT a.RealEstMarket FROM MarketMap a, RegionMap b " + 4."WHERE a.RegionCode = b.RegionCode"; 5. DataSet dsMarketList = new DataSet();6. SqlConnection sqlConn = new SqlConnection(intranetConnStr); 7. SqlCommand cmd = new SqlCommand(sql,sqlConn);8. sqlConn.Open();9. SqlDataAdapter adapter = new SqlDataAdapter(cmd); 10. try11. {12. adapter.Fill(dsMarketList);
13. String bling = adapter.SelectCommand.CommandText;//BRG 14. dsMarketList.DataSetName="RegionMarket"; 15. dsMarketList.Tables[0].TableName = "MarketList"; 16. dsMarketList.WriteXml(Server.MapPath ("myXMLFile.xml" )); // The data written to 17. myXMLFile.xml is not the same data that is returned when I run the query on line 3&4 18. // from the SQL query 19. } 20. catch(Exception e) 21. { 22. // Handle the exception (Code not shown)

View 2 Replies View Related

OLE DB Provider MSDAORA For Linked Server DBNAME Returned Message ORA-01476: Divisor Is Equal To Zero

Aug 14, 2007

Hi All,

I have a strange problem with one of my Linked server connections. I am connecting from
SQL Server 2005 Standard Edition (9.00.3042.00) to and Oracle 10g database using the Microsoft OLE DB Provider for Oracle. The connection works and I am able to select from all the Oracle tables except for 1 table. When selecting from this table I get the following error:

OLE DB provider "MSDAORA" for linked server "DBNAME" returned message "ORA-01476: divisor is equal to zero".

Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "DBNAME".

This probem happens if the table has rows or has no rows (empty table).

I have tried SELECT * and count(*) along with selecting a specific column from the table.

I can use SQL*plus from the system that the SQL database server running on it and select from the table using the same login/password that the linked server uses to rule out a permissions problem.

Any suggestions on what I can try next?

Thanks.

View 3 Replies View Related

Linked Server Issue: OLE DB Error Trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface Returned 0x80004005

Aug 13, 2007

Window Server 2003 R2 Standard Edition (x64) SP1
Sql Server 2000 8.00.2039 SP4 Enterprise Edition (32 bit version)

A linked server is configured to a sql 2000 server and when I execute sql statement SELECT * FROM [LinkedServer].[Database].[dbo].[TableName] it gives following error message: -

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].

In case if anyone has a solution to it, please let me know.

View 3 Replies View Related

Handling Provider-level Errors From .Net SqlClient Data Provider

Jun 26, 2007

Hi,

After reading this helpful blog entry:

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

I think this might be a good place to ask the following question.

I am writing the error handling code for my data access layer for a web application. I am using the Enterprise Library Data Access Application Block. Although this supports generic database connections, I realized that I need to handle errors specific to each database type. Microsoft SQL is the only database type I am using for now, so I am using a try...catch (SqlException e).

In testing my code, I intentionally changed the instance name in web.config to a name that does not exist. I get the very popular error 26 - Error Locating Server/Instance Specified. This is returned as a SqlException, but the SqlError.Number property is set to -1.

Am I getting "-1" because the provider hasn't actually connected to SQL yet, so it doesn't have an actual SQL error number?
Can I assume that (SqlError.Number == -1) is always a fatal, provider-level connection exception?
Will the provider ever use another SqlError.Number of its own? Or do all numbers besides -1 come from the SQL sysmessages table?.
Is there a comprehensive list of what exceptions might be raised by the SqlClient provider, including #26?

The reason for all the questions is that in a web application, I want to prevent the end-user from seeing the "real" exception if it has to do with configuration errors. However, maybe there are other errors that the user should see and handle? It's hard to know without a full list of SqlClient provider errors, along with the SqlError.Number that each error maps to.

Thanks and regards,

Mark

View 6 Replies View Related

Unable To Set SQL Express Service Status To Running State

Nov 1, 2007

Hi! Im just starting to learn how to use an SQL express database. I used it over at my campus and it worked fine and now when I try running it on my machine it gave me this error :

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connection.(Provider : SQL Network Interfaces, error : 26 - Error locating server/ instance specified.)"

I know that by default SQL express doesnt not support remote connection but when i try to get the service status running, i got another error which is :

"The service did not respond to the start or control request in a timely fashion, you need administrator privileges to be able to start/stop this service. (SQLSAC)"

I am already logged on to the computer as an administrator but i still cant get the service to run! Pls help!

View 1 Replies View Related

Test Connection Failed Because Of Error Initializing Provider. The HTTP Server Returned The Following Error : Not Found

May 26, 2008

Hi All,

I am using windows 2003 server and i have installed SSAS 2005 and configured http request for AS 2005 with this below url : http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx. I had tried all the possiblities given in this url. But i am getting like "Test connection failed because of error initializing provider. The HTTP Server returned the following error : Not found" when i create udl file. Moreover i have installed MSOLAP 3.0 and OLAP 9.0 provider and MSXML 6.0 Parser.

Can you anyone please provide solution for this?

Thanks in advance,
Anand Rajagopal

View 1 Replies View Related

Configuring Reporting Service Add-in For Sharepoint - HTTP Status 401: Unauthorized.

Mar 22, 2007

I have the following setup

Machine 1

WSS 3.0

Installed Reporting Service Add-in

Machine 2

Reporting Service

Sharepoint Object Model

SQL Server

Sharepoint and Report Server DB

I have congigured Reporting Service for Sharepoint Integrated Mode adn Created new Reprot Server DB

Sahre Point Integration is Green and verified link

In Sharepoint Central Administration

Manage Reporting Service Integratio i have selected the URL and "Trusted Account" as my web applications use "Windows Integration - NTLM".

All services, DB access everything running under one domain user account.

I am logged into sharepoint with same account. When clieck on set server defaults i get following error

An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized.

Same error when i try to add a report to a sharepoint webapplication

The domain account is part of "Farm Administration", "site colletion administrato" and local administrator also on both servers.

Can someone let me know how to fix this.

View 15 Replies View Related

Web Service Task With An Provider Different From Microsoft

Dec 5, 2007

Hello,

I have a web service contained in a apache tomcat server and I try to execute a webservice and store the result into a flat file.But I have a message saying me that there is an error in the xml document.
I suppose that it's my wsdl file.
But my wsdl file is fine!!!
Can the error come from the provider of the web service (Apache Tomcat).
I suppose that because in every example on the internet I didn't see an example an tomcat or other web server use.

View 1 Replies View Related

Configuring Ole Db Provider For Indexing Service

Jun 6, 2007

Hi:

Am trying to access a Indexing Services catalog from SSIS. Problem is configuring the Data Connection.

I chose New Connection, Provider=Microsoft OleDB provider for Indexing Services.

Then I am not quite sure what to fill in for:

A. Server or File Name (I tried the IP address, the machine name, catalog name)

B. Location(tried catalog Name, ip address, machine name)

The Log On to Server frame is disabled.

Test Connection succeeds, but trying to use a Table or a Query does not work out.

How do I configure the Connection?

TIA

Kar

View 4 Replies View Related

Could Not Resolve Service Name - Oracle 8 And MS OLEDB Provider

Jan 23, 2001

Trying to used DTS from SQL Server 7 to import a table from Oracle 8 DB to SQL Server. SQL Server has Oracle 8 connectivity installed and a database instance setup. Connection using the instance works from Oracle Enterprise manager and all Oracle tools. The MS OLEDB provider for Oracle fails to connect : could not resolve service name. I have this working on a different server with the same setup (SQL Server 7 SP 2 + All Oracle 8.0.5 connectivity).

WHAT AM I MISSING?

View 1 Replies View Related

Query Notification - Subscription Created But Not Firing Service Broker Endpoint In Status SO

Mar 12, 2007

Hi,

SQL Server 2005 SP1. (+ 5 minutes fix installed).

Query notification subscription cretaed (sys.dm_qn_subscriptions).

Subscription does not fire in response to event.

sys.transmission_queue is empty.

profiler does not show errors.

sys.conversation_endpoints shows one endpoint in status SO. (along with a lot of left over garbage - about 300K records - but this should not be a problem other than storage).

I know SP2 is suppose to solve the garbage records problem but this is not our problem. This setup was working and then just stoped.

any ideas ?

Boaz

View 7 Replies View Related

HResult E_Fail Error

Dec 6, 2006

From a couple of days I have a strange and annoying problem on my development machine. Every time that I try to use the Import/Export wizard in the Management Studio I receive the error HResult E_Fail error refererencig to the dtsruntimewrap.

If I try to open a SSIS package and to check the setup of the connection I receive instead a message stating Could Not Edit OleDB Connection, error E_FAIL(0x80004005). (System.Data)

What can I do to fix this problem?

Thank you

View 6 Replies View Related

Where Can I Download The OLE DB Provider For Microsoft Active Directory Service

Feb 23, 2006

Hi,

Where can I download the OLE DB Provider for Microsoft Active Directory Service.

I'm using sql server 2005, windows server 2003. not sure the version of AD. (all 32 bit).

Cheers
Chris

View 1 Replies View Related

SQL 'Server' Or 'Local' Database For Uploading To Hosting Service Provider

Mar 23, 2007

Hi, I'm developing a website using VWD 2005 Express, which needs a Membership system and a products database. Using the VWD inherent Web Site Administration tool makes the membership set up easy but by default it creates a 'Local' SQL database in a folder named 'Apps_Data' in the VWD project. My question is: considering I will need to upload my web site to a Hosting Service, would it be better to change the default so that the membership systems, and the product database I need, are created in an SQL 'Server' database instead of a 'Local' database?
The hosting service I am considering using is having a bit of a problem understanding this question, I hope it makes sense to someone or am I asking a stupid question?
Regards
Sean.

View 2 Replies View Related

An Error Occurred In The Service Broker Internal Activator While Trying To Scan The User Queue '(null)' For Its Status. Error: 2

Apr 25, 2007

Hello - can't find any info on this error - can anyone shed some light?

There was a deadlock - which preceeded this message by 2 seconds.

04/25/2007 08:20:12,spid108,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid108,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:12,spid108,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:12,spid108,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:12,spid108,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:12,spid108,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:12,spid108,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:12,spid108,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:12,spid108,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:12,spid108,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:12,spid108,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:12,spid108,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:12,spid108,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:12,spid108,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:12,spid108,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:12,spid108,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:12,spid108,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:12,spid108,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:12,spid108,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:12,spid108,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:12,spid108,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:12,spid108,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:12,spid108,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:12,spid108,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:12,spid108,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:12,spid108,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:12,spid108,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,* Short Stack Dump
04/25/2007 08:20:12,spid108,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,* SegSs: 00000023:
04/25/2007 08:20:12,spid108,Unknown,* Esp: 1302E584: 13025387 80C87378 80C872F0 00000000 78140001 0009D9C2
04/25/2007 08:20:12,spid108,Unknown,* EFlags: 00010202: 00610067 00650074 0049003B 0076006E 006C0061 00640069
04/25/2007 08:20:12,spid108,Unknown,* SegCs: 0000001B:
04/25/2007 08:20:12,spid108,Unknown,* Ebp: 1302F67C: 1302F788 01793310 13025373 80C872F0 7093AB12 801E8B38
04/25/2007 08:20:12,spid108,Unknown,* Eip: 0179438B: 828B118B 000000E0 C085D0FF 00B9850F 9D890000 FFFFEF8C
04/25/2007 08:20:12,spid108,Unknown,* Edx: 00000E38:
04/25/2007 08:20:12,spid108,Unknown,* Ecx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Ebx: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Eax: A99EE598: 00000000 00000000 A99EE5B0 00000000 00000000 00000000
04/25/2007 08:20:12,spid108,Unknown,* Esi: 00000000:
04/25/2007 08:20:12,spid108,Unknown,* Edi: 80C872F0: 7093AB12 80C87FF0 00000007 B8A20008 7093AB15 00000000
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* dbghelp 14200000 14312FFF 00113000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 76780000 76913FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 764A0000 76633FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 76300000 76493FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 341D0000 343AFFFF 001e0000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 33590000 33764FFF 001d5000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 333F0000 33583FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 14490000 1467AFFF 001eb000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 13D10000 13EFBFFF 001ec000
04/25/2007 08:20:12,spid108,Unknown,* OLEDB32R 13770000 13780FFF 00011000
04/25/2007 08:20:12,spid108,Unknown,* MSDART 133D0000 133E9FFF 0001a000
04/25/2007 08:20:12,spid108,Unknown,* oledb32 13350000 133C8FFF 00079000
04/25/2007 08:20:12,spid108,Unknown,* msxml3 11BD0000 11CE1FFF 00112000
04/25/2007 08:20:12,spid108,Unknown,* msxmlsql 11AF0000 11BC5FFF 000d6000
04/25/2007 08:20:12,spid108,Unknown,* System.Xml 10FA0000 11193FFF 001f4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security 10F20000 10F61FFF 00042000
04/25/2007 08:20:12,spid108,Unknown,* System 10C10000 10EF3FFF 002e4000
04/25/2007 08:20:12,spid108,Unknown,* System.Security.ni 10A90000 10B45FFF 000b6000
04/25/2007 08:20:12,spid108,Unknown,* System.Transactions 0FAD0000 0FB12FFF 00043000
04/25/2007 08:20:12,spid108,Unknown,* System.ni 7A440000 7ABFDFFF 007be000
04/25/2007 08:20:12,spid108,Unknown,* System.Data 102D0000 10596FFF 002c7000
04/25/2007 08:20:12,spid108,Unknown,* mscorjit 0F910000 0F962FFF 00053000
04/25/2007 08:20:12,spid108,Unknown,* SqlAccess 0F8A0000 0F8F5FFF 00056000
04/25/2007 08:20:12,spid108,Unknown,* SensApi 0F880000 0F884FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* cryptnet 0F680000 0F691FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* SOFTPUB 0F670000 0F674FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* mscorsec 0F640000 0F652FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* mscorlib.ni 0EAC0000 0F5A7FFF 00ae8000
04/25/2007 08:20:12,spid108,Unknown,* mscorwks 080E0000 08640FFF 00561000
04/25/2007 08:20:12,spid108,Unknown,* xplog70 07CA0000 07CA2FFF 00003000
04/25/2007 08:20:12,spid108,Unknown,* xplog70 07C80000 07C8BFFF 0000c000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90 07C50000 07C75FFF 00026000
04/25/2007 08:20:12,spid108,Unknown,* odbcint 07C30000 07C46FFF 00017000
04/25/2007 08:20:12,spid108,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
04/25/2007 08:20:12,spid108,Unknown,* BatchParser90 07A40000 07A5EFFF 0001f000
04/25/2007 08:20:12,spid108,Unknown,* ODBC32 07A00000 07A3CFFF 0003d000
04/25/2007 08:20:12,spid108,Unknown,* SQLSCM90 079E0000 079E8FFF 00009000
04/25/2007 08:20:12,spid108,Unknown,* xpstar90 07980000 079C7FFF 00048000
04/25/2007 08:20:12,spid108,Unknown,* xpsqlbot 07960000 07965FFF 00006000
04/25/2007 08:20:12,spid108,Unknown,* msftepxy 07490000 074A4FFF 00015000
04/25/2007 08:20:12,spid108,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
04/25/2007 08:20:12,spid108,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
04/25/2007 08:20:12,spid108,Unknown,* COMCTL32 77530000 775C6FFF 00097000
04/25/2007 08:20:12,spid108,Unknown,* sqlncli 337A0000 339C1FFF 00222000
04/25/2007 08:20:12,spid108,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
04/25/2007 08:20:12,spid108,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
04/25/2007 08:20:12,spid108,Unknown,* ntdsapi 766F0000 76704FFF 00015000
04/25/2007 08:20:12,spid108,Unknown,* wshtcpip 070B0000 070B7FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* hnetcfg 071F0000 07248FFF 00059000
04/25/2007 08:20:12,spid108,Unknown,* dssenh 070C0000 070E3FFF 00024000
04/25/2007 08:20:12,spid108,Unknown,* imagehlp 76C10000 76C38FFF 00029000
04/25/2007 08:20:12,spid108,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
04/25/2007 08:20:12,spid108,Unknown,* dbghelp 06C10000 06D22FFF 00113000
04/25/2007 08:20:12,spid108,Unknown,* msfte 069B0000 06C08FFF 00259000
04/25/2007 08:20:12,spid108,Unknown,* security 06190000 06193FFF 00004000
04/25/2007 08:20:12,spid108,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* winrnr 76F70000 76F76FFF 00007000
04/25/2007 08:20:12,spid108,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
04/25/2007 08:20:12,spid108,Unknown,* RESUTILS 05D50000 05D62FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* CLUSAPI 05D30000 05D41FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
04/25/2007 08:20:12,spid108,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
04/25/2007 08:20:12,spid108,Unknown,* VERSION 77B90000 77B97FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* MTXCLU 05D10000 05D28FFF 00019000
04/25/2007 08:20:12,spid108,Unknown,* msvcp60 780C0000 78120FFF 00061000
04/25/2007 08:20:12,spid108,Unknown,* MSDTCPRX 05C90000 05D07FFF 00078000
04/25/2007 08:20:12,spid108,Unknown,* XOLEHLP 05C80000 05C85FFF 00006000
04/25/2007 08:20:12,spid108,Unknown,* COMRES 77010000 770D5FFF 000c6000
04/25/2007 08:20:12,spid108,Unknown,* schannel 76750000 76776FFF 00027000
04/25/2007 08:20:12,spid108,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
04/25/2007 08:20:12,spid108,Unknown,* kerberos 05BC0000 05C17FFF 00058000
04/25/2007 08:20:12,spid108,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
04/25/2007 08:20:12,spid108,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
04/25/2007 08:20:12,spid108,Unknown,* MSCOREE 05950000 05994FFF 00045000
04/25/2007 08:20:12,spid108,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
04/25/2007 08:20:12,spid108,Unknown,* rsaenh 04E90000 04EBEFFF 0002f000
04/25/2007 08:20:12,spid108,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
04/25/2007 08:20:12,spid108,Unknown,* SAMLIB 5CCF0000 5CCFEFFF 0000f000
04/25/2007 08:20:12,spid108,Unknown,* ole32 77670000 777A3FFF 00134000
04/25/2007 08:20:12,spid108,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
04/25/2007 08:20:12,spid108,Unknown,* SQLOS 344D0000 344D4FFF 00005000
04/25/2007 08:20:12,spid108,Unknown,* sqlevn70 4F610000 4F7A3FFF 00194000
04/25/2007 08:20:12,spid108,Unknown,* instapi 48060000 48069FFF 0000a000
04/25/2007 08:20:12,spid108,Unknown,* psapi 76B70000 76B7AFFF 0000b000
04/25/2007 08:20:12,spid108,Unknown,* comctl32 77420000 77522FFF 00103000
04/25/2007 08:20:12,spid108,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
04/25/2007 08:20:12,spid108,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
04/25/2007 08:20:12,spid108,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
04/25/2007 08:20:12,spid108,Unknown,* opends60 333E0000 333E6FFF 00007000
04/25/2007 08:20:12,spid108,Unknown,* USERENV 76920000 769E3FFF 000c4000
04/25/2007 08:20:12,spid108,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
04/25/2007 08:20:12,spid108,Unknown,* WS2_32 71C00000 71C16FFF 00017000
04/25/2007 08:20:12,spid108,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
04/25/2007 08:20:12,spid108,Unknown,* Secur32 76F50000 76F62FFF 00013000
04/25/2007 08:20:12,spid108,Unknown,* MSASN1 76190000 761A1FFF 00012000
04/25/2007 08:20:12,spid108,Unknown,* CRYPT32 761B0000 76242FFF 00093000
04/25/2007 08:20:12,spid108,Unknown,* GDI32 77C00000 77C47FFF 00048000
04/25/2007 08:20:12,spid108,Unknown,* USER32 77380000 77411FFF 00092000
04/25/2007 08:20:12,spid108,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
04/25/2007 08:20:12,spid108,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
04/25/2007 08:20:12,spid108,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
04/25/2007 08:20:12,spid108,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
04/25/2007 08:20:12,spid108,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
04/25/2007 08:20:12,spid108,Unknown,* kernel32 77E40000 77F41FFF 00102000
04/25/2007 08:20:12,spid108,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
04/25/2007 08:20:12,spid108,Unknown,* sqlservr 01000000 02BCEFFF 01bcf000
04/25/2007 08:20:12,spid108,Unknown,* MODULE BASE END SIZE
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* Access Violation occurred reading address 00000000
04/25/2007 08:20:12,spid108,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:12,spid108,Unknown,* Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* 04/25/07 08:20:12 spid 108
04/25/2007 08:20:12,spid108,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:12,spid108,Unknown,*
04/25/2007 08:20:12,spid108,Unknown,* *******************************************************************************
04/25/2007 08:20:12,spid108,Unknown,SqlDumpExceptionHandler: Process 108 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:12,spid108,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0007.txt
04/25/2007 08:20:12,spid108,Unknown,Using 'dbghelp.dll' version '4.0.5'
04/25/2007 08:20:12,spid60,Unknown,An error occurred in the Service Broker internal activator while trying to scan the user queue '(null)' for its status. Error: 2905<c/> State: 1.
04/25/2007 08:20:12,spid60,Unknown,External dump process return code 0x20000001.<nl/>External dump process returned no errors.
04/25/2007 08:20:10,spid60,Unknown,Stack Signature for the dump is 0x1229B5AA
04/25/2007 08:20:10,spid60,Unknown,78132A36 Module(MSVCR80+00002A36)
04/25/2007 08:20:10,spid60,Unknown,781329AA Module(MSVCR80+000029AA)
04/25/2007 08:20:10,spid60,Unknown,01447720 Module(sqlservr+00447720)
04/25/2007 08:20:10,spid60,Unknown,0144789A Module(sqlservr+0044789A)
04/25/2007 08:20:10,spid60,Unknown,0144859B Module(sqlservr+0044859B)
04/25/2007 08:20:10,spid60,Unknown,01447562 Module(sqlservr+00447562)
04/25/2007 08:20:10,spid60,Unknown,01006DAB Module(sqlservr+00006DAB)
04/25/2007 08:20:10,spid60,Unknown,01006BBC Module(sqlservr+00006BBC)
04/25/2007 08:20:10,spid60,Unknown,01006A96 Module(sqlservr+00006A96)
04/25/2007 08:20:10,spid60,Unknown,0112F65C Module(sqlservr+0012F65C)
04/25/2007 08:20:10,spid60,Unknown,0112F70F Module(sqlservr+0012F70F)
04/25/2007 08:20:10,spid60,Unknown,0112CB04 Module(sqlservr+0012CB04)
04/25/2007 08:20:10,spid60,Unknown,0112D1D1 Module(sqlservr+0012D1D1)
04/25/2007 08:20:10,spid60,Unknown,0112EA61 Module(sqlservr+0012EA61)
04/25/2007 08:20:10,spid60,Unknown,0108A5CB Module(sqlservr+0008A5CB)
04/25/2007 08:20:10,spid60,Unknown,0108A56B Module(sqlservr+0008A56B)
04/25/2007 08:20:10,spid60,Unknown,01060A5A Module(sqlservr+00060A5A)
04/25/2007 08:20:10,spid60,Unknown,01476CB2 Module(sqlservr+00476CB2)
04/25/2007 08:20:10,spid60,Unknown,01476FD3 Module(sqlservr+00476FD3)
04/25/2007 08:20:10,spid60,Unknown,017FA720 Module(sqlservr+007FA720)
04/25/2007 08:20:10,spid60,Unknown,017FAADC Module(sqlservr+007FAADC)
04/25/2007 08:20:10,spid60,Unknown,01796B1B Module(sqlservr+00796B1B)
04/25/2007 08:20:10,spid60,Unknown,01793310 Module(sqlservr+00793310)
04/25/2007 08:20:10,spid60,Unknown,0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,* Short Stack Dump
04/25/2007 08:20:10,spid60,Unknown,* -------------------------------------------------------------------------------
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,* SegSs: 00000023:
04/25/2007 08:20:10,spid60,Unknown,* Esp: 1189E584: 11895387 80C87378 80C872F0 00000000 03E90001 00087C2D
04/25/2007 08:20:10,spid60,Unknown,* EFlags: 00010202: 00610067 00650074 0049003B 0076006E 006C0061 00640069
04/25/2007 08:20:10,spid60,Unknown,* SegCs: 0000001B:
04/25/2007 08:20:10,spid60,Unknown,* Ebp: 1189F67C: 1189F788 01793310 11895373 80C872F0 7093AB12 801E8B38
04/25/2007 08:20:10,spid60,Unknown,* Eip: 0179438B: 828B118B 000000E0 C085D0FF 00B9850F 9D890000 FFFFEF8C
04/25/2007 08:20:10,spid60,Unknown,* Edx: 00000E38:
04/25/2007 08:20:10,spid60,Unknown,* Ecx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Ebx: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Eax: 5ADE8598: 00000000 00000000 5ADE85B0 00000000 00000000 00000000
04/25/2007 08:20:10,spid60,Unknown,* Esi: 00000000:
04/25/2007 08:20:10,spid60,Unknown,* Edi: 80C872F0: 7093AB12 80C87FF0 00000007 B8A20008 7093AB15 00000000
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* dbghelp 14200000 14312FFF 00113000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 76780000 76913FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 764A0000 76633FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 76300000 76493FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 341D0000 343AFFFF 001e0000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 33590000 33764FFF 001d5000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 333F0000 33583FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 14490000 1467AFFF 001eb000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 13D10000 13EFBFFF 001ec000
04/25/2007 08:20:10,spid60,Unknown,* OLEDB32R 13770000 13780FFF 00011000
04/25/2007 08:20:10,spid60,Unknown,* MSDART 133D0000 133E9FFF 0001a000
04/25/2007 08:20:10,spid60,Unknown,* oledb32 13350000 133C8FFF 00079000
04/25/2007 08:20:10,spid60,Unknown,* msxml3 11BD0000 11CE1FFF 00112000
04/25/2007 08:20:10,spid60,Unknown,* msxmlsql 11AF0000 11BC5FFF 000d6000
04/25/2007 08:20:10,spid60,Unknown,* System.Xml 10FA0000 11193FFF 001f4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security 10F20000 10F61FFF 00042000
04/25/2007 08:20:10,spid60,Unknown,* System 10C10000 10EF3FFF 002e4000
04/25/2007 08:20:10,spid60,Unknown,* System.Security.ni 10A90000 10B45FFF 000b6000
04/25/2007 08:20:10,spid60,Unknown,* System.Transactions 0FAD0000 0FB12FFF 00043000
04/25/2007 08:20:10,spid60,Unknown,* System.ni 7A440000 7ABFDFFF 007be000
04/25/2007 08:20:10,spid60,Unknown,* System.Data 102D0000 10596FFF 002c7000
04/25/2007 08:20:10,spid60,Unknown,* mscorjit 0F910000 0F962FFF 00053000
04/25/2007 08:20:10,spid60,Unknown,* SqlAccess 0F8A0000 0F8F5FFF 00056000
04/25/2007 08:20:10,spid60,Unknown,* SensApi 0F880000 0F884FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* cryptnet 0F680000 0F691FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* SOFTPUB 0F670000 0F674FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* mscorsec 0F640000 0F652FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* mscorlib.ni 0EAC0000 0F5A7FFF 00ae8000
04/25/2007 08:20:10,spid60,Unknown,* mscorwks 080E0000 08640FFF 00561000
04/25/2007 08:20:10,spid60,Unknown,* xplog70 07CA0000 07CA2FFF 00003000
04/25/2007 08:20:10,spid60,Unknown,* xplog70 07C80000 07C8BFFF 0000c000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90 07C50000 07C75FFF 00026000
04/25/2007 08:20:10,spid60,Unknown,* odbcint 07C30000 07C46FFF 00017000
04/25/2007 08:20:10,spid60,Unknown,* ATL80 7C630000 7C64AFFF 0001b000
04/25/2007 08:20:10,spid60,Unknown,* BatchParser90 07A40000 07A5EFFF 0001f000
04/25/2007 08:20:10,spid60,Unknown,* ODBC32 07A00000 07A3CFFF 0003d000
04/25/2007 08:20:10,spid60,Unknown,* SQLSCM90 079E0000 079E8FFF 00009000
04/25/2007 08:20:10,spid60,Unknown,* xpstar90 07980000 079C7FFF 00048000
04/25/2007 08:20:10,spid60,Unknown,* xpsqlbot 07960000 07965FFF 00006000
04/25/2007 08:20:10,spid60,Unknown,* msftepxy 07490000 074A4FFF 00015000
04/25/2007 08:20:10,spid60,Unknown,* SQLNCLIR 007A0000 007D2FFF 00033000
04/25/2007 08:20:10,spid60,Unknown,* comdlg32 762B0000 762F9FFF 0004a000
04/25/2007 08:20:10,spid60,Unknown,* COMCTL32 77530000 775C6FFF 00097000
04/25/2007 08:20:10,spid60,Unknown,* sqlncli 337A0000 339C1FFF 00222000
04/25/2007 08:20:10,spid60,Unknown,* CLBCatQ 777B0000 77832FFF 00083000
04/25/2007 08:20:10,spid60,Unknown,* xpsp2res 10000000 102C4FFF 002c5000
04/25/2007 08:20:10,spid60,Unknown,* ntdsapi 766F0000 76704FFF 00015000
04/25/2007 08:20:10,spid60,Unknown,* wshtcpip 070B0000 070B7FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* hnetcfg 071F0000 07248FFF 00059000
04/25/2007 08:20:10,spid60,Unknown,* dssenh 070C0000 070E3FFF 00024000
04/25/2007 08:20:10,spid60,Unknown,* imagehlp 76C10000 76C38FFF 00029000
04/25/2007 08:20:10,spid60,Unknown,* WINTRUST 76BB0000 76BDAFFF 0002b000
04/25/2007 08:20:10,spid60,Unknown,* dbghelp 06C10000 06D22FFF 00113000
04/25/2007 08:20:10,spid60,Unknown,* msfte 069B0000 06C08FFF 00259000
04/25/2007 08:20:10,spid60,Unknown,* security 06190000 06193FFF 00004000
04/25/2007 08:20:10,spid60,Unknown,* rasadhlp 76F80000 76F84FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* winrnr 76F70000 76F76FFF 00007000
04/25/2007 08:20:10,spid60,Unknown,* DNSAPI 76ED0000 76EF8FFF 00029000
04/25/2007 08:20:10,spid60,Unknown,* RESUTILS 05D50000 05D62FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* CLUSAPI 05D30000 05D41FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* OLEAUT32 77D00000 77D8BFFF 0008c000
04/25/2007 08:20:10,spid60,Unknown,* WSOCK32 71BB0000 71BB8FFF 00009000
04/25/2007 08:20:10,spid60,Unknown,* VERSION 77B90000 77B97FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* MTXCLU 05D10000 05D28FFF 00019000
04/25/2007 08:20:10,spid60,Unknown,* msvcp60 780C0000 78120FFF 00061000
04/25/2007 08:20:10,spid60,Unknown,* MSDTCPRX 05C90000 05D07FFF 00078000
04/25/2007 08:20:10,spid60,Unknown,* XOLEHLP 05C80000 05C85FFF 00006000
04/25/2007 08:20:10,spid60,Unknown,* COMRES 77010000 770D5FFF 000c6000
04/25/2007 08:20:10,spid60,Unknown,* schannel 76750000 76776FFF 00027000
04/25/2007 08:20:10,spid60,Unknown,* cryptdll 766E0000 766EBFFF 0000c000
04/25/2007 08:20:10,spid60,Unknown,* kerberos 05BC0000 05C17FFF 00058000
04/25/2007 08:20:10,spid60,Unknown,* iphlpapi 76CF0000 76D09FFF 0001a000
04/25/2007 08:20:10,spid60,Unknown,* msv1_0 76C90000 76CB6FFF 00027000
04/25/2007 08:20:10,spid60,Unknown,* MSCOREE 05950000 05994FFF 00045000
04/25/2007 08:20:10,spid60,Unknown,* AUTHZ 76C40000 76C53FFF 00014000
04/25/2007 08:20:10,spid60,Unknown,* rsaenh 04E90000 04EBEFFF 0002f000
04/25/2007 08:20:10,spid60,Unknown,* WLDAP32 76F10000 76F3DFFF 0002e000
04/25/2007 08:20:10,spid60,Unknown,* SAMLIB 5CCF0000 5CCFEFFF 0000f000
04/25/2007 08:20:10,spid60,Unknown,* ole32 77670000 777A3FFF 00134000
04/25/2007 08:20:10,spid60,Unknown,* NTMARTA 77E00000 77E21FFF 00022000
04/25/2007 08:20:10,spid60,Unknown,* SQLOS 344D0000 344D4FFF 00005000
04/25/2007 08:20:10,spid60,Unknown,* sqlevn70 4F610000 4F7A3FFF 00194000
04/25/2007 08:20:10,spid60,Unknown,* instapi 48060000 48069FFF 0000a000
04/25/2007 08:20:10,spid60,Unknown,* psapi 76B70000 76B7AFFF 0000b000
04/25/2007 08:20:10,spid60,Unknown,* comctl32 77420000 77522FFF 00103000
04/25/2007 08:20:10,spid60,Unknown,* SHLWAPI 77DA0000 77DF1FFF 00052000
04/25/2007 08:20:10,spid60,Unknown,* SHELL32 7C8D0000 7D0D2FFF 00803000
04/25/2007 08:20:10,spid60,Unknown,* NETAPI32 71C40000 71C97FFF 00058000
04/25/2007 08:20:10,spid60,Unknown,* opends60 333E0000 333E6FFF 00007000
04/25/2007 08:20:10,spid60,Unknown,* USERENV 76920000 769E3FFF 000c4000
04/25/2007 08:20:10,spid60,Unknown,* WS2HELP 71BF0000 71BF7FFF 00008000
04/25/2007 08:20:10,spid60,Unknown,* WS2_32 71C00000 71C16FFF 00017000
04/25/2007 08:20:10,spid60,Unknown,* MSWSOCK 71B20000 71B60FFF 00041000
04/25/2007 08:20:10,spid60,Unknown,* Secur32 76F50000 76F62FFF 00013000
04/25/2007 08:20:10,spid60,Unknown,* MSASN1 76190000 761A1FFF 00012000
04/25/2007 08:20:10,spid60,Unknown,* CRYPT32 761B0000 76242FFF 00093000
04/25/2007 08:20:10,spid60,Unknown,* GDI32 77C00000 77C47FFF 00048000
04/25/2007 08:20:10,spid60,Unknown,* USER32 77380000 77411FFF 00092000
04/25/2007 08:20:10,spid60,Unknown,* RPCRT4 77C50000 77CEEFFF 0009f000
04/25/2007 08:20:10,spid60,Unknown,* ADVAPI32 77F50000 77FEBFFF 0009c000
04/25/2007 08:20:10,spid60,Unknown,* MSVCP80 7C420000 7C4A6FFF 00087000
04/25/2007 08:20:10,spid60,Unknown,* msvcrt 77BA0000 77BF9FFF 0005a000
04/25/2007 08:20:10,spid60,Unknown,* MSVCR80 78130000 781CAFFF 0009b000
04/25/2007 08:20:10,spid60,Unknown,* kernel32 77E40000 77F41FFF 00102000
04/25/2007 08:20:10,spid60,Unknown,* ntdll 7C800000 7C8BFFFF 000c0000
04/25/2007 08:20:10,spid60,Unknown,* sqlservr 01000000 02BCEFFF 01bcf000
04/25/2007 08:20:10,spid60,Unknown,* MODULE BASE END SIZE
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* Access Violation occurred reading address 00000000
04/25/2007 08:20:10,spid60,Unknown,* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
04/25/2007 08:20:10,spid60,Unknown,* Exception Address = 0179438B Module(sqlservr+0079438B)
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* 04/25/07 08:20:10 spid 60
04/25/2007 08:20:10,spid60,Unknown,* BEGIN STACK DUMP:
04/25/2007 08:20:10,spid60,Unknown,*
04/25/2007 08:20:10,spid60,Unknown,* *******************************************************************************
04/25/2007 08:20:10,spid60,Unknown,SqlDumpExceptionHandler: Process 60 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
04/25/2007 08:20:10,spid60,Unknown,***Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0006.txt
04/25/2007 08:20:10,spid60,Unknown,Using 'dbghelp.dll' version '4.0.5'

View 5 Replies View Related

Reducing Like Returned Data

Jul 20, 2005

I am working on a personal project and am drawing a complete blank(too much celebrating last night?) on the SQL term that is used toeliminate multiples of like data when it is returned from thedatabase.ie, instead of ....redblueredgreenit would return ...redbluegreenSorry for the trouble and thanks.

View 2 Replies View Related

Forcing A Value If No Data Is Returned?

Jan 6, 2008

In the following procedure i write the results to a temp table called #temp1I now want to count the results of #temp1, if the count of #temp1 = 0
I want to insert 'No Records Found' into #temp.ERRORMSG else return what is in the table

any idea on how to do this?

ALTER PROC [dbo].[SPU_RPT_Savings_AnomalyDispatches] 40,'04/01/07|06/30/07'
@PropertyID varchar(4000),
@DropDown varchar(50)

AS
SELECT Client.CLIENT, Client.CLIENTID, ErrorEmailLog.ID, ErrorEmailLog.SITEID, ErrorEmailLog.PROPID, ErrorEmailLog.DISTINCTERRORS,
ErrorEmailLog.ERRORMSG, ErrorEmailLog.ERRORDATETIME, ErrorEmailLog.EMAILRECIPIENTS, Property.PROPERTY, Property.STREET,
Property.CITY, Property.STATE, Property.ZIP, Property.PHONE
INTO #TEMP1
FROM ErrorEmailLog INNER JOIN
Property ON ErrorEmailLog.PROPID = Property.PROPID INNER JOIN
Client ON Property.CLIENTID = Client.CLIENTID
WHERE (ErrorEmailLog.ERRORDATETIME BETWEEN SUBSTRING(CONVERT(VARCHAR(12), @DropDown), 0, 9)

View 3 Replies View Related