Problem using OLEDB connector

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
 - Correct SP:s not executing I often use ADO.NET and SP:s, but now I'm stuck after spending all yesterday on two issues 1) ARITHABORT A form calls SP to insert a record, but executing it only results in the following message :"Insert failed becase the following SET options have incorrect settings 'ARITHABORT'". I've checked the SQL Server documentation and can't see how it at all applies in this case. Tracing the command in SQL Profiler this is what it looks like exec insertReportPeriodExchangeRates @FromCurrencyID = N'GBP', @ToCurrencyID = N'USD', @ExchangeRate = 1.600000, @ReportPeriodID = N'2004Q3', @ReportPeriodExchangeRateID = @P1 output, @TimeStamp = @P2 output If I execute that command from SQL Analyzer it works just fine. No error message 2) .SP does not execute at all Another form calls a SP to delete a record, but the SP is never executed! How is that possible? Tracing the command in SQL Profiler this is what it looks like exec deleteReportPeriods @Original_ReportPeriodID = N'2003Q5', @Timestamp = 0x00000000000083C1 If I execute that command from SQL Analyzer it works just fine. All in all about 200 SP:s are called in the application, and these are the only one that failing. Again, if I run them from SQL Analyzer they execute correctly, so there is something odd happing in ADO:NET. All the commands are executed from inherited forms. Any ideas where to look? Kind regards, Kenneth Bohman Tag: Problem using OLEDB connector Tag: 76442
 - 2
 - Concurrency violation: the DeleteCommand affected 0 records ----------------------------------------------------------------- The PK in the oledbdeletecommand.parameters collection *appears* to have the appropriate Primary Key to look for to delete, so I'm not sure why it's not able to find the record to delete... After reloading the master form, the datarow deletes and the dataadapter.update(me.ds) goes just fine. ----------------------------------------------------------------- I have two forms in a master/detail relationship, with the master form's dataset shared with the detail form. I use the form's currencymanagers to synch the detail record, add a new row, etc. The database is Access, using the Jet driver. After creating a new record with "cm.AddNew()" in the detail form, the following gives me the "affected 0 records" error: 1. update the database with the dataadapter via "masterForm.da.update(masterForm.ds)" 2. use "@@Identity" to get the database's primary key just generated on this database connection for my new row, and alter our dataset row's PK field to conform with database by using "drCm.Item("PK") = newPK" 3. call cm.EndCurrentEdit() & drCm.acceptChanges() to set the row's state from "Modified" to "Unchanged". 4. back in the master form, delete the new record via "dr.Delete()" ////////////////// This throws the Exception ////////////////// 5. attempt to synch the datarow delete w/ the database by using the dataadapter via: "me.da.update(me.ds)" Here are some code snippets: mngUsers.vb ------------------------------------- Private cmEmployees As CurrencyManager Private Sub mngUsers_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.cmEmployees = CType(Me.BindingContext(Me.DsUsers1.Employees), CurrencyManager) '// some code snipped from here End Sub Private Sub btnNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNew.Click Dim myUser As New mngUsersNewEdit(mngUsersNewEdit.formAction.newUser) Me.AddOwnedForm(myUser) myUser.Show() End Sub Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim drCm As DataRow drCm = CType(Me.cmEmployees.Current, DataRowView).Row Try drCm.Delete() Me.OleDbDataAdapter1_Users.Update(Me.DsUsers1.Employees) Catch ex As Exception MessageBox.Show(ex.Message + vbCrLf + vbCrLf + ex.StackTrace) End Try End Sub mngUsersNewEdit.vb ----------------------------------- Private m_actionToTake As formAction Private m_parent As mngUsers Private cmEmployees As CurrencyManager Private cmOwner As CurrencyManager Private Sub mngUsersNewEdit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.m_parent = Me.Owner Me.cmEmployees = CType(Me.BindingContext(Me.m_parent.DsUsers1.Employees), CurrencyManager) '// If appropriate, Synchronize our Form to the record currently selected in parent form If m_actionToTake = formAction.editUser Then '// set a currency manager for the owner form to find Form1's current record position cmOwner = CType(CType(Me.Owner, masterdetailDeleteTest.mngUsers).BindingContext(Me.m_parent.DsUsers1.Employe es), CurrencyManager) '// synchronize the table record positions between form1 and form2 Me.cmEmployees.Position = Me.cmOwner.Position Else '// create a new itemOption cmEmployees.AddNew() '// set up default data so avoid DBnull conflicts '// casting the currency manager and accessing it's 'row' object allows us to access an item by column name. Dim drNew As DataRow = CType(cmEmployees.Current, DataRowView).Row drNew.Item("IsActive") = True drNew.Item("Birthdate") = "1/1/1970" End If '// Set our databindings Me.tbEmployeeID.DataBindings.Add("text", Me.m_parent.DsUsers1.Employees, "EmployeeID") Me.tbFirstName.DataBindings.Add("text", Me.m_parent.DsUsers1.Employees, "FirstName") '// etc. w/ the databinding End Sub Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click Me.cmEmployees.EndCurrentEdit() Try Me.m_parent.OleDbDataAdapter1_Users.Update(Me.m_parent.DsUsers1) If Me.m_actionToTake = formAction.newUser Then '// To avoid having the autogenerated primary key in dataset out of synch with database, '// retrieve the newly created database PK and update our dataset's PK with it. '// Include a variable and a command to retrieve the autogenerated primary key value '// (identity value) from the Access database. '// cf. ms-help://MS.VSCC/MS.MSDNVS/cpguide/html/cpconretrievingidentityorautonumber values.htm Dim newID As Integer = 0 Dim idCMD As OleDbCommand = New OleDbCommand("SELECT @@IDENTITY", Me.m_parent.OleDbConnection1) '// Retrieve the identity value. newID = CInt(idCMD.ExecuteScalar()) '// Assign retrieved autonumber to our new row's primary key. Dim drCm As DataRow = CType(Me.cmEmployees.Current, DataRowView).Row '// datarow to inspect our current row drCm.Item("EmployeeID") = newID '// push DB's new PK to row's "Current", "Original", and "Default" values '// Roll our PK value change into the row's "original version." '// The deleteCommand uses the original row PK values to do the deletion, '// which may be out of synch with the database. If so, the dataset would throw an '// exception when the database (looking for the wrong PK) could still not find the row to delete. cmEmployees.EndCurrentEdit() '// allow this row's changes to remain drCm.AcceptChanges() '// set row's state from "Modified" to "Unchanged" to prevent unneccessary labor End If Catch ex As Exception MessageBox.Show(ex.Message + vbcrlf + vbcrlf + ex.StackTrace) End Try Me.Owner.Focus() Me.Close() End Sub Tag: Problem using OLEDB connector Tag: 76440
 - 3
 - How to create dataview from two datatables Hi is there any way to create a dataview from two different datatables. My purpose is to display a datagrid. some columns from one table and some other columns from other table. i am using commandbuilder for automatic query. so i am not able to join query from datasource. Thanks in advance. Regards H. Mahadevan Tag: Problem using OLEDB connector Tag: 76436
 - 4
 - Select a Row in A DATAGRID Hai All, I have a Datagrid in a help Screen. How I can select more than one row (HIGHLIGHTS). Help me to get the selected rows from that datagrid. I am awiting for your earlier valuable reply. Thanks in Advance, Regards, Karnan.S Tag: Problem using OLEDB connector Tag: 76434
 - 5
 - how to do transaction hiye, is there a nice sql script example out there which shows how t-sql transaction is done? Tag: Problem using OLEDB connector Tag: 76432
 - 6
 - how to return stored procedure error? hiye, does anyone know how to return a stored procedure error to vb.net? any or all error capture in stored procedure i want em to be return to vb.net. thanks for the help.. Tag: Problem using OLEDB connector Tag: 76428
 - 7
 - "One or more accessor flags were invalid." -- VFPOLEDB I am trying to do a simple Asp.Net update using the same OleDb code that has worked for Access databases, and I get this error message when using a Visual Foxpro database: "One or more accessor flags were invalid." It retrieves data ok, but won't update it. Anyone know why? Thanks. Tag: Problem using OLEDB connector Tag: 76418
 - 8
 - Table Names with Spaces I wrote a program that inserts records into a table in a MS Access database. For some reason, it works only for tables without spaces in their names: There are four tables: "test 1" "test2" "test 3" and "test4" each with fields word, pos, and meaning. The following code works only for test2 and test4, the tables whose names do not contain any spaces. string tableName="test 1"; //place table name here OleDbConnection conn=new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=lists.mdb"); OleDbDataAdapter da=new OleDbDataAdapter("select * from ["+tableName+"]",conn); OleDbCommandBuilder cb=new OleDbCommandBuilder(da); DataSet ds=new DataSet(); da.Fill(ds); conn.Close(); DataTable dt=ds.Tables[0]; DataRow dr=dt.NewRow(); dr["word"]="myword"; dr["pos"]="mypos"; dr["meaning"]="mymeaning"; dt.Rows.Add(dr); try { da.Update(ds); } catch(OleDbException ole){Console.WriteLine(ole.Message);} Tag: Problem using OLEDB connector Tag: 76415
 - 9
 - OleDb versus (Sql,Oracle,Odbc etc..) Is there a peformance difference when using OleDB classes instead of SqlServer? Or are the differences mainly functional, for example SqlServer lets you perform more of its proprietry functions using it's classes. Any help appriciated! This question is the same for Oracle, Odbc and any other specific .NET provider... Thanks, Robby Tag: Problem using OLEDB connector Tag: 76410
 - 10
 - possible to step into a stored procedure Hi- when debugging, is it possiblt to step into a stored procedure? For example, if I have a method in my DAL class called AddProduct() and it makes a call to SqlCommand.ExecuteNonQuery() can I step into that sproc that it will be calling? I hope so, that would be the coolest! OK, if this is possible and you know how, please do share. Thanks, Steve Tag: Problem using OLEDB connector Tag: 76404
 - 11
 - Why aren't there any interfaces?? I'm working with DataSets in my code and cannot find a suitable Interface to reference. As a work-around, I've written an Interface (IDataSet) that defines all of the public method signatures of a DataSet class. A custom class (DataSetExt) implements that Interface and delegates public method calls to *base*. I know that in taking this approach I've left myself open to a slew of potential problems especially if the signatures of the DataSet class change. However, the System.Data.DataSet class has no primary interface....???? Any thoughts on this? thx Tag: Problem using OLEDB connector Tag: 76399
 - 12
 - SqlParameter SqlDBType.text size What is the correct way to address the size of a SqlDBType.text field in a SqlParameter The Data Adapter configuration wizard does this cmdUpdate.Parameters.Add("@myvar", SqlDbType.Varchar, 2147483647) Is that right (I'm assuming so), but could I also do this? (using SqlDbType.Text) cmdUpdate.Parameters.Add("@myvar", SqlDbType.Text, 2147483647) or even this, as the size is defined in Sql server cmdUpdate.Parameters.Add("@other_accident_cause", SqlDbType.Text, 16) Little confused here.. :) --Michael Tag: Problem using OLEDB connector Tag: 76397
 - 13
 - Speeding up a Directory Search Process This is a multi-part message in MIME format. ------=_NextPart_000_00D6_01C3D46F.A23E0DE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I having trouble querying for users that have changed, when I have a = node that have over 750 users. It takes way to long over 1 hour, if it = does return users. How can I improve this? objADSDirEntry =3D New DirectoryEntry(sInADSADsPath, strADSUserName, = strADSPassword, AuthenticationTypes.ServerBind) ObjADSDirSearcher =3D New = DirectoryServices.DirectorySearcher(objADSDirEntry) Err.Clear() ObjADSDirSearcher.Filter =3D = "(&(|(objectClass=3Duser)(objectClass=3Dgroup)(objectClass=3Dcontact))(&(= uSNChanged>=3D" & LastMod & ")(uSNChanged<=3D" & NewLastMod & ")))" 'ObjADSDirSearcher.PageSize =3D 1000 ObjADSDirSearcher.ServerTimeLimit =3D TimeSpan.FromMinutes(3) For Each objSearchResult In ObjADSDirSearcher.FindAll objadsDirEntry2 =3D objSearchResult.GetDirectoryEntry Thanks Robert ------=_NextPart_000_00D6_01C3D46F.A23E0DE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1126" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> </DIV> <DIV>I having trouble querying for users = that have=20 changed, when I have a node that have over 750 users. It takes way to = long over=20 1 hour, if it does return users. How can I improve this?</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>objADSDirEntry =3D New = DirectoryEntry(sInADSADsPath,=20 strADSUserName, strADSPassword, = AuthenticationTypes.ServerBind)</DIV> <DIV>ObjADSDirSearcher =3D New=20 DirectoryServices.DirectorySearcher(objADSDirEntry)</DIV> <DIV>Err.Clear()</DIV> <DIV>ObjADSDirSearcher.Filter =3D=20 "(&(|(objectClass=3Duser)(objectClass=3Dgroup)(objectClass=3Dcontact)= )(&(uSNChanged>=3D"=20 & LastMod & ")(uSNChanged<=3D" & NewLastMod &=20 ")))"</DIV> <DIV>'ObjADSDirSearcher.PageSize =3D = 1000</DIV> <DIV>ObjADSDirSearcher.ServerTimeLimit =3D=20 TimeSpan.FromMinutes(3)</DIV> <DIV>For Each objSearchResult In=20 ObjADSDirSearcher.FindAll</DIV> <DIV>objadsDirEntry2 =3D=20 objSearchResult.GetDirectoryEntry</DIV> <DIV> </DIV> <DIV> </DIV> <DIV>Thanks</DIV> <DIV> </DIV> <DIV>Robert </DIV></BODY></HTML> ------=_NextPart_000_00D6_01C3D46F.A23E0DE0-- Tag: Problem using OLEDB connector Tag: 76392
 - 14
 - ConnectionString: set ANSI NULL on/off I want to know if there is a way to specify ANSI NULL processing ON/OFF, based on a ConnectionString parameter. This will take care of processing "x = NULL" and "x IS NULL" kind of SQL expressions appropriately based on the ON/OFF setting. I expect to set this like: ConnectionString="Provider=...; ANSI_NULL=no"; OR ConnectionString="Provider=...; Extended Properties="ANSI_NULL=no;" This is for connecting to Sybase, using Ole DB classes. TIA Raj "Operator... Get me outa here." Tag: Problem using OLEDB connector Tag: 76385
 - 15
 - Oracle CLOB Support Does latest MDAC versions possibly could support Oracle CLOB datatype? Thanks, Leonid. Tag: Problem using OLEDB connector Tag: 76381
 - 16
 - DataGrid Help This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C3D45A.E2D57150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using Provider=3DMSIDXS.1 and following code to fill datagrid.=20 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As = System.EventArgs) Handles Button1.Click Dim strCatalog As String ' Catalog Name strCatalog =3D "TestCatalog" Dim strQuery As String If TextBox1.Text <> "" Then DataGrid1.Visible =3D True strQuery =3D "Select DocTitle,Filename,Size,PATH,URL from SCOPE() where = FREETEXT('" & TextBox1.Text & "')" Dim connString As String =3D "Provider=3DMSIDXS.1;Integrated Security = .=3D'';Data Source=3D'" & strCatalog & "'" Dim cn As New System.Data.OleDb.OleDbConnection(connString) Dim cmd As New System.Data.OleDb.OleDbDataAdapter(strQuery, cn) Dim testDataSet As New DataSet() cmd.Fill(testDataSet) Dim source As New DataView(testDataSet.Tables(0)) DataGrid1.DataSource =3D source DataGrid1.DataBind() Else DataGrid1.Visible =3D False End If End Sub End Class The result I am getting in datagrid is in plain text How do I make datagrid to show url in clickable format? Or how can I make datagrid item in hyperlink format? ------=_NextPart_000_0008_01C3D45A.E2D57150 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV>I am using Provider=3DMSIDXS.1 and following = code to fill=20 datagrid. </DIV> <DIV> </DIV> <DIV> Private = <FONT=20 color=3D#0000ff size=3D2>Sub = Button1_Click(<FONT=20 color=3D#0000ff size=3D2>ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim = strCatalog=20 As = <FONT=20 color=3D#0000ff size=3D2>String ' Catalog Name strCatalog =3D "TestCatalog" Dim = strQuery=20 As = <FONT=20 color=3D#0000ff size=3D2>String If = TextBox1.Text=20 <> "" Then DataGrid1.Visible =3D True<FONT=20 size=3D2> strQuery =3D "Select DocTitle,Filename,Size,PATH,URL from SCOPE() = where=20 FREETEXT('" & TextBox1.Text & "')" Dim = connString=20 As = <FONT=20 color=3D#0000ff size=3D2>String =3D = "Provider=3DMSIDXS.1;Integrated=20 Security .=3D'';Data Source=3D'" & strCatalog & "'" Dim cn = <FONT=20 color=3D#0000ff size=3D2>As New = System.Data.OleDb.OleDbConnection(connString) Dim cmd = <FONT=20 color=3D#0000ff size=3D2>As New = System.Data.OleDb.OleDbDataAdapter(strQuery,=20 cn) Dim = testDataSet=20 As = <FONT=20 color=3D#0000ff size=3D2>New DataSet() cmd.Fill(testDataSet) Dim source As New<FONT=20 size=3D2> DataView(testDataSet.Tables(0)) DataGrid1.DataSource =3D source DataGrid1.DataBind() Else DataGrid1.Visible =3D False<FONT=20 size=3D2> End = <FONT=20 color=3D#0000ff size=3D2>If End = <FONT=20 color=3D#0000ff size=3D2>Sub End Class   The = result I am getting=20 in datagrid is in plain text</DIV> <DIV>How do I make datagrid to = show url in=20 clickable format?</DIV> <DIV>Or how can I make datagrid item = in hyperlink=20 format?</DIV></BODY></HTML> ------=_NextPart_000_0008_01C3D45A.E2D57150-- Tag: Problem using OLEDB connector Tag: 76379
 - 17
 - Getting a RecorSet returned by a SP Please, how can i get and read a RecordSet returned by a SQL SERVER stored procedure? Tks in adv. Fabiano Tag: Problem using OLEDB connector Tag: 76377
 - 18
 - Navigation in DataGrid Hallo I have a DataGrid that shows records from my database and allow the user to navigate to the children records (i.e. press on the + sign and then on the DataRelation name to navigate to the corrosponding rows) Anyway the DataRelation names are not very user-friendly. My client expects something more discriptive than "credit2details". How can I change only these tabs without to change all the DataRelation throughout the whole project thanks in advance Tag: Problem using OLEDB connector Tag: 76373
 - 19
 - .Tif Pictures I got some .tif pictures that I used in ACCESS. I am trying to use these pictures in VB.NET. Do I have to switch these pictures format over to something else or is there a way I can use them? Tag: Problem using OLEDB connector Tag: 76365
 - 20
 - Abstracting field names in strongly-typed datasets? I'm working with a table that has poorly-named fields which I cannot change: dptnum dptname I'm creating a strongly-typed DataSet to work with the data in this table, and I would much rather that my DataSet have fieldnames of: DepartmentNumber DepartmentName Is there some way to accomplish this without modifying the original table? some sort of "alias" that I can add to the elements in the XSD? I considered using a Sql Server view to accomplish this, but views do not have primary keys, and so the DataSet would have problems with Update commands. I look forward to your suggestions. Thanks! Tag: Problem using OLEDB connector Tag: 76362
 - 21
 - Updating and Access table with more than 127 columns Due to an existing limitation of Access, you cannot issue an UPDATE query with more than 127 fields (Access has a limit of 255 fields and during an update query, both the column your are updating and the value your are inserting are treated as fields, which therefore limits you to having 127 columns in your query). ADO didn't have a problem with this if you used a connected recordset (I'm assuming because it uses cursors or something). Since updates are submitted via UPDATE queries in ADO.NET this becomes an issue. Making the table have less than 127 columns is not an option as there are existing implmentations of the database (using old clients that used VB and ADO that worked...). Only updating the 'changed' fields does not solve the problem as the problem still exists when you change more thant 127 fields... There are issues with splitting the UPDATE into 127 field chucks if some of the fields more then one chunk are marked as 'required'. My question is, is there any way to deal with this issue in ADO.NET? I don't want to have to resort to using interop and old ADO recordsets but it appears to me like this is the only way to deal with this issue in a generic way. Thanks Wayne Tag: Problem using OLEDB connector Tag: 76355
 - 22
 - Configuration File Hello, I was wondering where I might find a "sample" application configuration file for a windows applications. What should the file be named.... ApplicationName.config ? I am have created web applications and the system automatically generates a "template" configuration file. Can the system generate a template file for windows applications? In a web application I use the method ConfigurationSettings.AppSettings ("ConnectStr") to obtain my configuration settings. Will I still be able to use the same method? Thanks in advance for your assistance!!!!!!!! Tag: Problem using OLEDB connector Tag: 76353
 - 23
 - IDataReader - cannot read I have a method in my datalayer that returns IDataReader. When I call this method it returns the datareader but when I try to read it , gives me following error: any idea ? thanks in advance ------------------ Error description: ------------------ An unhandled exception of type 'System.Runtime.Remoting.RemotingException' occurred in mscorlib.dll Additional information: This remoting proxy has no channel sink which means either the server has no registered server channels that are listening, or this application has no suitable client channel to talk to the server. Tag: Problem using OLEDB connector Tag: 76351
 - 24
 - HELP serious performance degradation compared to QA I have a stored procedure that takes 4 seconds to execute (returning 3840 rows) from Query Analyser, yet when I fill it using the following (assume the variable SQL is the stored procedure) Dim cmd As SqlCommand Dim ds As New DataSet Dim sa As SqlDataAdapter cmd = New SqlCommand(SQL, cn) sa = New SqlDataAdapter(cmd) sa.Fill(ds) it times out or takes much, much longer than 4 seconds - on the order of a minute. This delay has a lot of corresponding server processor activity but absolutely none for the client. I've read some previous posts about timeout issues, but none of them explain this performnace degradation. All I want is the data, and no extra overhead. Is there any way in .Net I can get the *same* performance that I get from QA? The same problem happens in VB6 using recordsets - the 4 second query takes 62 seconds. I already looked at the DataSetSurrogate and it performance is worse. http://support.microsoft.com/?id=829740 DataReader shows the same behavior/problem, only it times out at 30 seconds and reports "system error". Someone please help. TIA, Bob Tag: Problem using OLEDB connector Tag: 76350
 - 25
 - Fill a DataTable in a Class from another Class Hi, I need to fill a dataset in a form and automatically take affect in other form. For example: I have a DataGrid attached to a DataTable in Form1 and I'm adding a record in the same DataTable, but this time from Form2 and it doesn't take effect in form1. Please help me Tag: Problem using OLEDB connector Tag: 76348
