SQL server 2000 transation deadlock in a cluster environment

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - A quick question: How to use variables in the SQL insertion string Hello, I am new to ADO.NET and SQL. What I am trying to do is very basic - to insert some variable values into database. The following is the C# code: private static void InsertIntoSqlDb(OleDbDataReader reader) { string insStr = ""; string list_no = reader.GetString(0); string item_no = reader.GetString(1); string description = reader.GetString(2); string priceStr = reader.GetString(3); insStr = "INSERT INTO dliTestDb (list, item, description, price) VALUES (list_no, item_no, description, priceStr)"; SqlCommand cmd = new SqlCommand(insStr, conn); //Insert // try { cmd.ExecuteNonQuery(); } catch(Exception ex) { Console.WriteLine(ex); } } Upon execution of the above, I got exception: System.Data.SqlClient.SqlException: The name 'list_no' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names ar e not permitted. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() Doesn't any one know how to use variable names exactly in the SQL insertion string? Thanks. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113069
  - 2
    - Time is Stripped off When Saving DateTime to MS Access All, Using C# with ADO.NET I am trying to save a date time to an Access database. After the saving occurs I open Access database and only see the date not the time. I know the time was part of the DateTime object prior to saving it. Also while in Access I tried changing the format of the date time field to see the time, which showed it as 12:00 AM and is incorrect. See code snippet below: DataRow newRow = dataSet12.Table1.NewRow(); newRow["Index"] = 5; newRow["Column1"] = "Added"; newRow["MyDateTime"] = DateTime.Now; // <== Time is in object dataSet12.Table1.Rows.Add(newRow); Does anyone know who to have the time saved ad well? Thanks in advance for any help. Scott Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113059
  - 3
    - need help on basic save!!! I am having some problems with getting squgglie lines under stringbuilder and ConfigurationSettings what am I doing wrong, is this even close to working? help. ------------------------------------------------------------------------------------ Imports System Imports System.Data Imports System.Data.SqlClient Imports Microsoft.VisualBasic Public Class Locations Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click Dim mySQLConnection As New SqlConnection(ConfigurationSettings.AppSettings("DSN")) Dim strSQLCommand As New StringBuilder, mySQLCommand As SqlCommand strSQLCommand = New StringBuilder With strSQLCommand .Append("INSERT INTO Locations (Loc_Name, Address, ContactName, Phone) ") .Append("VALUES ('" & txtName.Text & "', '" & txtAddress.Text & "', '" & txtContactName.Text & "', '" & txtPhone.Text & "');") End With mySQLConnection.Open() mySQLCommand = New SqlCommand(strSQLCommand.ToString, mySQLConnection) mySQLCommand.ExecuteNonQuery() mySQLConnection.Close() End Sub End Class -- -- Adam S Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113054
  - 4
    - Unable to reconnect to SQL Server after the server is restarted I am using C#, SQL Server 2000 and ADO.NET in my application. The Database Server and the application are running on seperate physical machines. If the database server and the application lose connection (possibly because the server was restarted, or a network failure of some sort) the application fails to re-connect. The application will periodically attempt to re-connect to the server. It seems that I am unable to connect for a period of time after the server is restarted. I receive the error message "SQL Server is unavailable or access is denied". I have seen this error message for as long as 45 minutes after the server has been restarted. Does anybody have any ideas on the cause of this? I am using connection pooling with the default connection pool size. Sample code is provided below. Thanks in advance for your help, Trevor SqlConnection conn = new SqlConnection( conString ); if ( waitForConnection && AllowWaitForConnection ) { // Retry the connection to the database periodically until successful while ( conn.State != ConnectionState.Open ) { try { conn.Open(); } catch ( SqlException e ) { conn.Close(); ThreadSupport.Sleep( connectionRetryInterval ); } catch ( InvalidOperationException e2 ) { conn.Close(); ThreadSupport.CheckAbort(); } } } else { ... } Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113052
  - 5
    - Pivoting DataSet- Hyperlinkcolumn+Sorting http://weblogs.sqlteam.com/jeffs/articles/5091.aspx provided an excellent insight for pivioting DataSet. As things stand, the example could happily pivot Something SQLServer returns as: frmInstanceID frmName Department Status 1 formA IT Complete 2 formB IT Complete 3 formC IT Incomplete 4 formA HR Missing 5 formB HR Inomplete 6 formC HR Complete with the invocation of Pivot(dataReader,"frmInstanceID","frmName","Status"), pivotted data into frmInstanceID Department formA formB formC 1 IT Complete 2 IT Complete 3 IT Incomplete 4 HR Missing 5 HR Incomplete 6 HR Complete What I really really want is: Department formA formB formC IT Complete Complete Incomplete HR Missing InComplete Complete With each of the form status being a hyperlink with the frmInstanceID as a parameter: e.g. <a href="showStatus.aspx?id=7">Complete</a> I managed to "fool" the system into displaying the above with the invocation of Pivot(dataReader,"Department","frmName","Status") (i.e. changing the keyColumn parameter to the Pivot method). Could someone assist with helping me set a hyperlink column and managing sorting with this example at http://weblogs.sqlteam.com/jeffs/articles/5091.aspx ? Many Thanks Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113047
  - 6
    - clear connection pooling i face prob. of connection pooling, i want to know how to clear the pool size in ado.net, i know that there is a facility in ado.net to clear the max pool size, Any one can give me the code about that. thanks. *** Sent via Developersdex http://www.developersdex.com *** Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113042
  - 7
    - Concurrency violation where there shouldn't be one I have the following error message and I can't see where in code it could of came from or what could of caused it. It happened randomly for one of our users and no one else ever, and I am unable to reproduce it at all. System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records. Now this was caused during the update method of a data adapter that is tied to a table alled Categories... On the form where the data entry takes place we have a brand new record called coverage, This is stored in the dataset's coverage table. At this point this is in thet table as a new record with a uniquely generated ID Primary key that gets changed when the dataset is updated to the database (that part works fine, SQL Server returns the new ID and the local dataset updates approperiatly to match)... the problem though seems to of occured on the referenced table Categories... This table has records that are dynamically generated based on what a user checkes in a check listbox. So if the user unchecks an item, the corresponding record is removed from the datatable in teh categories table, if they check one a record gets added... here is an example piece of code... Private Sub chklstCategories_ItemCheck(ByVal sender As Object, ByVal e As System.Windows.Forms.ItemCheckEventArgs) Handles chklstCategories.ItemCheck ' update dataset in memory to reflect changes If Me.b_refillingData = False Then Select Case e.NewValue Case CheckState.Checked Dim dr_catItem As DataRow = ds_formData.Tables("CoverageJunCategories").NewRow If Me.fs_FormViewState = bdb.Business.FormStates.AddNew Then 'dr_CoverageRow dr_catItem("coverageid") = Convert.ToInt32(dr_CoverageRow("CoverageID")) Else dr_catItem("coverageid") = Convert.ToInt32(Me.lstvCoverages.SelectedItems(0).Tag) End If dr_catItem("categoryid") = DirectCast(Me.chklstCategories.Items(e.Index), CategoryItem).ID ds_formData.Tables("CoverageJunCategories").Rows.Add(dr_catItem) Debug.WriteLine(ds_formData.Tables("CoverageJunCategories").Rows.Count) Case CheckState.Unchecked Dim rowKeys(1) As Object If Me.fs_FormViewState = bdb.Business.FormStates.AddNew Then rowKeys(0) = Convert.ToInt32(dr_CoverageRow("CoverageID")) Else rowKeys(0) = Convert.ToInt32(Me.lstvCoverages.SelectedItems(0).Tag) End If rowKeys(1) = DirectCast(Me.chklstCategories.Items(e.Index), CategoryItem).ID Dim dr_catitem As DataRow = ds_formData.Tables("CoverageJunCategories").Rows.Find(rowKeys) dr_catitem.Delete() Debug.WriteLine(ds_formData.Tables("CoverageJunCategories").Rows.Count) End Select End If End Sub as you can see this is a junction table which joins the list of categories and the list of coverages together.. In our dataset we also have the coverages and this table referenced like this ds_formData.Relations.Add("CoveragesJunCategories", ds_formData.Tables("Coverages").Columns("CoverageID"), ds_formData.Tables("CoverageJunCategories").Columns("CoverageID")) to me this code all seems to be correct, but I can't figure out what is wrong... prior to this we were getting a "Missing update command" error for the data adapter that handles the coveragesjuncategories table's... I figured since all I was doing was adding and removing rows I only would need a Select, Insert, and Delete command... Since it seemed like no real updateing was occuring (unless when coverages gets its new primary key from the server when a coverage row is created, it changes the category junction's table also since they are referenced together with a primary/foreign key, but if this is a update how would the row be created to start with? just a little confused on the procedure for a new row in one table that references a new row in another when the primary key gets updates on the parent, what happens to the row the foreign key is on is it still an insert or is it now an update (i assumed insert because the row does not exist yet in the database only locally in the data table since the update method as not been called yet on the categorys junction table (child table) but only on the coverages one (parent table))... anyone that can help me out would be great! thanks! Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113040
  - 8
    - concurrency violation where it makes no sense to have one I recieved the following error pretty much randomly (haven't been able to reproduce it or see what caused it in code at all) Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113039
  - 9
    - =?Utf-8?Q?Is_there_a_way_to_set_=22Jet_OLEDB?= Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113027
  - 10
    - Dynamically Populating a SqlParameter object I'm using the SqlHelper object model from MDAAB, which requires that I pass in a SqlParameter object if I have more then parameter when calling a Stored Procedure. My current code seems verbose in the setup of this parameter and I'm trying to figure out if there is a better approach to populate this object. Here is a sample in VB that uses SqlHelper to call a Stored Procedure: Public Shared Sub GatewayRecordCreate(ByVal GatewayName As String, _ ByVal ResponseString As String, _ ByVal UserEmail As String, _ ByVal TranAmount As String) ' Public Consts used to store element position in String Array, used in other classes Const PositionGatewayName As Short = 0 Const PositionResponseString As Short = 1 Const PositionUserEmail As Short = 2 Const PositionTranAmount As Short = 3 Const PositionMaxElement As Short = 3 Dim returnVal(PositionMaxElement) As String ' String Array returned by function Dim parms() As SqlParameter = New SqlParameter(PositionMaxElement) {} 'Used to hold Details from DB ' @GeneratedBy Input Parameter parms(PositionGatewayName) = New SqlParameter("@GatewayName", SqlDbType.VarChar, 200) parms(PositionGatewayName).Direction = ParameterDirection.Input parms(PositionGatewayName).Value = GatewayName ' @ResponseString Output Parameter parms(PositionResponseString) = New SqlParameter("@ResponseString", SqlDbType.VarChar, 5000) parms(PositionResponseString).Direction = ParameterDirection.Input parms(PositionResponseString).Value = ResponseString ' @UserEmail Output Parameter parms(PositionUserEmail) = New SqlParameter("@UserEmail", SqlDbType.VarChar, 100) parms(PositionUserEmail).Direction = ParameterDirection.Input parms(PositionUserEmail).Value = UserEmail ' @TranAmount Output Parameter parms(PositionTranAmount) = New SqlParameter("@TranAmount", SqlDbType.VarChar, 20) parms(PositionTranAmount).Direction = ParameterDirection.Input parms(PositionTranAmount).Value = TranAmount ' Call ExecuteNonQuery static method of SqlHelper class ' Pass in database connection string, command type, stored procedure name and an array of SqlParameter object SqlHelper.ExecuteNonQuery(Global.ConnectionString, CommandType.StoredProcedure, "spGatewayTranInsert", parms) End Sub My primary goal is to improve the code so that I don't have to setup Constants and hard code the PositionMaxElement value which is used SqlParameter object. Any thoughts? Please post or point to VB source code if you are replying. I learn best by example. Thanks. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113025
  - 11
    - The asp services blocked I have a problem about asp.net and databases in Access. Every time the asp service is blocked. When this happens i must phone to my ISP provider of hosting in order to begin the service again. The tell me it is a problem of access with asp.net. ¿How can i solution it? I detail below the connection line of the web.config, maybe I am doing wrong. Thank you very much. <add key="Connection" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\bd\bd1.mdb;Persist Security Info=True" /> Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113020
  - 12
    - debug suggestion for connection pool problem with Oracle using daa Hi We have a asp.net web application with oracle 9.1. Data access layer we use is DAAB 2.0. We use connection pool and set max pool size = 150. But we always get the following error almost every month ( we have to restart web server to make it work): Timeout expired, The timeout period elapsed prior to obtaining a connection from the pool. This may have occured becasue all pooled connections where in use and max pool size was reached. As many perople said, after I went though whole implementation, I did not find any connections we did not close. Anyone have good advice for how to debug such issue? or recommend some tool? I have seen lots of similar questions and topics, and found many answers are extremely confused. Can anyone make clear for my some questions? 1. We use USING to dispose connection and OracleDataReader in most cases, but also there are some exceptions, we use close() to close connection in Catch block of try-catch. here is example: ============================================== OracleConnection cn = new OracleConnection(connectionString); cn.Open(); try { return ExecuteReader(cn, null, commandType, commandText, commandParameters, OracleConnectionOwnership.Internal); } catch { cn.Close(); throw; } ========================================== Is anything wrong for these pieces of code? 2. In many cases, we opened connection in one function, and call another to process the real operation of DB., example: =================================================== using (OracleConnection cn = new OracleConnection(connectionString)) { cn.Open(); return ExecuteNonQuery(cn, commandType, commandText, commandParameters); } =================================================== if ExecuteNonQuery() got exception, the USING still can dispose connection? 3. =================================================== using(OracleDataReader r = OracleHelper.ExecuteReader(ConnectionManager.GetConnStr(), CommandType.Text, sql.SQLString, pa)) { ArrayList al = QueryResultsParser.Parse(r, request); r.Close(); //Force the OracleDataReader to be closed return al; } ==================================================== (we have add For these pieces of code, we use datareader to get data, I wonder: 1. is it necessary we explicitely close the datareader? 2. if answer yes for 1., and if OracleHelper.ExecuteReader() falied, does it mean we cannot close connection? 4. for some objects, do we need to displose them as soon as it is not used? example: ================================================= OracleCommand cmd = new OracleCommand(); PrepareCommand(cmd, connection, (OracleTransaction)null, commandType, commandText, commandParameters); //create the DataAdapter & DataSet OracleDataAdapter da = new OracleDataAdapter(cmd); DataSet ds = new DataSet(); //fill the DataSet using default values for DataTable names, etc. da.Fill(ds); cmd.Dispose(); da.Dispose(); ======================================= Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113017
  - 13
    - datagrid webcontrol in C# Hi, I just have a simple question regarding dataGrid in ADO.NET. I developed the web application by ASP.net and C#. I want to implment a dataGrid for the product list. The product list display the product name, size, type, price .... But for the specfic product category, its size column may not has any data. So i want to write the code in back-end by C# to determin whether every item in the size column in dataGrid has data. How I can write it in C# ? is there methods I can use to determin every item in size column contains data ? Thank you, H. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113016
  - 14
    - Add Record to MS Access Database Is there anyone that knows how to add a record to a MS Access database with VB.NET. I have search for 3 days for some code that works. I have gathered bits and pieces of code and put it together, but I have not found a solution that works. If anyone has some code that works please reply. Thanks Thomas The following gives an Invalid SQL Statement at: oAdapter.Update(ds, "LCMR") Dim oAdapter As OleDb.OleDbDataAdapter Dim cb As OleDb.OleDbCommandBuilder Dim dr As DataRow Dim ds As DataSet Dim strSQL As String = "Select * from LCMR" Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & strAppPath & "TAM.mdb;Persist Security Info=False" ds = New DataSet() oAdapter = New OleDb.OleDbDataAdapter(strSQL, strConn) oAdapter.Fill(ds, "LCMR") Try dr = ds.Tables("LCMR").NewRow() dr.BeginEdit() dr("ID") = 1000 dr("ADate") = "6-JUN-5" dr("ATime") = "01:00" dr("POO") = strPOO dr("POO_Alt") = 22 dr("POI") = strPOI dr("POI_Alt") = 22 dr("Distance") = 1000 dr("Direction") = 100 dr("Target_NO") = "KT1001" dr("Weapon Type") = "sasdf" dr("Confirmed") = 1 dr.EndEdit() ds.Tables("LCMR").Rows.Add(dr) cb = New OleDb.OleDbCommandBuilder(oAdapter) oAdapter.InsertCommand = cb.GetInsertCommand oAdapter.Update(ds, "LCMR") ds.AcceptChanges() Catch oException As Exception MessageBox.Show(oException.Message) End Try -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service ------->>>>>>http://www.NewsDemon.com<<<<<<------ Unlimited Access, Anonymous Accounts, Uncensored Broadband Access Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113008
  - 15
    - Oracle transaction rollback problem I have problem with transaction. When I try to rollback transaction commit happend and record is updated. Can anybody tell me, where I made a mistake. Thanx, S. Imports Oracle.DataAccess.Client Imports Oracle.DataAccess.Types private sub mWriteOnOra() Dim inFile As System.IO.FileStream Dim binaryData() As Byte inFile = New System.IO.FileStream(p_datoteka, _ System.IO.FileMode.Open, _ System.IO.FileAccess.Read) ReDim binaryData(inFile.Length) Dim bytesRead As Long = inFile.Read(binaryData, _ 0, _ inFile.Length) inFile.Close() Dim cnStr As String = "Data Source=Oracle8i;User ID=" & gsUser & ";Password=" & gsPwd & ";Data Source=" & gsDs & ";" Dim sErr As String Dim cn As OracleConnection Dim myTrans As OracleTransaction Dim cmd As New OracleCommand("SP_LOAD", cn) cmd.CommandType = CommandType.StoredProcedure With cmd.Parameters .Add("BLOB_LOAD", OracleDbType.Blob, binaryData.Length, ParameterDirection.Input).Value = binaryData End With Try cmd.ExecuteNonQuery() myTrans.Rollback() ' file shouldn't be in the table, but it is there ' myTrans.Commit() Catch ex As Exception myTrans.Rollback() DoLog(1, ex.Message) Finally If cn.State <> ConnectionState.Closed Then cn.Close() End Try end sub Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113005
  - 16
    - Query Result Paging with different Ordering Hi, I have posted to multiple groups - I hope this is ok. For the past week or so I have been trying to find out how to perform a search against SQL Server, and have the results sorted on a choice made by the UI (ASP.NET), and supports paging. I have trawled the net a number of times, and have spent hours looking through peoples examples which just dont seem to cut it, due to all their caveats. Can someone offer good, useful links on how I can do this type of functionality? Vry much appreciated, after so much reading and playing I am still little further forward. I am not a DB person, which is causing part of the problem. Thanks j.r Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113003
  - 17
    - problem in uploading and downloading files from DB in ASP.Net hi, Can anybody tell me that thru asp.net using c#, how can we upload and download physical files in any table of SQL Server Database. the uploading part is running successfully but the problem arises in the retriving part of the code. i am not getting that how will i able to download the file which is there in the SQL Server database in the field type "image". here is the code by which i am uploading any file to the my SQL Server database private void btnUpload_Click(object sender, System.EventArgs e) { HttpPostedFile filPosted = filUpload.PostedFile; int intFileLength = System.Convert.ToInt32(filPosted.ContentLength); byte[] byteData = new byte[intFileLength]; filPosted.InputStream.Read(byteData, 0, intFileLength); Conn.OpenConnection(); string sql="Insert into HRRecruitmentMaster(CandidateName,HighestQualificationID,JobFieldID,TotalExperienceInYears,CandidatePresentLocation,FileName,CandidateResume,type,length) Values (@CandidateName," + cmbHighestQuali.SelectedValue + "," + cmbJobField.SelectedValue + "," + txtTotalExp.Text + ",'" + txtPresentLoc.Text + "',@FileName,@CandidateResume,@Type," + intFileLength + ")"; SqlCommand Cmd = new SqlCommand(); Cmd.CommandText=sql; Cmd.Connection =Conn.Cn; Cmd.Parameters.Add("@CandidateName",txtCandidateName.Text) Cmd.Parameters.Add("@FileName",System.IO.Path.GetFileName(filPosted.FileName)) Cmd.Parameters.Add("@CandidateResume",System.Data.SqlDbType.Image,intFileLength); Cmd.Parameters["@CandidateResume"].Value=byteData; Cmd.Parameters.Add("@Type",filPosted.ContentType); Cmd.ExecuteNonQuery(); Conn.CloseConnection(); } so pls. help me out in this matter i'll be very much grateful to u Regards Himanshu Saxena Sahara India India Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 113001
  - 18
    - Using UPDATE I con't write the dataset back to datasource It works fine with the datagrid but with the sqlAdapter. Here is the code I was using. if State is always undefined. so it skips the logic, but the Textboxes hold the changed information. I am learning, please advise. Thanks Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112995
  - 19
    - ODBC Data Sources Hi All, Is there a method that I can call to return a list of available database drivers? If so, is there then a way to get the list of fields that are required for those the database drivers? L. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112989
  - 20
    - TNSPING Doesn't Do Much I have TNSPING on my Windows laptop, ver 8.1.7.3.0. It was showing good when the database was down for maintenance. Looking at the output, it doesn't appear to be sending a SID as the later versions do. Is this so? If so, then its just checking for a port? Won't it miss a large class of outages? Thanks. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112985
  - 21
    - Connection Won't Die Application - give Oracle DB connection status on an ongoing basis Technique--thread is fired off by a timer every minute. It attempts to open a connection. It catches an open error as a failure, and otherwise indicates success. It then disposes the connection and ends. The status indicated seems to be good the first time. However, subsequently, it seems to get stuck in the old status, and doesn't always see the connection as transitioning to good from bad or vice-versa. Here's a snippet --- private void testDev(Object state) { try { oracleConnection1.Open(); oracleConnection1.Dispose(); devStatus.ForeColor = Color.Green; devStatus.Text = "DEV UP"; devErrorTxt.Text = ""; } catch (Exception e) { errorMsg = e.Message.ToString(); try { oracleConnection1.Dispose(); } catch (Exception e2) { errorMsg += (" Dispose: " + e2.Message.ToString()); } devErrorTxt.Text = errorMsg; failureMode = true; devStatus.ForeColor = Color.Red; devStatus.Text = "DEV DOWN"; } TimerCallback timerDelegate = new TimerCallback(testDev); t = new System.Threading.Timer(timerDelegate,null,60000,-1); } Suggestions?? Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112982
  - 22
    - Convert _Recordset to DataSet/DataTable I have a Visual C++ .NET function that is calling an unmanaged function that returns an ADO _Recordset* object. I want to be able to convert that into an ADO.NET DataSet (or DataTable). I tried to use the OleDbDataAdapter.Fill method, but I could only get that to work if I gave it an ADODB::RecordsetClass object. I couldn't figure out how to get an ADO _Recordset into an ADODB::RecordsetClass. Any ideas? I don't want to have to rewrite all of our existing unmanaged code. - Brad Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112981
  - 23
    - There is a way to set "Jet OLEDB:Transaction Commit Mode"? Hi, I'm using OleDb Provider for Jet and ADO.NET to connect to an Access 2000 Database. My application spans various transactions and issues various commits in sequence to this database (physically on a network share). Right after a transaction is committed I need to read the information on the database. The fact is that the commit "still not committed" in my next read. I recently discovered that Jet works by default in asynchronous mode. To guarantee the commit, I need to set the provider specific option â??Jet OLEDB:Transaction Commit Modeâ?? to 1. The problem is that I canâ??t find a way to do that in ADO.NET. The KB article 318161 says thatâ??s not possible. Could someone confirm that itâ??s really not possible? Thanks. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112977
  - 24
    - Could not find installable ISAM Using William Ryan's articles as a guide (excellent help, is William) I am trying to connect to my Excel data source. However, I am running into a "Could not find installable ISAM." error message trying to connect to the datasource. Does anyone have any tips as to how this is overcome? Thanks! Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112975
  - 25
    - How DataRelation object is updated After the VS 2003 creates a strongly typed DataSet object that contains a couple of tables and serveral many-to-may data relations among all the tables, and the data got populated, I am wonder how the DataRelation object of the DataSet object is updated when some new rows are added to some of the tables. Do I have to update the relation of the added rows or in somewhere the relations are added automatically? Can someone explain this for me or point me to some resources? Thanks a lots. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112967
- Next
  - 1
    - ADO or String.Format bug ? ...... Hi It seems that String.Format method, when use a ***ZERO VALUE*** object coming from a SqlDataAdapter Fill method works fine, while if the same query is runned using an SqlDataReader ExecuteReader method, the formatted result is wrong .... For my tests i've used the Sql Server 2000 Northwind database and i've updated the Orders.Freight Column to zero (UPDATE Orders SET Freight=0). My general objective is to format all significative decimal values (value > 0)using a mask: #####0.00 and format all zero values using another mask: #####.##. This is obtained with: String.Format("{0:#####0.00;-#####0.00;######.##}", VALUE-TO-FORMAT) The VALUE-TO-FORMAT is obtained either using a server-side cursor (DataReader) and a client-side cursor (DataTable). In the first case it display ",00" (!!! ???) .... ... while using a DataAdapter it (correctly) display "" ..... The complete VB.net code is the following: ============================================================================= Dim Cn As New SqlClient.SqlConnection("uid=sa; pwd=; database=northwind; server=xdev99") Dim Cmd As New SqlClient.SqlCommand("SELECT Freight FROM orders", Cn) Cn.Open() Dim Dr As SqlClient.SqlDataReader = Cmd.ExecuteReader If Dr.Read Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dr.Item("Freight"))) End If Dr.Close() Dim Dt As New DataTable Dim Da As New SqlClient.SqlDataAdapter("SELECT 0 FROM orders", Cn) Da.Fill(Dt) If Dt.Rows.Count > 0 Then Console.WriteLine(String.Format("{0:#####0.00;-#####0.00;######.##}", Dt.Rows(0).Item("Freight"))) End If Cn.Close() ============================================================================== What's your idea ? Thanks. Nicola. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112963
  - 2
    - "Object is no longer valid" exceptions Hi, we have a .NET application that uses ADOMD to query a MS analysis OLAP cube. In a typical query, we get data for about 3 dimensions (800 x 15 x 2 entities) and then iterate over the resulting cell set to extract information. Occasionally, we see "Object is no longer valid" exceptions being thrown. The object (whose access usually throws this error) is of the type "ADOMD.Position". Sometimes the error appears while executing Cell.Get_Item(). We have a mechanism to retry the query if these exceptions are thrown in a (vain) hope that on the retry the whole thing will go off successfully. This works sometimes, but not always, so this isn't satisfactory. Does anyone have any idea why this would be happening? Is this something to do with garbage collection? Are there any workarounds/fixes? I would be grateful to know. Thanks, Ramanand [P.S. Apologies if this is the wrong newsgroup for purely ADOMD queries] Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112957
  - 3
    - connection question I'm getting an error while running an aspx page on a production server. The error is that either the server can not be found or the access is denied. The following code fails at line 36. Line 34: str = "Driver={SQL Server};server=sallyserver;database=school;uid=www_intra;pwd=www_intra" Line 35: C.ConnectionString = str Line 36: C.Open() Line 37: Dim R As New ADODB.Recordset Other aspx pages that don't talk to the data server run correctly. The same page run on the development PC (WinXp Pro) connects and dispays the data correctly. (SQL server is on another box) If I alter the code to run in an Access 2000 database on the same production server, it runs correctly. Thus I'm not sure how to go about getting this up and running. Any thoughts would be appreciated. Cheers Mike Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112936
  - 4
    - MSDE, ASP.NET, Visual Studio .NET, and connectionstrings I have Visual Studio .NET and SQL Server Desktop Engine on my computer. I have created an empty database using Visual Studio .NET's Server Explorer. However, I am having trouble connecting to the database using ASP.NET. I think the problem is somewhere in my connection string, but because I do not know much about connection strings, I am not sure what it should look like. Can someone please help me determine what my connection string should look like? I am using the version of IIS that comes with XP Pro. Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112929
  - 5
    - ODP.NET Publisher Policy? We recently started running into a problem. We had a .NET winform application built with ODP.NET 9.2.0.4. We rolled out a new OS image that had only the 10.1.200 Oracle client and ODP.NET. The existing application stopped working, as it wanted a 9.2.0.4 client. After doing some further research, I've discovered that publisher policies are my answer. All our machines are currently running 10.1.0.200 of ODP.NET, however, and that build did not seem to install or include publisher policies. 10.1.0.400 both includes, and installs by default these policies into the GAC. I'm hoping there's some way I can get or build publisher policies for 10.1.0.200. That way, I could get a script run that simply installs these policies into the GAC of all machines on site. Otherwise, it seems my other option is to uninstall all the 10.1.0.200, and reinstall 10.1.0.400. >From what I've managed to learn about publisher policies, they're done by the publisher of the component. I think I need access to the .key file in order to generate my own, which of course, I do not have for the Oracle.DataAccess assemblies. Anyone know if these publisher policies are available for 10.1.0.200 somewhere? Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112923
  - 6
    - datatable.select("Distinct") or such to string? I am hitting a bit of a wall - I am building a table - public DataTable theTownships = new DataTable("AdjacentTownships"); public DataTable buildTownshipTable() { DataColumn tscolumn; //Townships-Range Field tscolumn = new DataColumn(); tscolumn.DataType = System.Type.GetType("System.String"); tscolumn.ColumnName = "TSR"; tscolumn.ReadOnly = false; tscolumn.Unique = false; theTownships.Columns.Add(tscolumn); return theTownships; } This table is built from another query where each coloumn in that row is turned into a row here. So I can have between 1 and 0 rows, some can be duplicates. What I need to do is then select the distinct rows from this table and pass them to a for loop that I can then parse/process each of the distinct rows. Any and all suggestions would be greatly appreciated!! -- D @ premierdata Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112922
  - 7
    - Using System.GUID in a RowFilter I have a table in SQL server that has a column of type UniqueIdentifier. I use a DataAdapter to fill a typed DataSet with rows from the table. (Interestingly, when I look at the typed dataset, the datatype of this column has magically changed to STRING). Anyway, I need to use this column value in a DataView.RowFilter. However, when I try to create the RowFilter="ColumnName='" & value & "'" I get a runtime error that says I there's no operator that will contatenate (&) a STRING and a SYSYEM.GUID. Apparently, when I fill the typed dataset, the datatype changes to SYSTEM.GUID (I assume the same as UniqueIdentifier), even though the datatype in the typed dataset says STRING. So, how do I use a SYSTEM.GUID in a RowFilter when there doesn't seem to be a way to convert it into a string? -- Michael Hockstein Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112921
  - 8
    - Dataset Relationship I have a grid that is bound to a typed dataset. Three fields make up the key in the parent table and those same three fields are also in the child tables with a 1 to many relationship. When I bind this dataset to a grid it displays it hierchalily (which is what I want) when I drill to the child rows however it has the child row data plus the same data that is on the parent row. I only want to see the child information in the child row. I have looked in the Dataset and found no extra fields in the two sub tables so it is my assumption that it's doing this at runtime. Any ideas how I can get this to stop? Thanks, Justin Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112920
  - 9
    - Using Rollup operator in Sql Server 2000 Guys, I need some advice on displaying Rollup results this is the query (SP). select Org_lvl_2,level_one,doe,sum(RegHours),sum(OtHours) from ZT where Ppe= @PERIOD GROUP BY level_one,org_lvl_2,doe WITH ROLLUP HAVING sum(RegHours) >0 or sum(OtHours) >0 ORDER BY level_one,Org_lvl_2,Doe the Results: NULL NULL 53.0 0.0 NULL CANM 53.0 0.0 HQJ CANM 53.0 0.0 HQJ CANM 32.0 0.0 HQJ CANM 13.0 0.0 HQJ CANM 8.0 0.0 what i'd like to display in a datagrid is:(with the Grand Total @ the bottom & leaving out the Nulls) HQJ CANM 32.0 0.0 HQJ CANM 13.0 0.0 HQJ CANM 8.0 0.0 HQJ CANM 53.0 0.0 i've been able to gain a little control putting the returned dataset into a dataRow and using IsDBNull(myRow.Item(0)) -[like that] - to weed out those null values. but,i've only had success if i then use a Listbox.item.add(myRow.Item(0) & myRow.Item(1)) - like that and i do have control, except for the Grand Total appears at the top of the list, not the bottom. i'm a little lost how to do this same thing in a datagrid, but a repeater or datalist control would be fine too if that's possible. i've worked the sql to death trying to get subTotals & then Grand Total, so if anyone knows another way in sql, i'd appreciate some help on that. other wise any advice on a good asp.net Control to use and maybe the method to display this would be very helpful. i've tried using templates in the datagrid but it doesnt seem to recognize the aggregate columns. thanks again rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112918
  - 10
    - SQL queries and datasets etc As only an occasional ado.net user I'm realising that there's something important and basic that I don't understand: I can obviously perform SQL queries on a database, but sometimes the data I need to access is in a bare datatable. So the question is whether there is a mechanism for performing a query directly on a bare datatable or, failing that, if add the table to a temporary dataset will that do? Or do I need to go the whole hog and integrate it into a full database? (In VB.Net if it makes any difference) Thanks JGD Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112913
  - 11
    - Error saving data from dataset with expression column Hi, I have a dataset created by dragging table from database explorer. Then I have added a column in dataset with expression cant * price in order to get calculation from two columns. This work fine. But when I try to save data into database using datadapter.update method i get the error: Cannot change ReadOnly Property for expression column. Anyone can help me? Thanks. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112902
  - 12
    - Loss of datetime precision when attaching parameters to an ADO.NET command Hi, I am encountering some strange losses of datetime precision when calling a stored procedure through ADO.NET. I'm using ExecuteNonQuery in the Microsoft Data Access Application Block for .NET, which simply creates an ADO.NET command, and attaches each of the parameters, before calling cmd.ExecuteNonQuery(). I have a stored procedure that does nothing but take a whole load of input parameters and insert them into a table. Calling the SP directly from Query Analyser works fine. However, calling the SP from code as follows: ... parameters[5] = new SqlParameter("@Time", SqlDbType.DateTime); parameters[5].Value = time; ... SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.StoredProcedure, "MyStoredProc", parameters); ...results in the time entry made into the database always having a zero value for the seconds. Similarly, if I execute: SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.Text, "EXEC MyStoredProc ..., @Time, ...", parameters); ...the same thing happens. However, if I dump the INSERT statement that's in the stored procedure into a string called sql in the code, and then execute: SqlHelper.ExecuteNonQuery(sqlConnectionString, CommandType.Text, sql, parameters); ...then everything works just fine and I don't get the rounding error. Does anyone have any ideas as to why this may be? Many thanks in advance for your help, Chris. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112900
  - 13
    - Dataset ambiguous error I am getting an error from defining my Dataset. The error is: BC30561: 'DataSet' is ambiguous, imported from the namespaces or types 'System.Data, DreamweaverCtrls'. I am using Dreamweaver, but am doing all the database functions by hand. My function is: Sub CheckStoredLetters() Dim myDbObject as new DbObject() Dim parameters As SqlParameter () = { _ New SqlParameter("@Email",SqlDbType.VarChar,45) } parameters(0).value = session("Email") Dim dbDataSet as DataSet = myDbObject.RunProcedure("GetCoverLetters", parameters,"CoverLetters") DataList1.DataSource=dbDataSet DataList1.Member="Letters" DataList1.databind() End Sub The error is on this line: Dim dbDataSet as DataSet = myDbObject.RunProcedure("GetCoverLetters", parameters,"CoverLetters") I also got the error if I tried: Dim dbDataSet as DataSet What would cause this error? Thanks, Tom Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112888
  - 14
    - DataReader error I have a dataReader that I am trying to use with datalist that works fine with my dropdown but gives me an error when binding with the datalist. The error is: Invalid attempt to FieldCount when reader is closed The code is: ********************************************************** Dim myDbObject as new DbObject() Dim DBReader As SqlDataReader Dim parameters As SqlParameter () = { _ New SqlParameter("@Email",SqlDbType.VarChar,45) } parameters(0).value = session("Email") dbReader = myDbObject.RunProcedure("GetLetters", parameters) DataList1.DataSource=dbReader DataList1.databind() ************************************************************* The myDbObject.RunProcedure is my object that fills a datareader from the Stored Procedure "GetLetters". The dropdown list worked fine when I had: StoredLetters.DataSource=dbReader StoredLetters.DataValueField="LetterID" StoredLetters.DataTextField= "LetterTitle" StoredLetters.databind() I just changed the datasource area and assumed this would work, but it doesn't. The datalist is: <asp:DataList ID="DataList1" RepeatColumns="4" RepeatDirection="Horizontal" runat="server" > <ItemTemplate><%# Container.DataItem("LetterTitle") %> </ItemTemplate> </asp:DataList> Very simple - I would have thought. What would cause that problem? It is virtually identical code, except for the dropdownlist vs the Datalist. Thanks, Tom Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112886
  - 15
    - DA Update Error I realize this is a broad ADO .Net question but i thought I'd give it a shot because i can't solve it When my DG opens and I select a row for deletion everything works fine. If I add a row through a separate Add Form class that returns a merged DS and try to delete the row I just added from the DG the DA.update(DS) gives an exception ("deletecommand affected 0 records"). The Row State of the row is "Delete" and the DS haschanges(). i think the total row counts of the DS and DG are correct Any Ideas? I'm possessed by it. Steve Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112883
  - 16
    - REQ: Practice code/files for Microsoft ADO.Net Step By Step - Please Hi all, Can someone please email me the code for this book .. Microsoft ADO.Net Step By Step 2002 rob012669@inbox.com Thanks in advanced Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112882
  - 17
    - FYI - Alternative DB engine for .net I found a alternative DB engine for .net suited stand alone apps that may not wish to use Jet or MSDE. I have not used it so can not comments on stability. Comes with source code and a license to allow use in commercial products. http://www.gotdotnet.com/workspaces/workspace.aspx?id=ea06f702-480a-4b60-8402-70b27c6472dd Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112872
  - 18
    - Help - MSDE or Jet for Stand-alone App, I am converting a older VB app to .net. The app currently strores info. Into a JET database. As this is an end user app, I can not convert to SQL server, etc. so I need to use either the older Jet engine or using MSDE. Questions: Issues with loading MSDE on a neophyte user's machine. Will it require user tweaking and will it effect their system performance? Also, will they need to install as ADMIN? Also, if multiple people need access to the same database, will MSDE need to be installed on all of the machines and can it access the same database file on a network drive? Or will one machine need to be designated as the DB server? Eg. Time for SQL server? If one is running SQL server 2000, can the databases be used by MSDE? If not, where can find info on what changes need to be done? What is the current stability state of the Jet engine. I know that the pre-4 versions had data corruption issues. Did version 4.x fix most of these issues? Thanks P.S. Any recommendations for a good tutorial on installing MSDE on the target machine and replicating the database files would be helpful. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112865
  - 19
    - SQL Server SPIDs Hello, I don't know much about SQL Server processes/SPIDs but everytime our web app creates a ADO.NET connection and closes it, the SPID is still hanging around in "sleeping status" well after it's closed in the ADO.NET code. Is this normal or I am making database calls inefficiently? I also thought mutiple connection w/ the exact same connection string becomes pooled. If pooled, will that not affect the number of SQL SPIDs created. Should I be concerned about the number of SPIDs the app is producing or is this normal? Thanks in advance, Jim Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112854
  - 20
    - Database query performance I have a database table. The table has number of fields. Out of those fields one is Company and another is DateTime. The table has thousands of records. I want to get the most recent record for each company. In order to do that I am using the following query SELECT * from CompanyDetail AS X WHERE [DateTime]=(SELECT max([DateTime]) FROM CompanyDetail WHERE Company=X.Company) ORDER BY Company Note: There is only one record exists for the given company on a given date The problem is that this query is very slow. Am I doing something wrong or there could be another alternative way to improve it ? Thanks in advance KDV Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112850
  - 21
    - ERROR [42724] - .NET to DB2 via Managed Provider The complete error is at the end of this cry for help. I've been tasked with hooking an interface in ASP.NET and a handheld (via web services) to an existing DB2 data store. The requirement for real-time data submission is driving the development, and all is going well, In fact, the managed provider is working perfectly to execute stored procedures to read from the data store, both ones that have no parameters (simple lookup lists), lookup lists that are pre-filtered with parameters, and ones that use identity columns to pull editable records. Performance is fine, and everything on the interface side is great. BUT (always is one), I get the same basic error (see below) every time I execute a stored procedure that inserts or updates a record. These same procedures all work perfectly from inside the command editor, and the logon to the data store there is the same as the one in the .NET development environment (to eliminate permissions issues). Yet, the error is pulled every time, and being somewhat of a newcomer to the DB2 world, I expect it is probably looking me right in the face. The code accessing the stored procedure is almost identical to the read code, rendered in VB.NET, and patterned after examples on the IBM sample set. Absolutely any insight, even where to look to resolve this, would be highly appreciated. Thanks. Frank Buchan ***ERROR DETAILS BELOW*** ERROR [42724] [IBM][DB2/NT] SQL0444N Routine "*ERT_DEST" (specific name "SQL050622125403880") is implemented with code in library or path "...2.V1_INSERT_DEST", function "MDM2.V1_INSERT_DEST" which cannot be accessed. Reason code: "4". SQLSTATE=42724 Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112849
  - 22
    - Huge data needs to be transfer from Fixed width Text File to SQL S Hi Experts, I have huge fixed width text files around 9GB or 60 TO 75 millions records. I need to transfer 300GB data from these Text files to SQL Server 2000 monthly bases. I am trying to develop VB.NET application. One problem is I need to transform this data, like date is 6 char (mmddyy) which needs to be convert into real Date (mm/dd/ccyy) during the import. I tried to use datareader to bring data into DataTable and then append data into SQL Server using SQLBulkInsert but its taking long time and start failing after 10-16 millions records appended into SQL Server 2000 table. I have following questions:- 1- Which class-method should I use to read the data from text file? 2- How to perform Transformation data ( like converting 6 char date fields into DATE and other validations)? 3- Which Class-method should I use to append data into SQL Server 2000 to get the best performance? 4- Is there any better way to done the same job? I am using VB.NET 2005 Beta. Thank you so much for your time and help. Some code what I am using right now to do so Using rdrDataFile As New TextFieldParser(mstrDataFilePath) rdrDataFile.TextFieldType = FileIO.FieldType.FixedWidth rdrDataFile.SetFieldWidths(objDataFile.SplitPositions) arrNumToExclude.AddRange(objDataFile.ColumnIndicesToExclude) tblDataFile = objDataFile.StagingTable Dim currentRow As String() Dim rowIndex As Integer = 0 destConn = New SqlConnection(strConnectionString) 'Creates Connection destConn.Open() 'Opens Connection ' intTotalRowCount = 1 While Not rdrDataFile.EndOfData Try Dim myRow As DataRow = tblDataFile.NewRow currentRow = rdrDataFile.ReadFields() Dim currentField As String Dim columnIndex As Integer = 0 Dim intCounter As Integer = 0 For Each currentField In currentRow If Not arrNumToExclude.Contains(intCounter) Then myRow(columnIndex) = objDataFile.FormatData(columnIndex, currentField) columnIndex += 1 End If intCounter += 1 Next tblDataFile.Rows.Add(myRow) Catch ex As Exception End Try rowIndex += 1 If rowIndex = 100000 Or rdrDataFile.EndOfData Then 'Upload data To Database in Batches BulkCopyToDB(tblDataFile, objDataFile.DestinationTable) 'Copy Data into DB tblDataFile.Clear() rowIndex = 0 End If 'vpbDataFile.Value = IIf(intTotalRowCount < vpbDataFile.Maximum, intTotalRowCount, vpbDataFile.Value) 'intTotalRowCount += 1 End While End Using Public Sub BulkCopyToDB(ByVal vtblDataFile As DataTable, ByVal vstrDestTable As String) Dim bcp As SqlBulkCopy = Nothing Dim strConnectionString As String = "" Try bcp = New SqlBulkCopy(destConn) bcp.DestinationTableName = vstrDestTable bcp.WriteToServer(vtblDataFile) Catch ex As Exception Finally If Not bcp Is Nothing Then bcp.Close() End If End Try End Sub Regards, -Permood Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112847
  - 23
    - retrieve id when adding a new record in SQL Hello, Iâ??m adding a record to a SQL database. One of the columns in the database generates a uniquely identifying integer when a record is added. I would like to retrieve this number when I add a new record to the table. By the way I do not want to use stored procedures. Iâ??m using the following VB.NET code to add a record to a database how would I change this so that at the same time I can retrieve the unique record id generated by the database in the table? Imports System.Data.SqlClient Dim conDB As SqlConnection Dim strInsert As String Dim cmdInsert As SqlCommand conDB = New SqlConnection("connection string") strInsert="Insert Products (ProdName,ProdCat) Values ('Flat Chair',â??Chairâ??)" cmdInsert = New SqlCommand(strInsert, conDB) conDB.Open() cmdInsert.ExecuteNonQuery() conDB.Close() Thank you. Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112845
  - 24
    - Pivoting DataSet I currently have from SQL a stored procedure that is vaguely doing something like: SELECT FormName, frmDueDate, DepartmentName, Country frmStatus FROM wholeBunchOfTables So data will be returned like: Form1 ITDept USA Incomplete Form2 ITDept UK Completed Form1 HRDept FR Completed Form2 HRDept FR Missing The DataSet resultant from the Stored procedure execution is binded to a sortable DataGrid. However, I would like the data "pivoted": i.e. Form1 Form2 ITDept USA Incomplete Completed HRDept FR Completed Missing Is this at all possible (natively)?? - Can't think of any pivoting SQL operators?? - Can't pivot on ASP.NET/ADO.NET?? Would I have to resort to --- creating another DataSet with columns pivoted?? or --- render my own table, etc. and handle by own sorting? Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112844
  - 25
    - Bug in framework? I'm having a very funny behaviour in my application. My windows App running on XP sp2, has data from various table. If I make changes to only 1 table on the form and click save, it gives an error: "Object reference not set to an instance of an object." If I debug the code, it crashes on the line with "*" (I'm showing the code above, so that it would give a better idea) public void UpdateDataSet() { // Create a new dataset to hold the changes that have been made to the main dataset. ClientManagementPro.dsClientT objDataSetChanges = new ClientManagementPro.dsClientT(); // Stop any current edits. this.BindingContext[dvClient,"relClient-ClientAddress"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-ClientNote"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-Action"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-Child"].EndCurrentEdit(); this.BindingContext[dvClient,"relClient-Job"].EndCurrentEdit(); this.BindingContext[dvClient].EndCurrentEdit(); * <------------------- It crashes here (mind u dvClient is the only thing that is modified). Now, after it gives that error, if I click save, it goes through just fine! Again this only happens sometimes, if I edit the same fields on the same tab, it works just fine. I'm completely lost here and have no clue how to troubleshoot this, any insights would be highly appreciated. Thanks HS Tag: SQL server 2000 transation deadlock in a cluster environment Tag: 112840

hi all

got a situation here, there are 3 app server that are running this
application to delete records in the sql server
periodically. what happen is that they all start up at the same time.(this
could be fixed by varying the start up
time on each app server for that application, but it's not a good solution.)
to delete records on the same table.

so there is:
transaction (process ID #100) was deadlocked with another process and
has been chosen as the deadlock victim. Rerun your transaction."

now I have read some article online saying putting a "with (UPDLOCK)" after
the FROM <some table> will
fix the problem.

does anybody have the similar experience? what would be a perfect fix?

thx

Kevin

Top