SqlDatetime-Overflow On Production Server
Hey everybody!
I'm getting a pretty annoying error on my production server when i want to run an app ..
Error Msg (german): SqlDateTime-Ãœberlauf; muss zwischen 1/1/1753 12:00:00 AM und 12/31/9999 11:59:59 PM liegen.
Funny thing is that on my client development machine i'm not getting an error at all. The DateTimes I use (C# and SQL Server) are dd/mm/yyyy hh:mm:ss formatted. I also don't write to the databse - only read!
Anyone familiar with this issue?
Thanks in advance & best regards!
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
SqlDateTime Overflow
I've seen a few comments on this error and they've all been basically "You're passing a bad date time". I don't think that's what's happening in my case though. I'm trying to write a record to my SQL database using a business logic layer class that writes the record with a stored procedure. Here's the codebehind on the page: Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) 'Create New User UsersBLL.NewUser(txtFirstName.Text, _ txtLastName.Text, _ txtPhone1.Text, _ ddlOffice.SelectedIndex, _ lblManager.Text, _ lblManagerAlt.Text, _ txtDepartment.Text, _ cbxNewPosition.Checked, _ cbxContractor.Checked, _ Calendar1.SelectedDate.ToString, _ txtJobTitle.Text, _ ddlFunctionCodes.SelectedIndex) End Sub Here's the BLL function that I'm calling: Public Shared Function NewUser(ByVal UsersNameFirst As String, _ ByVal UsersNameLast As String, _ ByVal UsersPhone1 As String, _ ByVal OfficesID As Int32, _ ByVal UsersID_Manager As Int32, _ ByVal UsersID_ManagerAlt As Int32, _ ByVal UsersDepartment As String, _ ByVal UsersNewPosition As Boolean, _ ByVal UsersContractor As Boolean, _ ByVal UsersStartDate As DateTime, _ ByVal UsersJobTitle As String, _ ByVal FunctionCodesID As Int32, _ Optional ByVal UsersGSN As String = Nothing, _ Optional ByVal UsersEmail As String = Nothing, _ Optional ByVal UsersNameMiddle As String = Nothing, _ Optional ByVal UsersKnownAs As String = Nothing, _ Optional ByVal UsersPhone2 As String = Nothing, _ Optional ByVal UsersPhoneMobile1 As String = Nothing, _ Optional ByVal UsersPhoneMobile2 As String = Nothing, _ Optional ByVal UsersSSN As String = Nothing, _ Optional ByVal UsersContractType As String = Nothing, _ Optional ByVal UsersContractAgency As String = Nothing, _ Optional ByVal UsersEndDate As DateTime = Nothing, _ Optional ByVal UsersCompanyCode As String = Nothing, _ Optional ByVal UsersCostCenter As String = Nothing, _ Optional ByVal UsersRole As String = Nothing, _ Optional ByVal StatusesID As Int32 = Nothing) Dim dbConnection As SqlConnection, Command As SqlCommand dbConnection = New SqlConnection(DBConnectionString) dbConnection.Open() Command = New SqlCommand("EXECUTE NewUser", dbConnection) Command.Connection = dbConnection Command.CommandText = "NewUser" Command.CommandType = Data.CommandType.StoredProcedure Command.Parameters.Add(New SqlParameter("@UsersNameFirst", UsersNameFirst)) Command.Parameters.Add(New SqlParameter("@UsersNameLast", UsersNameLast)) Command.Parameters.Add(New SqlParameter("@UsersPhone1", UsersPhone1)) Command.Parameters.Add(New SqlParameter("@OfficesID", OfficesID)) Command.Parameters.Add(New SqlParameter("@UsersID_Manager", UsersID_Manager)) Command.Parameters.Add(New SqlParameter("@UsersID_ManagerAlt", UsersID_ManagerAlt)) Command.Parameters.Add(New SqlParameter("@UsersNewPosition", UsersNewPosition)) Command.Parameters.Add(New SqlParameter("@UsersContractor", UsersContractor)) Command.Parameters.Add(New SqlParameter("@UsersStartDate", UsersStartDate)) Command.Parameters.Add(New SqlParameter("@UsersJobTitle", UsersJobTitle)) Command.Parameters.Add(New SqlParameter("@FunctionCodesID", FunctionCodesID)) Command.Parameters.Add(New SqlParameter("@UsersGSN", UsersGSN)) Command.Parameters.Add(New SqlParameter("@UsersEmail", UsersEmail)) Command.Parameters.Add(New SqlParameter("@UsersNameMiddle", UsersNameMiddle)) Command.Parameters.Add(New SqlParameter("@UsersKnownAs", UsersKnownAs)) Command.Parameters.Add(New SqlParameter("@UsersPhone2", UsersPhone2)) Command.Parameters.Add(New SqlParameter("@UsersPhoneMobile1", UsersPhoneMobile1)) Command.Parameters.Add(New SqlParameter("@UsersPhoneMobile2", UsersPhoneMobile2)) Command.Parameters.Add(New SqlParameter("@UsersSSN", UsersSSN)) Command.Parameters.Add(New SqlParameter("@UsersContractType", UsersContractType)) Command.Parameters.Add(New SqlParameter("@UsersContractAgency", UsersContractAgency)) Command.Parameters.Add(New SqlParameter("@UsersEndDate", UsersEndDate)) Command.Parameters.Add(New SqlParameter("@UsersCompanyCode", UsersCompanyCode)) Command.Parameters.Add(New SqlParameter("@UsersCostCenter", UsersCostCenter)) Command.Parameters.Add(New SqlParameter("@UsersCostCenter", UsersCostCenter)) Command.Parameters.Add(New SqlParameter("@UsersRole", UsersRole)) Command.Parameters.Add(New SqlParameter("@StatusesID", StatusesID)) Return Command.ExecuteScalar() dbConnection.Close() Here's the stored procedure I'm running in SQL: ( @UsersGSNvarchar(20) = Nothing, @UsersNameFirstvarchar(20), @UsersNameMiddlevarchar(20) = Nothing, @UsersNameLastvarchar(20), @UsersKnownAsvarchar(20) = Nothing, @UsersPhone1varchar(50), @UsersPhone2varchar(50) = Nothing, @UsersPhoneMobile1varchar(20) = Nothing, @UsersPhoneMobile2varchar(20) = Nothing, @UsersEmailvarchar(50) = Nothing, @OfficesIDint, @UsersDepartmentvarchar(50), @UsersSSNvarchar(5) = Nothing, @UsersNewPositionbit, @UsersContractorbit, @UsersContractTypevarchar(20) = Nothing, @UsersContractAgencyvarchar(50) = Nothing, @UsersStartDatedatetime, @UsersEndDatedatetime = Nothing, @UsersJobTitlevarchar(50), @FunctionCodesIDint, @UsersCompanyCodevarchar(20) = Nothing, @UsersCostCentervarchar(20) = Nothing, @UsersID_Managerint, @UsersID_ManagerAltint, @UsersRolevarchar(20) = "User", @StatusesIDint = 1 ) AS SET NOCOUNT OFF; INSERT INTO [Users] (UsersGSN, UsersNameFirst, UsersNameMiddle, UsersNameLast, UsersKnownAs, UsersPhone1, UsersPhone2, UsersPhoneMobile1, UsersPhoneMobile2, UsersEmail, OfficesID, UsersDepartment, UsersSSN, UsersNewPosition, UsersContractor, UsersContractType, UsersContractAgency, UsersStartDate, UsersEndDate, UsersJobTitle, FunctionCodesID, UsersCompanyCode, UsersCostCenter, UsersID_Manager, UsersID_ManagerAlt, UsersRole, StatusesID) VALUES (@UsersGSN, @UsersNameFirst, @UsersNameMiddle, @UsersNameLast, @UsersKnownAs, @UsersPhone1, @UsersPhone2, @UsersPhoneMobile1, @UsersPhoneMobile2, @UsersEmail, @OfficesID, @UsersDepartment, @UsersSSN, @UsersNewPosition, @UsersContractor, @UsersContractType, @UsersContractAgency, @UsersStartDate, @UsersEndDate, @UsersJobTitle, @FunctionCodesID, @UsersCompanyCode, @UsersCostCenter, @UsersID_Manager, @UsersID_ManagerAlt, @UsersRole, @StatusesID); Seems about as simple as it can get to me. UsersStartDate is a datetime (which I'm picking from a calendar control on the web page) and it's passing (for example) "08/01/2007 12:00:00 AM". I've debugged and that's the value being passed. Now when I go to my DB and write a simple insert query and insert exactly that date, it works fine. Maybe my development machine date settings are changing it somehow before it sends to the DB? Also I'm pretty sure there's a lot of redundant passing of all those vars but I'm brand new to tiered apps and just learning. If there's a simpler way, feel free to enlighten me. :)
View Replies !
View Related
SqlDateTime Overflow
Hi All, Please help!!! I've looked all over the place and tried all the solutions that worked for others. I just want to insert a Null value to a DateTime field in my SQL db! I am calling dv_ItemInserting on ItemInserting of my FormView. I tried using a stored procedure to fix this problem SET @opDate = NullIf(@opDate, NULL). I am still getting the same error. Please forward any info you have. Thanks!!! ---------------------------------------------- Error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Protected Sub dv_ItemInserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertEventArgs) If e.Values.Item("opDate").Equals(Nothing) OrElse e.Values.Item("opDate").Equals(DateTime.MinValue) Then'Tried the followings and they do not work !!! 'SqlDataSource1.InsertParameters("opDate").DefaultValue = System.DBNull.Value 'e.Values.Item("opDate") = System.Data.SqlTypes.SqlDateTime.Null.Value end if End sub
View Replies !
View Related
SqlDateTime Overflow.
Hello, I have a method that inserts on a table. it retrieves the values from a formview, there are some calendars and I select dates for each date field.The strange thing is that I placed breakpoints at the beginning of the method but the debugger never gets there, the sqldatabase has the fields with type datetimeand here is the insertmethod but as I say above the debugger never gets there? public Guid insertarPersona(Persona p) { SqlConnection sqlconn = new SqlConnection(_connectionstring); try { //MembershipUser user= Membership.CreateUser(, password); //Guid guidusername = (Guid)Membership.GetUser(username).ProviderUserKey; SqlCommand sqlcmd = new SqlCommand("insPersonas", sqlconn); sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Add("@idpersona", SqlDbType.UniqueIdentifier); Guid nuevapersona = new Guid("dddddddd-dddd-dddd-dddd-dddddddddddd"); sqlcmd.Parameters["@idpersona"].Value = nuevapersona; sqlcmd.Parameters.Add("@idtipoidentificacion", SqlDbType.TinyInt); sqlcmd.Parameters["@idtipoidentificacion"].Value = (Int32)p.idTipoidentificacion; sqlcmd.Parameters.Add("@identificacion", SqlDbType.NChar, 20); sqlcmd.Parameters["@identificacion"].Value = p.Identificacion; sqlcmd.Parameters.Add("@primernombre", SqlDbType.NChar, 50); sqlcmd.Parameters["@primernombre"].Value = p.Primernombre; sqlcmd.Parameters.Add("@segundonombre", SqlDbType.NChar, 50); sqlcmd.Parameters["@segundonombre"].Value = p.Segundonombre; sqlcmd.Parameters.Add("@primerapellido", SqlDbType.NChar, 50); sqlcmd.Parameters["@primerapellido"].Value = p.Primerapellido; sqlcmd.Parameters.Add("@segundoapellido", SqlDbType.NChar, 50); sqlcmd.Parameters["@segundoapellido"].Value = p.Segundoapellido; sqlcmd.Parameters.Add("@codigo", SqlDbType.NChar, 10); sqlcmd.Parameters["@codigo"].Value = p.Codigo; sqlcmd.Parameters.Add("@idestado", SqlDbType.TinyInt); sqlcmd.Parameters["@idestado"].Value = p.Idestado; sqlcmd.Parameters.Add("@pathfoto", SqlDbType.NChar, 50); sqlcmd.Parameters["@pathfoto"].Value = p.Pathfoto; sqlcmd.Parameters.Add("@idtipovinculacion", SqlDbType.TinyInt); sqlcmd.Parameters["@idtipovinculacion"].Value = p.idtipovinculacion; sqlcmd.Parameters.Add("@fechaingreso", SqlDbType.DateTime); sqlcmd.Parameters["@fechaingreso"].Value = p.Fechaingreso; sqlcmd.Parameters.Add("@fecharetiro", SqlDbType.DateTime); sqlcmd.Parameters["@fecharetiro"].Value = p.Fecharetiro; sqlcmd.Parameters.Add("@fechanacimiento", SqlDbType.DateTime); sqlcmd.Parameters["@fechanacimiento"].Value = p.Fechanacimiento; sqlcmd.Parameters.Add("@sexo", SqlDbType.NChar, 10); sqlcmd.Parameters["@sexo"].Value = p.sexo.ToString(); ; sqlconn.Open(); sqlcmd.ExecuteNonQuery(); return nuevapersona; } catch (SqlException sqlex) { throw sqlex; } catch (Exception ex) { throw ex; } finally { sqlconn.Close(); } }
View Replies !
View Related
Error: SqlDateTime Overflow !!!???
When I run my query dr = Me.SqlComm_Chk_ATLGroup.ExecuteReader it give me this error: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. This is my Query : SELECT break_time, break_rep_no, break_type, break_user_id FROM breaks WHERE (break_date = @p1) AND (break_group = @p2) AND (break_time > @p3) AND (break_time < @P4) ORDER BY break_time This is the code Dim dr As SqlClient.SqlDataReader Me.SqlConn.Open() Me.SqlComm_Chk_ATLGroup.Parameters(0).Value = #7/23/2004# Me.SqlComm_Chk_ATLGroup.Parameters(1).Value = 0 Me.SqlComm_Chk_ATLGroup.Parameters(2).Value = #10:00:00 AM# Me.SqlComm_Chk_ATLGroup.Parameters(3).Value = #2:00:00 PM# dr = Me.SqlComm_Chk_ATLGroup.ExecuteReader While dr.Read End While Me.SqlConn.Close() Note : when I store the time in a string and display it it gives me 10:00:00 AM 1/1/0001 or something like that ? Where is the problem?
View Replies !
View Related
SqlDateTime Overflow. Must Be Between 1/1/1753 12:00:00 AM And 12/31/9999 11:59:59 PM.
Yes, I've parsed many a topic on many a site regarding this issue.sigh.I am using a calendar control within a TemplateField on a DetailsView.I know that my SQL DB will accept NULL for my DATETIME field, because if I don't bind the control to the insert, the insert succeedes, yeilding a null for DATETIME in the new record.My problem is that I want the user to be able to choose to not select a date. I find that I have to bind selected value to the insert parameter, so that if they do select a date, it get inserted.( duhh!! ) When I do though, and the user does not select a date, I get the above error.My best guess? it is sending a datetime value of 00:00:0000 00:00:00 (or something like that anyhow)?So... does anyone have any ideeas on a simple way to evaluate the value when the form is submitted? and how to set it to NULL if it is, for example "in the past" or "00:00:0000....." ? ,Gary"We truly fail, only when we quit."
View Replies !
View Related
SqlDateTime Overflow. Must Be Between 1/1/1753 12:00:00 AM And 12/31/9999 11:59:59 PM.
hey, i will make calender(by use Asp.net 2003 - C# - framework 2.0 ) that stored and retreive data from Database(SQL Server 2000), that success , but if add this function (Calendar1_DayRender) Server Error in '/bwarq' Application. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.Source Error: Line 1999:DA.SelectCommand.Parameters.Add("@eventdate",eventdate); Line 2000:DataTable DT=new DataTable(); Line 2001:DA.Fill(DT); Line 2002:DA.SelectCommand.Connection.Close();return DT; Line 2003:} Source File: c:inetpubwwwroot4paldataaccess.cs Line: 2001 and i want to see my files here: 1- DataAccess(put here Stored proceure)public static DataTable GetCalendar(DateTime eventdate) {SqlDataAdapter DA=new SqlDataAdapter("GetCalendar",createConn()); DA.SelectCommand.CommandType=CommandType.StoredProcedure; DA.SelectCommand.Parameters.Add("@eventdate",eventdate);DataTable DT=new DataTable(); DA.Fill(DT);DA.SelectCommand.Connection.Close();return DT; } 2- User Control Page private void Calendar1_SelectionChanged(object sender, System.EventArgs e) { DataTable DT=DataAccess.GetCalendar(Calendar1.SelectedDate);if(DT.Rows.Count == 0) {DGEvent.Visible = false; } else {DGEvent.Visible = true; DGEvent.DataSource=DT; DGEvent.DataBind (); } }private void Calendar1_DayRender(object sender, System.Web.UI.WebControls.DayRenderEventArgs e) { DataTable DT2=DataAccess.GetCalendar(Calendar1.SelectedDate); // If the month is CurrentMonthif (! e.Day.IsOtherMonth ) {for(int i=0 ; i< DT2.Rows.Count;i++) {if ((DT2.Rows[i]["eventdate"].ToString() != DBNull.Value.ToString())) { DateTime dtEvent= (DateTime)DT2.Rows[i]["eventdate"];if (dtEvent.Equals(e.Day.Date)) { e.Cell.BackColor = Color.PaleVioletRed; } } } } //If the month is not CurrentMonth then hide the Dates else { e.Cell.Text = ""; } } so, i want the exaclty solution for this problem,plz
View Replies !
View Related
PLEASE HELP ME: SqlDateTime Overflow. Must Be Between 1/1/1753 12:00:00 AM And 12/31/9999 11:59:59 PM.
I cannot for the life of me figure out why im still getting this error. I have tried everything i can think of from using dbnull.value to setDOBnull() to datetime.minvalue. Can anyone help me? Here's the code on my BLL: Public Function AddEmployee(ByVal SSN As String, ByVal FirstName As String, ByVal LastName As String, ByVal PreferredName As String, ByVal MaidenName As String, ByVal MaritalStatus As Nullable(Of Char), ByVal DOB As Nullable(Of Date), ByVal Gender As Nullable(Of Char), ByVal Ethnicity As String, ByVal StartDate As Nullable(Of Date), ByVal TerminationDate As Nullable(Of Date)) As Boolean ' Create a new employeeRow instance Dim employees As New HRMS.EmployeesDataTable() Dim employee As HRMS.EmployeesRow = employees.NewEmployeesRow() Dim sqldatenull As SqlDateTime sqldatenull = SqlDateTime.MinValue.Value employee.SSN = SSN employee.FirstName = FirstName employee.LastName = LastName If PreferredName Is Nothing Then employee.SetPreferredNameNull() Else employee.PreferredName = PreferredName If MaidenName Is Nothing Then employee.SetMaidenNameNull() Else employee.MaidenName = MaidenName If Not MaritalStatus.HasValue Then employee.SetMaritalStatusNull() Else employee.MaritalStatus = MaritalStatus.Value If Not DOB.HasValue Then employee.SetDOBNull() Else employee.DOB = DOB.Value If Not Gender.HasValue Then employee.SetGenderNull() Else employee.Gender = Gender.Value If Ethnicity Is Nothing Then employee.SetEthnicityNull() Else employee.Ethnicity = Ethnicity If StartDate = DateTime.MinValue Then employee.StartDate = SqlDateTime.MinValue.Value Else employee.StartDate = StartDate.Value 'If StartDate = DateTime.MinValue Then employee.SetDOBNull() Else employee.StartDate = StartDate.Value 'If Not StartDate.HasValue Then employee.StartDate = sqldatenull Else employee.StartDate = StartDate.Value If TerminationDate = DateTime.MinValue Then employee.TerminationDate = SqlDateTime.MinValue.Value Else employee.TerminationDate = TerminationDate.Value P
View Replies !
View Related
SqlDateTime Overflow. Must Be Between 1/1/1753 12:00:00 AM And 12/31/9999 11:59:59 PM
Hi there... i have a search page with consitst of DatePicker and DataView this is how i'm binding my dataview <asp:ObjectDataSource runat="server" EnableCaching="false" ID="ods" TypeName="daab.Employee" SelectMethod="GetEmployee"> <SelectParameters> <asp:ControlParameter ControlID="DatePicker1" ConvertEmptyStringToNull="true" PropertyName="SelectedDate" Name="SearchDate" Direction="Input" Type="DateTime" /> </SelectParameters> </asp:ObjectDataSource> .......................................................................................... the searchDate is optional user may select date from datepicker or leave it blank if (!string.IsNullOrEmpty(DatePicker1.SelectedDate)) { // } else { this.ods.SelectParameters["SearchDate"].DefaultValue = DBNull.Value.ToString(); } when i execute the above code i get this error:, what i'm missing? error Message = "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."
View Replies !
View Related
SqlDateTime Overflow. Must Be Between 1/1/1753 12:00:00 AM And 12/31/9999 11:59:59 PM
Hi. I am getting the error described in the title - SqlDateTime overflow. I have read what is available online but am still not able to get rid of it. Help much appreciated... thanks. The Full Error Is: Code: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. at System.Data.SqlTypes.SqlDateTime.FromTimeSpan(TimeSpan value) at System.Data.SqlTypes.SqlDateTime.FromDateTime(DateTime value) at System.Data.SqlTypes.SqlDateTime..ctor(DateTime value) at System.Data.SqlClient.MetaType.FromDateTime(DateTime dateTime, Byte cb) at System.Data.SqlClient.TdsParser.WriteValue(Object value, MetaType type, Int32 actualLength, Int32 encodingByteSize, Int32 offset, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at ASP.audiobook_viewdetails_aspx.DetailsView1_ItemInserting(Object Src, DetailsViewInsertEventArgs Args) in C:InetpubwwwrootdushkinmediasupportwebPresentationTieraudiobook_servicesaudiobook_viewdetails .aspx:line 151 And, below is the method that is raising the errors. The culprit is "created_date" as "DateTime". Code: Sub DetailsView1_ItemInserting(ByVal Src As Object, ByVal Args As DetailsViewInsertEventArgs) 'validate the controls If Args.Values("ISBN") = "" Then Args.Cancel = True MSG.Text = "-- Missing ISBN number" End If If Args.Values("author_first") = "" Then Args.Cancel = True MSG.Text = "-- Missing first name" End If If Args.Values("author_last") = "" Then Args.Cancel = True MSG.Text = "-- Missing last name" End If If Args.Values("publisher") = "" Then Args.Cancel = True MSG.Text = "-- Missing Publisher" End If If Args.Values("text_description") = "" Then Args.Cancel = True MSG.Text = "-- Missing item description" End If If Not IsNumeric(Args.Values("regular_price")) Then Args.Cancel = True MSG.Text = "-- regular price is not numeric" Else If Args.Values("regular_price") < 0 Then Args.Cancel = True MSG.Text = "-- regular price is out of range" End If End If If Not IsNumeric(Args.Values("discount_price")) Then Args.Cancel = True MSG.Text = "-- Discount price is not numeric" Else If Args.Values("discount_price") < 0 Then Args.Cancel = True MSG.Text = "-- Discount price is out of range" End If End If 'if all the controls are valid, decalre the types Dim audiobookID As Integer Dim title As String Dim author_first As String Dim author_last As String Dim publisher As String Dim ISBN As String Dim regular_price As String Dim discount_price As String Dim text_description As String Dim created_date As DateTime ' ||||| Set up a Connection Object to the SQL DB Dim MyConn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection("server=ARIA;database=dushkinmedia;Integrated Security=SSPI") ' ||||| Pass in the StoreProcedure or Command String, as well as the Connection object Dim MyCmd As New System.Data.SqlClient.SqlCommand("sp_RegisterNewAudioBook", MyConn) ' ||||| Set the Command Type (Stored Procedure, Text, etc) MyCmd.CommandType = System.Data.CommandType.StoredProcedure ' ||||| Create Parameter Objects for values passed in Dim objParam1, objParam2, objParam3, objParam4, objParam5, objParam6, _ objParam7, objParam8, objParam9, objParam10, objParam11, objParam12, _ objParam13, objParam14, objParam15 As System.Data.SqlClient.SqlParameter ' ||||| Add your parameters to the parameters Collection objParam1 = MyCmd.Parameters.Add("@audiobookID", Data.SqlDbType.Int) objParam2 = MyCmd.Parameters.Add("@title", Data.SqlDbType.VarChar) objParam3 = MyCmd.Parameters.Add("@author_first", Data.SqlDbType.VarChar) objParam4 = MyCmd.Parameters.Add("@author_last", Data.SqlDbType.VarChar) objParam5 = MyCmd.Parameters.Add("@publisher", Data.SqlDbType.VarChar) objParam6 = MyCmd.Parameters.Add("@ISBN", Data.SqlDbType.VarChar) objParam7 = MyCmd.Parameters.Add("@regular_price", Data.SqlDbType.VarChar) objParam8 = MyCmd.Parameters.Add("@discount_price", Data.SqlDbType.VarChar) objParam9 = MyCmd.Parameters.Add("@text_description", Data.SqlDbType.Text) objParam10 = MyCmd.Parameters.Add("@created_date", Data.SqlDbType.DateTime) 'objParam10 = MyCmd.Parameters.AddWithValue("@img_name", imgName) objParam11 = MyCmd.Parameters.AddWithValue("@img_data", System.Data.SqlDbType.Image) 'objParam12 = MyCmd.Parameters.AddWithValue("@img_contenttype", imgcontenttype) 'objParam13 = MyCmd.Parameters.AddWithValue("@aud_name", audName) objParam14 = MyCmd.Parameters.AddWithValue("@aud_data", System.Data.SqlDbType.VarBinary) 'objParam15 = MyCmd.Parameters.AddWithValue("@aud_contenttype", audcontenttype) ' ||||| Set the Parameter values to the passed in values objParam1.Value = audiobookID objParam2.Value = title objParam3.Value = author_first objParam4.Value = author_last objParam5.Value = publisher objParam6.Value = ISBN objParam7.Value = regular_price objParam8.Value = discount_price objParam9.Value = text_description objParam10.Value = created_date 'objParam11.Value = imgBinaryData 'objParam14.Value = audBinaryData Try ' ||||| Check if Connection to DB is already open, if not, then open a connection ' ||||| DB not already Open...so open it MyConn.Open() MyCmd.ExecuteNonQuery() ' ||||| Close the Connection Closes with it MyConn.Close() Catch e As Exception Beep() MSG.Text = e.ToString End Try 'Response.Redirect("~/audiobook_services/audiobook_view.aspx") End Sub Any help at all would be MUCH appreciated... Thanks in advance.
View Replies !
View Related
SqlDateTime Overflow. Must Be Between 1/1/1753 12:00:00 AM And 12/31/9999 11:59:59 PM.
Hi, Is there a way to catch the exeption (SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM) with in SQL Server, so it does not need to be caught in the code calling the procedure. E.g. I do not want to send null to the stored procedure. e.g. The stored procedure should be able to catch dates that are outside the range 1/1/1975 and 12/31/9999 and change them to the limits. E.g. IF @StartDate < CONVERT(DateTime, '01/01/1753 12:00:00') BEGIN SET @StartDate = CONVERT(DateTime, '01/01/1753 12:00:00') END IF @EndDate > CONVERT(DateTime, '01/01/1753 11:59:59') BEGIN SET @EndDate = CONVERT(DateTime, '12/31/9999 11:59:59') END This still throws an exception because the StartDate or EndDate when tested fail the condition.
View Replies !
View Related
SQLDATETIME In Bcp File...
Hi, i m using sql server 2005 YUKON...and in my format file i have one datetime column..the format of it is as follow :(bulk_format.fmt) 9.0 3 1SQLCHAR 012 " " 1 number SQL_Latin1_General_CP1_CI_AS 2 SQLDATETIME 0 8 " " 2 date_time SQL_Latin1_General_CP1_CI_AS 3SQLCHAR 04 " " 3alphabet SQL_Latin1_General_CP1_CI_AS and the format of my input data file is as follow: 12345896236507-08-2005a 56785698412305-06-2009b 91023698547502-08-2003c 35691458963201-02-2000d now,whenever i m trying to run this in CMD...it gives me the error as: Starting Copy... SQLState = 42000, NativeError=4896 error= [microsoft][sql native client][sql server] Invalid column value from bcp client for colid 2 BCP copy in failed..... So, now can anyone pleaseeeeeeeee tell me..how to deal with this???? any help will be greatly appreciated... thnks..
View Replies !
View Related
Converting DateTime To SqlDateTime Format
Hi, I have a function that generates a range of DateTimes, which I then cast to SqlDateTime to compare with SqlDateTime values in a database. The problem is my converted DateTimes come out in this type of format "6/2/2006 12:00:00 AM" wheras my SqlDateTimes in the database are in this format "2006-01-18T00:00:00.0000000-12:00" Any ideas how I can convert the DateTime values to SqlDateTime correctly so that I can compare them? As I said I tried creating a new SqlDateTime object with the DateTime value ie DateTime dt = new DateTime(""); SqlDateTime sdt = new SqlDateTime(dt); But that doesn't work correctly, its still not in the format that is in the database.
View Replies !
View Related
C++ Ole DB Stack Overflow During Sql Server Compilation
hi,when i execute :CCommand<CManualAccessor, CBulkRowset, CNoMultipleResults> rs;rs.SetRows(100);HRESULT code_resultat = rs.Open(session, requete, &propset, NULL,DBGUID_DBSQL, FALSE);with a requete with length = 13000, it works perfectlybut when my requete length is 200000 (example : SELECT * FROM myTABLEWHERE id_table IN("lot of number : more then 30000 number"))i have code_resultat = DB_E_ERRORSINCOMMAND (= 0x80040e14)and when i explore the IErrorInfo message, i have :minor = 565 and the message issource :Microsoft OLE DB Provider for SQL Serverserveur has made a stack overflow during compilation...Is there a solution to extract to data ?in a fast way ...thanks in advance ...Mike
View Replies !
View Related
Arithmetic Operation Resulted In An Overflow. (System.Data) - Connection Error With SQL Server 2005
We've been using SQL Server 2005 for a while as the db for our web app. Everything has been working fine, until yesterday when we started getting a "Arithmetic operation resulted in an overflow. (System.Data)" error message when trying to connect from SQL Server Management Studio or from our web app. This only happens when trying to connect remotely, although remote connections have worked for us perfectly in the past. The full error message is reproduced below. Thanks ahead of time for any help. ===================================Cannot connect to serverName===================================Arithmetic operation resulted in an overflow. (System.Data)------------------------------Program Location: at System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
View Replies !
View Related
Sql Server 2005 Full Text Search Not Working As Expected On Production Server
I have this simple full text search query that works perfectly on my own computer using sql server 2005 express, however, on the production server(shared hosting)when I added the first 50+ rows, the full text search works perfect, but as the number of rows increases, the full text search can only see the first50+ rows, but not the new ones. Is there any quick solution for this or it's just a common mistake for developers for not properly indexed columns?Is there a way to re-indexed all rows without loosing data on the live server? search query: SELECT TOP 50 *FROM li_BookmarksWHERE FREETEXT(Keywords,@Keywords)
View Replies !
View Related
Help Needed - How Can I Set Up A Backup SQL Server Machine As An Exact Copy Of My Production SQL Server
Any help would be greatly appreciated.My problem is that I need to set up a backup SQL Server 2000 machinewhich can be used in case of a failure to my primary. All databases(30 as of now) must be an up to the minute exact copy of productionand include most recent changes in data as well as any structurechanges (Tables, Views, SP's, Triggers, Users . . etc).When I tried this using Transactional Replication, the replicationprocess gets fouled up once I introduce any kind of structure changesto the DB. I've considered the idea of doing periodic backups andrestoring it to my backup SQL server, but this does not give me theconcurrency needed with 0 latency.I've seen articles that recommend using Transaction Replication with'Scheduled Table Refresh', and also doing database dumps to restore onthe backup machine, but I have not been able to find any documentationregarding this to try out. How can I implement this type of backupstrategy in SQL 2000?
View Replies !
View Related
Auto Restore .bak From Production To Same Server's TEST Db With Other Dbs && .baks In Same Server.
Howdy; I've tried this in the 'tools' area, but that didn't work too well. I suspect, I will have to generate a T-SQL code then schedule it as a job. Why I can't just drag and drop with basic desires, is beyond me, but THAT probably does exist. anyway here is the problem [this server has many databases, on SQL 2000 sp2] 1. User only wants me to use Monday morning's full backup, which is good in that it doesn't include transaction logs. 2. Restore that data overtop/into Developement db. = good, no data to worry about damaging. 3. User does NOT want me to do this by hand, but schedule it. ok, a. must do a RESTORE WITH FILELISTONLY from [?] what ?, master? and if I user the *.bak of the production, it has a coded date field in the name entry SO, I would, I guess, have to generate all sorts of wonderful code to find the date and build a file name. Why, because using the FROM DISK = 'F:MSSQLBACKUPDBPRODUCTION_yyyyddmm.BAK' is not going to work with a wild card. Can I do a file lookup using a 'PRODUCTION' prefix into a variable, then use that or should I look for latest file date [remember there are several database backups here], or ???? then. How does one schedule such a T-SQL. Do I save it to some text file, and invoke it using a job scheduler. any help appreciated. IS there an easier way. rik
View Replies !
View Related
Aspnetmdf And Production Server
Hello there; I have developed an Application and I used the Login controls for authentication which created the aspnetmdf database. I also have another database for all my other data stuff. What is the best practice to deploy this application? Should I merge the databases together first then copy the resulting database to the production server? If so, how do I copy the whole aspnetmdf database? And can I copy it to a SQL 2000 server? Thank you for your time.
View Replies !
View Related
SQL Server On Production Very Slow
Hi,I ran test data on my development machine and it took 1 minute toinsert the data. Ran the same set of data on the server and took 5minutes.Check both database and everything is the same. I even copied theproduction DB on my machine and it was taking still about 1 minute.Look at the fragmentation, and all the numbers are better on the serverthan my development machine so it should be faster.In the application I put some timer and discover that the insert istaking 0.015 ms on the server and 0 on the development. So the problemis on the insert.It is a Web application using ASP.NET.Here are the spec of the computers:Development: P4 HT 3.2GHz 1gig memory running WIN XPServer: Xeon 2.8GHz 1.5Gig memory running WIN 2000 serverAny idea how I to pinpoint the problem? I'm not at the point ofthinking that it can be the hardware, but how to verify that?ThanksFrank
View Replies !
View Related
Problem On Production Server
Problem - stored procedure failing on Production Server. Platform - NT Server with SP 4 and sql server 6.5 I have a process which locked up a few tables and was running for a few hours on my production server, i backed up the database and restored the same on my test server. the same process ran sucessfully in less than 3 minutes (which is the expected time frame). I have checked the server configurations on both the production and test servers. they are the same. what could be going wrong ? any ideas ppl ? would really appreciate the help.
View Replies !
View Related
Copy Production Db To Another Server
I have a brand new database server with system databases. I need to copy like four production database from another server to this new server. Can i do restore of the last production backups and restore them on the new server without creating the empty databases on the new server.If any one has better approach i will appreciate
View Replies !
View Related
Moving The .LDF On A Production Server
ok ok, stop laughing. for real, is there any programatic way of doing this? whom ever created this database i inherited (SQL 2000) created the LDF and DATA files on the same drive and in the same folder for that matter. just trying to do a little disaster magament. thanks matt
View Replies !
View Related
Beta 3 On A Production Server.
This feels like a silly question, but I`m going to ask it anyway... I have limited SQL Server experience, but have run into a wall with a client`s Web/Access combination. I need to upgrade to SQL Server. I have Beta3 installed on a development box and am very happy with it. Is anyone running this thing in a production environment? This isn`t going to be experience huge loads, so I`m tempted. Tell me if I`m crazy for wanting to try it.
View Replies !
View Related
Replace A SQL 7 Production Server
Hi everybody, I scribe you from France and I have to replace an old SQL 7.0 server by a new. Is there anybody who can give me the proccess in details to do it (Audit, checking, installing new server, backup all on the old, restore and verify, etc..) Thank you very much for your help.
View Replies !
View Related
Usage Of CLR In Production SQL Server
Like most enterprise there is the database administrator (dba) and there are the developers(dev). The dba are conservative while the developers are also exploring their options. One of the current usage I'm experimenting on is to provide data visualization - image for the data. Like most I needed to "create" the System.Drawing assembly in the database, marking it unsafe. During my testing, my code had some exception and that brought down SQL Server. I read that the CLR is better compare to the sp_OAs as well as the extended stored procedures written in C++ because it isolates the execution in a separate app domain and termination is clean - in case of any errors, it should not bring down SQL Server. Also I read marking assembly unsafe void these benefits of isolation. Instead of having to manage the situation where it involves code review by the dba and asking the dba to take some risk, is there a technique where all CLR code that runs in the production server does not pose stability issues.
View Replies !
View Related
Acess On Production Server
Hi, Presently our Organisation is in process of Implementing SOX. Under Compliance all the User have to be removed from the Production Server. 1.My Question is Do a DBA Should have Admin Privilages on the Production Server. If yes then what are the Actitvies that a DBA has to perform only if DBA have admin privilages. Regards Sufian
View Replies !
View Related
Linking To Production Server
I developed an Access 2003 application that linked through to a server running SQL 2000 under MS Small business server 2003. The server has now gone to the clients site and is in production. The application is running on a couple of work stations under MS Access runtime license. It is accessing the customer's server. I have made changes to the application on my development box running MS Visual studios Tools 2003 incl MS access 2003 developer extensions. I want to apply these changes to the Customers environment. However the front end application is linked to the development server by three different methods: 1. Visual basic connection coded, which can be changed to point to the correct occurrence. cnn.Open "Provider=Microsoft.Access.OLEDB.10.0;" & _ "Persist Security Info=False;" & _ "Data Source=PHACT-PC;" & _ ' Production server is IMEXFX-SERVER "Integrated Security=SSPI;" & _ "Initial Catalog=IMEX_HQ;" & _ "Data Provider=SQLOLEDB.1" 2. qdf queries that are linked to development server 3. Combo box lookups linked through linked table manager. I can change the coding for (1) easily. How can I change the link for (2) & (3) without having a full version of Access 2003 on one of the customer's workstations and configuring in situ?
View Replies !
View Related
Production Server Issue
1.First issue The port number already allocated was 2059. We have changed that into the default port 1433 in the node. Now we are able to connect the node from the client application. But we are not able to see the configuration manager in any of the environment now. 2. 2nd issue Cluster Environment Error while executing the Package The connection details are not loaded in the connection manager tag The same error with advanced information. Another error window R.S.Moorthy
View Replies !
View Related
Production Server Probs
I have production server 2000. The server gets disconnected sometime by itself and sometime it is working fine.Sometimes it even doesn't get restarted. Is there any problem with service packs and some performance issues. Can you SQL guru give me best suggestion and how should i proceed.
View Replies !
View Related
Moving Just Data Between A Production Server & Test Server
We have both a production SQL 7 server, QA, and Development. From time to time, I want to move just the data from the production server to the other 2 servers without modifing the objects that may have been changed such as stored procedures and rights. Is there a way using the SQL tools provided that we can just move the data. Becuase also what happens is that the rights to the objects change which means my developers no longer have access to the tables for selects in QA since the changes where overwritten by production where they do not have the rights. Thanks Ricky Kelley
View Replies !
View Related
Updating An ASPNETDB On The Production Server
Group, I have an ASP.NET web application using the default ASPNETDB that I did in VWD 2005, and deployed to a production server (IIS). I need to make a table addition to the production database (ASPNETDB). I'm trying to use SQL Management Studio to attache the database, but it keeps saying the database is locked by a process. I shut down all the services that would likely be using it, but it's still showing locked. What do I need to shut down to attach the database to make the change? Or is there a better way to do it?
View Replies !
View Related
Lock Issue On Production Sql Server
I have a 3rd party app which gets the error below on my sql 2000 box. I can't change the app or the db, so I am going to need to tweak sql to make the plane fly. The box is a new dell quad attached to a SAN. Runs on Win 2003 with 16 gig of RAM. 450 concurrent users. Anyone think more memory would help? I have the locks set to default. Are locks more of a memory killer, or CPU? Error: 1204, Severity: 19, State: 1 The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
View Replies !
View Related
Production Server/Backup Fails
Hi, We have a production server on which backup is scheduled in night hours.The problem is when the backup fails it take up the memory and we end up rebooting the server to free up the memory resources the next day.I know this is not a feasible solution. Any thoughts? TIA. PD
View Replies !
View Related
SQL Server REplication (Very Urgent In Production) Please Help
I intially created the pull subscription it said it was never started i did'nt know what to do...got lost.Then i tried with Push and fire the intial snapshot at the creation which went well then when it comes to push the same to remote server it fails trying couple of times. Could anyone tell what might be goin wrong and how to configure the pull or push subscription. And what do u think which one would be the best option. This is the error. The process could not connect to Subscriber 'indya1200P'. Thanks, Kavitha
View Replies !
View Related
Linked Server (very Very Urgent) Production
I am in a deep shit with this...its my life and survival... How to configure a linked server for oracle. My oracle instance name is dbserver.internal.ca.com and how do i query since it gives me an error when i use the above name i had this come up some time early. what information do i need to create a linked server for orale on sql server either using ole-db or odbc. One more question is there a way where i can import data from oracle to sql server with having a oracle client installed on the machine where sql server exists. Thanks, Tina
View Replies !
View Related
SSIS Package Won't Run In Production Server
Hi, I have a package that I developed on my local machine and runs well. I run it through the command line on my production server the following way: D: estCMS_MoveContentToLive>dtexec /f D: estCMS_MoveContentToLiveCMSMoveIte mToLive.dtsx -de The -de option is because i changed the default security protection level of the package as BOL says that for the default protection level (EncryptAllWithUserKey): "Only the user who created or exported the package can open the package in SSIS Designer or run the package by using the dtexec command prompt utility." The problem is that the package does not run successfully and vomits a lot of error message that I do not understand, such as: <errorMessage> Error: 2006-02-15 18:13:43.55 Code: 0xC004706E Source: Data Flow Task DTS.Pipeline Description: The module containing "component "Multicast" (637)" cannot be lo cated, even though it is registered. End Error Error: 2006-02-15 18:13:43.55 Code: 0xC004706E Source: Data Flow Task DTS.Pipeline Description: The module containing "component "OLE DB Destination" (756)" can not be located, even though it is registered. End Error ... Error: 2006-02-15 18:13:43.62 Code: 0xC0048021 Source: Data Flow Task Multicast [637] Description: The component is missing, not registered, not upgradeable, or mi ssing required interfaces. The contact information for this component is "Multic ast;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation ; All Rights Reserved; http://www.microsoft.com/sql/support;0". End Error Error: 2006-02-15 18:13:43.62 Code: 0xC0047017 Source: Data Flow Task DTS.Pipeline Description: component "Multicast" (637) failed validation and returned error code 0xC0048021. End Error </errorMessage> Notice that at the end it says that the validation failed. I looked on the internet but I did not found any information regarding this issue. I also created a dummy SSIS package that does not have any data flaw but just have a single SQL task doing a single insert in a table. When i execute it on the production server, it runs successfully! Then what is wrong with my "complex" package that all the data flow components seems to: "can not be located, even though it is registered." ??? To be exact, I have an error for all the data flow components except the script component. Thanks for any help. Best regards, Francois Malgreve PS: I also would like to mention that on my production server, only the SSIS service is installed, not SQL Server itself. When you run the setup of SQL 2005, it is indeed possible to install only the SSIS component which is what I need in my case as SSIS packages are run from a middle tier server and connect to various DBs. I think this is important as I just discovered that the package can run successfully when I run it on a server which has a full version of SQL Server 2005. By that I mean having SQL Database Server + SSIS installed. But it will run only from the command line, if i run it from an asp.net application it won't run successfully and return the same kind of error i showed in this message. in a desesparate attempt to solve my problem, I granted more rights to the ASPNET user and NETWORK_SERVICE user by adding them in the administrator group as I quite believe it might be related to security as on that server it works well from the command line. But it did not help.
View Replies !
View Related
Packages Not Executing Right On Production Server?
Hi, I have developed about 20 to 30 packages that are executed on a specific order by a parent package that iterates a foreach cycle... Has in development server all packages run just fine... when deployed to the production server and executed the first child package to run gives error and says that the logging text file was unable to find the file??? It was supposed for the log to create and send information to the file right? So i think this is a little bit weird... Any idea of what is going on here? Regards,
View Replies !
View Related
SQL Report Server From Oracle Production
I have been doing research into the best way to do this for some time. I use SQL Server 2005 Standard so replication is out of the question. I have discovered Slowly Changing Dimensions, Linked Servers, etc Which may help me bring the data out of Oracle 9i and into SQL. Ideally I want the data refreshed on a daily basis. I want to specify which tables and views are taken from Oracle and manage the relationships in SQL. Any direction as to best practices for this task would be greatly appreciated. I am fairly new to the game of synchronizing two major server products but have worked extensively with data integration on smaller scales.
View Replies !
View Related
Performance Dashboard On Production Server
I've been using Sql server 2005 Performance Dashboard Reports on our test servers for a while now, and they are great! Now I'd like to use them in the production environment, but prior to installing them on the production server, I'd like to here yuor opinion of using them on a production server. From what I can understand, they don't add anyting but some functions and procedures to the MSDB database. So, the impact on the production environment should be none apart from the seconds when the reports are executed, or? Do the added functions or procedures add any security related risks? Something else to be concerned about regarding having the reports on the production server? Regards Andreas
View Replies !
View Related
How To Deploy SSRS To Production Server ?
Hi All I am having a problem with SSRS reports which I hope you can help with. We have a web application which contains a couple dozen reports built using SSRS. In order to do a new release I first deploy the web application and the SSRS reports to our pre-production server for testing. Whilst testing is going on, developers are making further changes to some of the reports and also the the database structure. My problem is that when I want to move the new release from the pre-production server to the production server, I can copy the application but not the SSRS reports. So my only choice appears to be to deploy the SSRS reports from a devlopment machien directly to the production server. This is clearly going to cause me problems as those reports may have been further developed and the database structure may have changed sine deploying the application to the pre-production server so I am effectly releasing untested reports directly to the production srever. So my quesiton is: How can I copy my SSRS reports from the pre-production server to the production server? Is there another way of dong this? Regards Smeat
View Replies !
View Related
Deploying Reports On Production Server
hello experts, i need help with deployment of reports (SSRS 2005). we need to deploy many reports (more then 100) on the production everytime we make changes in them. "the problem is we cannot install visual studio on the server to open the project and use the deploy option from it" i tried using the script - PublishSampleReports.rss but everytime i run i need to go and manully configure the report to map the shared datasource to it. any way to pass the information in the script itself, or is there any smart way to deploy on production. /chandresh soni
View Replies !
View Related
Cannot Open Report On Production Server
Hello there, I have created a report with MySQL using ODBC connection.It works on my localhost server.then when i deployed it on the production server i get error saying.i checked my data source connection to my localhost and both have the same setting.what could be wrong.please help i am very desperate to make this work.thanks. An error has occurred during report processing. Cannot create a connection to data source 'Payment'. For more information about this error navigate to the report server on the local server machine, or enable remote errors cheers zolf
View Replies !
View Related
|
TRACKER
