Sp_create_trace Throws Errorcode = 12
Hi,
I'm trying to execute server-side trace with SqlServer 2000 on
cluster. After scripting trace by Profiler I executed this script in
Queryanalyzer and got error code 12. According to BOL this code says
that file is not created but I don't know why, is there are any
obstacles which preventing to add this trace??
Does anybody had that problem?
If it helps I added script which I tried to execute:
-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
set @maxfilesize = 5
exec @rc = sp_trace_create @TraceID output, 0, N'C:Profiler_result
esult.trc', @maxfilesize, NULL
if (@rc != 0) goto error
-- Client side File and Table cannot be scripted
-- Set the events
declare @on bit
set @on = 1
exec sp_trace_setevent @TraceID, 10, 1, @on
/*here are n-setevents*/
exec sp_trace_setevent @TraceID, 43, 35, @on
-- Set the Filters
declare @intfilter int
declare @bigintfilter bigint
exec sp_trace_setfilter @TraceID, 1, 1, 6, N'history'
exec sp_trace_setfilter @TraceID, 1, 1, 6, N'move_history'
exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'
exec sp_trace_setfilter @TraceID, 35, 1, 6, N'kis'
-- Set the trace status to start
exec sp_trace_setstatus @TraceID, 1
-- display trace id for future references
select TraceID=@TraceID
goto finish
error:
select ErrorCode=@rc
finish:
go
Thanks in advance for any advice
Regards,
Bartolo
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
ErrorCode 14
I've scripted a sql trace for Sql Server 2000 and added the filename in the appropreate location andthe result is a column called ErrorCode with a value of 14. Can anyone tell me what this error code means and what could be infered about what I need to resolve it? Thanks, Marc
View Replies !
View Related
OleDbException ErrorCode
When a user finally confirms his order in a shopping cart application (using MS-Access as the backend), the items he has purchased are populated in a Access DB table named Orders & his personal details (like name, mail, billing address, shipping address etc.) are populated in another table named CustDetails. Both the DB tables have a column named OrderID. This column is the Primary Key in the CustDetails table & the Foreign Key in the Orders table. The Session.SessionID becomes the unique OrderID.After confirming an order, if the user refreshes the page, the app will try to populate the same Session.SessionID in the CustDetails table but since the column OrderID is a Primary Key column in the table CustDetails, it won't accept duplicate OrderIDs. Under such circumstances, an OleDbException will be raised.Since a DB app can throw other OleDbExceptions other than the one about which I mentioned above, I want to display custom error messages to the user. For e.g. if he refreshes the page after confirming his order, I want to display a message saying "Your order has already been placed".To do this, I tried using the ErrorCode property of the OleDbException class but what I found is the ErrorCode changes from time to time! Had a particular ErrorCode been assigned to the error, I could have done something like this (assuming that the ErrorCode for the above error is -12345 which is constant):Try 'some codeCatch ex As OleDbException If (ex.ErrorCode = -12345) Then Response.Write("Your order has already been placed") ElseIf (ex.ErrorCode = <some other constant ErrorCode>) Then Response.Write("Another custom error message") End IfEnd TryBut I can't do the above since the ErrorCode changes from time to time.So how do I display custom error messages to users under such circumstances?Of course, I can use the Message property of the OleDbException class but that would be a rather tedious workaround.
View Replies !
View Related
SYSTEM::ErrorCode Always 0
Hi In my SSIS package I have an Execute Task (that calls a stored proc) that gets executed when an error occurs (On Error Event). I am passing the stored proc the System::ErrorCode. This value always seems to be 0. How does one get the error code number, the event description seems to be populating ok Regards Tim
View Replies !
View Related
ErrorCode Description
This is a request to the Microsoft SSIS staff. I did a search for the keywords in the description and can already see a lot of people frustrated about this. A lot of well designed integration packages will route error messages to an error table or file. SSIS appends a couple of extra error columns called ErrorCode and ErrorColumn. At runtime, an extra column is visible in the DataViewer called ErrorCode - Description. The description is hardcoded into the dtsmsg.h file in the SDK folder of Sql Server. This file is very hard to parse. Can some from SSIS please post an XML or CSV file with all the error codes and descriptions for us to download please. This will be such a big help in debugging. Many Thanks. Shailen Sukul Software Architect/Developer/Consultant (BSc | Mcts (Biztalk (IP)) | Mcpd | Mcts (Web, Win, Dist Apps) | Mcsd.NET | Mcsd | Mcad) Ashlen Consulting Services Pty Ltd (http://www.ashlen.com.au) MSN | Skype | GTalk Id: shailensukul Ph: +61 0421 277 812 Fax: +61 3 9011 9732 Linked In: http://www.linkedin.com/in/shailensukul
View Replies !
View Related
ErrorCode 8144
Hi, In my local , application is working fyn...but when i had uploaded in the file in Live and executed the SP's ,It is showing up the error 8144... Whene i had checked in google it is showing: has too many arguments specified: Msg 8144....But i had not passed to many arguments... (The same SP is working in local but not in live)... The related files also i had shifted to live... This is the SP I Have used.... while Submiting iam getting error GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO --- STORED PROCEDURE USP_CREATE_USER TO SAVE THE APPLICATION INFORMATION INTO DATABASE CREATE PROCEDURE dbo.USP_CREATE_APPLICATION_ONLINE ( @ApplicationID INT, @Broker CHAR(1), @Name VARCHAR(30), @Phone VARCHAR(15), @Email VARCHAR(50), @LoanAmount Decimal(9), @LoanPurpose VARCHAR(200), @DeedType_ID VARCHAR(50), @SubDeedType_ID INT, @DeedAddress VARCHAR(200), @City VARCHAR(50), @CountryID INT, --@StateID INT, @MarketValue Decimal(9), @LoanTerm INT, @Appraised CHAR(3), @Comments VARCHAR(50), @DeleteFlag VARCHAR(1), @RETURN int OUT, @ERRORCODE int OUT ) AS set @RETURN=1 SET NOCOUNT ON iF EXISTS(SELECT * FROM APPLICATION_ONLINE WHERE ApplicationID=@ApplicationID) Begin BEGIN TRANSACTION TRANSUPDATE UPDATE APPLICATION_ONLINE SET ApplicationID = @ApplicationID, Broker = @Broker, [Name] = @Name, Phone = @Phone, Email = @Email, LoanAmount=@LoanAmount, LoanPurpose=@LoanPurpose, DeedType_ID=@DeedType_ID, SubDeedType_ID=@SubDeedType_ID, DeedAddress =@DeedAddress, City =@City, CountryID = @CountryID, MarketValue = @MarketValue, LoanTerm = @LoanTerm, Appraised =@Appraised, Comments =@Comments WHERE [ApplicationID] = @ApplicationID SET @ERRORCODE=@@ERROR IF @ERRORCODE <> 0 BEGIN ROLLBACK TRANSACTION TRANSUPDATE SET @ERRORCODE=@@ERROR RETURN END ELSE BEGIN COMMIT TRANSACTION TRANSUPDATE SET @ERRORCODE=50002 RETURN END END else BEGIN BEGIN TRANSACTION TRANSINSERT INSERT INTO APPLICATION_ONLINE( ApplicationID, Broker, [Name], Phone, Email, LoanAmount, LoanPurpose, DeedType_ID, SubDeedType_ID, DeedAddress, City, CountryID, -- StateID, MarketValue, LoanTerm, Appraised , Comments, DeleteFlag ) VALUES ( @ApplicationID, @Broker, @Name, @Phone, @Email, @LoanAmount, @LoanPurpose, @DeedType_ID, @SubDeedType_ID, @DeedAddress, @City, @CountryID, -- @StateID, @MarketValue, @LoanTerm, @Appraised, @Comments, @DeleteFlag ) SET @ERRORCODE=@@ERROR IF @ERRORCODE <> 0 BEGIN ROLLBACK TRANSACTION TRANSINSERT SET @ERRORCODE=50004 RETURN END ELSE BEGIN COMMIT TRANSACTION TRANSINSERT SET @ERRORCODE=50001 RETURN END END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO Thanks
View Replies !
View Related
How Do You Make Use Of ErrorCode And ErrorColumn
SSIS automatically adds the columns ErrorCode and ErrorColumn to the error pipe routing bad rows. However, both these columns appear to be meaningless. We need to translate the error column to the actual problem column and the error code to a meaningful error. ErrorColumn is the more important issue for us. The question is 'Are these just useless columns? If not, how do we translate them into something useful?' Thanks
View Replies !
View Related
SQL Express ERRORCODE:37000
Installed SQL express 2005 w/Studio Manager. Everything installed Ok except got an error IIS was not running or not installed. When installing a software program, when it tries to create the database I get an error at the initialization: An error has occured while processing an SQL statement. Please refer to the system administrator guide for further assistance. ERRORCODE:37000 ERROR:CREATE DATABASE failed. Some of the file names cound not be created. Check related errors. SQL STATEMENT CREATE DATABASE xxxx Has anyone seen or know a fix for this? Thanks in advance.
View Replies !
View Related
Problem With ErrorCode (DT_NTEXT Not Supported...???)
Hi again! I have another problem, this time with a flatfile source component. The file is pretty simple organized and in fact everything works as expected. The file itself comes from an FTP server, so it is not available at designtime. For setting up the flatfile source i downloaded it, but afterwards i delete it, set 'dalayvalidation' to true and try to execute. FTP download works fine, the file is there but then i get the errormessage: Copier ErrorCodes [586]: The data type for "output column "Flat File Source Error Output Column" (610)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component. When i try to set the datatype of the Error Output Column (610) to DT_NEXT i only get an errormessage telling me that this would not be a valid value for this property. The only chance i have to get it working again is to completely delete the flatfile-source, readd and setup it again, then everything works... but only until i remove the files and try to download them via FTP. It's strange :-( and annoying. Anyone any idea? kind regards, Wolfgang
View Replies !
View Related
SSIS : ErrorCode OnInformation EventHandler
Hello, Within my SSIS packages I use a logging logic quite similar as the one described by Jamie Thomson here : http://blogs.conchango.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx But I still have a small "problem". When my package end with success the ErrorCode returned at the OnInformation event handler level is : 0x4001100B 1073811467 DTS_I_COMMITTINGTRANSACTION Committing distributed transaction started by this container. Instead of : 0x40013001 1073819649 DTS_MSG_PACKAGESUCCESS Package "__" finished successfully. Another example. When there's an integrity constraint violation, I've got the following ErrorCode returned : 0xC0047021 -1073450975 DTS_E_THREADFAILED Thread "__" has exited with error code __. Instead of : 0xC020907D -1071607683 DTS_E_OLEDBDESTINATIONADAPTERSTATIC_INTEGRITYVIOLATION The data value violates integrity constraints. Anyone has a clue ? Thanks a lot by advance. Cheers, Bertrand
View Replies !
View Related
Decoding Decimal Form Of HRESULT From ErrorCode
I have an OLE-DB Command transformation that inserts a row. If the insert SQL command fails for some reason, I use the "Redirect Row" option to send the row to another OLE-DB Command transformation that logs the error on that row to a "failed rows" table. In this table I log the ErrorCode and ErrorColumn values that come with the error path from the first OLE-DB Command. OK, that's all working great. However, here's the kicker: there's no error description value. The ErrorCode value, naturally, is the decimal form of an HRESULT--for example, -1071607696. Without some further information, however, this code is not useful for troubleshooting. Has anyone figured out a trick here? I'm not even certain that this is an SSIS HRESULT, since it could for all I know be from the OLE-DB layer, the database layer, or somewhere else. Thanks, Dan
View Replies !
View Related
Copy Database Wizard ErrorCode=-1073548784
I am transfering a database from sql server 2000 to sql server 2005 using copy database wizard. I have this error coming up error Error: ERROR : errorCode=-1073548784 description=Executing the query "EXEC dbo.sp_grantdbaccess @loginame = N'Testusername', @name_in_db = N'username' " failed with the following error: "The login already has an account under a different user name.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} StackTrace: at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.ExecuteTransfer() at Microsoft.SqlServer.Management.Smo.Transfer.TransferData() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.TransferDatabasesUsingSMOTransfer() How do i handle this error...looked online but didn't find right answers... Please let me know
View Replies !
View Related
Kirk: Importing/Exporting With Column ErrorCode, ErrorColumns
I am currently redirecting lookup failures into error tables with ErrorCode and ErrorColumn. It works fine until I want to transfer data into the archived database. The SSIS pacakage generate by SQL Exporting tool is throwing an "duplicate name of 'output column ErrorCode and ErrorColumn" error. This is caused by oledb source error output. The error output automatically add ErrorCode and ErrorColumn to the error output selection and not happy with it. I think the question is down to "How to importing/exporting data when table contains ErrorCode or ErrorColumn column?"
View Replies !
View Related
Best Practices: Recording Error Information (Beyond ErrorCode And ErrorColumn)
I'm sorry for asking this, as I'm sure tha the answer is in one of the 208 matches I found searching on "ErrorCode". Unfortunately, this project is overdue and I need a solution fairly soon. I should add that I've only been developing in SSIS since August 2007. I have a complicated package, loading about 17 outputs of the XML Source into staging tables. I have been using the error outputs of any standard components I use, out of faith that, if Microsoft provided them, then they should be useful for something. I've been directing all of the error outputs for one of the 17 "tables" from the XML Source into a Union All, and then into an "Error staging table", for each of the 17 outputs. This table includes all of the possible columns, but permits nulls for all of them. It also incldues the ErrorCode and ErrorColumn. Unfortunately, if these latter two are useful for anyting, I haven't found it yet. Right now, working with our first "mostly real" data, I'm getting 100% of my input rows written into error tables. Unfortunately, the information in the tables are of limited use in determining what went wrong. For instance, the ErrorColumn seems only to be populated if there was a specific error with a specific column. The Lookup component, doesn't seem to populate ErrorColumn, even if only one column was used for the lookup! No information about the component producing the error output is supplied in the error output, either, which makes it difficult to determine which of the five or so possible error outputs is the one that produced the particular error row. This proves that I'm missing something simple. How do people handle errors? In my custom components, I learned to use the Fire* methods to produce detailed messages before redirecting the row to the error output, but this sort of thing is not available through the standard components. Do I really have to create a separate "add useful information to the error output" component, and use it on each error output? Sorry for the attitude, but just when I think I'm winning, SSIS brings me back down to earth!
View Replies !
View Related
DeriveParameters Throws When Called Against A C# Function?
When I call DeriveParameters against a function written in SQLCLR function it throws an exception. I've been working on this a little while and haven't found a fix. I understand that I could write additional code to do the same work DeriveParameters does, but it seems like this should work. This is the exception thrown: [InvalidOperationException: The stored procedure 'GSI.Utils.IsMatch' doesn't exist.] The function is defined as CREATE FUNCTION [Utils].[IsMatch](@Value [nvarchar](4000), @RegularExpression [nvarchar](4000)) RETURNS [bit] WITH EXECUTE AS CALLER AS EXTERNAL NAME [RegularExpressionsHelper].[UserDefinedFunctions].[IsMatch] The C# function is defined as: [Microsoft.SqlServer.Server.SqlFunction(IsDeterministic=true)] public static SqlBoolean IsMatch(SqlString Value, SqlString RegularExpression) { Regex rx = new Regex( RegularExpression.ToString() ); string s = Value.ToString(); return new SqlBoolean(rx.IsMatch(s)); } This is the code I'm using to call DeriveParameters: static void Main(string[] args) { using (SqlConnection conn = new SqlConnection(m_GetConnectionString())) { conn.Open(); SqlCommand myCommand = new SqlCommand("GSI.Utils.IsMatch", conn); myCommand.CommandType = System.Data.CommandType.StoredProcedure; SqlCommandBuilder.DeriveParameters(myCommand); } } I found that DeriveParameters seems to call sp_procedure_params_managed and when I call it myself it returns the parameters correctly for T-SQL functions, but returns no records when I specify a SQLCLR function. DECLARE @procedure_name sysname; DECLARE @group_number int; DECLARE @procedure_schema sysname; DECLARE @parameter_name sysname; SET @procedure_name = 'IsMatch'; SET @group_number = 1; SET @procedure_schema = 'Utils'; SET @parameter_name = null; DECLARE @RC int EXECUTE @RC = [GSI].[Sys].[sp_procedure_params_managed] @procedure_name ,@group_number ,@procedure_schema ,@parameter_name I'm able to execute the function without issue and I'm able to use DeriveParameters against everything in the database except C# based functions (and I've tried others besides IsMatch). I'm attempting to run DeriveParameters from a console application and from ASP.NET, both running .NET 2.0. I've experienced the same behavior in these versions: SQL Server 2005 Enterprise Edition RTM (MSDN Image on Virtual Server) SQL Server 2005 Enterprise Edition SP1 (MSDN Image on Virtual Server) SQL Server 2005 Enterprise Edition SP1 + Hotfix kb918222 (MSDN Image on Virtual Server) SQL Server 2005 Developer Edition SP1 Has anyone else seen similar behavior? Any advice would be greatly appreciated -- Thanks Steve
View Replies !
View Related
Script Component Throws Error
Hi, I have three script component A,B, C. A reads certain data from a table. B inserts records into a .txt file when the recordtype = 1. C inserts records into same .txt file when the recordtype = 0. Now I receive a script comp error for C as follows. [Error Desc] ************************************************************ The process cannot access the file 'D:Documents and SettingsAdministratorDesktopAuditLog.txt' because it is being used by another process. ************************************************************ at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options) at System.IO.StreamWriter.CreateFile(String path, Boolean append) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize) at System.IO.StreamWriter..ctor(String path, Boolean append) at ScriptComponent_6bda9d13fce34f90ac6315546c8d0d54.ScriptMain.PreExecute() in dts://Scripts/ScriptComponent_6bda9d13fce34f90ac6315546c8d0d54/ScriptMain:line 19 at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PreExecute() [/Error Desc] Can anyone throw some light on it. Thanks
View Replies !
View Related
OLE DB Source With Transaction Throws An Error
Hello, I have OLE DB Connection to Access database using Jet 4.0 provider. I have a data flow task in package. In this data flow task, I have an OLE DB source. This source uses above mentioned connection. When this data flow task is not a part of transaction, it works fine. But when I set "TransactionOption" property to "Required", the OLE DB source returns following error. [OLE DB Source [1]] Error: The AcquireConnection method call to the connection manager "databasename" failed with error code 0xC001A004. I have checked Distributed Transaction Cordinator running. I have some other package running fine which uses transactions but does have OLE DB source. I have also tried setting "RetainSameConnection" property of a connection to TRUE. But still it is failing. In short, I am not able to execute OLE DB source in side transaction. Please guide. Thanks,
View Replies !
View Related
SQL Standard Setup Throws SEHException
I copied the MSDN setup DVD content to a local drive from USB DVD drive. Started the setup process; accepted the EULA and setup installed the SQL Native Client and Setup Support Files successfully. During System Configuration Checks, the process raises the following dialog: --------------------------- System.Runtime.InteropServices.SEHException: External component has thrown an exception. at System.Windows.Forms.UnsafeNativeMethods.IntCreateWindowEx(Int32 dwExStyle, String lpszClassName, String lpszWindowName, Int32 style, Int32 x, Int32 y, Int32 width, Int32 height, HandleRef hWndParent, HandleRef hMenu, HandleRef hInst, Object pvParam) at System.Windows.Forms.UnsafeNativeMethods.CreateWindowEx(Int32 dwExStyle, String lpszClassName, String lpszWindowName, Int32 style, Int32 x, Int32 y, Int32 width, Int32 height, HandleRef hWndParent, HandleRef hMenu, HandleRef hInst, Object pvParam) at System.Windows.Forms.NativeWindow.CreateHandle(CreateParams cp) at System.Windows.Forms.Control.CreateHandle() at System.Windows.Forms.Control.get_Handle() at System.Windows.Forms.Control.CreateHandle() at System.Windows.Forms.TextBoxBase.CreateHandle() at System.Windows.Forms.Control.get_Handle() at System.Windows.Forms.Control.CreateGraphicsInternal() at System.Windows.Forms.Control.CreateGraphics() at Microsoft.SqlServer.Management.UI.WizardForm.AdjustInfoPanelScrollBar() at Microsoft.SqlServer.Management.UI.WizardForm.set_InfoText(String value) at Microsoft.SqlServer.Setup.SetupBootstrapWizard_WizardForm.InitializeComponent() --------------------------- OK --------------------------- Any hints?
View Replies !
View Related
ExecuteNonQuery() Throws An Incorrect Syntax Error
I try to update from datalist by using sqlcommand, it throws an error on the date field: Mark up: 10/11/2008 12:00:00 AM <--- the format in the SQL database Error: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'DOB'.Dim strSQL As String = _ "UPDATE [Customers] SET [country] = @country, " & _"[nickName] = @nickname, [identityid] = @identityid " & _ "[DOB] = @DOB, [Hpno] = @Hpno " & _"[address] = @address, = @email " & _ "WHERE [CustomerID] = @CustomerID" ...Dim parameterdob As SqlParameter = _ New SqlParameter("@DOB", SqlDbType.DateTime) parameterdob.Value = Request.Form("txtdob") & " 00:00:00" myCommand.Parameters.Add(parameterdob) myCommand.ExecuteNonQuery() <--- error here ... <form id="form1" runat="server"> <asp:DataList ID="ProfileDataList" runat="server"> <ItemTemplate> <asp:TextBox runat="server" ID="txtdob" Text='<%#DataBinder.Eval(Container.DataItem, "DOB", "{0:d}")%>' /> </ItemTemplate> </asp:DataList>
View Replies !
View Related
Connection.ServerVersion Throws System.InvalidOperationException
I am using VWD2005 and SQLExpress 2005. In web.config I define the connection:<connectionStrings> <add name="ProFeeRevenueUser" connectionString="Data Source=.SQLEXPRESS;AttachDBFilename=|DataDirectory|ProFeeRevenue.mdf; Initial Catalog=ProFeeRevenue;User Id=whomever;Password=whatever" providerName="System.Data.SqlClient"/> When I try this code in a class (util.cs), I get an error on trying to open the connection:System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["ProFeeRevenueUser"].ConnectionString); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("usp_UserSystemRolesListByUser", cn);System.Data.SqlClient.SqlDataReader dr; try {cmd.CommandType = System.Data.CommandType.StoredProcedure; System.Data.SqlClient.SqlParameter retValParm = cmd.Parameters.Add("@RowCount", System.Data.SqlDbType.Int);retValParm.Direction = System.Data.ParameterDirection.ReturnValue;cmd.Parameters.AddWithValue("@UserLogin", userLogin); cn.Open(); // error occurs here <<---------------------------- dr = cmd.ExecuteReader();if (dr.HasRows) {while (dr.Read() == true) {string MyRole = dr[1].ToString().Trim(); SystemRoles.Add(MyRole); } dr.Close(); } It works fine if I point to a SQL server database on my server, but not with SQLExpress, so I assume I have done something wrong with the connection string or the SQL Express database. Any ideas?
View Replies !
View Related
Datareader Object Throws A Non-descript Error.
I call the datareader using a sqlCommand that I programmatically build and it accesses the database fine. I can use the exact SQL command that I generate and I can get a result when i run it in SQL Management Studio. When I run the application and try to access the datareader, it throws an exception whose message is quite frustratingly, <column name>, or in this case "image_URL". Anyone have any idea what might be causing such an ambiguous error?
View Replies !
View Related
Update Throws System.FormatException - SQL Server
I have found out that my UPDATE statement throws an exception : "System.FormatException: Input string was not in a correct format." For testing purpos I created a simple table in my SQL server containing columns "id" (identity) and "test"(varchar50) and populated 2 rows with data. SELECTing from the database is ok, so the connection should be fine (connectionstring = server=localhost;database=test;user=sa;) The update that throws the exception is : "UPDATE test SET test = 'updating' WHERE id = 1" The same statement is ok in the SQL Query analyser - can anyone help on why this is not the correct format for the UPDATE?
View Replies !
View Related
What Am I Missing In This Code Which Throws An Exception At Runtime?
{ //setup the connection and connection string SqlConnection addTutor = new SqlConnection(); addTutor.ConnectionString = "data source=QUAKEMASTER;" + "initial catalog=DThomas;uid=sa;password=**********;"; string InsertTutor = "INSERT INTO Tutors (firstname, lastname, tutorID, office)Values(@firstName, @lastName,@tutorID,@location)"; SqlCommand insertTutor = new SqlCommand(InsertTutor); insertTutor.Connection = addTutor; //populating an array of sqlParameters performs the same function as an SqlParameters.Add SqlParameter[] param = new SqlParameter[4]; param[0] = new SqlParameter("@firstName",txtFirstName.Text); param[1] = new SqlParameter("@lastName",txtLastName.Text); param[2] = new SqlParameter("@tutorID",int.Parse(txtTutorID.Text)); param[3] = new SqlParameter("@location",listOffice.SelectedItem.ToString()); try { //open the connection addTutor.Open(); //execute the NonSqlQuery insertTutor.ExecuteNonQuery(); //close the connection insertTutor.Connection.Close(); } catch (Exception ThatFeckedUp) { throw ThatFeckedUp; } finally { addTutor.Close(); } } Sure i've missed something just not sure what.....
View Replies !
View Related
Group By On The Text Colum Throws Error
Hi ,I have this querypaprojnumber is varcharpatx500 is textpalineitemseq is intselect Paprojnumber,Patx500,max(palineitemseq) from pa02101,pa01601wherepa02101.pabillnoteidx=pa01601.pabillnoteidx group bypaprojnumber,patx500it throws this errorServer: Msg 306, Level 16, State 2, Line 1The text, ntext, and image data types cannot be compared or sorted,except when using IS NULL or LIKE operator.Thanks a lot for your help.AJ
View Replies !
View Related
Drillthrough Report Throws Exception On Second Page
I have a problem with a report which shows values created by a drillthrough MDX statement. The first page of the report is rendered quickly and shows the values. But when I try to browse to further pages of the report (the report contains about 3 pages at all, not too much data) the following exception is thrown: " An exception of type Microsoft.ReportingServices.ReportRendering.Report RenderingExtension was thrown. (rrRenderingError) " The version of the reporting services is 2000 sp2. The SQL Server and Analysis Server have both SP4. A few parameters were passed to the report, the dataset is dynamically set. No entries in system or application log of the system (Windows Server 2003 EE) Could someone help?
View Replies !
View Related
Forms Authentication Throws Unhelpful Exception
I have implemented a membership provider and added it to Reporting Services. On one machine it works well. On another, when I log into /ReportServer using the form, I get back: Exception of type 'System.Exception' was thrown. I haven't been able to find any evidence of what threw the exception or why. Where do I start?
View Replies !
View Related
GetDate() Throws Error With MS JDBC Driver V1.2
Hi, I have a small program to query a stored procedure in SQL Server 2000 and print out the contents of a returned date field. The program is as follows: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String connectionUrl = "jdbcqlserver://host:1433;database=db;user=u1;password=p1"; Connection con = DriverManager.getConnection(connectionUrl); CallableStatement cbstmt = con.prepareCall(" {call stored_proc (?,?)}"); cbstmt.setString(1, "value1"); cbstmt.setString(2, "value2"); ResultSet resultSet = cbstmt.executeQuery(); while (resultSet.next()) { System.out.println(resultSet.getDate("end_date")); } The date field is nullable, and the records in the database are currently null. But when I run this program, I get the following exception when using version 1.2 of the MS JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from int to DATE is unsupported. at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.DTV.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getDate(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getDate(Unknown Source) at jdbc.main(jdbc.java:38) Exception in thread "main" This started happening when we upgraded to the new driver. Any ideas why? Thanks.
View Replies !
View Related
SQL Server Column Name Starts With A Number. C# Throws Error.
I have a table in sql server 2000 which has a column whose name starts with a number("2ndName").I have a c# code which updates the table by filling a Dataset.When I issue an update, it throws the following error:-"Incorrect Syntax near 2"Query I use to build the adapter is "SELECT id, Name, [2ndName] FROM MyTBL WHERE 1 = 3" and the statement issued to update is "objAdapter.Update(objDSDB, "MyTBL")" when it throws the error "Incorrect Syntax near 2".Any help to resolve this is appreciated.Thanks in advance.Jai
View Replies !
View Related
Casting Float Output Param Throws An Exception.
I keep getting an exception when trying to cast an output param as a float type. the SPROC is marked as float OUTPUT and the Cost column in the database is a float type as well. And there are no nulls in the cloumn either. here is how my code looks: SqlParameter prmCost= new SqlParameter("@Cost", SqlDbType.Float,8); prmCost.Direction=ParameterDirection.Output; cmd.Parameters.Add(prmCost); //...blah blah blah //invalid cast gets throw on here (it happens with all my float types) productDetails.Cost=(float)prmCost.Value; Any suggestions as to what I am doing wrong?
View Replies !
View Related
AcquireConnection Throws COMException (0x80131904) In Custom Component
We have built a custom component that is run in a dataflow contained in a sequence container, which in turn is contained in a loop. Transactions are enabled on the sequence container in such a way that if one step in the loop fails, that step is rolled back but the loop continues. Now, whenever anything happens causing a rollback in one of the iterations, sometimes the call to AcquireConnection in the next iteration will fail with the following error: Error: 2007-03-25 09:47:31.98 Code: 0xC0047062 Source: KODPLAN Surrogate Key KO_ID [8204] Description: System.Runtime.InteropServices.COMException (0x80131904): Exception from HRESULT: 0x80131904 at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction) at Intellibis.SqlServer.Dts.SurrogateKeyTransform.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90wrapper, Object transaction) End Error Is there a way to avoid this? It causes that particular iteration to fail as well as the one causing the rollback. Regards, Lars
View Replies !
View Related
Export To Excel Error Throws System.OutOfMemoryException
Hi, My server configuration is Intel Xeon(R) X5355 @ 2.66GHz, 3.75 GB RAM Win 2k3 I have been receiving the above mentioned error when I try to use the out of the box feature of "Export To Excel" provided in the Reporting Services, the reports are hosted on MOSS 2007 using the Reporting Services Add-In. The number of pages generated by the report is 500+, so I don't think exporting a report of around 500 - 1000 should give out a memory exception since we have sufficient RAM on the server. Please advice a solution to solve the error. Thanks in Advance. Vikas Mestry.
View Replies !
View Related
Instancing ADODB.Connection Throws Exception Under Debugger
This is a new behavior. Longtime running code reports an exception from mscorlib when instancing a Connection object. I believe this may have come about from a recent patch or service pack? Message: Could not find file 'D:...myappicationinDebugmyapplication.vshost.exe.config'. Stack Trace: at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) adodb version is 7.0.3300.0 mscorlib version is 2.0.50727 I have set to break on all exceptions, and the software otherwise runs entirely without exceptions unless there are unanticipated errors. I can allow the program to continue, but it is a pain getting this break now when ever debugging at start up. There are some critically timed activities that occur at program start up, so it is sometimes a challenge getting a clean start when debugging.
View Replies !
View Related
Trigger Throws Exception Error In Great Plains 8.0
Not sure if there's a GP 8.0 forum, so giving this one a go. I've added an AFTER UPDATE trigger to the RM00101 table (customer master) in a Great Plains 8.0 SQL Server 2000 SP4 DB. The trigger assigns field values to variables, constructs an update query, and executes the query on a table in a linked SQL Server 2005 DB. The trigger works fine when fired as a result of a direct field update made through Enterprise Manager. However, when the same update is made through the Great Plains GIU (customer card window), an exception error is thrown: "Unhandled database exception: A Save operation on table €˜RM_Customer_MSTR€™ failed accessing SQL data EXCEPTION_CLASS_DB DB_ERR_SQL_DATA_ACCESS_ERR€? The odd thing is that if I drop the trigger from the RM00101 table, the exception error still occurs. Not just on the record originally updated, but on all records and all fields within the record. Code for the trigger follows: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE TRIGGER CTrig_Logic_Update_Customer ON RM00101 AFTER UPDATE AS IF UPDATE(CUSTNMBR) or UPDATE(CUSTCLAS) or UPDATE(CNTCPRSN) or UPDATE(STMTNAME) or UPDATE(SHRTNAME) or UPDATE(TAXSCHID) or UPDATE(ADDRESS1) or UPDATE(ADDRESS2) or UPDATE(ADDRESS3) or UPDATE(CITY) or UPDATE(STATE) or UPDATE(ZIP) or UPDATE(PHONE1) or UPDATE(FAX) or UPDATE(SLPRSNID) or UPDATE(PYMTRMID) or UPDATE(PRCLEVEL) or UPDATE(SALSTERR) or UPDATE(INACTIVE) or UPDATE(HOLD) or UPDATE(CRLMTAMT) BEGIN DECLARE @Server_Name Varchar(25), @Logic_DB_Name Varchar(25), @SQLStr nvarchar(1000), @CustomerN int, @SICCode int, @ARContact Varchar(35), @LongName Varchar(50), @CustomerName Varchar(24), @SalesTaxCode Int, @AddrLine1 Varchar(40), @AddrLine2 Varchar(40), @AddrLine3 Varchar(40), @City Varchar(30), @StateProv Varchar(4), @PostalCode Varchar(15), @TelephoneN Varchar(25), @FaxTelephoneN Varchar(25), @SalespersonN Int, @TermsCode Varchar(60), -- Put the customer terms into the CommentN1 field @CustRateSched Int, @SalesAreaCode Int, @InactivePurge Tinyint, @CreditStatus Tinyint, @CreditLimit Int ------- Get the new Customer data from Inserted table SELECT @CustomerN = CAST(RTRIM(i.CUSTNMBR) as Integer), @SICCode = ISNULL((SELECT Dex_Row_ID FROM RM00201 WHERE RM00201.CLASSID = i.CUSTCLAS),0), @ARContact = RTRIM(i.CNTCPRSN), @LongName = RTRIM(i.STMTNAME), @CustomerName = RTRIM(i.SHRTNAME), @SalesTaxCode = ISNULL((SELECT Dex_Row_ID FROM TX00101 WHERE TX00101.TAXSCHID = i.TAXSCHID),0), @AddrLine1 = RTRIM(i.ADDRESS1), @AddrLine2 = RTRIM(i.ADDRESS2), @AddrLine3 = RTRIM(i.ADDRESS3), @City = RTRIM(i.CITY), @StateProv = RTRIM(LEFT(i.STATE,2)), @PostalCode = RTRIM(i.ZIP), @TelephoneN = RTRIM(LEFT(i.PHONE1,10)), @FaxTelephoneN = RTRIM(LEFT(i.FAX,10)), @SalespersonN = RTRIM(i.SLPRSNID), @TermsCode = RTRIM(i.PYMTRMID), @CustRateSched = RTRIM(i.DEX_ROW_ID), @SalesAreaCode = ISNULL((SELECT Dex_Row_ID FROM RM00303 WHERE RM00303.SALSTERR = i.SALSTERR),0), @InactivePurge = i.INACTIVE, @CreditStatus = i.HOLD, @CreditLimit = i.CRLMTAMT FROM inserted i ------- Get Logic server name and database name SELECT @Server_Name = RTRIM(l.Server_Name), @Logic_DB_Name = RTRIM(l.Logic_DB_Name) FROM tbl_Logic_DB l ------- Insert new Customer record into Logic database SET @SQLStr = 'UPDATE [' + @Server_Name + '].[' + @Logic_DB_Name + '].dbo.[Customer] ' + ' SET SICCode = ' + CAST(@SICCode as varchar(10)) + ', ' + ' ARContact = ''' + @ARContact + ''', ' + ' LongName = ''' + @LongName + ''', ' + ' CustomerName = ''' + @CustomerName + ''', ' + ' SalesTaxCode = ' + CAST(@SalesTaxCode as varchar(10)) + ', ' + ' AddrLine1 = ''' + @AddrLine1 + ''', ' + ' AddrLine2 = ''' + @AddrLine2 + ''', ' + ' AddrLine3 = ''' + @AddrLine3 + ''', ' + ' City = ''' + @City + ''', ' + ' StateProv = ''' + @StateProv + ''', ' + ' PostalCode = ''' + @PostalCode + ''', ' + ' FaxTelephoneN = ''' + @TelephoneN + ''',' + ' SalespersonN = ' + CAST(@SalespersonN as varchar(10)) + ', ' + ' CommentN1 = ''' + @TermsCode + ''', ' + ' CustRateSched = ' + CAST(@CustRateSched as varchar(10)) + ', ' + ' SalesAreaCode = ' + CAST(@SalesAreaCode as varchar(10)) + ', ' + ' InactivePurge = ' + CAST(@InactivePurge as varchar(10)) + ', ' + ' CreditStatus = ' + CAST(@CreditStatus as varchar(10)) + ', ' + ' CreditLimit = ' + CAST(@CreditLimit as varchar(10)) + ' ' + ' WHERE CustomerN = ' + CAST(@CustomerN as varchar(10)) SET ANSI_NULLS ON SET ANSI_WARNINGS ON SET XACT_ABORT ON EXEC sp_executesql @SQLStr END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
View Replies !
View Related
URGENT: Stored Procedure Throws Windows Error 203
I am trying to execute a stored procedure on Server1 which creates an excel report on a share of Server2: The following error message is thrown: Saving of scheduled report(s) to Excel file failed : 203 SaveReportToExcel() in TlRptToFile.RptExcel failed in sproc_SaveReportAsFile - TLRptXL::SaveReportToExcel - Connection to Database failed for Analytics DataBase Server : TKTALSQL3, Application Server: and DataBase : tlAnalytics : Windows Error - The system could not find the environment option that was entered. A DCOM component on Server1 runs the stored procedure that creates the excel report. The account under which DCOM component runs is a member of 'Administrators' group on both Server1 and Server2. Checked permissions on the shares. Account is a local Admin on both Server1 and Server2. Account under which SQLServer and ServerAgent runs is also an Admin on these shares (implicitly as part of 'Administrators' group). I am manually able to create an excel/text file on the Server2 share while accessing it from Server1, though. Appreciate your help in resolving the issue.
View Replies !
View Related
Suspect Database - DBCC CHECKDB Throws Error
Hi all, we've been having this ancient database with old accounting data running in suspect mode since as long as I can remember (I started working here a year ago), and finally I had some time on my hands so I thought I'd try to get it online again. However I'm running in to problems: DBCC CHECKDB (myDBName) gives this error: Msg 926, Level 14, State 1, Line 1 Database 'myDBName' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. Running sp_helpdb only does not display the suspect database and sp_helpdb 'myDBName' gives this error even though I'm a system administrator: No permission to access database 'myDBName'. It's possible that I might be able to dig up a backup but that would be quite tedious. Is it possible to bring the database to a state where I'm able to do a CHECKDB at least...? -- Lumbago "Real programmers don't document, if it was hard to write it should be hard to understand"
View Replies !
View Related
Full Text Indexing - CONTAINS Throws Error With Single Alphabets
I am using a full text search index on a text column in one of my tables. This column is used in a dynamically generated SQL query, where the search argument is submitted from a page in my web application. I wanted minimal restrictions on the search argument, therefore I have removed everything from the noise words file for English before generating the catalog. Now the CONTAINS clause accepts nearly everything, except for single alphabets, as the search argument. For example, if the where clause of the query is like this: WHERE CONTAINS (RES_RESUME, '*C*') it throws an error message. ODBC Error Code = 01000 (General warning) Does the CONTAINS predicate have any problem with single alphabets ? Or am I doing something wrong here ? I need users of my website to be able to search by single alphabets. Any solutions (or workarounds) to this problem ?
View Replies !
View Related
Import And Export Wizard Throws Errors When Theres Alot Of Tables
I€™m trying to copy data from production to my local machine using the SQL Server 2005 import and export wizard. It works fine if I select a small number of tables but throws errors When there€™s a lot of tables. Have you ever experienced problems using it? Is there a better way to transfer the data? the data source is SQL Server 2000 and the target is 2005. I have the optimize for many tables and transaction options selected Here€™s the errors I get Execute the transfer with the TransferProvider. (Error) Messages · ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (49)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 · ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (31)" and "input column "ErrorCode" (52)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 · ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (49)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 · ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (31)" and "input column "ErrorCode" (52)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 · ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (49)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 · ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (31)" and "input column "ErrorCode" (52)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 · ERROR : errorCode=-1073451000 description=The package contains two objects with the duplicate name of "output column "ErrorCode" (49)" and "output column "ErrorCode" (14)". helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
View Replies !
View Related
Table Not Involved In Replica Throws Error When Write Data In It
Hi everybody. I have a merge replication scenario between 2 servers. Everything is OK when I write data in UP server (the server which does the replication). But when I write data in any tables in the DOWN server throws an error saying that the table where I'm trying to insert data is updating or inicializating for merge replica. This table, where the error throws, isn't involved in the replica. In fact, that table is not involved in none replication. Can you help me? Thanks in advance
View Replies !
View Related
OPENQUERY Throws Error 7357 When The Source SP Uses Temporary Table.
Hello Everybody / Anybody, Sorry but exiting problem! The Problem: OPENQUERY throwing error [Error 7357]when the source SP uses temporary table. Description : Need to validate data against master list. My combo on UI has a source Stored Proc(contains a temp table in it). I'm importing data from Excel. Before import, I want to validate it against my master list values. [say field Priority has master values "High, Medium,Low".] and in excel user has added 'ComplexHigh' under priority field] In this case, my import validator StoredProc should not accept value 'ComplexHigh' as it is not present in my Priority master list] I'm preparing a temp table tabName containing o/p of SP, it works fine zakkas if my SP usp_SelectData does not contain temp table. I think you got what the situation is!! Woh! Note : I have searched net for this and found nothing! So its challenge for all of us. TRY OUT!! ------------------------------------- The Code ---------------------------- create proc usp_SelectData as create table #xx (FixedCol int) insert into #xx select 1 union select 2 select * from #xx drop table #xx create proc usp_SelectData2 as create table xx (FixedCol int) insert into xx select 1 union select 2 select * from xx drop table xx -- Please replace MyDB with your current Database SELECT * INTO tabName FROM OPENQUERY('EXEC MyDB.dbo.usp_SelectData') -- Throws Error 7357 : [Could not process object 'EXEC MyDB.dbo.usp_SelectData'. The OLE DB provider 'SQLOLEDB' indicates that the object has no columns.] SELECT * INTO tabName FROM OPENQUERY('EXEC MyDB.dbo.usp_SelectData2') -- Works fine Thanks in advance...
View Replies !
View Related
Report Server Throws ERROR [HY024] With Access Database
I've set up a report server on IIS on my local machine using SSRS 2005. All is well in the world--it shows up, and I can publish reports and have them display successfully. However, I'm trying to publish a couple of reports based on an Access database--and this is where the problem lies. The reports run perfectly in Visual Studio, which is on the same machine as the report server. Thus, I can deduce that the ODBC connection to the Access database is set up properly. There are no errors on the report, which means that the reports are set up correctly. I've spent the last day researching the problem, but nothing I've tried thus far (from putting the Access database in a shared folder to changing security on the file and report server to rebuilding the reports from scratch) works. The exact error is given below, with the data source name changed: An error has occurred during report processing. Cannot create a connection to data source 'MyODBCDataSource. ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [HY024] [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Can anyone suggest something I missed? I'm stumped on this one. Edit: Just to clarify, EVERYTHING is on my local machine--the web browser I'm viewing from, IIS, SSRS 2005, the Access database, the ODBC connection (in the System DSN), everything.
View Replies !
View Related
Reporting Service Setup Throws Error Regarding Security Rights
Hello, I am trying to install SQL Server 2000 Reporting Services on a machine. All worked fine until the setup tries to start ReportServer service. It throws an error message stating that "ReportServer failed to start: Verify that you have sufficient privileges to start the service". I am installing Reporting Services on the same machine on which SQL Server 2000 Developer Edition is installed. The pc has operating Windows XP Service pack 2 and is on workstation instead of a domain. After the error message is thrown, the reporting services setup doesn't proceed further and ultimately roll back. I am installing Reporting Services with local Administrator account and with service start as local system account option. I have used the same user and service options for SQL Server 2000 Developer edition while installing and its service gets installed and run succesfully. So I don't think that there should be any problem with user privileges. Has anybody encountered this before. I have installed all pre-requisites of Reporting Services. Thanks.
View Replies !
View Related
Sqldriver Throws Java.lang.SecurityException: 'invalid SHA1 Signature'
hi! I'm trying to connect to a sql server 2005 express edition but have some trouble with it: i can connect to server through eclipse but when i try connecting via a jar , I get the following error. I'm using eclipse 3.2.0 and jdk1.5.0_06. here are the drivers i've used : -sqljdbc_1.1.1501.101 -sqljdbc_1.2.2828.100 . Exception in thread "main" java.lang.SecurityException: invalid SHA1 signature f ile digest for com/microsoft/sqlserver/jdbc/SQLServerException.class at sun.security.util.SignatureFileVerifier.verifySection(Unknown Source) at sun.security.util.SignatureFileVerifier.processImpl(Unknown Source) at sun.security.util.SignatureFileVerifier.process(Unknown Source) at java.util.jar.JarVerifier.processEntry(Unknown Source) at java.util.jar.JarVerifier.update(Unknown Source) at java.util.jar.JarFile.initializeVerifier(Unknown Source) at java.util.jar.JarFile.getInputStream(Unknown Source) at sun.misc.URLClassPath$JarLoader$2.getInputStream(Unknown Source) at sun.misc.Resource.cachedInputStream(Unknown Source) at sun.misc.Resource.getByteBuffer(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$000(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) i searched for this problem on the net and found that it could be something about manifest file. I controlled it but everything seemed OK. the content of the file is like that : Manifest-Version: 1.0 Created-By: Fat Jar Eclipse Plug-In Main-Class: mssql.Test_Connection Name: com/microsoft/sqlserver/jdbc/AppDTVImpl$SetValueOp.class Digest-Algorithms: MD5 SHA1 MD5-Digest: KrvkkdiHwdXHNmPcE9RQBQ== +SHA1-Digest: 6opr4+DKaQZj0Fr3FVaZUEm7jo8=+ Name: com/microsoft/sqlserver/jdbc/AppDTVImpl.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: nDtY9xaWCEF+HnuZII0/mQ==+ SHA1-Digest: DKIMpF6OfIdlemGRNzve/44H5Bc= Name: com/microsoft/sqlserver/jdbc/AsciiFilteredInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: MDazBTywxhvxqlUrhkPxow== +SHA1-Digest: OVOhhS+HSPRJRBlmM65EINXM984=+ Name: com/microsoft/sqlserver/jdbc/AsciiFilteredUnicodeInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: KFMWLcM7G/HaooQeoAslOA== +SHA1-Digest: 4SOJmXOY0Av56Pc5u0qgF+/GMzY=+ Name: com/microsoft/sqlserver/jdbc/AuthenticationJNI.class Digest-Algorithms: MD5 SHA1 MD5-Digest: owvL9clivyEz2OD4njgW5g== SHA1-Digest: jacrgyzx0s31HQuYEGl4knZZtv4= Name: com/microsoft/sqlserver/jdbc/BaseInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 8UwiSw2I6D8vJ0MAlHn8HQ== SHA1-Digest: AlpmKqvo88cY4iIqqn39PI2PFJw= Name: com/microsoft/sqlserver/jdbc/CharacterStreamSetterArgs.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 5FVUasVuBJJNhBaJXckXXA== +SHA1-Digest: NZmT+0FEnwq+PkZK98nto8dWhuI=+ Name: com/microsoft/sqlserver/jdbc/Column.class Digest-Algorithms: MD5 SHA1 MD5-Digest: QvaRl418P7vpLoCIwLy9hw== SHA1-Digest: NCKil6R7dY7PbYMwICn6oYQGAwU= Name: com/microsoft/sqlserver/jdbc/ColumnFilter.class Digest-Algorithms: MD5 SHA1 MD5-Digest: DM7QIlmxQqNTXJoTKTdgTw== SHA1-Digest: 4k5pCzi2O9lmADuEtNgj/DZUVJY= Name: com/microsoft/sqlserver/jdbc/DataType.class Digest-Algorithms: MD5 SHA1 MD5-Digest: LZ4lkzDrIxj6wb8yqarWRQ== SHA1-Digest: q2D0ord4ZMVzBkDZWMO0L8h0zBM= Name: com/microsoft/sqlserver/jdbc/DataTypeFilter.class Digest-Algorithms: MD5 SHA1 MD5-Digest: kcoFF4FJarGc8yX0K7Tsfg== SHA1-Digest: 6zvSgP97xHEVQURGizMQx8F6dQw= Name: com/microsoft/sqlserver/jdbc/DataTypes.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: OZduC9x+5pV8ae5UiBGq7Q==+ SHA1-Digest: zJlNR3lNWvwgC7ofCaVvTQO4FdM= Name: com/microsoft/sqlserver/jdbc/DDC.class Digest-Algorithms: MD5 SHA1 MD5-Digest: zl5b7X4pW9iywH3vQhSOBQ== SHA1-Digest: xk6f2qt5vWcRsXGWxXWDEJmQxpQ= Name: com/microsoft/sqlserver/jdbc/DTV$SendByRPCOp.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 7bEGlb/JluzfBUvBDKWHvQ== SHA1-Digest: gIHpiBKFMFAz/tsSPSGrq4lAFj4= Name: com/microsoft/sqlserver/jdbc/DTV.class Digest-Algorithms: MD5 SHA1 MD5-Digest: vaRSwQ78bW//c1VTyKnb9A== SHA1-Digest: nfrW3P32MeIw8qg8d3DHQ7YNQrM= Name: com/microsoft/sqlserver/jdbc/DTVExecuteOp.class Digest-Algorithms: MD5 SHA1 MD5-Digest: G8QurVN7tYmnmTjVJ6uZvA== SHA1-Digest: VGB6KQ59o6DxxlbTolM/rd58Roo= Name: com/microsoft/sqlserver/jdbc/DTVImpl.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: pGAguj+Rv1V/xT1nSuIjzw==+ +SHA1-Digest: oX7PSsD+kD2M9KF2UYCfxddM140=+ Name: com/microsoft/sqlserver/jdbc/FailoverInfo.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: 6JP2wEBAsNkBr+0LxF4whg==+ +SHA1-Digest: IvB9xfJ8XmekkvwJBIcaKb+QFv0=+ Name: com/microsoft/sqlserver/jdbc/FailoverMapSingleton.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: aF5O7S7CvEWL794WD6+OiQ==+ SHA1-Digest: 1KJIQf9oSWCxvQwRXCOfy3wKAOw= Name: com/microsoft/sqlserver/jdbc/FailoverServerPortPlaceHolder.class Digest-Algorithms: MD5 SHA1 MD5-Digest: pkRfv6DJMJ1cbI0ZySddcg== SHA1-Digest: 8BTm4gf0DsRZjQcXvpJWShsifaU= Name: com/microsoft/sqlserver/jdbc/InputStreamGetterArgs.class Digest-Algorithms: MD5 SHA1 MD5-Digest: xv6Xhp0ZG2p99HyHmlYIbA== +SHA1-Digest: xCBFkC12sC+x1RE4GmpzCuIuTLM=+ Name: com/microsoft/sqlserver/jdbc/InputStreamSetterArgs.class Digest-Algorithms: MD5 SHA1 MD5-Digest: J8uf9qc9dWOO2ibbpzNFkQ== +SHA1-Digest: PRyC+dDhkvkt5FBLLAb+YzEnB3I=+ Name: com/microsoft/sqlserver/jdbc/IntColumnFilter.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: M+JCCL/Pb4N3FVU3u4UGfw==+ SHA1-Digest: mGfh77qp7SqLpYmUPk9IDXdYJL4= Name: com/microsoft/sqlserver/jdbc/JDBCCallSyntaxTranslator.class Digest-Algorithms: MD5 SHA1 MD5-Digest: Biaf0h6ft3Z5YrDDoVwXmw== SHA1-Digest: w3Ptfkjn3GSjLaSyVlUY74tBQ9g= Name: com/microsoft/sqlserver/jdbc/Parameter$GetTypeDefinitionOp.class Digest-Algorithms: MD5 SHA1 MD5-Digest: nOiCtsYETd5f6VdQTVGsOw== SHA1-Digest: PfMpi0gL1onZJFUBIQiItbnGgo0= Name: com/microsoft/sqlserver/jdbc/Parameter.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: QobDlCAy+7wlVufP8gcFAQ==+ +SHA1-Digest: Tl+TkHWixps0mjL/f4P9TMnpNGg=+ Name: com/microsoft/sqlserver/jdbc/ParameterUtils.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: BJwnBdb3lCP+be777p406Q==+ SHA1-Digest: dMcur/9Ic0DiHxqGqhXBlIkWrtc= Name: com/microsoft/sqlserver/jdbc/PLPInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: hi0aHdabPRCPLLRUgJM6Ig== +SHA1-Digest: MkgTRyeFLK/xU2+xIWmxYncwXD4=+ Name: com/microsoft/sqlserver/jdbc/PLPXMLInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: ayb78OAA4rxOCs5tj9rEAw== SHA1-Digest: eA50cKPfKgujA/N3pOiYVxrEZBY= Name: com/microsoft/sqlserver/jdbc/PrecisionFilter.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: aHy3gx9qL5ijl+3tCkU2tA==+ SHA1-Digest: SSUICkdKyafZY970D62alfpjyfs= Name: com/microsoft/sqlserver/jdbc/ScrollWindow.class Digest-Algorithms: MD5 SHA1 MD5-Digest: myWNT/crSiPrLAkPVMTlzw== +SHA1-Digest: q0ZyiZZzZhFD3iKvMgTV+PNjnHM=+ Name: com/microsoft/sqlserver/jdbc/ServerDTVImpl.class Digest-Algorithms: MD5 SHA1 MD5-Digest: jpyUZ7Yc9o1nPdxvsQZy6w== +SHA1-Digest: ZmTZWrBm/Ut2+zEd7Am5LYEDk8E=+ Name: com/microsoft/sqlserver/jdbc/SimpleInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: pjWOjG0JtKNajWWbsfhL9w== +SHA1-Digest: R+UGgaa5ZizY+ufR9abFnE4+37I=+ Name: com/microsoft/sqlserver/jdbc/SLocaleMapItem.class Digest-Algorithms: MD5 SHA1 MD5-Digest: V9Do452KY5ID7rmgJWCbtA== SHA1-Digest: t2BXjxOEgH9hO0D0JZYTgHVbRrM= Name: com/microsoft/sqlserver/jdbc/SQLCollation.class Digest-Algorithms: MD5 SHA1 MD5-Digest: SE0dFaQH4uV/rKccaBZhSg== SHA1-Digest: NgGOCBHt37HI1GKXVU2m7MuiCZY= Name: com/microsoft/sqlserver/jdbc/SQLJdbcVersion.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: hHmVef0QLYb+OfjA8D/PTA==+ SHA1-Digest: 0LDcCKZMfMDTNGaQJeO11IayR/A= Name: com/microsoft/sqlserver/jdbc/SQLServerBlob.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: EoQ+WPH+Hg7k1hqGwFfQrw==+ +SHA1-Digest: jjmx72+oDGk33XVdLdvEGvTbjt4=+ Name: com/microsoft/sqlserver/jdbc/SQLServerBlobInputStream.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: xvligoWsSNvIb+XPhf7RVQ==+ SHA1-Digest: E41qtDrniBZ/vhDmloDP09PMPEU= Name: com/microsoft/sqlserver/jdbc/SQLServerBlobOutputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 3lP3NpbZYGKBiaD1QolVOg== SHA1-Digest: n94OEcWf3bvzv2n/OxtF/nvAWKk= Name: com/microsoft/sqlserver/jdbc/SQLServerCallableStatement$1ExecDoneHandler.class Digest-Algorithms: MD5 SHA1 MD5-Digest: IdATatJ0uvx8f84YHDbA7Q== SHA1-Digest: 9R3L6eOSI5nIbQLLppMDG6VmJik= Name: com/microsoft/sqlserver/jdbc/SQLServerCallableStatement$1OutParamHandler.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 9eINbGaphxjNDDl0N9FzuA== SHA1-Digest: PYHZskir/KroYtt5Qxc53mksc6s= Name: com/microsoft/sqlserver/jdbc/SQLServerCallableStatement$1ThreePartNamesParser.class Digest-Algorithms: MD5 SHA1 MD5-Digest: aDlNWb0hhOD2CJm0sNQtLQ== SHA1-Digest: E7D4PXImN3RLNVdix4LEtQoG3Vk= Name: com/microsoft/sqlserver/jdbc/SQLServerCallableStatement.class Digest-Algorithms: MD5 SHA1 MD5-Digest: FrMyeRMPh3z/DVC7YsMYww== SHA1-Digest: C1VeMECh92ssAtsGRXU4gFLcrSE= Name: com/microsoft/sqlserver/jdbc/SQLServerClob.class Digest-Algorithms: MD5 SHA1 MD5-Digest: ToPV4GRUVh0Jr6VlgbFCRg== +SHA1-Digest: w1WtM1+F6N208efp1Duvoed3p98=+ Name: com/microsoft/sqlserver/jdbc/SQLServerClobAsciiInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: frEBjWcXC6r4eU3GwzxToQ== SHA1-Digest: VMtsPTDullEEyIsxSKaROaiVkNU= Name: com/microsoft/sqlserver/jdbc/SQLServerClobAsciiOutputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 8ZUub0EulZVXTHyXFzzLgA== SHA1-Digest: X6SLryGWPiEheb4zvi8NpAvvlBI= Name: com/microsoft/sqlserver/jdbc/SQLServerClobCharacterReader.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: mTTxF0lk6+R4cmKcTaqQvA==+ +SHA1-Digest: tqj+ib1+L1KRfkxlr5L5zrXmtFs=+ Name: com/microsoft/sqlserver/jdbc/SQLServerClobWriter.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: Ru5HKt+19anL9/F8tAk8+A==+ SHA1-Digest: PNI6PkDs5dQur1aL8aZfYxwI6ks= Name: com/microsoft/sqlserver/jdbc/SQLServerConnection$1ConnectionCommand.class Digest-Algorithms: MD5 SHA1 MD5-Digest: b8k7fJuxhQtl4Z5PVbopVQ== +SHA1-Digest: 9ye9+Pgj9P6VjVghn3dIVU5CxLU=+ Name: com/microsoft/sqlserver/jdbc/SQLServerConnection$1DTCCommand.class Digest-Algorithms: MD5 SHA1 MD5-Digest: INB9j4Mys5q1j39Kb1frzA== SHA1-Digest: 4E4pvcjzufvIDL1zLCN1ezguj/8= Name: com/microsoft/sqlserver/jdbc/SQLServerConnection$1LogonProcessor.class Digest-Algorithms: MD5 SHA1 MD5-Digest: xXERxh6EKNOhyPkjxnZHYg== SHA1-Digest: G/McSB9K8oavRpnANxfriiGLYjo= Name: com/microsoft/sqlserver/jdbc/SQLServerConnection$LogonCommand.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: VbUNLXs+3JcBY6mRxH0Gew==+ SHA1-Digest: W1oCAj6tWQqsS5WWLJzqzXpIjuI= Name: com/microsoft/sqlserver/jdbc/SQLServerConnection.class Digest-Algorithms: MD5 SHA1 MD5-Digest: ukyApHFBROjacLamWuLOfg== SHA1-Digest: ozapup9ZhovU65UQdc5GEmapAAw= Name: com/microsoft/sqlserver/jdbc/SQLServerConnectionPoolDataSource.class Digest-Algorithms: MD5 SHA1 MD5-Digest: tCCb43ZUS/zQwh43resvfQ== SHA1-Digest: LsN1Eksk8jx/kZ85KXbXmmPPvgE= Name: com/microsoft/sqlserver/jdbc/SQLServerConnectionPoolProxy.class Digest-Algorithms: MD5 SHA1 MD5-Digest: Ukf60CZx2gBL2VeIqKss6Q== SHA1-Digest: td0mO6AlbkU7qg3OOkmmGfbb/jw= Name: com/microsoft/sqlserver/jdbc/SQLServerConnectionSecurityManager.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: uY+Jooai7bXZzYPavcEEQw==+ SHA1-Digest: SKQnRot6DNmdKbYDPn0Gyk7rwgU= Name: com/microsoft/sqlserver/jdbc/SQLServerDatabaseMetaData.class Digest-Algorithms: MD5 SHA1 MD5-Digest: D88Usnvd5yAL/dhkhe9Zeg== SHA1-Digest: TenfnnWHoTmTJBoY0/OCEm4OTkQ= Name: com/microsoft/sqlserver/jdbc/SQLServerDataSource.class Digest-Algorithms: MD5 SHA1 MD5-Digest: /bXQh8vsbTNbJFIu5Kxcsw== +SHA1-Digest: SGBQVSoql5ToxpAoSvX+TUe5cwA=+ Name: com/microsoft/sqlserver/jdbc/SQLServerDataSourceObjectFactory.class Digest-Algorithms: MD5 SHA1 MD5-Digest: CYpa9Jr8T/Zf8rcDW40hzQ== +SHA1-Digest: HLZtZjgqtC98Wrk2Ls+GsiQnGls=+ Name: com/microsoft/sqlserver/jdbc/SQLServerDriver.class Digest-Algorithms: MD5 SHA1 MD5-Digest: zshMOXd/YEIJsyKpfQ9wgw== SHA1-Digest: hXcQGtLhfTYOa3aFWq22tElaZG0= Name: com/microsoft/sqlserver/jdbc/SQLServerException.class Digest-Algorithms: MD5 SHA1 MD5-Digest: lq23ZC1Zh7BykHpcPvrL0A== +SHA1-Digest: jnt0iyDNlvX1cIXf0+TZfGKqNuI=+ Name: com/microsoft/sqlserver/jdbc/SQLServerParameterMetaData.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: II7ltsKX+WveohelGSnL8A==+ SHA1-Digest: fJrVP15RofvLl4MUWzTKuTNPNmQ= Name: com/microsoft/sqlserver/jdbc/SQLServerPooledConnection.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: +DYdyX1uX1+ptMRdkjXmGg==+ SHA1-Digest: FVrhnZQMRNKhCfCdn38K1QjxdT8= Name: com/microsoft/sqlserver/jdbc/SQLServerPreparedStatement$1PreparedHandleClose.class Digest-Algorithms: MD5 SHA1 MD5-Digest: Ks/NWndrZ8D7R7VX7v81jg== SHA1-Digest: qe2qUD7IJIni/dLgAExQgyW9x/Y= Name: com/microsoft/sqlserver/jdbc/SQLServerPreparedStatement$PrepStmtBatchExecCmd.class Digest-Algorithms: MD5 SHA1 MD5-Digest: CqiWHpE04CH1MEr/ORAqBA== SHA1-Digest: ufGGAEhJS9piDLcwXnK/HdbR0VU= Name: com/microsoft/sqlserver/jdbc/SQLServerPreparedStatement$PrepStmtExecCmd.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: J/TFdXECeUaZTy8ItGcbA== SHA1-Digest: nqo9O6Nb3bELP7x3JvtpzydFecU= Name: com/microsoft/sqlserver/jdbc/SQLServerPreparedStatement.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 712g/SBx7UXb/QuOcCiUkw== SHA1-Digest: NvkliHWgAVcYuNtihyMpyjr7eAw= Name: com/microsoft/sqlserver/jdbc/SQLServerResource.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: TLtJUW+aK9NsosZaEnPF0A==+ SHA1-Digest: zKxWyVtrfJH3r1T7MfAJ1IMF4MI= Name: com/microsoft/sqlserver/jdbc/SQLServerResource_de.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: E0ITpAMOm3/12uT2+ABkTw==+ SHA1-Digest: 3WyeiHOv0SpHCvpqQa362lMe9gU= Name: com/microsoft/sqlserver/jdbc/SQLServerResource_es.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: SRA0***+5xhNK763WLG+Sw==+ +SHA1-Digest: /KRsDPtqAI6pWH9PQPX1ZdE46c= Name: com/microsoft/sqlserver/jdbc/SQLServerResource_fr.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 6rCOBPChgstl2xJ7PdoesQ== SHA1-Digest: EpUWqvqIKTzs9yZKmdia2bzHb8w= Name: com/microsoft/sqlserver/jdbc/SQLServerResource_it.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: Em0Bw0BRQJGmXCz+CHb7wA==+ SHA1-Digest: /ibhwmn8BxJQ3DvZ220gSbSEwUA= Name: com/microsoft/sqlserver/jdbc/SQLServerResource_ja.class Digest-Algorithms: MD5 SHA1 MD5-Digest: oXJEk4ZxXYGbugt15DtNyw== +SHA1-Digest: VMki788zmJz+uaWNeBFnMuwyIbU=+ Name: com/microsoft/sqlserver/jdbc/SQLServerResource_ko.class Digest-Algorithms: MD5 SHA1 MD5-Digest: GH6o929hB1ZFNEs46WnQxw== SHA1-Digest: sRMe5dXciopIvOgP3w0V0v02Kzc= Name: com/microsoft/sqlserver/jdbc/SQLServerResource_sv.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 41UJW87qhrju6cCqR8lBVA== +SHA1-Digest: fqkc+nf9IAFRwurl4CVqsCppt8c=+ Name: com/microsoft/sqlserver/jdbc/SQLServerResource_zh_CN.class Digest-Algorithms: MD5 SHA1 MD5-Digest: GDrcoCEhsyQP39yeykA1tw== +SHA1-Digest: G/qAkBgLsukMyMBX+JnoEiC00+Y=+ Name: com/microsoft/sqlserver/jdbc/SQLServerResource_zh_TW.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: a9OENMRP+kjd5Or7sKm47w==+ +SHA1-Digest: byfJQu9LZR/b5UWBb/xHgk0+qc8=+ Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$1CloseServerCursorCommand.class Digest-Algorithms: MD5 SHA1 MD5-Digest: bgSdFMh3rRTsb6RJ2MSYsA== SHA1-Digest: mgC/PUAr6OvLYQHZQ3NOl3v6KRo= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$1CursorFetchCommand.class Digest-Algorithms: MD5 SHA1 MD5-Digest: ETHGFEJw6xxp6uZ0gVGEgQ== +SHA1-Digest: DEXtoBYY/yiRUT11cju/H9+JoRo=+ Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$1DeleteRowRPC.class Digest-Algorithms: MD5 SHA1 MD5-Digest: YMc3h4J0PKZPbdkxucrV6A== SHA1-Digest: oMNOy7U0MfDjLKJY/rXqB9JaecY= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$1InsertRowRPC.class Digest-Algorithms: MD5 SHA1 MD5-Digest: Pq3gYSCKvZCnn0uS9c4H9g== SHA1-Digest: xfmkmqjldysnYwiobk9Och3yU3c= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$1ServerCursorFixup.class Digest-Algorithms: MD5 SHA1 MD5-Digest: knpVbJIjmot2hEm6/756fQ== +SHA1-Digest: +0NFdr7+YS+xxNLDSXEmHUN1lt0=+ Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$1ServerFetchHandler.class Digest-Algorithms: MD5 SHA1 MD5-Digest: ypDMH2UBGh4MWg9hZNpCzg== SHA1-Digest: OLD7lZIiaaAOiiY7S8l9yaRkh4Y= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$1UpdateRowRPC.class Digest-Algorithms: MD5 SHA1 MD5-Digest: XQ/4DLfWDYfnjRs5csdmUg== SHA1-Digest: 5tgEWzJtKVD0cyQZEIEh7rwCpss= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.class Digest-Algorithms: MD5 SHA1 MD5-Digest: TOMon6DDTiB4iFrl80Yotw== SHA1-Digest: YEbZqGqQf1RVZ3ftnp5uAYVPdiw= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet$FetchBuffer.class Digest-Algorithms: MD5 SHA1 MD5-Digest: SSlLzOUtOHBEZdX8Dq2LGA== SHA1-Digest: OaDfXGsdoZAq5BHNZAb2CTpG8kY= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSet.class Digest-Algorithms: MD5 SHA1 MD5-Digest: yDTrB3lndMb/MhroUTQS3w== SHA1-Digest: SXfUedcDCGACFfxL6JNn8O0VcIs= Name: com/microsoft/sqlserver/jdbc/SQLServerResultSetMetaData.class Digest-Algorithms: MD5 SHA1 MD5-Digest: RG3FGCtLCv2QQy/ZR2DoEQ== SHA1-Digest: ZMkJ5dUjiv2ZBQ7HuRpL2xtAiN8= Name: com/microsoft/sqlserver/jdbc/SQLServerSavepoint.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: rSpPB+Od3pFexbAq4qdeAA==+ SHA1-Digest: 3G5fNJgIBakIvv4aAWnPb3n3KJE= Name: com/microsoft/sqlserver/jdbc/SQLServerStatement$1NextResult.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: AFoe87pDR6SpxJzmFfN+Pw==+ SHA1-Digest: f9MQypBr2/l5SGdokACgOVcli3o= Name: com/microsoft/sqlserver/jdbc/SQLServerStatement$ExecuteProperties.class Digest-Algorithms: MD5 SHA1 MD5-Digest: fQM74ufMBwnHpDk06PwsRg== +SHA1-Digest: iX85wzfzAGratMtBSI1npij+wes=+ Name: com/microsoft/sqlserver/jdbc/SQLServerStatement$StmtExecCmd.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: bHU0XvlCLC+GKbsHm9mG/g==+ +SHA1-Digest: es8aifOlK24xF8AbsqJOxJx78Q= Name: com/microsoft/sqlserver/jdbc/SQLServerStatement.class Digest-Algorithms: MD5 SHA1 MD5-Digest: dBX7k8Btr8bijgJJs7CwoA== SHA1-Digest: Kx5szvdYTA165gZEqza0fbckqDM= Name: com/microsoft/sqlserver/jdbc/SQLServerXAConnection.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: RU3ADesYUzYpu9ZWs0G+ww==+ SHA1-Digest: nPtre40RztB8W6FpCLdbuJN3CDQ= Name: com/microsoft/sqlserver/jdbc/SQLServerXADataSource.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 1YfhM9bKe6r9GYV7/7TwLQ== +SHA1-Digest: V+UTRrJc3aaVu5t3PzSAUiu1650=+ Name: com/microsoft/sqlserver/jdbc/SQLServerXAResource.class Digest-Algorithms: MD5 SHA1 MD5-Digest: IZ03u5AgZBUoXGkYH8FZmQ== SHA1-Digest: ammsb/CuvvyUZjzkhGJSDOCXwLo= Name: com/microsoft/sqlserver/jdbc/StreamColumns.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: EIQ9aWkn+LSxB0QUCD8N3g==+ SHA1-Digest: VUsN0QNLEMJX8zVlsarOs48dAaE= Name: com/microsoft/sqlserver/jdbc/StreamDone.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 0zEBZeiCsq30Lzx1ybTUzw== SHA1-Digest: /k8012fx3L1igb4EtJv7/ozSBbY= Name: com/microsoft/sqlserver/jdbc/StreamError.class Digest-Algorithms: MD5 SHA1 MD5-Digest: TWSkmcx3mLSdgNyXKUXP3w== SHA1-Digest: U/xZDcZAEivRztUGaccCknZYZAM= Name: com/microsoft/sqlserver/jdbc/StreamInfo.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: Wk+XWbXpyb56zk/1NIHtkQ==+ SHA1-Digest: opJPa29/fXDlqG0lSrLAB4uGm4o= Name: com/microsoft/sqlserver/jdbc/StreamLoginAck.class Digest-Algorithms: MD5 SHA1 MD5-Digest: cOa6txu1kQman9lXTM6tQg== SHA1-Digest: aFx2oE6cyrzEod/xbYocM/yTYXU= Name: com/microsoft/sqlserver/jdbc/StreamPacket.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: 93ifX3w+ybd+kyybjXvmSA==+ SHA1-Digest: u4i3z8N/26aWvbesb3RC3lx9Dao= Name: com/microsoft/sqlserver/jdbc/StreamRetStatus.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: Lc3yNgwP+wOLRseFmStjvg==+ +SHA1-Digest: QQGo91qQ2I3vO5VIPz0ZG+qK2tQ=+ Name: com/microsoft/sqlserver/jdbc/StreamRetValue.class Digest-Algorithms: MD5 SHA1 MD5-Digest: Zs9ihi0oknRRRQAYRkf/vA== SHA1-Digest: clage5yF7LxRezjb1swoMMfeVtI= Name: com/microsoft/sqlserver/jdbc/StreamSSPI.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 6RHEqETZE4BK7mWshie2Uw== +SHA1-Digest: Oew1yBSh9gc+zvlvchVHo3AFKQM=+ Name: com/microsoft/sqlserver/jdbc/TDS.class Digest-Algorithms: MD5 SHA1 MD5-Digest: dO0UHIN/SW6vUeSzmfNqsQ== +SHA1-Digest: t2fs/46/8vXk831guhQDXW4o5+Y=+ Name: com/microsoft/sqlserver/jdbc/TDSChannel$HostNameOverrideX509TrustManager.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: TYtYeEgPIr4G3f+AN7Xa4w==+ +SHA1-Digest: K4Yis+S4owGiYy78koCO21gh1hc=+ Name: com/microsoft/sqlserver/jdbc/TDSChannel$PermissiveX509TrustManager.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: /yggGP+izOmX6ZtwfVFqdQ==+ SHA1-Digest: QPL6px7AGSa7v8NaeIfUjqsEnIs= Name: com/microsoft/sqlserver/jdbc/TDSChannel$ProxyInputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: AQ3nysJTlSXZcemIeSCR0A== SHA1-Digest: DMs7k9KmOIxuZOzP0LIIJNkPzHI= Name: com/microsoft/sqlserver/jdbc/TDSChannel$ProxyOutputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: bdom5oSLvIa3gUMXb4X/xA== SHA1-Digest: SSf4ycrwEviG3kOPx2Y1Jm0HYuM= Name: com/microsoft/sqlserver/jdbc/TDSChannel$ProxySocket.class Digest-Algorithms: MD5 SHA1 MD5-Digest: n/RDAyFj0rxhcdAZZcxlSw== SHA1-Digest: RjFwsZKQ9fqt4oPZu49aTu/jlL4= Name: com/microsoft/sqlserver/jdbc/TDSChannel$SSLHandshakeInputStream.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: 2Hq5bOf+M5O+ZkRGOeI7jw==+ SHA1-Digest: QKtAd6iPOBmvgUIpqY0jHBCEXX8= Name: com/microsoft/sqlserver/jdbc/TDSChannel$SSLHandshakeOutputStream.class Digest-Algorithms: MD5 SHA1 MD5-Digest: tVt8UNtnbfCNluGAmR40gQ== SHA1-Digest: 1eJorvKJFE1p2TydhqppFjZTMuw= Name: com/microsoft/sqlserver/jdbc/TDSChannel.class Digest-Algorithms: MD5 SHA1 MD5-Digest: 1FVCaurZ4dxfXMr5b1UyVg== +SHA1-Digest: TJhluep5/s3Ln+ZJ9PKxmF6HNVI=+ Name: com/microsoft/sqlserver/jdbc/TDSCommand$1AttentionAckHandler.class Digest-Algorithms: MD5 SHA1 MD5-Digest: px2jPUbbtZS5LISk5kvFnw== +SHA1-Digest: Fghyqds9QQm3qjUt6ZG0GEyx+YA=+ Name: com/microsoft/sqlserver/jdbc/TDSCommand.class Digest-Algorithms: MD5 SHA1 MD5-Digest: ihuie5Pu3Q/dRuPOuEYn7w== SHA1-Digest: q/Nb/eEX4SMz6Btjb0ewdBgyo9w= Name: com/microsoft/sqlserver/jdbc/TDSPacket.class Digest-Algorithms: MD5 SHA1 MD5-Digest: GPrcJCKps8U3GFZZ2cv9UA== SHA1-Digest: Bp3t043cThJGevAmA0y1orjikHg= Name: com/microsoft/sqlserver/jdbc/TDSParser.class Digest-Algorithms: MD5 SHA1 MD5-Digest: cj2KCX97GmbhSwtbCHrRDA== SHA1-Digest: zMIJFyEfxZm5QCpqn2a2rclciCk= Name: com/microsoft/sqlserver/jdbc/TDSReader.class Digest-Algorithms: MD5 SHA1 MD5-Digest: GVTNRTKHfsxcIrrtwnNO/A== SHA1-Digest: CTiAFX6zGmusaNEpnbEOIZKRJlM= Name: com/microsoft/sqlserver/jdbc/TDSReaderMark.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: vmxP4o8xmrF+P41fFqLlXQ==+ SHA1-Digest: OikFwDggo1mQI27nicpP/ViyPIc= Name: com/microsoft/sqlserver/jdbc/TDSTokenHandler.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: 1b4h+8VTpRwXcf2ydIV9Zw==+ SHA1-Digest: B0M1HmLhm25qI991udMwFlp55ds= Name: com/microsoft/sqlserver/jdbc/TDSWriter.class Digest-Algorithms: MD5 SHA1 MD5-Digest: oGei/XbS7pK/sgdZE20swQ== SHA1-Digest: xsHqNdHufrZ1SG7xm1BlV71hrbs= Name: com/microsoft/sqlserver/jdbc/TimeoutTimer.class Digest-Algorithms: MD5 SHA1 MD5-Digest: qPVdK2tdV9Ric5IC8VTp4A== SHA1-Digest: WKHemeJfd8dco8mMHtuAigxB7dY= Name: com/microsoft/sqlserver/jdbc/TypeInfo.class Digest-Algorithms: MD5 SHA1 MD5-Digest: kyPtrRIFAvHLA2RLiPEaSA== +SHA1-Digest: cgArSVVR2bDuDJ+YQQm6pT83ZPE=+ Name: com/microsoft/sqlserver/jdbc/UDTTDSHeader.class Digest-Algorithms: MD5 SHA1 MD5-Digest: cFWFGGzYQsChDRXU4qwXnA== SHA1-Digest: i7XrxQlYeMa5MS58Pwh0uGXwZG0= Name: com/microsoft/sqlserver/jdbc/UninterruptableTDSCommand.class Digest-Algorithms: MD5 SHA1 MD5-Digest: uWgTVexos0jaqZfNFms95Q== +SHA1-Digest: HXdjxOUegAqRKGJ2Y+sHGvb+ugU=+ Name: com/microsoft/sqlserver/jdbc/Util.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: ow8+2U7DJQZ5B3Tasmac3A==+ SHA1-Digest: zd/Eh2rYU1dblqcOpwLWf7NF1E4= Name: com/microsoft/sqlserver/jdbc/XAReturnValue.class Digest-Algorithms: MD5 SHA1 MD5-Digest: NXp3iNEEoqIMObIvKvTipQ== +SHA1-Digest: odszdc6MFn6L+hxmJtNoOevaWbY=+ Name: com/microsoft/sqlserver/jdbc/XidImpl.class Digest-Algorithms: MD5 SHA1 +MD5-Digest: RU7zu+rqsphCXK/s8xCvug==+ +SHA1-Digest: 2ECxDbL3kDDEXXPk/E3BJC0l+MA=+ Name: com/microsoft/sqlserver/jdbc/XMLTDSHeader.class Digest-Algorithms: MD5 SHA1 MD5-Digest: bYFJI5zkearxmFgmB7W4eg== SHA1-Digest: u5OikuNUbfMd0oFsxA9ljw9PJ0Y= Name: sqljdbc.jar Digest-Algorithms: MD5 SHA1 MD5-Digest: 1B2M2Y8AsgTpgAmY7PhCfg== SHA1-Digest: 2jmj7l5rSw0yVb/vlWAYkK/YBwk= Name: sqljdbc.jar.old Digest-Algorithms: MD5 SHA1 MD5-Digest: 0sODYMNpQ2ytnSf/VNVnTw== +SHA1-Digest: PU1a6z+B4BuXkuUTLxGsgPjGvCI=+ is there anything i'm missing? do you have any idea?
View Replies !
View Related
Com.microsoft.sqlserver.jdbc.SQLServerException.class Throws Java.lang.SecurityException
I'm trying to connect to a sql server 2005 express edition but have some trouble with it: i can connect to sql server through eclipse IDE but when I create a jar and try connecting to server, I get the following error. Exception in thread "main" java.lang.SecurityException: invalid SHA1 signature f ile digest for com/microsoft/sqlserver/jdbc/SQLServerException.class at sun.security.util.SignatureFileVerifier.verifySection(Unknown Source) at sun.security.util.SignatureFileVerifier.processImpl(Unknown Source) at sun.security.util.SignatureFileVerifier.process(Unknown Source) at java.util.jar.JarVerifier.processEntry(Unknown Source) at java.util.jar.JarVerifier.update(Unknown Source) at java.util.jar.JarFile.initializeVerifier(Unknown Source) at java.util.jar.JarFile.getInputStream(Unknown Source) at sun.misc.URLClassPath$JarLoader$2.getInputStream(Unknown Source) at sun.misc.Resource.cachedInputStream(Unknown Source) at sun.misc.Resource.getByteBuffer(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$000(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) I'm using : - os : winxp - jdk1.5.0_06 - drivers : sqljdbc_1.1.1501.101 / sqljdbc_1.2.2828.100 is there anything i've missed? please, help me..
View Replies !
View Related
Transfer SQL Server Objects Task Throws An Error Because The DropObjectsFirst Property Does Not Check Whether Object Exists.
I wanted to create a package to copy the objects from one database to another and replace those object if they already exist. Therefore, before the package executes you do not know whether all the objects exist on the target server or only some of them. Using the 'Transfer SQL Server Objects Task' I have found that I cannot get this to execute cleanly by itself. If I set the 'DropObjectsFirst' to false then an error is thrown if the object exists and if I set it to true then an error is thrown if it does not exist. In order to get round this I have had to create an 'Execute SQL Task' to list all the objects and then go through them dropping them on the target server in a for each loop before executing the 'Transfer SQL Server Objects Task' with 'Transfer SQL Server Objects Task' set to false. However, is there a better way of achieving this or am I missing something in the 'Transfer SQL Server Objects Task'?
View Replies !
View Related
CASE Throws &&"Conversion Failed When Converting Datetime From Character String&&" Exception
Hi All, I have SQL query as: SELECT CASE @sortcolumn WHEN 'TYPE' THEN TYPE_TXT WHEN 'DATE' THEN CHECKOUT_TS WHEN 'ACCT' THEN ACCT_NBR WHEN 'FIRST' THEN FIRST_NM WHEN 'LAST' THEN LAST_NM WHEN 'DAYS' THEN DATEDIFF(dd, CHECKOUT_TS, GETDATE()) ELSE DELIVER_ID END FROM REQUEST If @sortcolumn has 'DATE' or 'DAYS' it runs fine....any other value, I get an exception "Conversion failed when converting datetime from character string". All columns except CHECKOUT_TS are of type varchar. Any help would be greatly appreciated. Thanks, Shashi
View Replies !
View Related
Script Component Throws Object Reference Not Set To An Instance Of An Object
Hello, I've ran into trouble while creating a rather simple transformation script component (one input, one output). The only thing it has to do is test the values coming from it's input rows and set the values of the output rows according to some rules; something like: Code Block Public Overrides Sub InputBrowser_ProcessInputRow(ByVal Row As InputBrowserBuffer) If Row.UserAgent.Contains("MSIE") Then 'test input Row.BrowserName = "Internet Explorer" 'set output End If End Sub This raises an "Object reference not set to an instance of an object." exception. Commenting out the input (Row.UserAgent) solves the exception, but I actually do need to test the contents of the input row (and by leaving only the output manipulation, the script won't reach it's end, the components remain yellow). What can I do about this? Thanks in advance!
View Replies !
View Related
Stopping SQL Server 2005 Via Local Management Studio Throws Error &&"RPC-server Is Not Available&&"
Hi everybody, I use my local installed Management Server to stop SQL Server 2005 instances. I use the context menu of the "registered Servers" window. That works fine several times. Today I suddenly got error message "RPC-server is not available. (As we run a german version the exact error message is : "Der RPC-Server ist nicht verfügbar (Exception from HRESULT: 0x800706BA) (mscorlib)"). I checked the services of the machine hosting the SQL Server, but verything seems to be OK. I rebooted the maschine without success. I don't know what happened. But I installed a lot of Updates from MS update site. I think it has something to do with one of these updates. By the way, it is no problem to stop SQL Server via Management Studio installed on the maschine that host the SQL Server! Anyone experience the same problem ? Wolfgang
View Replies !
View Related
Flat File Connection Manager Throws Error When A Column Gets Added To The Flat File
Hi, I have a situation where a tab limited text file is used to populate a sql server table. The tab limited text file comes from a third party vendor. There are fixed number of columns we need to export to the sql server table. However the third party may add colums in the text file. Whenenver the text file has an added column (which we dont need to import) the build fails since the flat file connection manager does not create the metadata for it again. The problem goes away where I press the button "Reset Columns" since it builds the metadata then. Since we need to build the tables everyday we cannot automate it using SSIS because the metadata does not change automatically. Is there a way out in SSIS?
View Replies !
View Related
|
TRACKER
