Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Mmx.exe As Encountered A Problem And As To Close


Hi,
since yesterday I have this message everytime I try to open Sql Server
"Enterprise manager"; I reinstalled the outfit completely without success

any solution

thanks

Fernand


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SQL Server Integration Services Script Task Has Encountered A Problem And Needs To Close
I am unable to debug the first Script Task (not Script Component) since adding a second Script Task in one of my packages.  The script completes successfully and goes green but the above error is displayed followed by another which is not mentioned here as I'm sure it's because of the first error.  The second script task debugs fine so I know this is not the problem.  But if I delete the second Script Task the first task starts debugging.

 

I have moved the breakpoint around in the first script and the only line that seems to work is the first line within the main method.  It's irrelevant what this first line of code does.  I know there is nothing wrong with the script tasks themselves as I have an exact copy in another package that debugs just fine.

View Replies !   View Related
MSVS2005 - &&"Microsoft Visual Studio Has Encountered A Problem And Needs To Close
We have created a data source view consisting of >500 tables. When we generate a report model using Add New Report Model Wizard, we are getting the ff. error:

"Microsoft Visual Studio has encountered a problem and needs to close...."

Error signature --------------------------------------------------------------------------

Event Type: clr20r3

P1: devenv.exe

P2: 8.0.50727.42

P3: 4333E699

P4: system.windows.forms

P5: 2.0.0.0

P6: 4333aefa

P7:1508

P8:12f

P9ystem.componentmodel.win32

-----------------------------------------------------------------------------------------------------

So the work-around is we added our Report Model manually by right-clicking Report Models>Add New Model. Then at the Report Model pane, right clicked the Model and then Autogenerate. The Report Model was successfully generated.

However, if we close our VS2005 then re-load our solution, the Report Model generated takes too much time to load. We're not even sure if it even loads since we're not waiting for it anymore and instead, delete the existing Report Model created from Autogenerate and repeat the same process all over again. Drawback is we're losing our added relationships and newly defined expressions each time we Autogenerate....

So, could you please help us in solving the error mentioned above or atleast a solution in being able to load Report Model created through Autogenerate?

By the way, we have already extended our MaxRequestLength as well as checked the Use current statistics checkbox in generating Report Model through Wizard yet neither works.

