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 Complete Forum Thread with Replies
Related Forum Messages:
Retrieving Result Set From Dynamically Called Stored Procedure Or Function In A Function
Is there any way I can retrieve the result set of a Stored Procedurein a function.ALTER FUNCTION dbo.fn_GroupDeviceLink(@groupID numeric)RETURNS @groupDeviceLink TABLE (GroupID numeric, DeviceID numeric)ASBEGINDeclare @command nvarchar(255)SELECT @command = Condition// @command is an SQL string or stored procedue nameFROM DeviceGroupWHERE GroupID = @groupIDINSERT @groupDeviceLinkEXEC @commandRETURNENDIs there any way i can do anything like this. @command is a variableholding the name of a stored produre. I need to run that storedprocure and return the values in such a way that they can be used in aSELECT StatementMy goal is SELECT * FROM Device INNER JOINdbo.fn_GroupDeviceLink(@groupID) ON ....this fn_GroupDeviceLink should run the proper stored procedure andreturn the values. What i also want to do is play with that result setof the specific stored procedure before i return it. Is this possible?If not, what is the work arround?ThanksMark
View Replies !
Function Returing As Double But When Called Giving An Error
Hello all, This is the Function: Public Dim GrossValue As double = 0.00 Public Function GetGrossValue(ByVal dPymt as Double,ByVal dFlag as Boolean) As Double If(dFlag = False) Then GrossValue = GrossValue + dPymt Return GrossValue Else Return 0.00 End If End Function Public Function ResetValue() GrossValue = 0.00 End Function I am calling this function in a textbox =IIF(Fields!IsEarnCancelled.Value, Nothing, (Code.GetGrossValue(Fields!Gross.Value,Fields!IsEarnCancelled.Value))) I DO NOT KNOW where I am doing wrong. But it is giving me "The Value expression for the textbox ''textbox200" contains an error: Input string was not in correct format. Please help
View Replies !
Bug In SqlCommandBuilder.DeriveParameters?
Hi there We tried to use SqlCommandBuilder.DeriveParameters on .Net Compact FW 2.0. It does pull in parameters of the stored procedure and the parameters do look valid (right quantity, right data types etc). However as soon as one tries to execute the command populated with DeriveParameters an internal exeption occurs which gives no clue about what it might be, just a general error somewhere deep in a procedure which has "Internal" postfix in its name. If we run that same executable compiled for compact framework 2.0 on a regular PC with "big" FW, it runs perfectly and no problems occur. That makes me think there's a bug with DeriveParameters in Compact FW 2.0 which is not present in the regular FW. Is there anything we can do? We can populate Parameters manually although that doesn't really suit us, we also can read SCHEMA information to populate them for any given procedure, but we'd like to get DeriveParameters work instead.
View Replies !
Caching Or Reusing Parameters Populated With SqlCommandBuilder.DeriveParameters
Hello, I have a real heartache with runtime parameter interogation on my DB. Sure I get the latest and greatest and sure I don't have to type in all those lovely parameter types..but...the hit I take on performance for making no less then 3 DB hits for each SqlAdapter is unreasonable! So ...I like the idea of maybe calling it once for all my stored procs on application startup...and then maybe saving this in CacheObject. My problem is that I can't see where you can even serialize a SqlParametersCollection or even for that matter assign it to a Command object. Can you cache a command object ? LOL I think I may just have to write some generic routine for creating and populating my command objects based on a key (type) and then use that to fetch my command.Update, command.Insert and command. I would like to use the new AsynchBlock to do the fetching of the stored proc parameters and then just pull them from the Cache object....put a file watch so that if the DB's change my params it re-pulls them again. *nice*..... Then I get the best of both worlds...caching...and no parameter writing... Eric
View Replies !
EnterpriseLibrary Multi Owner Stored Procs DeriveParameters Failure
Hi I am having diffuculty with multi owner stored procs with enterprise library deriveparameters. Eg: Create proc dbo.test @p1 int as select 'hi' create proc bob.test @p1 int as select 'hi' Deriveparameters appears to tell us the wrong number of parameters. I gather it is getting ALL the parameters for all procs called 'test' regardless of the owner. If anyone can give me some guidance on this I would appreciate it! Rich
View Replies !
Sp_create_trace Throws Errorcode = 12
Hi,I'm trying to execute server-side trace with SqlServer 2000 oncluster. After scripting trace by Profiler I executed this script inQueryanalyzer and got error code 12. According to BOL this code saysthat file is not created but I don't know why, is there are anyobstacles which preventing to add this trace??Does anybody had that problem?If it helps I added script which I tried to execute:-- Create a Queuedeclare @rc intdeclare @TraceID intdeclare @maxfilesize bigintset @maxfilesize = 5exec @rc = sp_trace_create @TraceID output, 0, N'C:Profiler_result esult.trc', @maxfilesize, NULLif (@rc != 0) goto error-- Client side File and Table cannot be scripted-- Set the eventsdeclare @on bitset @on = 1exec sp_trace_setevent @TraceID, 10, 1, @on/*here are n-setevents*/exec sp_trace_setevent @TraceID, 43, 35, @on-- Set the Filtersdeclare @intfilter intdeclare @bigintfilter bigintexec 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 startexec sp_trace_setstatus @TraceID, 1-- display trace id for future referencesselect TraceID=@TraceIDgoto finisherror:select ErrorCode=@rcfinish:goThanks in advance for any adviceRegards,Bartolo
View Replies !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
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 !
ReportViewer Control Throws OutOfMemory Exception For Large Data
I have a dataset with 500,000 records and I'm getting the following error with ReportViewer control for local report. "An error has occurred during local report processing. An error has occurred during report processing. Exception of type System.OutOfMemoryException was thrown. any help with this would be highly appreciated.
View Replies !
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 !
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 !
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 !
What Is This Called?
Hi, I just want to know how do you called when you are accessing another pc thru \. I forgot how it is called. Second, I like to know what [MACH] and [INST]. They don't look like directories. \MultforestHEALTH[MACH][INST]HEALTH_WAREHOUSEDeploy_20080228p_Vitals_FACT.sql'
View Replies !
Called Web Page From DTS
How can I execute or access a web page from a DTS package? Both SQL server AND website are hosted on the same server (a Dual 2.4Gz Xeon with 2Gb RAM, RAID 5 etc) I have 2 tables in SQL server 2000 that hold orders. These need to be posted into another table at a predefined time (ie: 4:30pm) and at the same time, access a remote address (a web service) and post certain elements of the order back. Basically, can anyone help me out on how to execute a web page from a DTS. I do NOT want to access a DTS from a webpage, which is all I'm finding at the moment.
View Replies !
Need A So-Called SSN Encryption
Hello, perhaps you guys have heard this before in the past, but here iswhat I'm looking for.I have a SQL 2000 table with Social security numbers. We need tocreate a Member ID using the Member's real SSN but since we are notallowed to use the exact SSN, we need to add 1 to each number in theSSN. That way, the new SSN would be the new Member ID.For example:if the real SSN is: 340-53-7098 the MemberID would be 451-64-8109.Sounds simply enough, but I can't seem to get it straight.I need this number to be created using a query, as this query is areport's record source.Again, any help would be appreciated it.
View Replies !
How Do I Specify More Than I Argument In A Called SP?
CREATE PROCEDURE sp_getT @m1 int , @txn int , @Pan varchar(50) , @Act varchar(50) OUTPUT, @Bal Decimal(19,4) OUTPUT, @CBal Decimal(19,4) OUTPUT AS declare @pBal money, @pCbal money, @pAct money SET NOCOUNT ON IF @m1 = 200 BEGIN IF @txn = 31 BEGIN exec ChkBal @Pan, @pBal output, @pCbal output, @pAct out END END SET @Act = @pAct SET @Bal = cast(@pBal as Decimal(19,4)) SET @CBal = cast(@pCBal as Decimal(19,4)) return @Act return @Bal return @CBal the above code returns this error message "Server: Msg 8144, Level 16, State 2, Procedure CheckBalance, Line 0 Procedure or function ChkBal has too many arguments specified." How do i specify all the arguments i want in the called procedure?
View Replies !
What Is This Methodology Called
Hi everyone - I'm stumped on what to cal this, there might even be a method or pattern named for what i am trying to accomplish... In the database, a number field is included on each table When the DAL reads the record from the database, it is passed to the client - work is possibly done to the record and is sent back to the DAL for update. A query is done against the table to retrieve the record again, the numbers are compared - if they don't match, it is assumed the record been modified by another user/thread/activity. An error is returned to the client stating the data has been changed. if the numbers match, the record is updated with the number field being incremented by one. what is this methodology called (beside crap :-) ) thanks tony
View Replies !
Coinitialization Has Not Been Called
Hello, Question is, when I try to create relationships in SQL 7 without using the wizard..upon adding the tables I get an errror message that says "Coinitialization has not been called". What does this mean?
View Replies !
UDF Used In SubQuery: Is It Called At EACH Row?
Hi, When a column is evaluated against an UDF in a SELECT ... or WHERE ... It makes sense that the UDF is called for every row of the SELECT. But is it still true if the UDF is called in a subquery as below? Code Snippet SELECT LineID, AnyText FROM dbo.UdfTest WHERE LineID IN (SELECT LineID FROM dbo.F_Bogus()) I've made a test and the SQL Profiler Trace shows that the UDF is called only once. Can anyone confirm if my test is valid and most importantly that the UDF is called only once? FYI, I never use sub queries. This is to clarify a technical detail for our performance investigation. Thank in advance for any help. Here is the code to setup the test: USE NorthWind GO CREATE TABLE dbo.UdfTest ( LineID int Identity(1,1) NOT NULL, AnyText varchar(200) COLLATE database_default NOT NULL ) GO INSERT dbo.UdfTest (AnyText) VALUES ('Test1') INSERT dbo.UdfTest (AnyText) VALUES ('Test2') INSERT dbo.UdfTest (AnyText) VALUES ('Test3') GO CREATE FUNCTION dbo.F_Bogus ( ) RETURNS @tab TABLE ( LineID int NOT NULL, AnyText varchar(100) COLLATE database_default NOT NULL) AS BEGIN INSERT @tab (LineID, AnyText) VALUES (1, 'UDF1') INSERT @tab (LineID, AnyText) VALUES (2, 'UDF2') INSERT @tab (LineID, AnyText) VALUES (3, 'UDF3') INSERT @tab (LineID, AnyText) VALUES (4, 'UDF4') INSERT @tab (LineID, AnyText) VALUES (5, 'UDF4') RETURN END GO Here is the capture of SQL Profiler when executing the statement: SELECT LineID, AnyText FROM dbo.UdfTest WHERE LineID IN (SELECT LineID FROM dbo.F_Bogus()) SQL:BatchStarting SELECT LineID, AnyText FROM dbo.UdfTest WHERE LineID IN (SELECT LineID FROM dbo.F_Bogus()) 51 2008-05-06 17:58:31.543 SQLtmtStarting SELECT LineID, AnyText FROM dbo.UdfTest WHERE LineID IN (SELECT LineID FROM dbo.F_Bogus()) 51 2008-05-06 17:58:31.543 SPtarting SELECT LineID, AnyText FROM dbo.UdfTest WHERE LineID IN (SELECT LineID FROM dbo.F_Bogus()) 51 2008-05-06 17:58:31.577 SPtmtCompleted -- F_Bogus INSERT @tab (LineID, AnyText) VALUES (1, 'UDF1') 51 2008-05-06 17:58:31.577 SPtmtCompleted -- F_Bogus INSERT @tab (LineID, AnyText) VALUES (2, 'UDF2') 51 2008-05-06 17:58:31.577 SPtmtCompleted -- F_Bogus INSERT @tab (LineID, AnyText) VALUES (3, 'UDF3') 51 2008-05-06 17:58:31.577 SPtmtCompleted -- F_Bogus INSERT @tab (LineID, AnyText) VALUES (4, 'UDF4') 51 2008-05-06 17:58:31.577 SPtmtCompleted -- F_Bogus INSERT @tab (LineID, AnyText) VALUES (5, 'UDF4') 51 2008-05-06 17:58:31.577 SPtmtCompleted -- F_Bogus RETURN 51 2008-05-06 17:58:31.577 SQLtmtCompleted SELECT LineID, AnyText FROM dbo.UdfTest WHERE LineID IN (SELECT LineID FROM dbo.F_Bogus()) 51 2008-05-06 17:58:31.543 SQL:BatchCompleted SELECT LineID, AnyText FROM dbo.UdfTest WHERE LineID IN (SELECT LineID FROM dbo.F_Bogus()) 51 2008-05-06 17:58:31.543
View Replies !
How Triggers Are Called
This seems like a basic question but I have not been able to find the answer in the help files or by searching this forum. Is a trigger called for each row updated or is it called once for all rows updated? for example if I have: Code Snippet CREATE TRIGGER mytrigger ON mytable AFTER UPDATE AS BEGIN EXEC e-mail-me inserted, N'mytrigger', getdate() END and I do this Code Snippet UPDATE mytable SET mycolumn = N'whatever' WHERE ID > 5 AND ID <= 10 Assuming there is a record for each nteger value of ID, than will mytrigger run 5 times (once for each row updated) or one time (with inserted containing all 5 rows)?
View Replies !
Cursor Can Not Be Seen In Called SP
Good day, I got a main Stored procedure sp_A which calls another stored procedure sp_B. Important fact: Running the called SP sp_B works without problem. As soon as I call sp_B from sp_A I get the following message: "A cursor with the name 'C1' does not exist." Cursor C1 in sp_B is dynamically built: SET @sql ='DECLARE C1 CURSOR GLOBAL FOR SELECT ranking FROM OPENROWSET(' + @apo+@int_provider_name+@apo+ ',' + @apo+@int_provider_string+@apo + ',' + @apo+@int_query_string+@apo + ') FOR READ ONLY' EXEC(@SQL) Yes, the burden of dynamic SQL. I assume I need to move the other steps (open / fetch etc.)into the same scope. Anybody any idea ? Thanks: Peter
View Replies !
How To Check Which Tables Were Called?
Hello everyone: I have some nightly jobs that execute stored procedure to call the tables? I want to know which table are called by these stored procedures. Is it possible? Any idea will be appreciated. Thanks ZYT
View Replies !
SP Not Working Correctly? When Called From App
Hi In a stored procedure the following code snippet 1 checks against duplicate data being inserted. I've tested it with snippet 2 and it works as expected. However, when the procedure is called from ASP.NET the check seems ineffective. I still get the error msg. The application uses a SqlDataSource with the following parameters. Any suggestions? Thanks, Bakis. PS I want to ask a question on the ASP.NET forum .The login/pwd for this forum "get me in" to the .net forum in the sense that when I log in I see a logout link. I don't get an "ask a question" button though. Is there a separate screening for each forum? <UpdateParameters> <asp:Parameter Name="CatItemUID" Type="Int32" /> <asp:Parameter Name="CatName" Type="String" /> <asp:Parameter Name="Item" Type="String" /> <asp:Parameter Name="Quad" Type="Int16" /> <asp:Parameter Name="UID" Type="Int64" /> </UpdateParameters> snippet 1 : if (@CatItemComboExists > 0 ) BEGIN --print @CatItemComboExists return 0 END snippet 2: begin tran declare @return_status int EXECUTE @return_status = spUpdateCatItemRec 343, 'blah','blih', 2,3 print @return_status rollback error msg only if proc is called from app Violation of UNIQUE KEY constraint 'IX_tblCatItemUID'. Cannot insert duplicate key in object 'tblCatItemUID'.
View Replies !
|
TRACKER