- Next
 - 1
 - Pros and Cons of MS Data Access Application Block? Is the Microsoft Data Access Application Block worth using? I'm new to it and would like to get the opinions of some seasoned veterans. I'm not sure it if will really save me very much time or effort. Thanks -- Dave Veeneman Chicago Tag: Problem using OLEDB connector Tag: 76345
 - 2
 - Performance Monitor Connection Pools I have done some reading and figured that i can determine the number of connections in my data pool. i.e. http://techrepublic.com.com/5100-6329_11-5034285- 2.html My question relates to performance monitor. While adding the counters to performance monitor there is a selection box for "Instance". I see a couple of my applications in this instance box however, i do not see the web application that I would like to measure. I see a number of w3svc/xx/xxx instances. How do i determine which w3svc instance is the one i need to track? I also have read that I should take the results with a grain of salt. That is fine. Any help is greatly appreciated. dave Tag: Problem using OLEDB connector Tag: 76344
 - 3
 - Browsing records from a specific location Hi, I've created a Data Form with the Wizard (Under VB.net and MS Access) I can browse the records with the buttons( movefirst, movelast,move previous,...). If I want to move to a specific location like where costumersID=5 for example, and then continuing browsing the records with the buttons from that position. How can it be done? Thanks in advance, Luis Mendes Tag: Problem using OLEDB connector Tag: 76343
 - 4
 - Gotcha Just so you know scorp I am downloadeding it and am going to try it out. I hope you did better on this one than the last thing you published!! I am sure you learned your lesson this time.... (ROFLMAO) Glad to see you came back...... I knew you would if I went away :) Did the rest of the group miss me? (ROFLMAO!!!!!) >-----Original Message----- >This morning I let the group know that I had finished an application that >categorizes posts in the vb.net and ado.net newsgroups and eliminates the >trash that we hate to wade through on sites like Google and such. > >Well I would like to thank the multitude of you that have emailed me >informing me of the bug in the datagrid (the scrollbars don't show up unless >you resize the form after populating the grid). > >I knew you would be a tough audience but geez :) > >Actually I appreciate you letting me know. It is the inital release of this >so I expected things like this. > >The bug is now fixed. The corrected version is 1.06. It should automatically >remove your previous version but may not because the installer can be buggy. > >You can download the fixed version at >http://www.kjmsolutions.com/newsgrouptool.htm > > > > > >. > Tag: Problem using OLEDB connector Tag: 76341
 - 5
 - ASP.NET Automatic vs. Manual ado.net objects Hello, I'm hoping someone here can help me out with this. I'm programming with asp.net within the VS.NET IDE. I've found two different ways to handle data access, I can program my own ado.net components, or drag and drop from the toolbox connections, adapters, datasets, etc. to the design view of the web form. I like the drag and drop features, but would like to know more about it, I kind of just stumbled on it, and never really found a good document explaining it. Does anyone out there have experience with this, and could offer any insight. Any showstoppers someone has run into from using the automatic stuff versus do-it-yourself. In the long term what will be the best option? Thanks for any help! --Michael Tag: Problem using OLEDB connector Tag: 76335
 - 6
 - Row Cell Hello, Coming from VB, accessing cells is a little different in C#. If I have a datatable, I see the ItemArray propery, which gives you an array of the items in a row (right?), but it does not allow you to access the individual cell. Do I have to get the ItemArray and access the individual cell from that, or is there another way. In VB there was the "item" property. dt.rows[myRow].item[2] = "Fred" If I have a Datarow is there a property that tells me the index of that row in a DataTable? Likewise, if I have a DataRowView Row, is there a property which tells me the index of that row? Thanks in advance for your assistance!!!! Tag: Problem using OLEDB connector Tag: 76329
 - 7
 - Lock HI, I am getting a Connection Time Out Error While executing the follwoing code Transaction isolation Level is "Read Commited" String sConnectStr = "User ID=sa;Password=sa;Database=DAL;Server=."; SqlConnection objConnection = new SqlConnection(sConnectStr); objConnection.Open(); SqlTransaction objTran = objConnection.BeginTransaction(); SqlCommand objCommand = new SqlCommand(); objCommand.Connection = objConnection; objCommand.CommandText = "INSERT INTO Patient (Name, OId) VALUES (@Name, @OId)"; SqlParameter objParam1 = objCommand.CreateParameter(); objParam1.DbType = DbType.String; objParam1.Value = "Test ST"; objParam1.ParameterName = "@Name"; objCommand.Parameters.Add(objParam1); SqlParameter objParam2 = objCommand.CreateParameter(); objParam2.DbType = DbType.String; objParam2.Value = "f6a07441-c3e2-4aaa-8913-cfbab8df395b"; objParam2.ParameterName = "@OId"; objCommand.Parameters.Add(objParam2); objCommand.Transaction = objTran; MessageBox.Show(objCommand.ExecuteNonQuery().ToString()); SqlConnection objConnection1 = new SqlConnection(sConnectStr); objConnection1.Open(); SqlCommand objCommand1 = new SqlCommand(); objCommand1.Connection = objConnection1; objCommand1.CommandText = "select count(*) from Patient"; SqlDataReader objReader = objCommand1.ExecuteReader(); objTran.Commit(); How to over come this?? Thanks in advance Regards, karthikeyan. G Tag: Problem using OLEDB connector Tag: 76314
 - 8
 - optimistic concurrency In the .NET Data Access Architecture Guide, under Performing Database Updates with DataSets | Managing Concurrency, it says there are four main approaches to manage optimistic concurrency when updating through a DataSet: 1. Including only the primary key columns 2. Including all columns in the WHERE clause 3. Including unique key columns and the timestamp columns 4. Including unique key columns and the modified columns Then it goes on to say that 1, 2, and 4 are not recommended -- even though 2 is the default behavior of the Data Adapter Configuration Wizard, and 3 is NOT supported by the Data Adapter Configuration Wizard. I think "ironic" is the applicable word here. What is a good way to implement optimistic concurrency, then? Is everyone putting a timestamp column in the tables, and leaving the Data Adapter Configuration Wizard to RAD hackers? ;-) Brad Williams Tag: Problem using OLEDB connector Tag: 76306
 - 9
 - SQLDataAdapter SP Generation Hi, I have created an SQLDataAdapter component on my vb.net winform project and stepped through the wizard. In my SQL Database I have a table with fields using user defined data types and not the base data types. The problem is that when the stored procedure gets created by the adapter the parameter's data types did not follow the data type of the table I used in the wizard. Is there any solution on how I could use my user defined data types in my SP, autogenerated by the adapter, w/o actually modifying the SP after running the wizard? Appreciate any help. Thanks. Ramil Domingo Developer Tag: Problem using OLEDB connector Tag: 76304
 - 10
 - Unspecified error when performing operations on OLE DB data adapters I have 7 data adapters connected to MS Access tables. When I try to 1) Preview Data or 2) Generate DataSet or 3) look at the Mapping collection in the DA Properties I get "Unspecified Error". Plus one of the data adaptors generates a bad Update statement that throws an error message when I try to update after a dataset Merge. None of the other adapters throw an Update error. I have tried reconfiguring, recreating and virtually every property parameter without luck. I have recreated the MS Access table from which the bad Update command is created. I have deleted the entire form containing the data adapters and started over again with the same result. Any thoughts? Best regards, Drew Yallop Tag: Problem using OLEDB connector Tag: 76286
 - 11
 - help with simple ado code Hey all, hoping you can help with this odd problem...hopefully I am just doing something really stupid. I have a small access database with a bunch of text fields, and I want to insert a row, using the following code: OleDbConnection conn = new OleDbConnection( @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\moneymakin.mdb"); String stmt = "INSERT INTO Person (FirstName, LastName, Email, LoginID, Password) VALUES (" + "'" + this.m_perFirstName + "', '" + this.m_perLastName + "', '" + this.m_emailAddress + "', '" + this.m_loginID + "', '" + this.m_password + "')"; MessageBox.Show(stmt); //conn.Open(); OleDbCommand perCommand = new OleDbCommand(stmt, conn); perCommand.Connection.Open(); perCommand.ExecuteNonQuery(); //OleDbDataReader perReader = perCommand.ExecuteNonQuery(); //perReader.Close(); conn.Close(); I get the following error msg when I run this update: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at WindowsSample.Person.saveNewData() in c:\Documents and Settings\Kirk Gray\My Documents\Borland Studio Projects\WindowsSample\DataItems\Person.cs:line 192 at WindowsSample.PersonalInfo.btnPersonalSave_Click(Object sender, EventArgs e) in c:\Documents and Settings\Kirk Gray\My Documents\Borland Studio Projects\WindowsSample\Forms\PersonalInfo.cs:line 326 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) I have no clue what the problem could be, but I know that when I only use firstname, lastname, and emailaddress, the query works fine. What could the problem be? ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: Problem using OLEDB connector Tag: 76285
 - 12
 - Row Number If I have a Row from a dataTable, how do I get the row number of the row? Thanks in advance for your assistance!!!!! Tag: Problem using OLEDB connector Tag: 76282
 - 13
 - Access Insert Error I am trying to run the following insert into an Access DB. For some reason I continually get a Syntax error in INSERT INTO statement. I have been looking at it way too long. There has got to be something relatively obvious that I am missing. Any suggestions would be greatly appreciated. conDb = New OleDbConnection( strConString ) 'Set up insert statement for order header strSql = "Insert Orders (UserID, FirstName, LastName, billStreet, billCity, billState, billZip, " & _ "shipStreet, shipCity, shipState, shipZip) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" cmdSql = New OleDbCommand( strSql, conDb ) cmdSql.Parameters.Add( "@userID", OleDbType.Guid).Value = guidUserID cmdSql.Parameters.Add( "@firstname", OleDbType.VarWChar).Value = txtfirstname.Text cmdSql.Parameters.Add( "@lastname", OleDbType.VarWChar).Value = txtlastname.Text cmdSql.Parameters.Add( "@billStreet", OleDbType.VarWChar).Value = ctrlBillingAddress.Street cmdSql.Parameters.Add( "@billCity", OleDbType.VarWChar).Value = ctrlBillingAddress.City cmdSql.Parameters.Add( "@billState", OleDbType.VarWChar).Value = ctrlBillingAddress.State cmdSql.Parameters.Add( "@billZip", OleDbType.VarWChar).Value = ctrlBillingAddress.Zip cmdSql.Parameters.Add( "@shipStreet", OleDbType.VarWChar).Value = ctrlShippingAddress.Street cmdSql.Parameters.Add( "@shipCity", OleDbType.VarWChar).Value = ctrlShippingAddress.City cmdSql.Parameters.Add( "@shipState", OleDbType.VarWChar).Value = ctrlShippingAddress.State cmdSql.Parameters.Add( "@shipZip", OleDbType.VarWChar).Value = ctrlShippingAddress.Zip conDb.Open() cmdSql.ExecuteNonQuery() The stack trace is as follows: [OleDbException (0x80040e14): Syntax error in INSERT INTO statement.] System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41 System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +174 System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92 System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65 System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112 System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +66 Thanks, J. Clay Tag: Problem using OLEDB connector Tag: 76278
 - 14
 - Viewing SQL Server system procedures? Does MSDE include SQL Server's system procedures? If so, can I view/execute them from the Server Explorer in VS.Net? If so, how? Thanks -- Dave Veeneman Chicago Tag: Problem using OLEDB connector Tag: 76277
 - 15
 - DataReader efficiency I noticed that the datareader has a way to reference returned fields by index or name. Is using the name parameter very inefficient? It seems that if the stored procedure is modified to have the fields in a different order, then using the name as an index would avoid problems. What are other peoples thoughts and experiences on this? Thank you, Ken Tag: Problem using OLEDB connector Tag: 76275
 - 16
 - DB data into a custom list... Hi, As I've decided to use my own custom collections to get data from my DB backend, to a web service, and then to my client frontend, I was wondering if there is a way to directly fill the objects of my collection without first having to load into a DataSet. Could I override the SqlDataAdapter.Fill method so instead of dbAdapter.Fill(dataSet, "site"), I have dbAdapter.Fill(myList, "site"), and then the Fill would simply map the fields of each row onto the object fields followed by adding them to the list? What about SqlDataReader, does that give me any more options? Is this a reasonable idea, or should I get my coat? Thanks in advance Colin B Tag: Problem using OLEDB connector Tag: 76274
 - 17
 - Inserting dates into SQL Server DB I'm running the following code in a C#.NET page and it doesn't enter the values into the DB. I'm certain the problem is to do with the txtBirth field. It allows users to enter a DOB as dd/mm/yyyy and I think it's the slashes(/) that are causing the problem. If I don't enter a DOB in this field then all the data enters into the database without a problem. Any ideas? SQL Server 2000, VS.NET, C# if (Page.IsValid) { // Save the new user to the database SqlConnection con; string sql; SqlCommand cmd; StringBuilder sb = new StringBuilder(); ArrayList values = new ArrayList(); sb.Append("INSERT INTO [User] "); sb.Append("(UserID, Login, Password, FirstName, LastName, "); sb.Append("PhoneNumber, Email, IsAdministrator, Address, "); sb.Append("CellNumber, DateOfBirth) "); sb.Append("VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', "); // Optional values without quotes as they can be null sb.Append("{8}, {9}, {10})"); // Add required values to replace values.Add(Guid.NewGuid().ToString()); values.Add(txtLogin.Text); values.Add(txtPwd.Text); values.Add(txtFName.Text); values.Add(txtLName.Text); values.Add(txtPhone.Text); values.Add(txtEmail.Text); values.Add(0); // Add the optional values or Null if (txtAddress.Text != string.Empty) values.Add("'" + txtAddress.Text + "'"); else values.Add("Null"); if (txtMobile.Text != string.Empty) values.Add("'" + txtMobile.Text + "'"); else values.Add("Null"); if (txtBirth.Text != string.Empty) values.Add("'" + txtBirth.Text + "'"); else values.Add("Null"); // Format the string with the array of values sql = String.Format(sb.ToString(), values.ToArray()); // Connect and execute the SQL con = new SqlConnection("data source=127.0.0.1;initial catalog=Friends; user id=sa;"); cmd = new SqlCommand(sql, con); con.Open(); bool doredirect=true; try { cmd.ExecuteNonQuery(); } catch { doredirect = false; this.lblMessage.Visible = true; //this.lblMessage.Text = "Insert couldn't be performed. Username may already be taken."; this.lblMessage.Text = sql; } finally { con.Close(); } if (doredirect) Response.Redirect("Login.aspx"); } else lblMessage.Text = "Fix the following errors and retry:"; } Tag: Problem using OLEDB connector Tag: 76267
 - 18
 - ADODB.Query Interface failed hello, I'm getting this Error when using a reference to ADODB.DLL Error#: 13 Error desc: QueryInterface for interface ADODB._Command failed can someone help me figure this out? thanks aj Tag: Problem using OLEDB connector Tag: 76255
 - 19
 - changing Dataset column order Hi, I am using a SP to fill a dataset and it has 5 columns and data in it. I want to reorder the columns to oldDs --> newDS col1 --> col2 col2 --> col3 col3 --> col1 col4 --> col4 Anybody has idea of how to do this in best possible way? A code snippet would be highly appreciated. Thanks in advance Bravo Tag: Problem using OLEDB connector Tag: 76254
 - 20
 - Grouping data at dataset level Hi, I have a SP and I am getting data in a dataset. The datatable in dataset is having 5 columns and out of 5 columns, data in 2 columns has composite unique value. Now I have to group the data based on these two column's value. Can anybody tell me how to do this?? I want to minimize the looping. A code sample would be highly appreciated. Thanks in advance Bravo Tag: Problem using OLEDB connector Tag: 76253
 - 21
 - Turning off connection pooling in VS.Net Server Explorer? Is there a way to turn off connection polling in VS.Net's Server Explorer? For debugging purposes, I'd like to create a connection with Pooling=False, but I don't see this option in the Data Link property pagers, and the connection string it creates is read-only in my version (Professional) of VS.Net. Can I turn pooling off in a Server Explorer Data Connections object? Thanks -- Dave Veeneman Chicago Tag: Problem using OLEDB connector Tag: 76250
 - 22
 - Primary column constrain programmatically How can I add Primary column constrainst on a DataTable Column in the program (C# or VB). Is the Unique property on DataColumn same as Primary cpnstraint. I need this because I need to Find() values in a DataColumn which is not a primary column in the DataSource. I want to make it a primary coulmn on the fly and search through it. What other option do I have to search through a column which is not a Primary column besides iterating through the DataRowCollection. thanks Aamir Tag: Problem using OLEDB connector Tag: 76246
 - 23
 - Auto-Create Parameters? Does anyone have any good tips for coding lots of input parameters? I was wondering if there any tool out there that will auto-generate parameters for me, so I could point it at a database table and it would create for me everything except the values I'd assign them. Thanks, --Michael Tag: Problem using OLEDB connector Tag: 76244
 - 24
 - (Search Tool) Alright Already I Fixed It :) This morning I let the group know that I had finished an application that categorizes posts in the vb.net and ado.net newsgroups and eliminates the trash that we hate to wade through on sites like Google and such. Well I would like to thank the multitude of you that have emailed me informing me of the bug in the datagrid (the scrollbars don't show up unless you resize the form after populating the grid). I knew you would be a tough audience but geez :) Actually I appreciate you letting me know. It is the inital release of this so I expected things like this. The bug is now fixed. The corrected version is 1.06. It should automatically remove your previous version but may not because the installer can be buggy. You can download the fixed version at http://www.kjmsolutions.com/newsgrouptool.htm Tag: Problem using OLEDB connector Tag: 76242
 - 25
 - Retricting database access. For debugging purposes I have a class that takes in a string and executes this supposed SQL string on a given SQL Server Engine. For obvious reasons I would like to lock down this class as tight as I can but I am finding the access permissions a little daunting and I would like to request some help. First, I would like to restrict the command generated by the SQL script to be read-only. I don't want it to modify the data in the database at all. I don't see a read-only mode for the database security. Second, I would like to restrict the SQL servers that this class can be run against. It seems like the KeyRestrictionBehavior is doing what I want but I need an example of how to use it with SqlClientPermissionAttribute. Any other tips would be much appreciated. Kevin rkevinburton@charter.net Tag: Problem using OLEDB connector Tag: 76240

Hi,
I am trying to insert data into an Excel sheet using Microsoft Jet OLE DB
4.0 driver. One of the fields is exceeding 255 characters. I get the error:

"The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data"

This is surely not a problem with Excel since I put in the data manually.
Please let me know if we have a solution/workaround for this.

Thanks,
Pranav.

Top

Re: Problem using OLEDB connector by Paul

Paul
Wed Jan 07 08:03:02 CST 2004

On Wed, 7 Jan 2004 14:09:52 +0530, "Pranav Nabar" <psnabar@msn.com> wrote:

¤ Hi,
¤ I am trying to insert data into an Excel sheet using Microsoft Jet OLE DB
¤ 4.0 driver. One of the fields is exceeding 255 characters. I get the error:
¤
¤ "The field is too small to accept the amount of data you attempted to add.
¤ Try inserting or pasting less data"
¤
¤ This is surely not a problem with Excel since I put in the data manually.
¤ Please let me know if we have a solution/workaround for this.

I believe you are encountering an issue with the Jet provider. See if the following helps:

PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow Error
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Top

Re: Problem using OLEDB connector by Pranav

Pranav
Wed Jan 07 21:59:42 CST 2004

Thanks Paul.

-pranav

"Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message
news:p74ovvgbh6ah9ospubebddv158v779835j@4ax.com...
> On Wed, 7 Jan 2004 14:09:52 +0530, "Pranav Nabar" <psnabar@msn.com> wrote:
>
> ¤ Hi,
> ¤ I am trying to insert data into an Excel sheet using Microsoft Jet OLE
DB
> ¤ 4.0 driver. One of the fields is exceeding 255 characters. I get the
error:
> ¤
> ¤ "The field is too small to accept the amount of data you attempted to
add.
> ¤ Try inserting or pasting less data"
> ¤
> ¤ This is surely not a problem with Excel since I put in the data
manually.
> ¤ Please let me know if we have a solution/workaround for this.
>
> I believe you are encountering an issue with the Jet provider. See if the
following helps:
>
> PRB: Transfer of Data from Jet 4.0LEDB Source Fails with Buffer Overflow
Error
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q281517
>
>
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Top