Thanks(")

View Replies !   View Related
Error: Fcb::close-flush: Operating System Error 21(The Device Is Not Ready.) Encountered
We are using sql server 2005 Enterprise Edition with service pack1

 

I got the following error messages in the SQL log

 

The operating system returned error 21(The device is not ready.) to SQL Server during a read at offset 0x00000000090000 in file '....mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.
fcb::close-flush: Operating system error 21(The device is not ready.) encountered.

I got these errors for about 2 hrs and after that I see these messages in the sql log

 

Starting up database ' '
1 transactions rolled forward in database ''  (). This is an informational message only. No user action is required.
0 transactions rolled back in database ' ' (). This is an informational message only. No user action is required.
Recovery is writing a checkpoint in database  ' ' ( ). This is an informational message only. No user action is required.
CHECKDB for database  '' finished without errors on   (local time). This is an informational message only; no user action is required.



Can anyone please help me in troubleshooting this issue. Why this migh have happened.

 

any help would be appreciated.

 

Thanks

 

 

View Replies !   View Related
&&"Execute Package Utility Has Encountered A Problem And Needs To Close&&"
I'm a SQL Server 2000 user trying to get my head around v2005, in particular the changes from DTS to Integration Services.

I've build a few packages in BIDS and they work fine there, but saving them to either the file system or MSDB locations and running them in Management Studio results in:

Execute Package Utility has encountered a problem and needs to close. We are sorry for the inconvenience.

If I click on the debug button, I get this:

An unhandled exception ('System.IO.FileNotFoundException') occurred in DTExecUI.exe [404].

I've searched the Internet and found a few people who has also experienced this, but not received any answers.

Is there a kind guru out there with some idea of what is going on? Preferably something that doesn't involve re-installing, because the database has already been configured for our Blackberry users and I can't re-do it now.

View Replies !   View Related
Sqlreader.close() And Sqlconn.close()
Hi,
My question is if I close the sqlreader i am using. will that close the connection it uses or the connection will still remain open?
Syed

View Replies !   View Related
URGENT!!! Encountered The Following...
Hi all... I've encountered the following error in NT Event Viewer - Application related to SQL Server.

"The description for Event ID ( 263 ) in Source ( CIS ) could not be found. It contains the following insertion string(s): ERROR Communication link failure for CAudit!."
&
"The description for Event ID ( 263 ) in Source ( CIS ) could not be found. It contains the following insertion string(s): Error Communication link failure in ApplicationLogon."

There are around 30-40 messages (same) in the Event Viewer & I couldn't find the cause of the problem.

& I also have this error messages in SQL Server error log (different server)

"Unable to write to ListenOn connection . pipesqlquery' loginname 'sa'. hostname 'testing'... followed by "OS Error: 232, The pipe is being closed". & this error occurs everyday & few times a day!

Not sure whether the problem is purely SQL Server or got to do with the network/NT. Can't get any help from our network/NT support until I can prove to them that it is related to network/NT!

Really need HELP!!!

Thanks in advance...

View Replies !   View Related
Divide By Zero Encountered
I'm getting such error. I want the result as blank once it's divided by zero. Is that possible?

Here's my formula:

SELECT (SUM(CASE WHEN Advoc_InfoCorec = 'No' THEN 1 ELSE 0 END) * 1.0 - SUM(CASE WHEN Info_Ofer = 'Y' THEN 1 ELSE 0 END)
* 1.0 + SUM(CASE WHEN Info_ServPolcy = 'Y' THEN 1 ELSE 0 END) + SUM(CASE WHEN Info_TodAdvan = 'Y' THEN 1 ELSE 0 END)
* 1.0 + SUM(CASE WHEN Info_UseOk = 'Y' THEN 1 ELSE 0 END) * 1.0 + SUM(CASE WHEN Info_MadChang = 'Y' THEN 1 ELSE 0 END) * 1.0)
/ (SUM(CASE WHEN Info_Ofer = 'Y' THEN 1 ELSE 0 END) * 1.0 + SUM(CASE WHEN Info_ServPolcy = 'Y' THEN 1 ELSE 0 END)
* 1.0 + SUM(CASE WHEN Info_TodAdvan = 'Y' THEN 1 ELSE 0 END) * 1.0 + SUM(CASE WHEN Info_UseOk = 'Y' THEN 1 ELSE 0 END)
* 1.0 + SUM(CASE WHEN Info_MadChang = 'Y' THEN 1 ELSE 0 END) * 1.0 + SUM(CASE WHEN Advoc_InfoCorec = 'No' THEN 1 ELSE 0 END)
* 1.0 - SUM(CASE WHEN Info_Ofer = 'Y' THEN 1 ELSE 0 END) * 1.0 + SUM(CASE WHEN Info_ServPolcy = 'Y' THEN 1 ELSE 0 END)
+ SUM(CASE WHEN Info_TodAdvan = 'Y' THEN 1 ELSE 0 END) * 1.0 + SUM(CASE WHEN Info_UseOk = 'Y' THEN 1 ELSE 0 END)
* 1.0 + SUM(CASE WHEN Info_MadChang = 'Y' THEN 1 ELSE 0 END)) * 1.0 AS Info_Other
FROM dbo.TPhones_Oct

View Replies !   View Related
Strtdb80.exe Has Encountered A Problem
After install Oracle 8.1.7 on Win XP, message "strtdb80.exe has encountereda problem and needs to close.." occurs afterrestarting comoputer..Any solution???

View Replies !   View Related
SQL 6.5 And BackupExec 7.3, Any Problems Encountered?
My company is thinking of using Veritas BackupExec Ver. 7.3 with the SQL agent to backup a 60+GB database. Has anyone encountered any problems backing up and/or restoring with this backup utility? Thank you in advance.

View Replies !   View Related
Divide By Zero Error Encountered.
How can i handle this kind of error in my execution of my storedprocedure? Error:Divide by zero error encountered.

thanks!

Funnyfrog

View Replies !   View Related
Error Encountered While Executing A UDF
Hi,

I get the following error while trying to execute a UDF.

Msg 6522, Level 16, State 1, Line 1

A .NET Framework error occurred during execution of user defined routine or aggregate 'test':

System.NullReferenceException: Object reference not set to an instance of an object.

System.NullReferenceException:

at SalesCentral_Database.UserDefinedFunctions.udfTest()

My function is defined as follows:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction(DataAccess:=DataAccessKind.Read)> _

Public Shared Function udfTest() As SqlString

SqlContext.Pipe.Send(System.DateTime.Now().ToString())

Dim conn As New SqlConnection("context connection=true")

conn.Open()

Dim cmd As New SqlCommand("SELECT MAX(ACCTPERIOD) FROM TBL_OPPORTUNITY_HIS", conn)

Return New SqlString(cmd.ExecuteScalar().ToString())

End Function

End Class

SQL Server

CREATE ASSEMBLY SalesCentral_Database from '\isew5l6c ranfSFS_SalesSalesCentral_Database.dll' WITH PERMISSION_SET = SAFE

CREATE FUNCTION test() RETURNS NVARCHAR(10) AS EXTERNAL NAME [SalesCentral_Database].[SalesCentral_Database.UserDefinedFunctions].[udfTest]

SELECT dbo.test()

- Here I get the error mentioned above. Can anyone please tell me what am I missing.

Thanks.

 

View Replies !   View Related
Errors Encountered When Inserting Data
I had been frequently encountering these errors when I run my page: "Error converting data type nvarchar to int.Cannot insert the value NULL into column 'COMPANY_CODE', table 'ZSWAREHOUSE.dbo.ZS_COMPANY_TBL'; column does not allow nulls. INSERT fails.The statement has been terminated.".  How do I solve this, so that I can insert data in my company table?

View Replies !   View Related
Unexpected EOF Encountered In BCP Data-file.
I'm getting this message on a replication distribution task after a successful SYNC task. The exact error message is:
" Unexpected EOF encountered in BCP data-file.Failed while bulk copying into '<table name>' "
I'm running SQL 6.5 Sp4.
I tried recreating the article, resyncing and redistributing, with no luck.
Is there anything I can do to fix this? Any help would be appreciated

View Replies !   View Related
Problem Encountered With Filterparameter On SQLDataSource For GridView
Hi,
I have a GridView connected to a sqldatasource control.  Everything is working great, updates, paging and filtering with one exception.  When the user enters in a name like O'Reilly (with a single quote), the page errors.  The error returned is:
Syntax error: Missing operand after 'Reilly' operator.
 Here is the definition of the sqldatasource:
        <asp:SqlDataSource ID="SqlDataSourcePersons" runat="server"             ConnectionString="<%$ ConnectionStrings:database %>"            SelectCommand="SELECT [Id], [FirstName], [LastName], , [PersonTypeId], [WorkerId], [_workerNTId], [Title], [City] FROM [Person]"            FilterExpression="(FirstName like '{0}%') AND (LastName like '{1}%') AND (WorkerId like '{2}%') AND (City like '{3}%')" ProviderName="System.Data.SqlClient">            <FilterParameters>              <asp:ControlParameter ControlID="TextBoxFirstName" Name="FirstName" DefaultValue="%" PropertyName="Text" Type="String" />              <asp:ControlParameter ControlID="TextBoxLastName" Name="LastName" DefaultValue="%" PropertyName="Text" Type="String" />              <asp:ControlParameter ControlID="TextBoxWorkerId" Name="WorkerId" DefaultValue="%" PropertyName="Text" Type="String" />              <asp:ControlParameter ControlID="TextBoxCity" Name="City" DefaultValue="%" PropertyName="Text" Type="String" />            </FilterParameters>        </asp:SqlDataSource>
Any suggestions would be appreciated.
Thank you, Jim

View Replies !   View Related
Bulk Insert: Unexpected End-of-file (EOF) Encountered...
Hi to all,I have a problem about a importation of a file *.csv with SQL Server,through a bulk insert, called in a store procedure that a c# sw calls.This is the description of the error:-----System.Data.SqlClient.SqlException č stata individuataMessage="Bulk Insert: Unexpected end-of-file (EOF) encountered indata file.
OLE DB provider 'STREAM' reported an error. The providerdid not give any information about the error.
OLE DB error trace[OLE/DB Provider 'STREAM' IRowset::GetNextRows returned 0x80004005:The provider did not give any information about the error.].
Thestatement has been terminated."Source=".Net SqlClient Data Provider"ErrorCode=-2146232060Class=16LineNumber=1Number=4832Procedure=""Server="ets3971"State=1StackTrace:at System.Data.SqlClient.SqlConnection.OnError(SqlExc eptionexception, Boolean breakConnection)atSystem.Data.SqlClient.SqlInternalConnection.OnErro r(SqlExceptionexception, Boolean breakConnection)atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObjectstateObj)at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,SqlCommand cmdHandler, SqlDataReader dataStream,BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObjectstateObj)atSystem.Data.SqlClient.SqlCommand.FinishExecuteRead er(SqlDataReader ds,RunBehavior runBehavior, String resetOptionsString)atSystem.Data.SqlClient.SqlCommand.RunExecuteReaderT ds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Booleanasync)atSystem.Data.SqlClient.SqlCommand.RunExecuteReader( CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Stringmethod, DbAsyncResult result)atSystem.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResultresult, String methodName, Boolean sendToPipe)at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at sarbox.Default.LoadFlux_Click(Object sender, EventArgs e) inc:Inetpubwwwrootarbox2.2SoxAdminDefault.aspx .cs:line 1509---Th@nks to allAB@

View Replies !   View Related
Urgent: My SQL Server Encountered A Strage Problem...
I'm trying to re-enable replication back on the server, it used to work, then we disable it for a while, then I.T. decided to change the server name, NOW, it encounters a bunch of problems when trying to configure replication....

there are a bunch of stored procedures are missing from teh MASTER database, is there are way to restore them without trashing our current production server???

also, when I try to create a missing stored procedure by copying the code from another server, sp_adddistributiondb, it gives me this error,
"Ad hoc updates to system catalogs are not enabled", what do this mean and how can i enable it.

thanks in advance with any answers/suggestions......

View Replies !   View Related
Bad Pointer Encountered While Remapping Stored Procedure
I am using SQL6.5 SP4 on NT4 SP3.

I have looked up this error in the Microsoft Knowledge base but the explanations for this error there refer to earlier versions of SQL Server.

The stored procedure uses a temporary table and INSERT ... SELECT a few times with a number of subqueries.

It doesn't use cursors or views.

This error does not always occur. I can recreate the proc, it works fine in ISQL/W, then I run my application, it reports a SQL error (just from executing the procedure), when I go back into ISQL/W I see this error message.

I added WITH RECOMPILE but this doesn't help.

Can anyone help? What I am attempting is legal SQL and not rocket science!

Regards

-Rich

View Replies !   View Related
Error Encountered While Starting The SSIS Service
I installed SQL Server 2005 Integration services on Windows XP machine. Then I went to the SQL Server Configuration Manager and tried to Start the SSIS service. The "Log On As" value is "NT AUTHORITYNetworkService". But I get the follwoing error:

The request failed or the service did not respond in a timely fashion. COnsult the event log or other applicable error logs for details.


Event Log details:
------------------
The SQL Server Integration Services service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

I tried running the service using the "Local Service" and the "Local System" accounts also, but am still encountering the same error. What do I do...

View Replies !   View Related
An Error Message I Encountered During Remote Installation
Good day good people of the forum thanks for the response this is the error message i encountered "an error occured while attempting to validate the setup source files unc path. verify that you have entered a valid unc path."

View Replies !   View Related
Do I Need To Close The Connection????
Hi all,
 
If this is used eg.
Return selectCommand.ExecuteReader(CommandBehaviour.Default)
Here  do i need to close the connection in finally explicitly????
Are there any links which can answer this kind of question ???
Thanks for any help in advance.....

View Replies !   View Related
Am I Close Or Way Off The Mark?
I am trying to select rows from a SQL2000 database table and then write a random number back into each row. I have already looked into do it all in a SP but there are well documented limitations for the SQL RAND function when called in the same batch, so I need to somehow do in .Net what I already have working in classic ASP.
I can't get the  UPDATE (part two section) to compile. I don't know how to call the stored procedure inside the 'foreach' loop or extract the SP parameters.  I have it working in classic asp but am having a lot of trouble converting to .Net 2.0.  Is the below even close to working? 
// stored procedure to write externally generated random number value into database
PROCEDURE RandomizeLinks@L_ID int,@L_Rank intASUPDATE Links SET L_Rank = @L_RankWHERE (L_ID = @L_ID)
// Part One select links that need random number inserted.
    public DataTable GetRandLinks()    {        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1A"].ConnectionString);        SqlCommand cmd = new SqlCommand("RandomizerSelect001", con);        cmd.CommandType = CommandType.StoredProcedure;        SqlDataAdapter da = new SqlDataAdapter();        da.SelectCommand = cmd;        DataSet ds = new DataSet();        try        {            da.Fill(ds, "Random001");            return ds.Tables["Random001"];        }        catch        { throw new ApplicationException("Data error"); }    }
    // Part Two I need two write a random number back into each row
    protected void Button1_Click(object sender, EventArgs e)    {        GetRandLinks();        int LinkID;               // this generates unassigned local variable "LinkID' error        int LRank;              // this generates unassigned local variable "LRank' error        SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString1A"].ConnectionString);        SqlCommand cmd2 = new SqlCommand("RandomizeLinks", con2);        cmd2.CommandType = CommandType.StoredProcedure;        cmd2.Parameters.AddWithValue("@L_ID", LinkID);        cmd2.Parameters.AddWithValue("@L_Rank", LRank);        SqlDataAdapter da2 = new SqlDataAdapter();
        int RowIncrement;        RowIncrement = 0;        DataTable dt = GetRandLinks();        foreach (DataRow row in dt.Rows)        {            System.Random myRandom = new System.Random();            int LinkRank = myRandom.Next(25, 250);            LRank = LinkRank;            da2.UpdateCommand = cmd2;            RowIncrement++;        }           }

View Replies !   View Related
@@identity... Am I Even Close Here?
string ConnectionString = ConfigurationManager.ConnectionStrings["myConnString"].ConnectionString;
SqlConnection connection = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(@"INSERT INTO CreditAppFile (GI_RB_Div) VALUES(@GI_RB_Div) SELECT @@idientity as 'NewID'", connection);
cmd.Parameters.Add("@ID", SqlDbType.BigInt, 8).Value = NewID.Text;
.
.
Response.Redirect(DisplayPage.aspx?ID=@ID);
 
i want the ID of the most recently added record to be passed to another page to show all entered data from the prior page...  am i close?

View Replies !   View Related
Close The Connection?
Hi, I've created a simple hit counter in my Session_Start event...
Dim myDataSource As New SqlDataSourcemyDataSource.ConnectionString = ConfigurationManager.ConnectionStrings("DatabaseConnectionString1").ToStringmyDataSource.UpdateCommand = "UPDATE Stats SET Hits = Hits + 1"myDataSource.Update()
It works fine but do I need to close the connection after I've finished with it or is this ok?
Thanks for your help.
 

View Replies !   View Related
ADO.net (how To Close A Reader)
Hello, I'm trying to run the following snippet as Console app, and I get an error: "a reader is already open for this connection, and should be closed first" I tried to manually say: SqlDataReader.Close() in the begining of the code, but still get the error, Any suggecstions how to manually close the reader? thank you ---------- here's the code -----------using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; namespace ADO.NET { /// <summary> /// Summary description for Class1. /// </summary> class Class1 { /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main(string[] args) { SqlConnection cn = new SqlConnection ("SERVER=MyServer; INTEGRATED SECURITY=TRUE;" + "DATABASE=AdventureWorks"); SqlCommand cmd1 = new SqlCommand ("Select * from HumanResources.Department", cn); cmd1.CommandType = CommandType.Text; try { cn.Open(); SqlDataReader rdr = cmd1.ExecuteReader(); while (rdr.Read()) { if (rdr["Name"].ToString() == "Production") { SqlCommand cmd2 = new SqlCommand("SELECT * FROM " + "HumanResources.Employee WHERE DepartmentID = 7", cn); cmd2.CommandType = CommandType.Text; SqlDataReader rdr2 = cmd2.ExecuteReader(); while (rdr2.Read()) { } rdr2.Close(); } } rdr.Close(); } catch (Exception ex) { Console.WriteLine (ex.Message); } finally { cn.Close(); } } } }

View Replies !   View Related
T-SQL CLOSE Connection To DB
How do i close a current connection to a database using t-sql?I fail some time to drop the database getting messages that it'scurrently in use.Using the wizard to delete the database, i could check the option toclose all connections to the db, but how do i do it using t-sql?best regards

View Replies !   View Related
How Do You Close Sql Connections?
how do i close an sql connection built with ado and asp?

when using sqltrace to watch the sql server, i see that an sql/asp app connections and runs a query, and even though i'm using ".close" to close the objects, the session doesn't actually close during the .close call. it appears to take about 60 seconds for each connection to close, so i assume it's simply timing out. and, is there another way to force an sql server connection to close once the query is complete? or am i coding wrong?

here's a simple example of the code i'm using:

====================
myDSN="whatever-you-want"
mySQL="select * from TABLENAME where NAME='YADA'"

set conntemp=server.createobject("adodb.connection")
conntemp.open MyDSN
set xtemp=conntemp.execute(mySQL)

xtemp.close
set xtemp=nothing
conntemp.close
set conntemp=nothing
========================

View Replies !   View Related
How Can I Close A Cursor?
Hi guys.

is there anyway I can find a cursor that is open
so that i can close it?

I have a procedure running daily (across servers). that stopped suddenly with this error.

A cursor with the name 'xyz' already exists.

I tried closing and deallocating on destination server. I am getting the error like "cursor doesnot exist"

I need to run this procedure. i dont want to recycle the destination server.

any ideas?
-MAK

View Replies !   View Related
How To Close CN Connection To A SDF Db
 

Hello all,
 
I have a DB on my WM2005 device.
I'm using a program which connect to the DB using a CN.
On the constructor of the DB Class I use the line
 

static string connString = "Data Source='" + strDB + "'; LCID=1033; Password=" + strPass + "; Encrypt = FALSE;";
SqlCeConnection cn = new SqlCeConnection(connString);

 
Then I Open the Connection.
Now, in some ways I need to drop a Table.
Before I do so, I disconnect the DB but I'm using only the line

cn.Close();

 
I saw om the Watch attributes that its not a real disconnect to the DB.
When I try to Drop the Table I get this message:
The system timed out waiting for a lock. [ Session id = 25,Thread id = -2096711882,Process id = -2090594918,Table name = Movies,Conflict type = x lock (s blocks),Resource = DDL ]

 
And the Table doesn't drop.
 
Is it related to the constructor line I made?
What is the best solution to Drop a table..and then to get connected again with the DB.
 
Thanks in advance..

View Replies !   View Related
Encountered Problems With Multiple Common Table Expression
Hi guys,

I'm trying to have two common table expression in my stored procedure, but I'm receiving errors when executing it, I found that they can't exist side by side,once I removed 1 of them, the stored procedure executed successfully.

The following are the errors

Code:


Msg 156, Level 15, State 1, Procedure GetProductsByCategory, Line 27
Incorrect syntax near the keyword 'With'.
Msg 319, Level 15, State 1, Procedure GetProductsByCategory, Line 27
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
Msg 319, Level 15, State 1, Procedure GetProductsByCategory, Line 33
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.



I'm using SQL Server Express

View Replies !   View Related
The ExistsOnSQLServer Method Has Encountered OLE DB Error Code 0x80004005
I export data from a dozen tables of one database to another database on another server regularly and it works well.  However, if i choose the option of "save SSIS package", I get the following error:

TITLE: SQL Server Import and Export Wizard
------------------------------

The operation could not be completed.

------------------------------
ADDITIONAL INFORMATION:

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement issued has failed.


------------------------------
BUTTONS:

OK
------------------------------


 

I use management studio to do this, but the servers are 2000.

Does anyone have any clue about this?

 

View Replies !   View Related
SQL Server Mobile Encountered Problems When Opening The Database.
Hi,

I am writing an application for a device (HP IPAQ 6828) having Windows Mobile 5.0 using

-MS .NET Compact Framework 2.0 SP-1 
-SQL Mobile 2005.
-VS 2005 .NET

The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.

"SQL Server Mobile encountered problems when opening the database."

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
I
also checked the the connection string and it seems to be fine. Both my
device and  server can ping each other. Moreever I can also access the
Web syncronization folder(on server) from the device.Is anyone having a resolution for this?

View Replies !   View Related
Error Encountered While Installing SQL Server Express Edition
I encountered an error when attempting to install Visual Basic Express Edition RTM. During the setup, I selected MSDN Express Edition and SQL Server 2005 Express Edition. Specifically, the SQL Server 2005 EE part of the installation failed. Here's the error I received:

Visual Basic 2005 Express Edition Setup
Error occurred during setup
Visual Basic 2005 Express Edition has been successfully installed.
The following component failed to install:
Microsoft SQL Server 2005 Express Edition x86

I had not installed any betas on this particular PC; however, I had already installed Visual Studio 2005 Pro and SQL Server 2005 Developer Edition.

(I selected SQL Server EE during the VBEE install because the VBEE readme said that the VSEE Editions (except for VWD) only work with SQL Server EE--so I figured I had to install SQL Server EE if I wanted to do any database work with VBEE. Is that the case?)

The following two log files were the only ones containing any error messages. How should I proceed?

C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core.log:
Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:40:32 2005
Process ID      : 5824
c:211395ac6e4ed715363fsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/11/19 14:40:31
Complete: LoadResourcesAction at: 2005/11/19 14:40:31, returned true
Running: ParseBootstrapOptionsAction at: 2005/11/19 14:40:31
Loaded DLL:c:211395ac6e4ed715363fxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:40:32, returned true
Running: ValidateWinNTAction at: 2005/11/19 14:40:32
Complete: ValidateWinNTAction at: 2005/11/19 14:40:32, returned true
Running: ValidateMinOSAction at: 2005/11/19 14:40:32
Complete: ValidateMinOSAction at: 2005/11/19 14:40:32, returned true
Running: PerformSCCAction at: 2005/11/19 14:40:32
Complete: PerformSCCAction at: 2005/11/19 14:40:32, returned true
Running: ActivateLoggingAction at: 2005/11/19 14:40:32
Complete: ActivateLoggingAction at: 2005/11/19 14:40:32, returned true
Running: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32
Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5824" returned false.
Running: PerformSCCAction2 at: 2005/11/19 14:40:32
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435
Complete: PerformSCCAction2 at: 2005/11/19 14:40:33, returned true
Running: PerformDotNetCheck at: 2005/11/19 14:40:33
Complete: PerformDotNetCheck at: 2005/11/19 14:40:33, returned true
Running: ComponentUpdateAction at: 2005/11/19 14:40:33
Complete: ComponentUpdateAction at: 2005/11/19 14:41:6, returned true
Running: DetectLocalBootstrapAction at: 2005/11/19 14:41:6
Complete: DetectLocalBootstrapAction at: 2005/11/19 14:41:6, returned true
Running: LaunchLocalBootstrapAction at: 2005/11/19 14:41:6
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run:
"c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1706
Aborting queue processing as nested installer has completed
Message pump returning: 1706

C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core(Local).log:
Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:41:10 2005
Process ID      : 5476
c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2005/11/19 14:41:9
Complete: LoadResourcesAction at: 2005/11/19 14:41:9, returned true
Running: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9, returned true
Running: ValidateWinNTAction at: 2005/11/19 14:41:9
Complete: ValidateWinNTAction at: 2005/11/19 14:41:9, returned true
Running: ValidateMinOSAction at: 2005/11/19 14:41:9
Complete: ValidateMinOSAction at: 2005/11/19 14:41:9, returned true
Running: PerformSCCAction at: 2005/11/19 14:41:9
Complete: PerformSCCAction at: 2005/11/19 14:41:9, returned true
Running: ActivateLoggingAction at: 2005/11/19 14:41:9
Complete: ActivateLoggingAction at: 2005/11/19 14:41:10, returned true
Running: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10
Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10, returned true
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5476" returned false.
Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions:
Condition "Setup is running locally." returned true.
Running: PerformDotNetCheck2 at: 2005/11/19 14:41:10
Complete: PerformDotNetCheck2 at: 2005/11/19 14:41:12, returned true
Running: InvokeSqlSetupDllAction at: 2005/11/19 14:41:12
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0
<Func Name='DwLaunchMsiExec'>
Examining 'sqlspars' globals to initialize 'SetupStateScope'
Opening 'MachineConfigScope' for [US05046]
Trying to find Product Code from command line or passed transform
If possible, determine install id and type
Trying to find Instance Name from command line.
No Instance Name provided on the command line
If possible, determine action
Machine = US05046, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = US05046, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = US05046, Article = XMLDomDocument, Result = 0 (0x0)
Machine = US05046, Article = Processor, Result = 0 (0x0)
Machine = US05046, Article = PhysicalMemory, Result = 0 (0x0)
Machine = US05046, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = US05046, Article = OSVersion, Result = 0 (0x0)
Machine = US05046, Article = OSServicePack, Result = 0 (0x0)
Machine = US05046, Article = OSType, Result = 0 (0x0)
Machine = US05046, Article = AdminShare, Result = 0 (0x0)
Machine = US05046, Article = PendingReboot, Result = 0 (0x0)
Machine = US05046, Article = IEVersion, Result = 0 (0x0)
Machine = US05046, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = US05046, Article = COMPlus, Result = 0 (0x0)
Machine = US05046, Article = ASPNETVersionRegistration, Result = 0 (0x0)
*******************************************
Setup Consistency Check Report for Machine: US05046
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2005/11/19 14:42:59, returned true
Running: SetPackageInstallStateAction at: 2005/11/19 14:42:59
Complete: SetPackageInstallStateAction at: 2005/11/19 14:43:1, returned true
Running: DeterminePackageTransformsAction at: 2005/11/19 14:43:1
Complete: DeterminePackageTransformsAction at: 2005/11/19 14:43:5, returned true
Running: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5
Complete: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5, returned true
Running: OpenPipeAction at: 2005/11/19 14:43:5
Complete: OpenPipeAction at: 2005/11/19 14:43:5, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2005/11/19 14:43:5
Complete: CreatePipeAction at: 2005/11/19 14:43:5, returned false
Error: Action "CreatePipeAction" failed during execution.
Action "RunRemoteSetupAction" will be skipped due to the following restrictions:
Condition "Action: CreatePipeAction has finished and passed." returned false.
Running: PopulateMutatorDbAction at: 2005/11/19 14:43:5
Complete: PopulateMutatorDbAction at: 2005/11/19 14:43:5, returned true
Running: GenerateRequestsAction at: 2005/11/19 14:43:5
 SQL_Engine = 3
 SQL_Data_Files = 3
 SQL_Replication = 3
 SQL_FullText = -1
 SQL_SharedTools = 3
 SQL_BC_DEP = -1
 Analysis_Server = -1
 AnalysisDataFiles = -1
 AnalysisSharedTools = -1
 RS_Server = -1
 RS_Web_Interface = -1
 RS_SharedTools = -1
 Notification_Services = -1
 NS_Engine = -1
 NS_Client = -1
 SQL_DTS = -1
 Client_Components = 3
 Connectivity = 3
 SQL_Tools90 = -1
 SQL_WarehouseDevWorkbench = -1
 SDK = 3
 SQLXML = -1
 Tools_Legacy = -1
 TOOLS_BC_DEP = -1
 SQL_Documentation = -1
 SQL_BooksOnline = -1
 SQL_DatabaseSamples = -1
 SQL_AdventureWorksSamples = -1
 SQL_AdventureWorksDWSamples = -1
 SQL_AdventureWorksASSamples = -1
 SQL_Samples = -1
Complete: GenerateRequestsAction at: 2005/11/19 14:43:11, returned true
Running: CreateProgressWindowAction at: 2005/11/19 14:43:11
Complete: CreateProgressWindowAction at: 2005/11/19 14:43:12, returned false
Error: Action "CreateProgressWindowAction" failed during execution.
Running: ScheduleActionAction at: 2005/11/19 14:43:12
Complete: ScheduleActionAction at: 2005/11/19 14:43:13, returned true
Skipped: InstallASAction.11
Skipped: Action "InstallASAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.18
Skipped: Action "InstallASAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.22
Skipped: Action "InstallASAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result.
Skipped: InstallASAction.9
Skipped: Action "InstallASAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result.
Skipped: InstallDTSAction
Skipped: Action "InstallDTSAction" was not run.  Information reported during analysis:
No install request found for package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.11
Skipped: Action "InstallDTSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.12
Skipped: Action "InstallDTSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.18
Skipped: Action "InstallDTSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.22
Skipped: Action "InstallDTSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result.
Skipped: InstallDTSAction.9
Skipped: Action "InstallDTSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result.
Skipped: InstallNSAction
Skipped: Action "InstallNSAction" was not run.  Information reported during analysis:
No install request found for package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.11
Skipped: Action "InstallNSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.12
Skipped: Action "InstallNSAction.12" was not run.  Information reported during analysis:
No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.18
Skipped: Action "InstallNSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.22
Skipped: Action "InstallNSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result.
Skipped: InstallNSAction.9
Skipped: Action "InstallNSAction.9" was not run.  Information reported during analysis:
No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result.
Skipped: InstallRSAction.11
Skipped: Action "InstallRSAction.11" was not run.  Information reported during analysis:
No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.18
Skipped: Action "InstallRSAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result.
Skipped: InstallRSAction.22
Skipped: Action "InstallRSAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result.
Running: InstallSqlAction.11 at: 2005/11/19 14:43:14
Installing: sqlsupport on target: US05046
Complete: InstallSqlAction.11 at: 2005/11/19 14:43:26, returned true
Running: InstallSqlAction.12 at: 2005/11/19 14:43:26
Installing: sqlncli on target: US05046
Complete: InstallSqlAction.12 at: 2005/11/19 14:43:40, returned true
Skipped: InstallSqlAction.18
Skipped: Action "InstallSqlAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "sql", install will be skipped as a result.
Running: InstallSqlAction.21 at: 2005/11/19 14:43:40
Installing: sqlwriter on target: US05046
Failed to install package
Fatal error during installation.
Setting package return code to: 1706
Complete: InstallSqlAction.21 at: 2005/11/19 14:43:50, returned false
Error: Action "InstallSqlAction.21" failed during execution.  Error information reported during run:
Target collection includes the local machine.
Invoking installPackage() on local machine.
Skipped: InstallSqlAction.22
Skipped: Action "InstallSqlAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "sql", install will be skipped as a result.
Running: InstallSqlAction.9 at: 2005/11/19 14:43:50
Installing: msxml6 on target: US05046
Complete: InstallSqlAction.9 at: 2005/11/19 14:43:54, returned true
Running: InstallToolsAction.11 at: 2005/11/19 14:43:54
Installing: sqlsupport on target: US05046
Complete: InstallToolsAction.11 at: 2005/11/19 14:44:2, returned true
Running: InstallToolsAction.12 at: 2005/11/19 14:44:2
Installing: sqlncli on target: US05046
Complete: InstallToolsAction.12 at: 2005/11/19 14:44:11, returned true
Skipped: InstallToolsAction.13
Skipped: Action "InstallToolsAction.13" was not run.  Information reported during analysis:
No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.18
Skipped: Action "InstallToolsAction.18" was not run.  Information reported during analysis:
No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.20
Skipped: Action "InstallToolsAction.20" was not run.  Information reported during analysis:
No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result.
Skipped: InstallToolsAction.22
Skipped: Action "InstallToolsAction.22" was not run.  Information reported during analysis:
No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result.
Running: InstallToolsAction.9 at: 2005/11/19 14:44:11
Installing: msxml6 on target: US05046
Complete: InstallToolsAction.9 at: 2005/11/19 14:44:15, returned true
Action "InstallSqlAction" will return false due to the following preconditions:
Condition "Action: InstallSqlAction.21 has finished and failed." returned true.
Installation of package: "sql"  failed due to a precondition.
Step "InstallSqlAction" was not able to run.
Skipped: InstallNSAction.10
Skipped: Action "InstallNSAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result.
Running: InstallToolsAction at: 2005/11/19 14:44:15
Installing: tools on target: US05046
Complete: InstallToolsAction at: 2005/11/19 14:44:26, returned true
Skipped: InstallToolsAction.10
Skipped: Action "InstallToolsAction.10" was not run.  Information reported during analysis:
No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.
Skipped: RepairForBackwardsCompatRedistAction
Skipped: Action "RepairForBackwardsCompatRedistAction" was not run.  Information reported during analysis:
Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Error: Action "UninstallForMSDE2000Action" failed during execution.  Error information reported during run:
Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchMSDE2000"  failed due to a precondition.
Error: Action "UninstallForSQLAction" failed during execution.  Error information reported during run:
Action: "UninstallForSQLAction" will be marked as failed due to the following condition:
Condition "sql was successfully upgraded." returned false. Condition context:
sql failed to upgrade and so the uninstall of the upgraded product will not occur.
Installation of package: "patchLibertySql"  failed due to a precondition.
Skipped: InstallASAction
Skipped: Action "InstallASAction" was not run.  Information reported during analysis:
No install request found for package: "as", install will be skipped as a result.
Skipped: InstallRSAction
Skipped: Action "InstallRSAction" was not run.  Information reported during analysis:
No install request found for package: "rs", install will be skipped as a result.
Skipped: UninstallForRS2000Action
Skipped: Action "UninstallForRS2000Action" was not run.  Information reported during analysis:
Action: "UninstallForRS2000Action" will be skipped due to the following condition:
Condition "Action: InstallRSAction was skipped." returned true.
Running: ReportChainingResults at: 2005/11/19 14:44:27
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1706
        Error Code: 0x800706aa (1706)
Windows Error Text: The endpoint format is invalid.

  Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep  1 22:23:05 2005
     Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3097

---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
sqls::HighlyAvailablePackage::manageVsResources
ce: 29539

Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_US05046_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0003.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2005/11/19 14:44:52
Message pump returning: 1706

View Replies !   View Related
OLEDB Error Encountered Calling ICommandText:: Execute
OLEDB error encountered calling ICommandText:: execute  ; hr = 0x80040e14 .
SQLSTATE : 42000 , Native Error : 3013
Error state 1 , Severity : 16
Source : Microsoft OLE DB Provider for SQL Server
Error Message : Backup Database is terminating abnormally
 

View Replies !   View Related
Report Server Has Encountered A SharePoint Error. (rsSharePointError)
Ive seen this asked all over but am yet to find a fix for my case.

I have 1 SharePoint 2007 server
1 SQL 2005 SP2 server with Reporting services running

Reporting services is configured and running all with ticks in SharePoint integration mode, the reporting services section shows up in Central Admin ok.

When I try to access reporting services I get the error :

http://reports.domain/reportserver


Report Server has encountered a SharePoint error. (rsSharePointError) Get Online Help

For more information about this error navigate to the report server on the local server machine, or enable remote errors Looking thru the logs I get the error :

w3wp!library!d!04/04/2008-13:54:20:: Call to GetItemTypeAction(/).
w3wp!library!d!04/04/2008-13:54:20:: Call to ListParentsAction(/).
w3wp!library!d!04/04/2008-13:54:20:: Call to ListChildrenAction(/, False).
w3wp!library!d!04/04/2008-13:54:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.SharePointException: Report Server has encountered a SharePoint error. ---> System.NullReferenceException: Object reference not set to an instance of an object.
   at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.internalFindObjectsNonRecursive(String wssUrl, CatalogItemList& children)
   at Microsoft.ReportingServices.SharePoint.Server.SharePointDBInterface.FindObjectsNonRecursive(String wssUrl, CatalogItemList& childList, Security secMgr, IPathTranslator pathTranslator, Boolean appendMyReports)
   --- End of inner exception stack trace ---

I setup a new website called RS Web Site in IIS on the SQL box, I then set this in the Configure Report Server. I have made sure Annonymous access is off.

Does anyone know how on earth I can resolve this ..

Many Thanks

Marcus

View Replies !   View Related
Error:sql Mobile Encountered Problems When Opening The Database
I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:

sql mobile encountered problems when opening the database

It happens when I sync data.

However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.

--when i run on my PPC (HP ra1950), there is no this error message.

I think it is a bug?

BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ???)

Please help me out. Thanks


James

View Replies !   View Related
SQL Server CE Encountered Problems In Creating The SQL Sever CE Database.
My exploit environment:
VS.net 2003, SQL Server 2000 SP4, SQL Server CE 2.0 SP4
 
I write next codes:
Private cn As New SqlCeConnection("data source=my documentsSQLCECF.sdf")
 
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Try
            If Not System.IO.File.Exists("my documentsSQLCECF.sdf") Then
                Dim en As New SqlCeEngine("data source=my documentsSQLCECF.sdf")
                en.CreateDatabase() 'create a blank database to subscribe
                Synch()
            End If
        Catch err As SqlCeException
            ShowErrors(err)
        Catch err As Exception
            MsgBox("There was an error:" & err.ToString())
        End Try
    End Sub
 
    Sub Synch()
        Try
            Dim rep As SqlCeReplication = New SqlCeReplication
            With rep
                .Publisher = "192.168.0.222"
                .PublisherDatabase = "CFLab"
                .PublisherLogin = "sa"
                .PublisherPassword = "sa"
                .Publication = "CFLab"
                .Subscriber = "SQLCENETCF"
                .SubscriberConnectionString = "Provider=Microsoft.SQLServer.OLEDB.CE.2.0;Data Source=My DocumentsSQLCECF.sdf"
                .InternetUrl = "http://192.168.0.222/SQLCE/sscesa20.dll"
                ' Create the Local SSCE Database subscription
                rep.AddSubscription(AddOption.CreateDatabase)
                rep.Synchronize() 'subscribe
            End With
 
        Catch err As SqlCeException
            ShowErrors(err)
        Finally
 
        End Try
    End Sub
 
    Public Sub ShowErrors(ByRef e As SqlCeException)
 
        Dim errorCollection As SqlCeErrorCollection = e.Errors
        Dim bld As System.Text.StringBuilder = New System.Text.StringBuilder
        Dim inner As Exception = e.InnerException
 
        If Not inner Is Nothing Then
            MessageBox.Show(("Inner Exception:" & inner.ToString()))
        End If
 
        For Each err As SqlCeError In errorCollection
            bld.Append("/n Error Code: " + err.HResult.ToString("X", System.Globalization.CultureInfo.CurrentCulture))
            bld.Append("/n Message : " + err.Message)
            bld.Append("/n Minor Err.: " + err.NativeError.ToString())
            bld.Append("/n Source : " + err.Source)
 
            For Each numPar As Int32 In err.NumericErrorParameters
 
                If 0 <> numPar Then
                    bld.Append("/n Num. Par. : " + numPar.ToString())
                End If
 
            Next
 
            For Each errPar As String In err.ErrorParameters
 
                If String.Empty <> errPar Then
                    bld.Append("/n Err. Par. : " + errPar)
                End If
 
            Next errPar
 
            MessageBox.Show(bld.ToString())
            bld.Remove(0, bld.Length)
 
        Next err
    End Sub
 
    Private Sub btnShow_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShow.Click
        connect()
 
        Dim query As String = "select * from FlightData"
        Dim dap As New SqlCeDataAdapter(query, cn)
        Dim dataset1 As New DataSet
            dap.Fill(dataset1, "FlightData")
 
            Disconnect()
    End Sub
    Sub connect()
            Synch()
        Try
            cn.Open()
        Catch err As SqlCeException
            ShowErrors(err)
        End Try
    End Sub
    Sub Disconnect()
        Try
            cn.Close()
        Catch err As SqlCeException
            ShowErrors(err)
        End Try
    End Sub
 
    Private Sub dgdResults_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dgdResults.Click
 
    End Sub
End Class
 
I want to synchronize the data from a SQLCE SERVER 2000
When i run the code above, the errors show:
Error Code:80040E17
MessageQL Server CE encountered problems in creating the SQL Sever CE database.
 
Error Code:80040E17
A data source with the specified name already exists.
 
I do not know what's going wrong..=(
Who can help me??!!! HELP~~~~~~~~~
thanks..

View Replies !   View Related
How Do You Close The Connection At The SQL Server?
How do you close the connection at the SQL Server? I have a backup I want to resotre to SQLExpress using SQL Management Studio Express. When I try, the SQL tells me he can't because the database is in use. I don't realy care about this I still want to restore the database. So I figured it's because there are some active connection to the database. My gues is I have to close those, but how? I also know I can restart SQLExpress and the connection will drop, but this server has more then one database, so I cant always do that. I'm looking for some T-SQL like DROP ALL CONNECTION.
Thanks for the help.

View Replies !   View Related
Close Connections Explicitly
Hi everybody,How is it possible to close any open connections from the connection pool explicitly like on the log off page? So when the users log off from the application I want to close all connections that were opened during the use of application.asp.net forums is the best....thanks,Murthy here 

View Replies !   View Related
Where Close Sqlconnection In BasePage ?
I am inheriting all my webpages from a BasePage which is storing my sqlconnection to the database. I open the connection in the "protected override void OnInit()" method (is this right?) but I don't know where I should write the close the connection. Can anyone give me any suggestions?
 Regards
EO
 

View Replies !   View Related
Is It Posiable To Close The Screen
HaiIs it possiable to close the current connection screen in the queryanalyser , not to close the query analyser.With ThanksRaghu

View Replies !   View Related
SqlConnection.Close() Not Working
 

Hi,
 
This is VERY VERY simple.
 
Here's a code test I did place in the Form_Load of my C#.NET app.
 

SqlConnection cnn = new SqlConnection();

cnn.ConnectionString = "bla bla...";

cnn.Open();

cnn.Close();

cnn.Dispose();

 
In SQL SERVER PROFILER, the Audit Login takes place as soon as I hit the .Open()
but when I hit the .Close() OR the .Dispose() there's no Audit Logout.  The Audit Logout is issued only
when I quit the application.
 
Is there someone to explain this behaviour ?
 
Thank you
 

View Replies !   View Related
Conversation Lifetime After Close
Given that the conversation states are as follows:  (Thanks Rushi!)

Event                                         Initiator Endpoint state       Target Endpoint state






BEGIN DIALOG                         SO                                    --
 from Initiator
 to Target                                     

SEND message(s)                     CO                                    --
  from Initiator
  to Target                   

Target receives a fragment        CO                                     SI
 of the first message sent
 or receives out of order 
 message

Target received entire               CO                                     CO
 first message

END conversation at                 CO                                     DO
 target

Initiator receives EndDialog       DI                                      DO
 message from target

Target receives ACK for the       DI                                       CD
 EndDialog message sent

END conversation at                 CD                                      CD
 Initiator

When does the 30 minute timer start for clearing the conversation from the sys.conversation_handles table?  Is it the same for both sides (initiator and Target) ie, the end conversation at the Initiator.  I guess it must be just in case a resend is necessary.

Gary

 

View Replies !   View Related
Why Do My Endpoint Connections Never Close?
Problem:  Connections to SOAP endpoints never close even if app initiating call was shutdown several days earlier.  Create Endpoint statement included at bottom
 
Questions:
1 Why?
2. Is there a configuration option I need to set?
 
[1] Client side: Multiple clients from XMLSpy running on XP Pro to WebSphere Process Server running on AIX
 
[2] Server side:
 

What is the MS SQL version?  SQL Server 2005  SP2

What is the SKU of MS SQL? Enterprise

What is the SQL Server Protocol enabled?  Shared Memory | and TCPIP

Does the server start successfully? YES 
If SQL Server is a named instance, is the SQL browser enabled? YES

What is the account that the SQL Server is running under? Domain Account
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? NO

Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance. NO
[2a]  Tool Used to Connect: Multiple clients from XMLSpy running on XP Pro to WebSphere Process Server running on AIX
 
 
[3] Platform:

What is the OS version?Windows 2003 SP2
Do you have third party antivirus, anti-spareware software installed? McAfee.  Exceptions have been set in accordance with MS SQL Server documentation
 
ENDPOINT:

CREATE ENDPOINT [TestEndpoint]


AUTHORIZATION [AuthID]

STATE=STARTED

AS HTTP (PATH=N'/SqlSSL/testEndpoint', PORTS = (SSL), AUTHENTICATION = (BASIC),


SITE=N'Win2003.ent.corp.net', SSL_PORT = 443, COMPRESSION=DISABLED)

FOR SOAP (


WEBMETHOD 'PutTestResponse'( NAME=N'[UserDb].[schema].[usp_test]'


, SCHEMA=DEFAULT

, FORMAT=ALL_RESULTS),

BATCHES=DISABLED,

WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]',

SESSIONS=ENABLED, SESSION_TIMEOUT=10,

DATABASE=N'UserDb',

NAMESPACE=N'http://tempTestEndpoint.org',

SCHEMA=STANDARD, CHARACTER_SET=XML)
 

View Replies !   View Related
Close ReportViewer After Print
is it possible to close automatically report preview after user's print 

Noticed there is event print but it fires *before* printers dialog show

I need somethink like AfterPrint



Plz help

View Replies !   View Related
Close Connection Of SQLExpress!
Hi,

I write a .NET Windows Form that connect to SQLExpress datafile. After updating data, I want to zip the .mdf file and send email. However, I got an exeption that the .mdf file is used by other thread so I cant zip. Even I try to close all connection, I still cant zip.

Is there any way to detach/unlock .mdf file connecting by SQLExpress?

MA.

 

 

View Replies !   View Related
Does Anyone Have Some Quick Sample Code For Retrying A SQL Command When A Deadlock Is Encountered?
I found a few samples but they all seemed overly complicated.  Does anyone have a quickie solution that works?
 
Thanks

View Replies !   View Related
Error Encountered When My Server Report Drillsthrough Multiple Levels...
I created 3 reports and when you drillthrough more than one level, or attempt to go back I recieve the following error:

 
The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)



 

