SPs, sqlCommand and Terminal Services

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
    - DataSet Filter Hello all. I'm trying to filter a dataset using the below snippet, however, it's returning 2 rows and it should only return 1. Can anyone please hel?p DataView dv = new Customer().GetCustomerFiles(4).Tables[0].DefaultView; dv.RowFilter = "FileType = 'Company Info'"; int b = dv.Table.Rows.Count; string a = dv.Table.Rows[0]["Title"].ToString(); Thanks all, Jon Tag: SPs, sqlCommand and Terminal Services Tag: 106593
  - 2
    - SqlCommand fires too soon..... I have the following: ___________________________________ Dim cmdSaveUser As New SqlCommand cmdSaveUser.Connection = con 'con has been configured previously cmdSaveUser.CommandType = CommandType.StoredProcedure cmdSaveUser.CommandText = "spInsertUser" cmdSaveUser.Parameters.Add("@FirstName", "Joe") cmdSaveUser.Parameters.Add("@Navn", "Brown") cmdSaveUser.Connection.Open ..... ___________________________________ What happens is this: As soon as i .open the connection, it seems that the command is fired. I don't want this to happen, as I want to call executeScalar and get an object in return. Any ideas? Jeppe Jespersen Tag: SPs, sqlCommand and Terminal Services Tag: 106592
  - 3
    - Losing records in a transaction I'm currently using .NET 1.0 and MS .NET provider for Oracle to connect to my Oracle9i R2(9.2.0.5) database. I have a piece of code which in essence is as given below Try m_Conn = New OracleConnection(strDBConnString) m_Conn.Open() m_Trans = m_Conn.BeginTransaction() 'Here I have a series of inserts and updates on huge tables. I am using ExecuteNonQuery function of the OracleCommand object for all these operations. InsertTb1() InsertTb2() UpdateTb3() 'If all goes fine I commit the whole transaction m_Trans.Commit() Catch ex as Exception 'Here I catch all exceptions and rollback the whole transaction m_Trans.Rollback() Finally m_Conn.Close() End Try I have similar code doing different actions on the same tables, running through out the application. Off late I have been getting database locks and subsequent slowness in the application. My DBA tracks down the holding statements and kills the session. Now, if the script used in InsertTb1() happens to be the statement of the assocated session that was killed, I expect Oracle to throw an exception, which inturn should be caught in the catch block and the whole transaction shoud be rolled back. But, it looks like I do not get an exception, due to which the code proceeds to fire the subsequent statements (InsertTb2(), UpdateTb3()) and I end up with incomplete records in the database. I have had an instance before, where Oracle database was throwing a 'No Data found' exception, but the exception never bubbled to my code i.e. The .NET provider ignored the excepton. Could this be a similar case? -- Message posted via http://www.dotnetmonster.com Tag: SPs, sqlCommand and Terminal Services Tag: 106591
  - 4
    - changing the table a dataadapter accesses changing the table a dataadapter accesses If I want to change the table a dataadapter accesses, can I remove the former table from the dataset's xsd file by simply deleting it? Thank you in advance. dennist685 Tag: SPs, sqlCommand and Terminal Services Tag: 106590
  - 5
    - DataTable.Select question Hi! An application adds DataRows into DataTable in random period of time, and after adding new rows saves DataTable as XML-file. DataTable contains DateTime Field named as "SaveTime", and some other fields... About "SaveTime" field, schema looks like... <xs:element name="SaveTime" type="xs:dateTime" minOccurs="0" /> Q: Is it possible to retrieve easily only those rows where rows are for example at least 10 minutes old according "SaveTime"? I mean something like... Dim drArr As DataRow() = dt.Select("SaveTime >= 10min") ...so how to make filterExpression correctly if it is possible? -- Thanks in advance! Mika Tag: SPs, sqlCommand and Terminal Services Tag: 106586
  - 6
    - Inject timeout BUT it's success Hi, My program uses DAAB to inject data to SQLServer using ExecNonQuery() with stored procedure. In normal case, it works property. But in some situations such as database backup process, I got timeout error and my program will retry to inject until success. In this week, I've found that my program inject data in backup period and it returns duplicate row after backup done. I think it will inject success but it returns timeout error. Do you have any suggestion to check this, because my program has to notify another program to process this data after injecting success. Best regards, Thana N. Tag: SPs, sqlCommand and Terminal Services Tag: 106585
  - 7
    - DataRowCollection.InsertAt method Hi to you all, I wonder if anyone has been able to get the DataRowCollection.InsertAt method to work correctly? I added 2 rows in DataGrid using InsertAt function. After I edited one of the rows and moved to Up/Down, a new identical row appeared in the DataGrid. Is this a bug? Any workaround in this case? Thanks, Daniel Tag: SPs, sqlCommand and Terminal Services Tag: 106583
  - 8
    - DataTable.TableName returns "Table"?? Hi, I get a DataTable based on this simple query: SELECT * FROM Customers Later, I want to know just the table name because I do not want to play with the string within the SELECT statement. I expect DataTable.TableName to give me an exact name, i.e. "Customers", but it gives me "Table" regardless of what query from what table. Can someone gives me some clarifications on the TabeName property? Thanks in advance. Regards, Antonio Tag: SPs, sqlCommand and Terminal Services Tag: 106578
  - 9
    - DataSet and GC.SuppressFinalize We are having issues with DataSet and related objects. They are staying in the memory for too long. When we started investigating the problem, windows debugger (windbg) showed that they are in the finalization queue. This surprised us as we were not aware that they have finalizers defined. The .net framework code (mentioned in this email) is reverse engineered by Anarkino tool. Even though DataSet does not define a finalizer, it derives from MarshalByValueComponent (MBVC) which does implement finalizer. In addition, the DataSet does not define a Finalize method but the base class does. However the base class has only proteted Finalize method. This means only derived classes can call this method. The constructor of DataSet makes GC.SuppressFinalize(this) call. Thinking that we have to call Dispose method, we checked for Dispose method implementation on DataSet. Well, it is not there. But MBVC has it. To my surprise, it is making GC.SuppressFinalize(this) again in the MBVC's Dispose method. This means these objects will never be finalized (is this right?) That is 2 times we saw the GC.SuppressFinalize between DataSet and MBVC implementations. Can any one explain why the supress call is required when we are not using any typed datasets? Is there an elegant way to make them disappear faster (other than using ReRegisterForFinalize method)? This problem applies all classes the derive from MBVC. Thanks. Raghu/.. Tag: SPs, sqlCommand and Terminal Services Tag: 106570
  - 10
    - Dataset XML Select Hello, I use VB.net I have a XML file and I read it with a dataset : myDS.readxmlschema("test.xsd") myDS.readxml("test.xml") I have 3 tables in my dataset. Is it possible to select easily data like with SQL ? ex. Select name from Table1 Where region = (Select num From Table2) .... Thanks for your help Tag: SPs, sqlCommand and Terminal Services Tag: 106567
  - 11
    - Removing empty fields from a bound datagrid Howdy folks: Long time listener...first time poster. My issue is that I am binding DB data to a datagrid using the <%# Container.DataItem("FOO") %> methodology. So my question is this...if FOO is empty, how can I substitute it out and replace it with something like "Not Entered"? Yes, I know I can choose to do this programatically, but before I go down that road I wanted to know if it's possible with a hidden Eval command or something of the like. Danke, Jacko Tag: SPs, sqlCommand and Terminal Services Tag: 106565
  - 12
    - Efficient Database Paging Tests I have been trying to determine the fastest way to implement database paging for an Access database with an ASP.NET front-end. I have a difficult database because the user can change the sorting and the fields are not unique, which excludes the "Select TOP" approach. Also the database has about 60,000 records and is growing. The user has to always have current data which excludes caching. I've tried the following approaches: 1. Using an OleDBDataAdapter to fill a datatable and then displaying the paged records from the table. 2. Using an OleDBDataAdapter to partially fill a dataset with the paged records and then running a second command to retrieve to the total records. 3. Looping through an OleDBDataReader until I get to the paged records and a second command to retrieve to the total records. 4. Looping through an OleDBDataReader to get the paged records and then completing the loop to count the total records. All 4 methods return the current total records which I need to set up my paging menu. Approach #1 if by far the slowest (up to 4 times slower) in every scenario. Approach #2 is the fastest most of the time. The Microsoft documentation warns that this approach is inefficient, but I have not found this to be the case. The only case where this approach faults is when the query's WHERE clause is very complicated. However, when there is no WHERE statement or ORDER BY and the page is near the start of the records then this approach is about 4 times faster than the next fastest. Approach #3 is slightly slower than #2 and also faults when the WHERE statement is complex. Approach #4 is also only slightly slower than #2, and it is not slowed down by a complex WHERE statement. My conclusion is that either #2 or #4 is best. Any suggestions would be appreciated. Tag: SPs, sqlCommand and Terminal Services Tag: 106563
  - 13
    - OleDbDataAdapter Partial Fill I'm using a OleDbDataAdapter to partially fill a dataset: Overloads Public Function Fill(DataSet, Integer, Integer, String) As Integer Everything works, but the function only return the records filled. Is there any way to get the total record count, without another command? Tag: SPs, sqlCommand and Terminal Services Tag: 106560
  - 14
    - Batch Queries with OLEDB I'm trying to use a batch SQL statement with an OleDbDataReader and the NextResult method. I tried: "SELECT Pages FROM Documents ; SELECT Date FROM Orders;" However, I get the error: "Characters found after end of SQL statement. " If I try removing the semicolon I get "Syntax Error in Query Expression." My database is a Microsoft Access 2000 mdb file and the code is running in ASP.NET. What am I doing wrong? Tag: SPs, sqlCommand and Terminal Services Tag: 106559
  - 15
    - Format of the initialization string does not conform to specification... I am trying to load data from a flatfile into a dataset, but I get the following errror: "Couldn't connect: Format of the initialization string does not conform to specification starting at index 170." What am I doing wrong? --gloria -------------------------- schema.ini: [861D_NI_03082005001.txt] ColNameHeader=False Format=TabDelimited CharacterSet=ANSI -------------------------- string filename = "861D_NI_03082005001.txt"; string fullfilename = @"\\asean-test2\sdc\" + filename; string connectionStr = "Provider=MediaCatalogMergedDB OLE DB Provider;" + "Persist Security Info=False;Data Source=" + fullfilename + ";Mode=Read" + "Extended Properties=\"Text;HDR=NO;\""; string loaddtlStr = "select * from " + filename; try { OleDbConnection loaddtlCN = new OleDbConnection(connectionStr); loaddtlCN.Open(); porerrorClass.WriteLine(3,CurrentFunction,"Connection is open."); OleDbDataAdapter loaddtlDA = new OleDbDataAdapter(loaddtlStr,loaddtlCN); DataSet loaddtlDS = new DataSet("LoadedDtl"); loaddtlDA.Fill(loaddtlDS); int rowcnt = loaddtlDS.Tables[0].Rows.Count; porerrorClass.WriteLine(3,CurrentFunction,"Rows loaded: " + rowcnt); loaddtlCN.Close(); } catch (Exception ex) { porerrorClass.WriteLine(3,CurrentFunction,"Couldn't connect: " + ex.Message); } Tag: SPs, sqlCommand and Terminal Services Tag: 106557
  - 16
    - Big Problem on SQL Server link to Web Services Dear developers, i hav face a big problem on connect my web services to my DB. i m using MS SQL Server 2000 to build the web services.. but i cannot invoke the input into the database and "HTTP 500 - Internal server error" on the IE. I hav try the same thing on newly created ASP.NET Web Application, it works fine... but when come to the ASP.NET Web Service, i face the problem.. can everybody out here pls advice.. anything additional setting should make on the Web Service..? Thanks a lot.. cheers, Wong CS Tag: SPs, sqlCommand and Terminal Services Tag: 106554
  - 17
    - DataRowCollection InsertAt method Hi to you all, I wonder if anyone has been able to get the DataRowCollection.InsertAt method to work correctly? I added 2 rows in DataGrid using InsertAt function. After I edited one of the rows and moved to Up/Down/Left/Right, a new identical row appeared in the DataGrid. Is this a bug? Any workaround in this case? Thanks, Daniel Tag: SPs, sqlCommand and Terminal Services Tag: 106549
  - 18
    - AutoIncrementSeed une solution complète qui marche C'est un mini exemple avec un DataGrid, un bouton "Add" (pas nécessaire, juste pour le code) et un bouton "Update". Le but : Utiliser des valeurs négatives pour les nouvelles saisies dans les champs auto incrémentés. Lors de la mise à jour avec DAProduits.Update(...), on cherche la prochaine valeur du champ auto incrémenté pour mettre à jour à la fois l'enregistrement du Dataset (pour le DataGrid...) mais aussi celui situé en base de données réelle. Si cette table est liée avec une autre, utiliser les mises à jour en cascade (dans le DataSet): ForeignKeyConstraint.acceptRejectRule ForeignKeyConstraint.DeleteRule ForeignKeyConstraint.UpdateRule Cet exemple a été réalisé pour une base de données Access. Public Class Form1 Inherits System.Windows.Forms.Form #Region " Code généré par le Concepteur Windows Form " Private DAProduits As New OleDb.OleDbDataAdapter Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim cmdBuilder As New OleDb.OleDbCommandBuilder(DAProduits) With DAProduits .SelectCommand = New OleDb.OleDbCommand("SELECT num,libellé FROM Produits", OleDbConnection1) .FillSchema(Me.DsProduits1, SchemaType.Source) '.FillSchema(Me.DsProduits1, SchemaType.Mapped) 'Fonctionne aussi .InsertCommand = cmdBuilder.GetInsertCommand() '(1) With Me.DsProduits1.Tables("Produits").Columns("Num") If .AutoIncrement Then .AutoIncrementSeed = -1 'Ne marche pas s'il est placé après le DAProduits.Fill(...) .AutoIncrementStep = -1 End If End With .Fill(Me.DsProduits1, "Produits") End With Grid.DataSource = Me.DsProduits1.Tables("Produits") End Sub Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click 'Ajout depuis un bouton (pour le code) 'Pas nécessaire car ça fonctionne aussi de manière classique, sans bouton "Add" Dim row As DataRow With Me.DsProduits1.Tables(0) row = .NewRow row("Libellé") = "Nouveau produit" .Rows.Add(row) .AcceptChanges() End With End Sub Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click If DsProduits1.Tables("Produits").Columns("num").AutoIncrement Then Try AddHandler DAProduits.RowUpdated, New OleDb.OleDbRowUpdatedEventHandler(AddressOf OnRowUpdated) DAProduits.Update(DsProduits1, "Produits") Finally RemoveHandler DAProduits.RowUpdated, AddressOf OnRowUpdated End Try Else DAProduits.Update(DsProduits1, "Produits") End If End Sub Private Shared Sub OnRowUpdated(ByVal sender As Object, ByVal e As OleDb.OleDbRowUpdatedEventArgs) Dim idCMD As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT @@IDENTITY", e.Command.Connection) 'Si le nom du champ AutoIncrement est nécessaire, une solution est de créer manuellement la requête SQL en (1) 'du DAProduits.InsertCommand en plaçant le champ AutoIncrement comme premier champ 'la ligne ci-dessous devient alors : e.Row(0) = CInt(idCMD.ExecuteScalar()) If e.Status = UpdateStatus.Continue AndAlso e.StatementType = StatementType.Insert Then e.Row("num") = CInt(idCMD.ExecuteScalar()) e.Row.AcceptChanges() End If End Sub End Class Tag: SPs, sqlCommand and Terminal Services Tag: 106547
  - 19
    - Error - No Value Given For One OR More required Parameters I have the following lines of VB.Net code. Its works if the HDR property is set to "No" but changing it to "Yes" generates the error "No Value Given For One OR More required Parameters". What am I missing? Dim sInsert, sSelect, sConn, sFile As String sFile = txtFileName.Text.Trim sInsert = "INSERT INTO [PassResults] (Model, Result, Operator) " sSelect = "SELECT F1, F2, F3 from [Excel 8.0;DATABASE=C:\PassResults.xls;HDR=Yes;IMEX=1].[Results$];" sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestResults.mdb" Dim AccessConn As New System.Data.OleDb.OleDbConnection(sConn) Try AccessConn.Open() Dim AccessCommand As New System.Data.OleDb.OleDbCommand(sInsert & sSelect, AccessConn) AccessCommand.ExecuteNonQuery() AccessConn.Close() Catch ex As Exception MessageBox.Show(ex.Message) Finally AccessConn.Close() End Try Tag: SPs, sqlCommand and Terminal Services Tag: 106538
  - 20
    - Selecting a Row in a DataTable Hi I'm very new to this so forgive me if I've made very amateur mistakes. I am writing a web page for work so that items in a database can be queried and then amended if required. I've written a function which returns a DataSet. I call this function from a sub procedure and assign the returned DataSet to a new dataset object (dsTable) with page level scope (dim at top of page). I then bind this data to a DataGrid control. All of this works fine. I then want to enter the row number of an item in the DataGrid and assign a new value to a column of the selected row. I'm doing this very simply by adding a text box for the user to enter the row number then to click a button to apply the changes. The button event calls the Preview sub and passes the row number. The way I expected this to work was private sub Preview(intLine as Integer) dim tSelect as DataTable tSelect = dsTable.Tables("Orders") tSelect.Rows(strLine).Item("Cost")=txtCos.Text '****Error here *** dgOrders.DataSource=dsTable dgOrders.DataBind() end sub However at the line of code I've highlighted I get an error saying "Object reference not set to an instance of an object." What does this mean. Any help would be greatly appreciated as it's driving me mad :o). Thanks Tag: SPs, sqlCommand and Terminal Services Tag: 106531
  - 21
    - datagrid rendering multiple tables I am building an online testing application that uses a usercontrol to navigate through a list of questions. The questions are multiple choice. I have a stored procedure that returns two tables: questions & answers. I have defined a relationship in code using a DataRelation. I would like to use a datagrid to display the questions and answers in order to take advantage of paging offered with the datagrid. Where I am having difficulty is determining how to have the datagrid list the question from one table and then the answers from the child table. Any suggestions? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: SPs, sqlCommand and Terminal Services Tag: 106529
  - 22
    - Multi-Database Transactions I've been looking into adding transaction capabilities into my object model framework. I always understood that, with SQL Server, a transaction could only cover one database, regardless of whether the transaction was done in a stored procedure or ADO ('classic ADO' or ADO.Net). But when I started reading in detail it got vague. For example, people were talking about data _sources_ instead of databases. So I did some testing and I can do a transaction in either SQL or ADO that successfully commits or rolls back updates to two databases. I'm using a single SQL Server 2000 Standard Edition with multiple databases on it and .Net 1.1. Before I get carried away, can anybody tell me the facts or point me to some definitive information about this, please? Thanks. Tag: SPs, sqlCommand and Terminal Services Tag: 106526
  - 23
    - Filter DataView for Duplicates? I have a DataTable with duplicates in a column. I would like to display only this column in a DataView, but remove any duplicates that exist. How can I do that? Thanks. Tag: SPs, sqlCommand and Terminal Services Tag: 106519
  - 24
    - use of SqlDataAdapter with a table without Primary Key Hi, I thought it isn't possible to use a SqlDataAdapter and a Databound grid when there isn't a 'real' primary key on the table. Although, is there a way to use it, and define somewhere in the SqlDataAdapter my own primary key on the table? I can't add a primary key to the table, so I guess that's the only way to find a solution? Any help would be really appreciated! Thans a lot in advance, Pieter Tag: SPs, sqlCommand and Terminal Services Tag: 106507
  - 25
    - Timeout at runtime but no timeout at design time in VS2003 Hi all, I have a timeout problem when retrieving data from my DB in a C# program. Everything is OK at design time : I can generate a Dataset and populate it with its data. Important note : the View1 is based on a UserDefined function returning a table variable, it takes 54 seconds to retrieve the data in SQL Analyser and approximatly the same in the VS designer. At runtime, this usual code crashes : ----------------------------------------------- sqlConnection1.Open(); try { sqlDataAdapter1.Fill(dataSet11); // crashes here. dataGrid1.DataSource = dataSet11; dataGrid1.DataSource = "View1"; } catch (Exception erreur) { MessageBox.Show(erreur.Message); } sqlConnection1.Close(); ----------------------------------------------- 1. How can the designer work differently ? 2. Where could I tell my connection to wait a longer time ? Thanks in advance, Patrice. Tag: SPs, sqlCommand and Terminal Services Tag: 106500
- Next
  - 1
    - re:creating a combobox column In my first post I tried to explain that I want to make a combobox column in a datagrid. But without having to buy a reference from a company I'm stuck! Did it make it a bit clearer? thanks! Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: SPs, sqlCommand and Terminal Services Tag: 106498
  - 2
    - I would like to insert a new column in DataTable at a specified position I would like to insert a new column in DataTable at a specified position, is it possible and how ? Thanks Tag: SPs, sqlCommand and Terminal Services Tag: 106492
  - 3
    - Timeout on Connection Pool I'm getting the following error message in an ASP.NET application: Time Expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. I've read several KB articles on this and examined the server through the performance monitor while this error was occurring. SqlClient: _global_ Current # connection pools: 6 SqlClient: _global_ Current # pooled & nonpooled connections: 14 SqlClient: _global_ Current # pooled connections: 14 We do have six different apps running each with its own connection string. The connection strings contain only the server, database uid and pwd keywords. So I think I understand the Current # connection pools. What I do not understand is how I'm running out of connections when there is only 14 being used/pooled when the default is 100? What am I missing here? Also, as a side note, does anyone know what the "SqlClient: Total # failed commands" represents? This number was in the thousands on the performance monitor but I cannot see anything in our log file. We do capture and log every failed execution for review and there was nothing reported. Thanks in advance. Steve Tag: SPs, sqlCommand and Terminal Services Tag: 106490
  - 4
    - How can I combine crystal reports into one? (Type your message here) -------------------------------- From: Wu Jerry Basically, I use dataset as the datasource of the report and the= report takes in some parameters, too=2E The primary purpose of my= report is to display the profile of the employee=2E In order to= display multiple records, I have created a number of these= reports and each with its own dataset and parameters=2E I would= like to know if I can combine these reports into one so that I= can make good use of some features of the crystal report= viewer=2E(e=2Eg=2E printing, export to pdf) p=2Es=2E Right now, when I am using the printing and export to pdf= function, I can only get one record done at a time instead of= the records I want=2E ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>bABLM3HYNE2FatekpPxAYg=3D=3D</Id> Tag: SPs, sqlCommand and Terminal Services Tag: 106482
  - 5
    - Problem installing MSDE 2000 Hi, I've tried to install MSDE 2000 but without success. At first i got an error message about missing SAPWD. After i got some guidance (thanks to Peter) I defined a new administrator account under the name "NetSDK" , and add it a password (my previous account did not contain a password). Then i run from the command line the following command : SETUP.EXE INSTANCENAME="NetSDK" SAPWD="myPassword" . At first it seemed like I'm on the right way since I passed the first step which at the beginning required the SAPWD, but then a small window of "configures Microsoft SQL Server Desktop Engine ... " opened and a time remaining clock start count toward 0. When it gets to 4 seconds remaining it stucks, reinstall everything and aborted the installation. I have no id what's the reason for that but i tried several times and i got the same unwanted result each time. If anyone knows the reason or has any idea for solving this matter I will be grateful. Thanks, Gal. Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: SPs, sqlCommand and Terminal Services Tag: 106473
  - 6
    - Ups... just realised this is probably posted in the wrong forum (even though I'm retrieving data from MS Access to fill my datagrid...) I'll try to move the post But feel free to answer anyways :D Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: SPs, sqlCommand and Terminal Services Tag: 106472
  - 7
    - "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." "Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction." I am recieving the above error when attempt to access a remote sql server database 2000 (sp3a) from ADO.Net. The database is on a windows 2003 machine and the ado.net code (web services) are on another winsdows 2003 machine in the same domain. I have configure the DTC to allow transactions and followed the resolution in the following KB but I am still getting the error. http://support.microsoft.com/?kbid=834849 Anyone got any ideas? Cheers Ollie Riches http://www.phoneanalyser.net Disclaimer: Opinions expressed in this forum are my own, and not representative of my employer. I do not answer questions on behalf of my employer. I'm just a programmer helping programmers. Tag: SPs, sqlCommand and Terminal Services Tag: 106461
  - 8
    - OleDbType for SQL Server Text? I have a column in a SQL Server 2000 table that is of type Text. That is so I can put an unlimited-size string inside that column. I am using the OleDb connector to put data in there, my pseudo code looks ike this: "@myparamname" , OleDbType.LongVarChar , 819200 , ParameterDirection.Input But text seems to be truncated after about 1000 characters. What is the OleDb type I should use when I want to insert say a 40k piece of text? Thanks. Tag: SPs, sqlCommand and Terminal Services Tag: 106456
  - 9
    - concurrencymanager refresh slow on first record I have the following situation. I have a datagrid bound to an arraylist. Initially, the arraylist is empty. When the user adds an item, the item is added to the arraylist and then the datagrid is updated by getting the currencymanager and calling its refresh method. For reasons I won't go into here, at this point in time the datagrid is simply for display purposes. The problem is, there is a second or two delay from when the refresh method is called and it returns but only on the first record. After the first record is put into the arraylist, any subsequent additions to the arraylist and calls to the currencymanager refresh method are almost instantaneous. Anyone run into this issue and/or know how to work around it? Thanks! -- -------------------------------------------------- Christopher C. Bernholt I.T. Research & Development .NET Re-Engineering Team R & L Carriers, Inc. http://www.gorlc.com -------------------------------------------------- Tag: SPs, sqlCommand and Terminal Services Tag: 106450
  - 10
    - Speed problems when accessing large MS Access database I?m doing some work on a project which involves accessing a large= Access database (about 850Mb) The problem is when I?m doing an update/insert into the database= the oleDbCommand=2EexecuteNonQuery() method seems to return before= Access has committed the change ? This means that a display I= have on screen which reads back what has just been ?inserted?= doesn?t work correctly=2E At first the problem was only intermittent but as the database= has grown it seems to happen all the time=2E It does work okay if= I step through the program in Visual Studio (thus introducing an= artificial delay)=2E Does anyone know a way around this? Someway= for the code to block until the operation has been committed? I= can?t seem to find info about this online=2E If I make the thread= sleep for 500 MS after performing the insert it's okay as well?= Is there a connection string parameter or something I can use?= Our customer wants to stick with MS Access for now although they= want to upgrade to SQL Server later=2E Thanks=2E Patrick=2E -------------------------------- From: Patrick Fryer ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>sOaUoMftzE+yoWng0QzNyg=3D=3D</Id> Tag: SPs, sqlCommand and Terminal Services Tag: 106442
  - 11
    - Oracle Connectivity/Windows Service We have a windows service written in VB.NET. This service is used to trigger applications. The functionality of the service can be briefly explained as 1. The Service accesses the Oracle database. 2. Checks the status of certain table entries. 3. Depending on the table entries processes are triggered. 4. The Service is a perpeterating one with a periodicity of 2 minutes. Issue: 1. The service is installed and is started. It is functioning as expected. Now the Database is brought down (say for backup) and is brought up again. When the Database is brought down the service is not able to access the database which is expected. Now when the database is brought up the service still persists with the error. ERROR from the service: -------------------------------- ERROR MESSAGE : ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist SVR4 Error: 2: No such file or directory -------------------------------- A manual restart of the service is required to make the service functional again. Software Details ------- Oracle Version : Oracle 9i Enterprise Edition, Release 9.2.0.4.0 .NET Framework: Microsoft .NET 2003, v1.1.4322 ------ The service works well on Windows 2003 server but this issue comes in Windows 2000 server SP4. Any inputs on this will be of help -------------------------------- From: Karthikeyan Raghuraman ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>o7P+hRe3/0WrQ0UqB79M1A==</Id> Tag: SPs, sqlCommand and Terminal Services Tag: 106441
  - 12
    - Add a record directly to a table (Type your message here) Hi All, I am new to VB Dot Net, coming straght from VB6=2E I have tried and= failed trying to add a record to a table directly from a Data= Entry Screen=2E From reading ref=2Ebooks, it seems that I have to= create a DataSet, populate it,then use that to update the table=2E= I am utterly confused=2E Any suggestions or advices to point me= in the right direction are most welcome and appreciated=2E= Thanks=2E -------------------------------- From: Lennie Kuah ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>hMQj/rC4yEGoijx/0C8WmA=3D=3D</Id> Tag: SPs, sqlCommand and Terminal Services Tag: 106439
  - 13
    - Problem in search function! Hi, i have a search function on my page. first i allow user to select from the dropdown a price.On btn_click i estalish Sql Connection..then ..creat command..and then creat dataview. dv.RowFilter = "Price=here i want to have the selected value" from the dropdown i have named DropDown as ddlComnapy...so my code looks like.. dv.RowFilter = "Price=ddlCompany.SelectedValue" but on running the program it says:System.Data.EvaluateException: Cannot find column ddlcompany.SelectedValue but if i hardcode a value ,then the code works perfectly fine. CAN SOME BODY PLEASE POINT OUT WHERE I AM GOING WRONG .NET ROCKS! Aal -------------------------------- From: Aal D ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>bpTi2sC0OE2D6LdXZs+/XA==</Id> Tag: SPs, sqlCommand and Terminal Services Tag: 106437
  - 14
    - crystal report (Type your message here) i am workin on crystal report i hav created a dataset i want columnname in report as that of one of field of dataset ie my dataset contains fields city,department,amount i want records to b dispalyed as delhi mumbai pune banglore admin 100 100 1000 10000 marketing 1000 1000 1000 10000 these citynameand departnment name is comming from database i am stuck here and will be very gr8ful if u can help me -------------------------------- From: pearl 123 ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>wzoF1UvGsUWz1gntDrJDGQ==</Id> Tag: SPs, sqlCommand and Terminal Services Tag: 106436
  - 15
    - Bucket Data Columns What are "bucket" DataColumns that I see in my DataTable.Columns DT.Columns.columnFromName I can see several entries in the quickwatch like follows... Name Value buckets[45] {key={System.Array} val = <undefined value>} I belive these bucket columns are preventing me from doing a DataTable.Select() call so I can sort the datatable. Tag: SPs, sqlCommand and Terminal Services Tag: 106431
  - 16
    - any info on how to use mysql with .NET ? Hi I'm trying to use MySql with .NET. Has anyone done this? where is a good place to look for how to do this? Thanks much Dee Tag: SPs, sqlCommand and Terminal Services Tag: 106426
  - 17
    - DatagridView and DateTime ... How to set DataGridView column property to display only time part of System.DateTime value type? For example - whem I have DateTimePicker, I can set format to custom HH:mm and everything is allright... Is any simple solution to do the same with DataGridView column property ?? Tag: SPs, sqlCommand and Terminal Services Tag: 106421
  - 18
    - DatagridView and DateTime ... How to set DataGridView column property to display only time part of System.DateTime value type? For example - whem I have DateTimePicker, I can set format to custom HH:mm and everything is allright... Is any simple solution to do the same with DataGridView column property ?? Tag: SPs, sqlCommand and Terminal Services Tag: 106420
  - 19
    - DatagridView and DateTime ... How to set DataGridView column property to display only time part of System.DateTime value type? For example - whem I have DateTimePicker, I can set format to custom HH:mm and everything is allright... Is any simple solution to do the same with DataGridView column property ?? Tag: SPs, sqlCommand and Terminal Services Tag: 106419
  - 20
    - Oracle Int/Decimal problem Using OracleDataAdapter we have a problem with integers. The following table can be used as an example: CREATE TABLE tCmpCommunic ( nCommunicKey INTEGER NOT NULL, nPartyKey INTEGER NULL, nContactMechanismType INTEGER NOT NULL, nGeoKey INTEGER NULL, sAddress NVARCHAR2(1000) NULL, sComment NVARCHAR2(100) NULL, nComViaGeoKey INTEGER NULL, bMainContact SMALLINT NULL ); For some reason, the integer-columns are returned as decimals when using the Fill-method on the dataadapter. Has anyone seen this before? Are there something we are missing? Thanks in advance Egil Winther ShipNet AS Tag: SPs, sqlCommand and Terminal Services Tag: 106418
  - 21
    - Insert Records from a DataSet to MS Access 2000 I have the following VB.Net code to read an Excel file and it works fine. How do I take these records and insert into an Access 2000 database table? gsDBName = "MyFile.xls" gsProvider = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & gsDBName & "; Extended Properties=Excel 4.0;" sConn = New System.Data.OleDb.OleDbConnection(gsProvider) goDA = New System.Data.OleDb.OleDbDataAdapter(sExcelQuery, sConn) goDS = New System.Data.DataSet Try goDA.Fill(goDS) Catch ex As Exception MsgBox(Err.Source & vbCr & Err.Description) End Try dgExcel.DataSource = goDS Tag: SPs, sqlCommand and Terminal Services Tag: 106413
  - 22
    - Jet 4.0, ISAM and Excel Hi, when I read an excel column containing numbers with Jet 4.0, and fill a = dataset, I obtain a "System.Double" datatype. I would prefer to have a = System.Integer value, to fill a sql database column... Some ideas ? Oriane Tag: SPs, sqlCommand and Terminal Services Tag: 106405
  - 23
    - Retrieve attributes from xml document using typed dataset I have an XML document that stores configuration settings for an app. I generated the schema using vs.net and also the corresponding dataset. I can load the config file (config.xml - below) and get all the data except for the element attribute values. I cannot figure out why the attribute values return a value of system.dbnull when the file contains values for those attributes. The code is as follows: config loader .vb Dim dsConfiguration As New Config dsConfiguration.ReadXml(Server.MapPath("Config.xml")) 'I cannot get the following attribute value title Response.Write(dsConfiguration.Page(0).Title) 'but this works fine Response.Write(dsConfiguration.JavaAttribute(0).AttributeName) config.xml <?xml version="1.0" encoding="utf-8" ?> <Config xmlns="http://tempuri.org/Config.xsd"> <Page Title="Some title"> <MetaTag> <Attribute AttributeName="something" Value="skdj" /> </MetaTag> <JavaScript Path="/script.js"> <JavaAttribute> <AttributeName>language</AttributeName> <Value>JavaScript</Value> </JavaAttribute> </JavaScript> <StyleSheet Path="/style.css"> <StyleAttribute> <AttributeName>rel</AttributeName> <Value>stylesheet</Value> </StyleAttribute> <StyleAttribute> <AttributeName>type</AttributeName> <Value>text/css</Value> </StyleAttribute> </StyleSheet> </Page> </Config> Tag: SPs, sqlCommand and Terminal Services Tag: 106404
  - 24
    - Update on child rows does nothing Hi, I have a Dataset with two tables related by an autoGen number in an Access mdb. I add one record to the first table (using -1 as my auto number), and two child records to the second table. I update the first table, use the RowUpdated event to find out the real autogen number and populate record with this number. I then try to update the second table, but the new rows have rowstates of unchanged. They were set to 'added' but I'm assuming the UPDATE has called AcceptChanges for the dataset, not the datatable! Please Help! Dim con As New OleDbConnection("Data Source='D:\Documents and Settings\Administrator\My Documents\NET\New Stuff\PlayGroup\Playgroup Database\Playgroup.mdb';Provider='Microsoft.Jet.OLEDB.4.0'") Dim ds As New SF.Children.Detail Dim drChild As SF.Children.Detail.tblChildrenRow Dim drCS As SF.Children.Detail.tblChildSessionRow 'one child record drChild = ds.tblChildren.NewtblChildrenRow() drChild.ChildID = -1 drChild.Surname = "fred" drChild.FirstName = "pip" drChild.MainCarerID = 1 ds.tblChildren.Rows.Add(drChild) 'add two session records drCS = ds.tblChildSession.NewtblChildSessionRow drCS.ChildID = drChild.ChildID drCS.SessionId = 1 ds.tblChildSession.Rows.Add(drCS) drCS = ds.tblChildSession.NewtblChildSessionRow drCS.ChildID = drChild.ChildID drCS.SessionId = 2 ds.tblChildSession.Rows.Add(drCS) Dim _Adapter As New OleDbDataAdapter Dim _InsertCommand = New OleDbCommand With _InsertCommand .commandtype = CommandType.Text .commandtext = "INSERT INTO tblChildren (Surname, FirstName,MainCarerid ) VALUES (?,?,?)" .Parameters.Add(New OleDbParameter("Surname", OleDbType.VarWChar, 30, "Surname")) .Parameters.Add(New OleDbParameter("FirstName", OleDbType.VarWChar, 30, "FirstName")) .Parameters.Add(New OleDbParameter("MainCarerID", OleDbType.Integer)) .PARAMETERS("MainCarerID").SOURCECOLUMN = "MainCarerID" .connection = con End With 'Update ds with ChildID autonumber AddHandler _Adapter.RowUpdated, AddressOf Me.ChildUpdated _Adapter.InsertCommand = _InsertCommand _Adapter.Update(ds.tblChildren) Dim _AdapterS As New OleDbDataAdapter Dim _InsertCommands = New OleDbCommand With _InsertCommands .commandtype = CommandType.Text .commandtext = "INSERT INTO tblChildSession (ChildId, SessionId ) VALUES (?,?)" .Parameters.Add(New OleDbParameter("ChildID", OleDbType.Integer)) .PARAMETERS("ChildID").SOURCECOLUMN = "ChildID" .Parameters.Add(New OleDbParameter("SessionID", OleDbType.Integer)) .PARAMETERS("SessionID").SOURCECOLUMN = "SessionID" .connection = con End With _AdapterS.InsertCommand = _InsertCommands _AdapterS.Update(ds.tblChildSession) Tag: SPs, sqlCommand and Terminal Services Tag: 106399
  - 25
    - Ignore SQL Server errors? Hi, I am executing a SQL Server SP to get a DataSet through SqlDataAdapter.Fill. The problem I have is that sometimes the SP will throw a divide by zero error which causes a SqlException, even though the error is handled in the SP. Is there anyway of stopping this error being thrown, as the SP will return the correct data after the divide by zero error has occured? I have tried setting ContinueUpdateOnError = True but this does not seem to do anything. Thanks, Steve Tag: SPs, sqlCommand and Terminal Services Tag: 106396

Hi all,

I just ran into something very, very strange..

I have this application which fires of a series of SQL
Scripts using the sqlCommand Object. One of the
statements executes the
procedure "sp_addMergePublication" on the server. If I do
this on a local machine, everything works fine. But if I
run my application on a server using Terminal Services
then the application will Halt on that statement saying
that "A severe error has occured." and that any changes
should be discharged.
Note. This happens ONLY when I run the application remote
and it is not an error bound to a specific machine. I can
recreate the problem on any given server.

Has anyone ever had this problem, or perhaps even knows
why this happens?

B

Top

SPs, sqlCommand and Terminal Services by Elton

Elton
Wed Mar 09 18:49:34 CST 2005

Hi Benny,

.NET application has strong security limitation. So if you
run it from Terminal Services, it's likely to be
restricted.

HTH

Elton Wang
elton_wang@hotmail.com

>-----Original Message-----
>Hi all,
>
>I just ran into something very, very strange..
>
>I have this application which fires of a series of SQL
>Scripts using the sqlCommand Object. One of the
>statements executes the
>procedure "sp_addMergePublication" on the server. If I do
>this on a local machine, everything works fine. But if I
>run my application on a server using Terminal Services
>then the application will Halt on that statement saying
>that "A severe error has occured." and that any changes
>should be discharged.
>Note. This happens ONLY when I run the application remote
>and it is not an error bound to a specific machine. I can
>recreate the problem on any given server.
>
>Has anyone ever had this problem, or perhaps even knows
>why this happens?
>
>B
>.
>

Top