Has anyone else encountered this error or have any idea on how I can fix this??? I'm using VS2k5 SP1 & MSSQL 2005DE

View Replies !   View Related
SQL Server Compact Edition Encountered Problems When Opening The Database
I'll try and ask one more time.  Does anyone have a clue how to fix this?

"A SQL Server Compact Edition DLL could not be loaded. Reinstall SQL Server Compact Edition. [ DLL Name = sqlceca30.dll ]"

or

"SQL Server Compact Edition encountered problems when opening the database"
"Internal error: The database is not initialized."


I've been fighting this for well over a week now.  My XP based version works fine but this error occurs routinely on my CE4.2 device.   I cannot find anything meaningful using Google other than 'look for non disposed' replication objects which I've done.  Is this bad hardware?  I don't believe I'm out of memory as the app is about 1.2MB including about 8 DLL's and GC indicates I have about 300KB of objects at the time of the failure. I also use a bunch of static (global) objects that I use throughout the code.

It would be nice if I could get the lower level error messages causing these failures but that is probably too much to ask.

The odd thing is that it's only the replication engine that fails as even after the failure, the app can reopen the DB and work with the data just fine.

My basic order of the application is...

1 Open DB SqlCEConnection
2 Create/Prepare any SqlCECommand objects
3 Do work here
4 Dispose any SqlCECommand objects
5 Close DB
6 Dispose SqlCEConnection object
7 Create SqlCEReplication object
8 BeginSynchronize
9 ... error here..
10 Dispose SqlCEReplication object
11 Reopen DB SqlCEConnection


I've tried creating the Replication object at program start and that does not help.  I'm guessing there is something about .net that I don't understand either with stack space, # dll's or whatever.   I've rearranged the order of the Dispose, Create,  SQL CE objects to include just about every permutation but still am hitting this same problem.

Are there any tools that can help me profile this app for memory problems or usage?  Everything seems geared for .Net and not .NetCF.

thanks.

View Replies !   View Related
Should You Close Connections And Datasets, Sqldatasource
should u always close everys sqldatasource connection string and the dataset associated with it,
 if so how do u do that (ie the proper way) and is it possible to to do it in the session area of global.aspx, NEt 2.0 or should it be done when exiting the page containing the data stuff,
 also same question for NET 1.0 datasets and adapters and strings,
 

View Replies !   View Related
SqlDataReader Object Not Wanting To Close
Hi I have double checked my code and cannot pin down why I am getting the error "There is already an open DataReader associated with this Command which must be closed first. "
on the lne:
Line 95:                        DR_IndJobPostings = oComm_IndPostings.ExecuteReader();
I have closed the DR_IndJobPostings object after every use of it as see n on line number 175
 
----------- Code--------------1 /// <summary>
2 /// Will generate and email job alerts based on the frequency
3 /// </summary>
4 /// <param name="frequency">WEEKLY or MONTHLY</param>
5 /// <param name="oServerIN">Instance of Server from ASPX page</param>
6 public void hk_DoAlertByFreq(string frequency, HttpServerUtility oServerIN)
7 {
8 SqlConnection oConn = new SqlConnection(ConfigurationSettings.AppSettings["CString"]);
9 oConn.Open();
10
11 SqlCommand oComm;
12
13 emailSystems oEmail = new emailSystems();
14 HttpServerUtility oServer = oServerIN;
15
16 bool validCall = false;
17 bool industryHasPostings = false;
18 string sEmail = "";
19 string sEmailTemplate = "";
20 string sVacListForEmail = "";
21
22 int IJPost_VacId = 0;
23 int IJPost_EmpId = 0;
24 string IJPost_Req = "";
25 string IJPost_KeyRes = "";
26 string IJPost_VacTitle = "";
27 string IJPost_VacJobTitle = "";
28 string IJPost_VacUrl = "";
29
30 int loopCounter1 = 0;
31
32 string CandEmailAddress = "";
33
34 oComm = new SqlCommand();
35 oComm.Connection = oConn;
36 oComm.CommandType = CommandType.Text;
37
38 SqlCommand oComm_IndPostings = new SqlCommand();
39 oComm_IndPostings.Connection = oConn;
40
41 SqlDataReader DR_Industries;
42 SqlDataReader DR_IndJobPostings;
43 SqlDataReader DR_AlertList;
44
45 if (frequency == "WEEKLY" || frequency == "MONTHLY")
46 {
47 validCall = true;
48 }
49
50 if (validCall)
51 {
52 if (frequency == "WEEKLY")
53 {
54 sEmailTemplate = oEmail.readTextFile("/email_templates/weeklyJobAlert.txt");
55 }
56
57 if (frequency == "MONTHLY")
58 {
59 sEmailTemplate = oEmail.readTextFile("/email_templates/monthlyJobAlert.txt");
60 }
61
62 sSql = "" +
63 "SELECT [id],[industry] FROM S_Utils_Industries " +
64 "WHERE [active] = 1";
65 oComm.CommandText = sSql;
66 DR_Industries = oComm.ExecuteReader();
67
68 if (DR_Industries.HasRows)
69 {
70 //
71 // Loop through each active industry
72 //
73 while (DR_Industries.Read())
74 {
75 industryHasPostings = false;
76 iCurrentIndustryId = (int)DR_Industries.GetSqlInt32(0);
77 sCurrentIndustryText = DR_Industries.GetSqlString(1).ToString();
78
79 // Get all active vacancy postings for this
80 // industry
81 sSql = "SELECT [id]," +
82 "[emp_id], " +
83 "[vac_Requirements]," +
84 "[vac_KeyResp]," +
85 "[vac_VacTitle]," +
86 "[vac_VacJobTitle]," +
87 "FROM [S_Vacancies] " +
88 "WHERE [vac_VacIndustry_Id] = " + iCurrentIndustryId.ToString() + " AND " +
89 "[status] = 1 AND " +
90 "[vac_ListingStart] >= '" + gf.SqlDateTimeFormat(DateTime.Today,1) + "' AND " +
91 "[vac_ListingEnd] < '" + gf.SqlDateTimeFormat(DateTime.Today, 1) + "'";
92
93 oComm_IndPostings.CommandText = sSql;
94
95 DR_IndJobPostings = oComm_IndPostings.ExecuteReader();
96
97 //
98 // If there are job vacancy postings for the industries
99 //
100 if (DR_IndJobPostings.HasRows)
101 {
102 industryHasPostings = true;
103 sEmail = sEmailTemplate;
104
105 //
106 // Loop through the job postings for this industry
107 //
108 while (DR_IndJobPostings.Read())
109 {
110 IJPost_VacId = (int)DR_IndJobPostings.GetSqlInt32(0);
111 IJPost_EmpId = (int)DR_IndJobPostings.GetSqlInt32(1);
112 IJPost_Req = DR_IndJobPostings.GetSqlString(2).ToString();
113 IJPost_KeyRes = DR_IndJobPostings.GetSqlString(3).ToString();
114 IJPost_VacTitle = DR_IndJobPostings.GetSqlString(4).ToString();
115 IJPost_VacJobTitle = DR_IndJobPostings.GetSqlString(5).ToString();
116 IJPost_VacUrl = "http://www.mann-power.net/vJDetails_FromFront.aspx?vid=" + IJPost_VacId.ToString() + "&from=myjobs";
117
118 sVacListForEmail += IJPost_VacTitle + @"
119
120 Job title: " + IJPost_VacJobTitle + @"
121
122 Key Responsibilities
123 " + IJPost_KeyRes + @"
124
125 Requirements
126 " + IJPost_Req + @"
127
128 " + IJPost_VacUrl + @"
129
130 ============================================================
131
132 ";
133 }
134
135
136 sEmail = sEmail.Replace("{VACANCYLIST}", sVacListForEmail);
137
138 // If there are job postings for this industry
139 // get all the people who signed up for a job alert
140 if (industryHasPostings)
141 {
142 sSql = "SELECT [S_JobAlerts].[IndustryId]," +
143 "[S_JobAlerts].[candidateEmail] " +
144 "[S_Cv_Status].[Cv_Online], " +
145 "[S_Cv_Status].[usingShortResume], " +
146 "[S_Cv_Status].[iHasHadIntro] " +
147 "FROM [S_JobAlerts] " +
148 "INNER JOIN [S_Cv_Status] ON " +
149 "[S_Cv_Status].[user_id] = [S_JobAlerts].[candidateUserId] " +
150 "WHERE ([S_JobAlerts].[frequency] = '" + frequency + "') AND " +
151 "[S_JobAlerts].[IndustryId] = " + iCurrentIndustryId.ToString() + "";
152
153 oComm.CommandText = sSql;
154
155 DR_AlertList = oComm.ExecuteReader();
156
157 // If there are candidates who signed up
158 // for a job alert
159 if (DR_AlertList.HasRows)
160 {
161 //
162 // Loop through each job alert for this industry
163 //
164 while (DR_AlertList.Read())
165 {
166 CandEmailAddress = DR_AlertList.GetSqlString(1).ToString();
167 oEmail.sendSingleMail("john.cogan@staffmann.co.za", "Mann-power Job alert", sEmail);
168 }
169
170 }
171 DR_AlertList.Close();
172
173 }
174 }
175 DR_IndJobPostings.Close();
176
177 }
178
179 }
180 DR_Industries.Close();
181
182
183 oConn.Close();
184 } // END: if (validCall)
185
186 }
 

View Replies !   View Related
Database Design Question. I Am Close ;)
Lets say I am selling parts for cars, trucks, suvs, vans, etc. 
I want a user to search for a part by selecting a vehicle type, then a vehicle make, and then a vehicle model.
So
Vehicle Makes have to be related to Vehicle Types (I.E: Land Rover doesn’t make a car) and vehicle models need to be related to vehicle make (I.E Toyato doesn’t make a mustang Ford does).
So I am okay with those relationships individually but what is confusing me is how to ensure that a Mustang doesn’t show up as a Ford Car.
 
Lets say I have: 
vehicle_typevehicle_type_cdvehicle_type_desc 

vehicle_makevehicle_make_cdvehicle_make_descvehicle_modelvehicle_model_cdvehicle_model_descThen I might have an intersect between vehicle_type and vehicle_make because certain makes don’t have certain types of vehicles.  BMW doesn’t have a truck, Lexus doesn’t have a truck, so when a user selects truck as a make lexus nad BMW shouldn’t show up in the drop down.Vehicle_type_makeVehicle_type_make_keyVehicle_type_cdVehicle_make_cd I might have the same relationship between make and model:

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved