DB2 Connection

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
 - Nullvalued doubles in a strong typed dataset I have a strong typed dataset with some double values. In my database, from where I fill the dataset, I have numbers for these doubles, but they can also bee empty (NULL). I need this to know if the user has typed in 0 or hase typed in nothing. If I set the nullvalue for the doubles in my dataset to (NULL), I get an exception. How can I pass the System.DBNULL value from my database to my doubles? Thanks Thomas Tag: DB2 Connection Tag: 69545
 - 2
 - Validations inside datagrid Pleas advise me how to do validations in side datagrid before updating the details into database. I am using VB.NET and updating the datagrid using sqlcommandbuilder. I want to validate the data that user changhes inside the grid. How can I do this? Pls help... Regards, Omav Tag: DB2 Connection Tag: 69536
 - 3
 - ASP.NET using ADO.NET connection runtime error I created a simple ASP.NET using ADO.NET application to connect to SQL Server. However, it produces the following run-time error. I think ASPNET is the ASP.NET machine account created by VS.NET, and I already added ASPNET in IIS Manager in directory security tab, and disable the checkbox of anonymous access. Unfortunately, it still not able to solve the problem. Any good suggestions?? Thanks! Exception Details: System.Data.SqlClient.SqlException: User 'MYComputerName\ASPNET' Registered Failure. Source Error on line 37: Line 35: Dim cs As String = "Data Source=MyComputerName;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=autoattendant;Trusted_Connection=yes" Line 36: Dim cn As New SqlConnection(cs) Line 37: cn.Open() Line 38: Response.Write("string = " & cn.ConnectionString) Line 39: End Sub Source File: E:\web\WebApplication2\WebForm1.aspx.vb Line: 37 Stack Trace: [SqlException: User 'TRUSTGOD\ASPNET' Registered Failed] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec tionString options, Boolean& isInTransaction) System.Data.SqlClient.SqlConnection.Open() WebApplication2.WebForm1.Submit1_ServerClick(Object sender, EventArgs e) in E:\web\WebApplication2\WebForm1.aspx.vb:43 System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e) System.Web.UI.HtmlControls.HtmlInputButton.System.Web.UI.IPostBackEventHandl er.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain() Tag: DB2 Connection Tag: 69532
 - 4
 - NewRow method changes values in a reference to another row?! Using .NET Framework 1.1. I do a select for a row, assign a strongly typed var to reference/change the row thuought the rest of the code(OrigRow). After various responses from the user that change some column values of OrigRow, I begin a transaction and select(By PK) for the row again to bring it into the transaction. I use the strongly typed NewRow method of the datatable and assign it to another variable(NewRow) to add a new row based on some of the user responses. Right after the newrow method is executed, the column values of both OrigRow and NewRow change to the original db values of OrigRow!!!??? DA.Fill(DS.DT) 'select * OrigRow as DTRow = DT.rows(0) 'here, OrigRow.Qty = 10 .... do some work, OrigRow.Qty += 10 'proposed value = 20 ... 'now work is done, start a transaction... conn.open conn.BeginTransaction 'change cmd obj for PK DA.Fill(DS.DT) 'select where ID = OrigRow.ID, assigned to Txn 'In retrospect, shouldn't this reset values of OrigRow? Another thread! 'now create a new row for another reason NewRow as DTRow = DT.NewRow 'RIGHT HERE, OrigRow Values AND NewRow Values change to pre-work values of OrigRow!!!!???? e.g., OrigRow.Qty = 10 AND NewRow.Qty = 10, NOT NULL!!?? Anybody else see this or able to explain what I'm seeing, I'm going CRAZY! Thanks for any help, Dwaine Tag: DB2 Connection Tag: 69531
 - 5
 - Need help with data relations I need to establish a relationship that looks like this: One Payment can have many PaymentLine One PaymentLine can have one Payer One PaymentLine can have many PaymentLine Details The relationships that I create between Payment and PaymentLine work, and the one between PaymentLine and PaymentLine detail work. Whenever, I bind the dataset to a grid, it will never pick up the auto-identity for a payment and payer on a payment line. How can I make this work? Any help or insight would greatly be appreciated. Here is some of the code that I built into a winform testing application: Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.Button1 = New System.Windows.Forms.Button Me.DataGrid1 = New System.Windows.Forms.DataGrid CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point (16, 16) Me.Button1.Name = "Button1" Me.Button1.TabIndex = 0 Me.Button1.Text = "Button1" ' 'DataGrid1 ' Me.DataGrid1.DataMember = "" Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText Me.DataGrid1.Location = New System.Drawing.Point (24, 56) Me.DataGrid1.Name = "DataGrid1" Me.DataGrid1.Size = New System.Drawing.Size(680, 240) Me.DataGrid1.TabIndex = 1 ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(712, 318) Me.Controls.Add(Me.DataGrid1) Me.Controls.Add(Me.Button1) Me.Name = "Form1" Me.Text = "Form1" CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit() Me.ResumeLayout(False) End Sub #End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myPmtTable As New DataTable("Pmt") Dim myColumn As New DataColumn Dim ds As New DataSet myPmtTable.Columns.Add(AddColumn ("Pmt_id", "System.Int32", True)) 'Add table to dataset ds.Tables.Add(myPmtTable) Dim myPmtLnTable As New DataTable("PmtLn") myPmtLnTable.Columns.Add(AddColumn ("PmtLn_id", "System.Int32", True)) myPmtLnTable.Columns.Add(AddColumn ("Pmt_id", "System.Int32", False)) myPmtLnTable.Columns.Add(AddColumn ("Payer_id", "System.Int32", False)) 'Add table to dataset ds.Tables.Add(myPmtLnTable) Dim myPmtLnDetTable As New DataTable("PmtLnDet") myPmtLnDetTable.Columns.Add(AddColumn ("PmtLnDet_id", "System.Int32", True)) myPmtLnDetTable.Columns.Add(AddColumn ("PmtLn_id", "System.Int32", False)) myPmtLnDetTable.Columns.Add(AddColumn ("PmtLnDet_amount", "System.Double", False)) 'Add table to dataset ds.Tables.Add(myPmtLnDetTable) Dim myPayerTable As New DataTable("Payer") myPayerTable.Columns.Add(AddColumn ("Payer_id", "System.Int32", True)) myPayerTable.Columns.Add(AddColumn ("Payer_name", "System.String", False)) ds.Tables.Add(myPayerTable) 'Create another dataset, just to see what happens Dim myDatasetWithRelations As DataSet = BuildPaymentDataRelations(ds) DataGrid1.DataSource = myDatasetWithRelations End Sub Public Function AddColumn(ByVal ColumnName As String, ByVal DataType As String, ByVal autoIncrement As Boolean) As DataColumn Dim myColumn As New DataColumn myColumn.ColumnName = ColumnName myColumn.DataType = Type.GetType(DataType) myColumn.AutoIncrement = autoIncrement If autoIncrement Then myColumn.AutoIncrementSeed = -1 End If Return myColumn End Function Private Function BuildPaymentDataRelations(ByVal dataset As DataSet) As DataSet 'blnRelationsCreated = True Dim parentCol, childCol As DataColumn parentCol = dataset.Tables("Pmt").Columns ("pmt_id") childCol = dataset.Tables("PmtLn").Columns ("pmt_id") dataset.Relations.Add("Pmt_PmtLn", parentCol, childCol) parentCol = dataset.Tables("Payer").Columns ("payer_id") childCol = dataset.Tables("PmtLn").Columns ("payer_id") dataset.Relations.Add("Payer_PmtLn", parentCol, childCol) parentCol = dataset.Tables("PmtLn").Columns ("pmtln_id") childCol = dataset.Tables("PmtLnDet").Columns ("pmtln_id") dataset.Relations.Add("PmtLn_PmtLnDet", parentCol, childCol) Return dataset End Function End Class Tag: DB2 Connection Tag: 69530
 - 6
 - newB trigger question, hello I have 2 table and I want to create a trigger and when ever I add a row in parent table the row insert in child table with the same id. creating tables : create table parent ( table_id integer not null primary key, dummycol integer ) create table child( table_id integer not null, dummycol2 integer , foreign key (table_id ) references parent(table_id) ON DELETE CASCADE ON UPDATE CASCADE ) and the trigger Í tried but couldn't fix : create trigger copyrow on parent after insert as insert into child (table_id) values (parent.table_id) the error message says it accepts only variables and constants, then how can i assign the value to the row? thanks in advance Tag: DB2 Connection Tag: 69528
 - 7
 - Hepl! Can't update one data source from another using DA I'm trying to move a data set filled from an OLEDB data source into a SQL Server using the routine below. I get no errors, but when I look, there are no records in the SQL server table, "test". I know that there are records in the data set (ds.Tables(0).Rows.Count = 69) so why are the records not moved into the "test" table? Any help would be greatly appreciated. Dim cnSource As OleDbConnection Dim cnDest As SqlClient.SqlConnection Dim strSQL As String cnSource = New OleDbConnection("Provider=IBMDADB2.1;Password=123;User ID=USR;Data Source=DB2DB;Mode=Read;Extended Properties=''") cnSource.Open() Dim daSource As New OleDb.OleDbDataAdapter("SELECT DISTINCT DBSVR.TABLE1.SITE_CD FROM DBSVR.TABLE1", cnSource) Dim ds As DataSet = New DataSet() daSource.Fill(ds, "test") cnSource.Close() cnDest = New SqlClient.SqlConnection("Server=SQLSVR;database=test;UID=testUSR;PWD=123") Dim daDest As New SqlClient.SqlDataAdapter("SELECT * FROM test", cnDest) Dim cmB As SqlClient.SqlCommandBuilder = New SqlClient.SqlCommandBuilder(daDest) cnDest.Open() daDest.Update(ds, "test") cnDest.Close() Tag: DB2 Connection Tag: 69521
 - 8
 - Why can't open the second DataReader ? our C# program: SqlCommand cmd = new SqlCommand(); SqlCommand cmd2 = new SqlCommand(); cmd.Connection = this.sqlConnection1; cmd2.Connection = this.sqlConnection1; cmd.CommandText = "select * from table1"; dr = cmd.ExecuteReader(); while(dr.Read()) { cmd2.CommandText = "select * from table2 where myid=" + dr[0].ToString(); dr2 = cmd2.ExecuteReader(); ... ... ... ... the cmd.ExecuteReader() can open DataReader, but cmd2.ExecuteReader can't why? Tag: DB2 Connection Tag: 69511
 - 9
 - Selecting from DataGrid and passing to... Here's my situation. I have a data reader and datacommand (ASP.NET and SQL database). I have a search form which gives me the results in a data grid. Usually 2 or 3 results (persons) with various information (Name, Surname, Address...) What I want to do is to select a row in that datagrid (after I do the search and get results in a Datarid) and transfer the selected row to to next page and insert the selected data from that row in a text boxes. I need you to point me in the right direction on how to do that. Thanks. Tag: DB2 Connection Tag: 69508
 - 10
 - dataform wizard problems I've used the dataform wizard any number of times, and it works on all but one kind of microsoft access database. The style I use is text boxes for each column, with all the buttons. I just used the wizard on the customers table in the northwind.mdb that comes with office 11. Worked fine. Most importantly, when I clicked the add button, all the text boxes were cleared and and record count says 92 of 92 records(there are 91 records to start in the customers table). I created an mdb (access 2003) with one table from a larger database. It's called datetypes, and the table is called datetype. It has 5 columns. ID autoincrement integer DateType string 255 characters CreateDate Date default Now ChangeDate Date default Now Active Boolean default True All fields are required. When I run the form created by the dataform wizard on this table, the behavior is different. If I click Add, the text boxes(and checkbox for the boolean column) do not clear. Furthermore the recordcount (there are 9 records to start), says 1 of 10. If I press cancel, nothing happens, it still says 1 of 10. If I remove the faults, the same thing happens. If I remove required for all the columns except the ID autoincrementing key field, the same thing still happens. Furthermore, this happens with any of my tables in which the primarykey is an autoincrementing integer. Any ideas? Dennist Tag: DB2 Connection Tag: 69505
 - 11
 - Reading from DB2 and Writing to SQL Server I need to be able to query a DB2 database and append the results to a similarly structured table in SQL Server 2000. What would be the best method to achieve this? Could someone provide some specifics? Tag: DB2 Connection Tag: 69504
 - 12
 - Error in INSERT INTO statement When I run the simple code below I get the following error message: Type = System.Data.OleDb.OleDbException Message = Syntax error in INSERT INTO statement I've tweaked the insert to statement every which way. All the other ways create earlier error messages. I've compared this insert to statement to many I've seen in the book ado.net core reference, as well as other books. For the life of me I can't see what's wrong with it. Perhaps one of you can help me. Imports System.Data Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents btnBuild As System.Windows.Forms.Button <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.btnBuild = New System.Windows.Forms.Button Me.SuspendLayout() ' 'btnBuild ' Me.btnBuild.Location = New System.Drawing.Point (16, 24) Me.btnBuild.Name = "btnBuild" Me.btnBuild.Size = New System.Drawing.Size(72, 24) Me.btnBuild.TabIndex = 0 Me.btnBuild.Text = "Build" ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 266) Me.Controls.Add(Me.btnBuild) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False) End Sub #End Region Private Sub btnBuild_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBuild.Click Dim strConn, strSQL As String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;OLE DB Services=-4;Data Source=H:\HasbaraNET\ado.net tests\DateTypes.mdb;" Dim cn As New OleDbConnection(strConn) strSQL = "SELECT * FROM DateType ORDER BY DateType;" Dim da As New OleDbDataAdapter(strSQL, cn) Dim ds As New DataSet ds.DataSetName = "ds1" cn.Open() da.FillSchema(ds, SchemaType.Source, "DateType") 'cn.Close() ds.WriteXmlSchema("H:\HasbaraNET\ado.net tests\CodeUpdate\ds.xsd") Dim dsA As New ds1 da.Fill(dsA, dsA.Tables(0).TableName) Dim tblDateType As ds1.DateTypeDataTable = dsA.Tables(0) Dim rowDateType As ds1.DateTypeRow rowDateType = tblDateType.NewDateTypeRow rowDateType.DateType = "xxx" rowDateType.CreateDate = Now rowDateType.ChangeDate = Now rowDateType.Active = True rowDateType.ID = Integer.MaxValue tblDateType.AddDateTypeRow(rowDateType) da.InsertCommand = New OleDb.OleDbCommand("INSERT INTO datetype(ID,DateType,CreateDate,ChangeDate,Active) (?,?,?,?,?)", cn) 'INSERT INTO [Order Details] (OrderID, ProductID, Quantity, UnitPrice) VALUES (?, ?, ?, ?) 'Try ' da.InsertCommand.Parameters.Add("@ID", OleDb.OleDbType.Integer,4, "ID") 'Catch er As Exception ' MessageBox.Show("Type = " & er.GetType.ToString & vbCr & "Message = " & er.Message) 'End Try da.InsertCommand.Parameters.Add("@DateType", OleDb.OleDbType.VarChar, 255, "DateType") da.InsertCommand.Parameters.Add("@CreateDate", OleDb.OleDbType.Date, 8, "CreateDate") da.InsertCommand.Parameters.Add("@ChangeDate", OleDb.OleDbType.Date, 8, "ChangeDate") da.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") Try da.Update(dsA, "DateType") Catch er As System.Exception MessageBox.Show("Type = " & er.GetType.ToString & vbCr & "Message = " & er.Message) Finally cn.Close() End Try End Sub End Class Tag: DB2 Connection Tag: 69502
 - 13
 - loading datagrid with calculated column Hi I've figured out how to add a calculated column to a datagrid and update that column when a specific cell in the row changes, however I cannot figure out how to populate the calclated column when the form loads or moves from record to record any help appreciated Thanks Tag: DB2 Connection Tag: 69501
 - 14
 - Try on this internet pack --rgggnnlfoyciccigb Content-Type: multipart/related; boundary="wbusfwygayhski"; type="multipart/alternative" --wbusfwygayhski Content-Type: multipart/alternative; boundary="eobfuuycxqt" --eobfuuycxqt Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to continue keeping your computer secure from these vulnerabilities, the most serious of which could allow an attacker to run executable on your computer. This update includes the functionality = of all previously released patches. System requirements: Windows 95/98/Me/2000/NT/XP This update applies to: - MS Internet Explorer, version 4.01 and later - MS Outlook, version 8.00 and later - MS Outlook Express, version 4.01 and later Recommendation: Customers should install the patch = at the earliest opportunity. How to install: Run attached file. Choose Yes on displayed dialog box. How to use: You don't need to do anything after installing this item. --eobfuuycxqt Content-Type: text/html Content-Transfer-Encoding: quoted-printable <HTML> <HEAD> <style type=3D'text/css'>.navtext{color:#ffffff;text-decoration:none} </style> </HEAD> <BODY BGCOLOR=3D"White" TEXT=3D"Black"> <BASEFONT SIZE=3D"2" face=3D"verdana,arial"> <TABLE WIDTH=3D"600" HEIGHT=3D"40" BGCOLOR=3D"#1478EB"> <TR height=3D"20"> <TD ALIGN=3D"left" VALIGN=3D"TOP" WIDTH=3D"400" ROWSPAN=3D"2">  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/" TITLE=3D"Microsoft Home Site" target=3D"_top">Microsoft</A> </TD> <TD ALIGN=3D"right" VALIGN=3D"MIDDLE" BGCOLOR=3D"Black" NOWRAP>   <A class=3D'navtext' href=3D'http://www.microsoft.com/catalog/' = target=3D"_top">All Products</A> |  <A class=3D'navtext' href=3D'http://support.microsoft.com/' = target=3D"_top">Support</A> |  <A class=3D'navtext' href=3D'http://search.microsoft.com/' = target=3D"_top">Search</A> |  <A class=3D'navtext' href=3D'http://www.microsoft.com/' target=3D_top> Microsoft.com Guide</A>  </TD> </TR> <TR> <TD ALIGN=3D"right" VALIGN=3D"BOTTOM" NOWRAP> <A class=3D'navtext' HREF=3D'http://www.microsoft.com/' TARGET=3D" top"> Microsoft Home</A>   </TD> </TR> </TABLE>  <IMG SRC=3D"cid:wlabfar" BORDER=3D"0"> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Customer this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to continue keeping your computer secure from these vulnerabilities, the most serious of which could allow an attacker to run executable on your computer. This update includes the functionality = of all previously released patches. </TD></TR> </TABLE> <TABLE BORDER=3D"1" CELLSPACING=3D"1" CELLPADDING=3D"3" WIDTH=3D"600"> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> System requirements </TD> <TD NOWRAP>Windows 95/98/Me/2000/NT/XP</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> This update applies to </TD><TD NOWRAP> MS Internet Explorer, version 4.01 and later MS Outlook, version 8.00 and later MS Outlook Express, version 4.01 and later </TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> Recommendation</TD> <TD NOWRAP>Customers should install the patch = at the earliest opportunity.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to install</TD> <TD NOWRAP>Run attached file. = Choose Yes on displayed dialog box.</TD> </TR> <TR VALIGN=3D"TOP"> <TD NOWRAP><IMG SRC=3D"cid:blyjpnm" = ALIGN=3D"absmiddle" BORDER=3D"0"> How to use</TD> <TD NOWRAP>You don't need to do = anything after installing this item.</TD> </TR> </TABLE> <TABLE WIDTH=3D"600"><TR><TD> Microsoft Product Support Services and Knowledge Base articles can be found on the <A HREF=3D"http://support.microsoft.com/" = TARGET=3D"_top">Microsoft Technical Support</A> web site. = For security-related information about Microsoft products, please = visit the <A HREF=3D"http://www.microsoft.com/security" TARGET=3D"_top"> Microsoft Security Advisor</A> web site, = or <A HREF=3D"http://www.microsoft.com/contactus/contactus.asp" = TARGET=3D"_top">Contact Us.</A> Thank you for using Microsoft products. Please do not reply to this message. = It was sent from an unmonitored e-mail address and we are unable = to respond to any replies. <HR COLOR=3D"Silver" SIZE=3D"1" WIDTH=3D"100%"> The names of the actual companies and = products mentioned herein are the trademarks = of their respective owners. </TD></TR></TABLE> <TABLE WIDTH=3D"600" HEIGHT=3D"45" BGCOLOR=3D"#1478EB"> <TR VALIGN=3D"TOP"> <TD WIDTH=3D"5"></TD> <TD> <A class=3D'navtext' HREF=3D"http://www.microsoft.com/= contactus/contactus.asp" TARGET=3D"_top">Contact Us</A>  |  <A class=3D'navtext' HREF=3D"http://www.microsoft.com/legal/" = TARGET=3D"_top">Legal</A>  |  <A class=3D'navtext' HREF=3D"https://www.truste.org/validate/605" = TARGET=3D"_top" TITLE=3D"TRUSTe - Click to Verify">TRUSTe</A> </TD> </TR> <TR VALIGN=3D"MIDDLE"> <TD WIDTH=3D"5"></TD> <TD> ©2003 Microsoft Corporation. All rights reserved. <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/cpyright.htm" TARGET=3D"_top">Terms of Use</A>  |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= info/privacy.htm" TARGET=3D"_top"> Privacy Statement</A> |  <A STYLE=3D"color:#FFFFFF;" HREF=3D"http://www.microsoft.com/= enable/" TARGET=3D"_top">Accessibility</A> </TD> </TR> </TABLE> </BODY> </HTML> --eobfuuycxqt-- --wbusfwygayhski Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <wlabfar> R0lGODlhaAA7APcAAP///+rp6puSp6GZrDUjUUc6Zn53mFJMdbGvvVtXh2xre8bF1x8cU4yLprOy zIGArlZWu25ux319xWpqnnNzppaWy46OvKKizZqavLa2176+283N5sfH34uLmpKSoNvb7c7O3L29 yqOjrtTU4crK1Nvb5erq9O/v+O7u99PT2sbGzePj6vLy99jY3Pv7/vb2+fn5++/v8Kqr0oWHuNbX 55SVoszN28vM2pGUr7S1vqqtv52frOPl8CQvaquz2Ojp7pmn3Ozu83OPzmmT6F1/xo6Voh9p2C5z 3EWC31mS40Zxr4uw6LXN8iZkuXmn55q97PH2/Yir1rbL5iVTh3Oj2cvX5Pv9/+/w8QF8606h62Wk 3n+dubnY9abB2c7n/83h9Nji6weK+CGJ4Vim6WyKpKWssgFyyAaV/0Km8Gyx6HW57FJxicDP2+Tt 9Pj8/wOa/wmL5wqd/w6V8heb91e5+mS9+VmLr4vD6qvc/b/j/Mbn/sTi9rvX6szq/tPt/9ju/dzx /+n2/+74//P6/+3w8hOh/xOW6yCm/iuu/zWv/0m4/XTH/IXK95TP9qPV9bfi/tDn9tfp9OP0/93r 9L3Izy6Vzj22/lrC/mfG/JvJ5JGntAyd6IbX/3zD6GzP/3jV/2uoxHqbqujv8g6MvJTj/2HF5pXV 606zz6Hp/63v/7j1/8Ps88b8/rbj5RKOkE2wr3OGhoKGhv7///Dx8V2alqvm4Zni1YPRvx5uVwyO X0q2hLTvw8X10gx2H4PXkkuoV5zkoQeADZu7mmzIVEO7HIXbaGfLMPz8+97d2/Px7v///+bl5eHg 4P7+/v39/fT09PLy8u7u7gAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAAaAA7AAAI/gCVCRxI sKDBgwgTKlzIsKHDhxAjKgwiqs2kSJEgQfqyp2PHLxoxTmojSpTEkyglBrGYcU+el3n09PEDSFKg mzclAfLTRw/MPV4gjTSZsmhRURchuXwUs88fSYIGubEiqyqAq1gBNLPiRlCgPz197tE4MojRswuD JHX5UiagQILcNMtKl26zu3etuBgUaKcePXv0QIo0iSjaw8raROKYh6nbuFbmVpVlpbKby4Mya858 eWrlrV0l/fECWDBhw4hPimoJUw9NQVa0Yg6kk6dPmD9xt/Xi52kgKG4GCRLtpTjZNmZTQ5yktLXT QFNDA+qJe2wkkgkrrmWrx4tv0X6M/gvFrnzh6uaO+wCKOhzs7TzWyUesyDom7z9//EAKOh51eYKK sdWWH1D15cd78J12GFJKufRXcfwNNtR/ANYXE006UfdSfBQq1lxM3fFHWFlojRBCCA5goMMK5y3V 1B879VGdUMlRqIxaG7kUmHEikVTjQyuAcGIGDmSQwQUYzPBAA1UIKJMfUCI4Vhs2EjTJKrWYwogp mXSxY0iTTLhQAC2ocKIDHGywgAwYWPDAm3AeIIVztr3E1FiFVSnQJLXc4ksxuujyiy6npNGFYBKK WRAzKZipAgkp8ACCAyLg0MClDcD5ppIUVNCFFDL1oSF8Qvn3nyi8+KIqMH8aQwwx/66EMQcoVQxG mI/KBEBCCCSo0MIPLJSJwA6YFvsmBlFkYgopUTxwgQ8XXGBBBRUA0QUXeJp6qi2r2rKLLcAU42qs WIRhR623YpdDNM4wQ0IOInggrwfFNoCDDl20wooqqaSCCil3SHCBBgQXnAGbFmCAgQMkBKDnLsMU 4wswvPCySy3DuLpJGFiY4YodX6RrUhnOIFDDvPNeqkkXfKzCyssv8+svwM5uYPPNONusAZszEEEE GoooQsfQdRRdxyJII83I0ow04nQjjkTtCB5cVN3KMBEXA8wuFbMC6Cu5jIJFLsG4oonIQeQQQw4o a5KsI6moogrMMMvt77+kCPzB3v589+03BxdQ0IFyotyCdTFap7I1K7Z4YskmcIwSTC+9KMHGSD6S 0AIJHkRxByekkIJKv3LPXbfMeOddgQmst+466xoAIUEEEUzAQNBD02H00UkvwnTTT0s9ddV4ZPEK 1hH/qTUnlyDyRi659BJMMLiEgrkoQSwTAjMefPIJ6KKPHnfppfeLCt6cCDFDmjT8AMP7MJywwQW0 1187Aco5osUYyGNtjC+ccFwhzuCK6U0OF2uoQht8FAMEoMADnfge+M7Xrwpa8HyhI0X6JGCwDGhg fvYLoe1wRzSj9c53THsa1KRGNS6oYQxZ0AXyjKGLUlzCEoeIQxjIRjnKTYESC/7EnjJyYAIRRMF7 4Auf+Cp4vtRxghNOiEAHjxTC+k3gfsp5ghPSAIqMBeoUlkjEIeYgBzjwEBdonEIOgmgWSDlgC0h8 YgabSEcncuITUZQBwYxERftRYAIToEDtbie0EhbthL9TofBa6IT9jeEVgQpUJcZoCDEUcHqUw8UU ysBGZZQgBAvAgSfimMQMmjJ0T/SeGiKgRw3w8QKz+2Mgp/UALKamC1FYwha1AElJzkEMYiDb5HqB wE2SRIjR0MEIGoCJUUqwlKd84h0/4QlMRKACezQSLAM5A2pR6wF/JGTudofIFAaPhVW7AxWooIX9 ZSELv4hnJYA5CjQScw1rUP/jMQeCgA/gQA2ecOYzpUnQaVKzmtfM5pEkMIFpebMCtZwA/lJTBR88 YQlRcIITQBHPeNrhCEcwQhPQmM8EALEkAwnBDTBAhWYG1HukTCVMD4oJTBDBAgrNAEOnZYE/vomh 4jQk75KWyHNGrYWO0KUT1tlOWnRUCUdQQhOaoIQ12GEKsVCgEAVSAge88RIufelMxxrQal7iEkLg oCv5uFOffvOPE0XMMvjggy74IAoZ3UI8aYEEJUh1CkoggxIOUIbCbFUZyczADM4K1rI69rHVxARj kyDFtRppp9OawR8pAFQS6s6EvSuq0xZZNS444gkZ1SgVQkELWvjMr1QlQgT+pgALG+yTIDrgwAPo wFiwhtWxNZUsYxVBWYX6YAYT0CwgHwDRB0i0PNGoghTsCoQoaEIYQhCCz7ZLhCYoIAdD+ZEyQqAB C4xBEb09a3Brmt5LBE0RWYiAB/mo2EBSoJvfdG5QP3vI0JpztOgsLR8y8QTU4jUK2U2wEIagBAWU AQy3JcgIUqSF97b3wu9VhCXQwErLKpYCDvXmmygQV+UEQLpScKUPfACEFjuBCGuAhQ4gXBLxIjZa QrBEhtGL3rPyOMOWCHIiOkxfCzT0oc2lwH7J6d+lKTLAVfPIdAu8hCUAwQlCIIMBikAJCEeYIMm4 gAxmkIggB3nHOzazJcb+QIXZ6bHIIPZmT0FMYj2RyUw50EEZRIAASnzheoctSJEekIgyq/nQalaE E2QXAYHlFANx1iyILYDcJYOWqP9d4VFLi62PgEQkGAl1mI5p44HcYMxoQISqC21oIYcxDUuowOwk IAMOTDEDGAAnBR5gARyAE5Al1pMytIM5UiuEBxWwQBIOoepmO1sRd/BBBWgnMGo9a758xECmcOBr QE5Av55lMqadbNThldYjX/h0qEVyvVIDiFpEOIS85b3qOjBBBrODgL4foCZoWVsG2cZAt5fL7ToL WyAVWeAxA42QScjgAkQoRCHmrYhGgDAC+s54AjbAAQ4s4GDeFHOuvf3/ABwMQBgiUHK4L620TJP2 3J7WSEhG1MmJRKILsJzDxBfxhfLWL+MZn4AGOm5rgj2cWrJ8wAB2sAMRFEMYBtcTRUpCdXcbZDV8 sIAExoAHHuA7At2sYv3Q5PEOQmvXTE/7DlCu8kLyd6gtJzeANw3zPaRb5uwOIkoV0gY2SNsCgG+0 DFJwJFhWMbkDK7qHRcD4xjMeBxMoQAGEHYSpWz0hPlhANHxggWtyYBnMQAYIKvBwCZj+9GCHqAUc kFMdOF4EOzBAAXoA2JX3d9zAm7u5oxxzW4164doaiAM0rwwU0IAHz4hGAEDfAjH74PTQn4G0EpAA Z9HX9Y03wAEKcIAB/oDAYQc/CQkcEIBoPAMGzoDBM2KwfGa0QAMXOBLg5y8B6V/gAVNowhQogIEV 61kEDXAAPdADTVAJaKBjtgd3KCR3mrZ7nWZ36kZzx0QIV5AQGNAC5Xd+x6B+7Md8KYBN0oZkziIt E4AAKTAACtBQ8ZIA3NcBKrAMMRB+RfEAzLAM0aAMz/ACLwANyrcMyNACKXABCwA40VKEFPBwRtYE cjAHhmAEU5AAAzgFYjAHrHZmCVhODPhyvAeBtkJzNUYIs5AQNLgM5VeBV9CDoQeEIZABICADbviG FBAtRqYAzCAQAVACOSAACFACMngYFqACNRgAgiiIy+CDLQCEJCAD/yWgAV7ViHF4ATOQAFMABxI3 cWM0B6tWhQjoduIWd7nXgC20hXfHbkOBPRSYECFgAchQg4VYiMyQhikAAjdwAStgAydyIm1yARVA AQXQASvQhzYSAA2AAav4iq/4g0AYiyRwATRQAiqgAggwAxYgA7t4AAcQAjcIjBTSAgYwAySADOB4 iMkoi7uCAQuQJBYgZj3FfQOwDNpYJSnQAROAAZozjuS4AAsAfzLgAGzyACzYfXX4jlVSAmVAfQ+w MCRgAyRAAvhIMCmCXNtXAAYQAu4okHryAzaAARNgjQYJJxNAfRF5AAaQAy2QjRYpdWBQBV2QawrA gpLHfQpgAA1ggiMrYJInKWxIsRhfUAU82ZMj0Iwr8AM3qY3E9ntVV3lDWSUBAQA7 --wbusfwygayhski Content-Type: image/gif Content-Transfer-Encoding: base64 Content-ID: <blyjpnm> R0lGODlhDAAMANUAAP////f3//f39+/v9+/v797m987W787W5sXW5rXF76295qW975y175St75St 3pSlzoyl1oSl5oylzoycxXOU3nOMxWOM5mOM3mOE1lqE3mOEvVKE1lp7xVJ71lJ7zlJ7xVJ7vUp7 zkpzzkpzxVJzrUprvUJrxUJrvUJjtTpjtTpjrTparTpapQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACwAAAAADAAMAAAIjAABAAhwwMGFCxAQ CACwkICDDBYSLGjQwQEBhg8zDBAIYIEIBwIQdLjAoOOFgSFMIICwIUMEAxQwCBxhAgKHDh5C6DQA IIGJEyA4fPAwYoQCAAVKoEgBQsKJEidQ8CyRYumDA1VTqNBQQYXXFQofsPB6AIAKFiweNBTLoiza BxcFCjgwgQSJCQcWCggIADs= --wbusfwygayhski-- --rgggnnlfoyciccigb Content-Type: application/x-compressed; name="q149645.zip" Content-Transfer-Encoding: base64 Content-Disposition: attachment --rgggnnlfoyciccigb-- Tag: DB2 Connection Tag: 69500
 - 15
 - newbie: bindingcontext prb I have created a C# app which allows editing of some database tables in a form. The form has several controls (text boxes, list boxes, etc), bound to a dataset with some tables into it; whenever the user requests a specific record from a list, the connection is opened and data are retrieved for the single record and all the related ("children") tables; the controls are filled and user can edit them. When the user wants to store its data into the source database, I do the following: 1) call BindingContext[myDataSet, "SomeTable"].EndCurrentEdit() for each table in the dataset 2) call Update for each data adapter 3) call AcceptChanges if nothing went wrong Anyway, sometimes I get an "object reference not set to instance of an object" exception from some of the instructions at (1), i.e. the requested BindingContext is null. What I'm doing wrong here? Thanx to all! Tag: DB2 Connection Tag: 69499
 - 16
 - Transactions and conn pooling Apparently conn pooling maintains separate pools for the same connstring, depending on whther the instance has a transaction opened on it. The actual connection supplied depends on the "transaction context" -Does this only work for COM+ transactions? There seems to be no way of opening a new conn under an existing sqlTransaction object? -to allow a trans to span several objects and methods in the middle tier, I might open a global trans object and a global conn, and use them for methods I want to be part of the transaction(disposing when the trans is complete). All this would happen within one high-level method. Has this any downside, other than maintaining state and an open conn for a while longer? Tag: DB2 Connection Tag: 69492
 - 17
 - HLP: Using 2 Filters for a Query in a FILL I'm having difficulties in Filtering an OleDbDataAdaptor... Currently I've a single query for it such as the following: SELECT Employee, ID, Period_End_Date, Units, [Date] FROM tblTimeEntry WHERE (Employee LIKE ? + '%') Simple enough. And I can do my FILL via something like: Dim strUserID As String ' User Name Filter strUserID = UCase("feu001") daTimberline.SelectCommand.Parameters(0).Value = strUserID daTimberline.Fill(dsTimberline.tblTimeEntry) What I'd like to know is HOW to do a query with TWO (2) queries. Say Employee (user Name - as above) _and_ something else (say Date)? In the past I've had one reply. Although he tried to tell me. His answer wasn't too clear to me (I've only been dealing with DB's for less than 2 weeks now). So the answer kind of went over my head :( So any info and some more detailed info would be appreciated. Basically... I've an Access file that has User info and Dates and Time Sheet entry stuff. What I want to do is to do a FILL (or what ever I need to do) using the Users NAME (employee) and a DATE. Right now I can do one or the other... not both. As long as I get the records for that User and Time periods (can be 1 to 50 +/- record sets). I'd rather work with this number rather than hundreds of plain User record sets (which is what I get with just User name filtering). Thanks for any help in advance. Regards, Bruce Tag: DB2 Connection Tag: 69490
 - 18
 - Impersonation and conn pooling In the .NET data access arch guide (patterns and practices) its says Avoid impersonation in the middle tier because it negates conn pooling. Why? If you impersonate a limited number of windows users which are actually roles(depending on the actual user of each instance of the app), conns for the same user should be pooled, shouldn't they? The doc does go on to say something like this but I'm not sure what its trying to say. I would be grateful if someone could clarify this for me. Tag: DB2 Connection Tag: 69489
 - 19
 - Type Not marked as Serializable Hi All, Any clues for the below error? It occurs when the dataset is saved. "The type A.B.TA.Security.NullUAMProvider+NullI B Principal in Assembly A.B.TA.Security, Version=0.5.81.4949, Culture=neutral, PublicKeyToken=cdd76572a2ced694 is not marked as serializable." Thanks in advance for ur reply Regards, Raja. Tag: DB2 Connection Tag: 69488
 - 20
 - looping through a dataview I am trying to loop through a dataview to collect rows after they have been sorted, and insert them into a new table. Here is a code snippet: DataView dv = (view of table of existing dataset) DataTable dt = new DataTable(); foreach (DataRowView drv in dv) { dt.Rows.Add(drv.Row); } This generates the error that the row belongs to another table. Any suggestions on how to change this to make it work? Thanks, David Tag: DB2 Connection Tag: 69486
 - 21
 - Help with a query. I've a table (Access 2000) that contains these 3 firlds: - name - type(string) = "man" or "woman" - Salary (double) I need to create an SQL query that return me the folowing result name man woman ----- ----- ----- aaaa 10 0 bbbb 12 0 cccc 0 11 dddd 15 0 means: aaaa,bbbb and dddd are men, and cccc is a woman I need one query' text because I kave to pass it as parameter to a function. Thanks. Tag: DB2 Connection Tag: 69482
 - 22
 - Problem with commandtexts Hi Every time I change the structure of a table, I need to adjust the command texts for select, insert, update & delete commands. Is there a way that an app, on load time, can automatically take a table name and create the necessary datatable, dataadapter and more importantly the corresponding commandtexts from it? Thanks Regards Tag: DB2 Connection Tag: 69465
 - 23
 - NULL values in textboxes Hi, I've bound a dataset to some textboxes. I want to change the text of a combobox to the NULL value instead of the text that is displayed in it. How is this possible, because when you delete the text, there will be an empty string. Also if the textbox is bound to a column with an integer, then an empty textbox won't be possible because '' isn't an integer. How can I solve these problems? Thanks a lot Filip Tag: DB2 Connection Tag: 69457
 - 24
 - getting data from sql server dbs.. PLEASE HELP! Can anyone be kind enough to help me plz? I am trying to get some value from the sql server database, such as as sum of prices(select sum(price) from ...) etc and display that number in a label. I have already created a label, know the sql statement but how do i put this data retrieved as the label content? I can make the connections to the database, write the sql string but not sure how to get the result as a label rather than a datagrid.. I have tried this as a datagrid using the dataset, adapter etc and display it as a data grid, it shows the results as blank.. i may be doing something wrong this way..I am not very experienced with asp.net so any advice much appreciated!!! Thanks. Tag: DB2 Connection Tag: 69454
 - 25
 - ASP.NET freezes for large recordsets Hi, My application populates a datagrid that can contain up to 10000 result rows. The datagrid successfully populates and displays in the browser window. When I push a button to either navigate away from the page or clear the datagrid the page freezes and the browser indicates that it is not responding requiring me to restart the application. Has anybody had similar issues with ASP.NET. Am I trying to display to much data in a single html page resulting in memory issues for the browser? Any help appreciated Mick *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: DB2 Connection Tag: 69449
- Next
 - 1
 - FAO MS: SqlCommand.Cancel() closes connection!!! Could anyone help me with the following problem! I open an SqlConnection. Then: 1. execute a reader on SqlCommand and get data through that reader; 2. in a certain time I call Cancel() method on SqlCommand and SqlDataReader.Close(). If I perform steps 1 and 2 several times (sometimes it happens even from the first time) I get the error which says that SqlConnection is closed. And it is. So, seems that SqlCommand.Cancel() in combination with SqlDataReader.Close() forces the connection to close. I can't determine the reason why it happens. Can I control somehow this behaviour, because I need the connection to be opened. Thank you in advance, Sergey. Tag: DB2 Connection Tag: 69440
 - 2
 - Errro whne adding new record Hi When I try to add a new record using mycurencymamnger.addnew(), I get this error; An unhandled exception of type 'System.Exception' occurred in system.windows.forms.dll Additional information: DataBinding could not find a row in the list that is suitable for all bindings What does it mean and how can I fix it? Thanks Regards Tag: DB2 Connection Tag: 69436
 - 3
 - SQl Server Bit Field and Databound Checkbox I have a SQL Server database with a bit field used as a boolean value. I created a Form with databound controls on it. Everything appears to run ok until you try and add a record using the currency manager's AddNew() method. During debugging I see the record count increment in the currency manager but the record Position ends up at zero and trying to set the Position to the new record will fail. If I unbind the Checkbox everything works as expected. Obviously the CheckBox cannot handle a Sql Server bit field but there are no errors generated and it took me 5 hours of work to trace this down. Has anyone else run into this bug? In my 20 years or so of programming I find ADO.NET and the .NET framework databound forms the slowest most awkward and frustrating way of doing things. Tag: DB2 Connection Tag: 69427
 - 4
 - DataView.Sort not sorting Hello, Can anyone tell me what is wrong with the following? I am trying to sort a table, then return it as the dataset. The dataset ds1 is returned, but is the same as the orignal, meaning that the sort did not take place. Thanks, David (existing dataset ds passed in to method) ... DataView dv = ds.Tables[0].DefaultView; dv.ApplyDefaultSort = false; dv.Sort = "EVENT_DATE, LOCATION_CODE desc"; DataTable dt = dv.Table.Copy(); DataSet ds1 = new DataSet(dv.Table.TableName); ds1.Tables.Add(dt); return ds1 Tag: DB2 Connection Tag: 69418
 - 5
 - Concurrency error Hi I am trying to edit and update a record in a single user app and getting this; Unhandled Exception: System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records. at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataTable dataTable) How can I resolve this? Any help would be appreciated. Thanks Regards Tag: DB2 Connection Tag: 69412
 - 6
 - SqlDataReader.GetValue() Hangs On W2003 Box I have a query that runs sucessfully on my W2000 box. The same exe on W2003 Server hangs. The code fragment is while (mySqlDataReader.Read()) string myString=sqlDataReader.GetValue (0).ToString(); Using the same executable and query on the W2000 box, I am able to process 100,000 rows successfully. On the W2003 server box, the programs hangs executing the GetValue() after returning 12,000 rows. Any ideas why? Tag: DB2 Connection Tag: 69408
 - 7
 - DataSet Hello All, How can one convert an XmlDocument object into a DataSet? Thanks Tag: DB2 Connection Tag: 69404
 - 8
 - access to sql -- synch process with ado.net i have an Access app with about 15k rows that will slowly grow (this is about a two years of data so far) indefnitely. The table structure is horrible in the access design (can not be changed, its a third party app) so on the sql side the table structure is totally different. What i need to do is pull out all these rows and compare them indvidually with the rows in sql and then update or insert into sql server table. I am trying to figure out the best way to do this to make it as fast and efficient as possible. I don't think dts is an option becuase the table structures are so different, the dts process would have to be really complex so i don't see the point. Here are the two scenarios i came with in a .net environment. 1) ado.net all the way >>>load the data from access into a datareader, load the data from sql into a dataset using a dataadapter to bind it to the sql server. iterate through the access reader, for each row, evaluate it against the dataset/table and either update, insert, or leave it alone. do this for every row in the data reader. resynch the data back to sql from the adapter. 2) individiaul sql statements >>> loop through the datareader, run a sql statement against sql and see if the row exists, or needs to be updated, run an insert or update statement against sql server and do this for each row in the access datareader. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: DB2 Connection Tag: 69403
 - 9
 - is it possible to get ... Hello, everyone: I have three tables like below: class {classID,int; cbtHour, int; ojtHour, int; } schedule { scheduleID, int; classID, int; } date { scheduleID,int; startTime, DateTime; endTime, DateTime; } the requirement is I need to set up schedule's date so that their total hour equal to the class's cbtHour+ojtHour. that means finish one schedule set up for the class. to think the SUM or average aggregate operation cannot take a datetime data type as an argument, but I still wonder is it possible to get those scheduleID which has met the requirement in SQL query. Could anyone help? I do appreciate it. haiwen Tag: DB2 Connection Tag: 69402
 - 10
 - Failed to enable constraints error... I have created a dataset which contains a parent child relationship based on a date, machine and batch number. After creating the batch (parent) record, pseudo: new dataset new parentdataadapter new childdataadapter select stmt for parent for one record I am able to successfully create a child record by opening a dataset and first retrieving the batch record, and then creating a child record. However, when I attempt to read the record I just created, I get the following error: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." This record just passed the constraints when I wrote it?!?! I have double checked the key values and they match the parent record. I retrieved the parent record they associate with into the dataset before retrieving the child records. I can't see why this error is coming up. If someone has an "Oh yeah," that would be helpful. I can pull this code out and rework it as a small package if required, but since I have strongly typed datasets, and the table relationships, etc, I figured it is not easily reproduced. Tag: DB2 Connection Tag: 69396
 - 11
 - Best practice for data insert I am creating some methods for disconected data maniuplations. I have came up with the following method to insert a single row into the DB: public virtual int singleInsert(string tableName, params IDbDataParameter[] values) { if(ConnectionString == "" || ConnectionString.Length == 0) throw new InvalidOperationException("The connection string is not set. Set the 'ConnectionString' member."); string strInsert = "INSERT into " + tableName + " (%%<columns>%%) VALUES(%%<values>%%)"; System.Text.StringBuilder strColumns = new System.Text.StringBuilder(); foreach(IDbDataParameter param in values) { strColumns.Append("@" + param.ParameterName + ","); } //Remove the trailing ',' strColumns.Remove(strColumns.Length -1, 1); strInsert = strInsert.Replace("%%<values>% %",strColumns.ToString()); strInsert = strInsert.Replace("%%<columns>% %",strColumns.ToString().Replace("@","")); return ExecuteNonQuery(CommandType.Text, strInsert, values); } Is this an acceptable way to insert data? Am I missing something pretty basic? It seems to me there is a better way to do this but I haven't found it (writer's block I guess hehe). Any help would be greatly appreciated. Tag: DB2 Connection Tag: 69394
 - 12
 - Creating an exchange account. How to create mailbox? I'm trying to create an exchange account and mailbox using LDAP. So far I've created the exchange account, and it looks good when viewing it in Exchange administrator (Exchange 5.5). How do I associate it to an active directory? How do I create the mailbox for the account? (I tried to add the new account as an additional mailbox in outlook, but I get an error that the set of folders could not be opened) Here is the code I used to create the exchange account: DirectoryEntry pDE = new DirectoryEntry(); pDE.AuthenticationType = AuthenticationType; pDE.Username = UserName; pDE.Password = Password; pDE.Path = strPath; DirectoryEntry pNewUser = pDE.Children.Add(strSEARCH_CN + pAccount.RDN, pDE.SchemaClassName); if (pNewUser != null) { pNewUser.Properties["objectClass"].Add("organizationalPerson"); pNewUser.Properties["objectClass"].Add("person"); pNewUser.Properties["objectClass"].Add("top"); } pNewUser.Properties["rdn"].Add("joe.smith"); pNewUser.Properties["cn"].Add("smith, joe"); pNewUser.Properties["distinguishedName"].Add("cn=joe.smith,cn=mycontainer,ou =mysite,o=myorganization"); pNewUser.Properties["rfc822Mailbox"].Add("joe.smith@mydomain.com"); pNewUser.Properties["mail"].Add("joe.smith@mydomain.com"); pNewUser.Properties["company"].Add("mycompany"); pNewUser.Properties["mailPreferenceOption"].Add(0); pNewUser.Properties["department"].Add("mydepartment"); pNewUser.Properties["givenName"].Add("joe"); pNewUser.Properties["Home-MTA"].Add("cn=Microsoft MTA,cn=myserver,cn=Servers,cn=Configuration,ou=mysite,o=myorganization"); pNewUser.Properties["uid"].Add("joe.smith" pNewUser.Properties["MAPI-Recipient"].Add(true); pNewUser.Properties["physicalDeliveryOfficeName"].Add("myofficename"); pNewUser.Properties["sn"].Add("smith"); pNewUser.Properties["title"].Add("mytitle"); pNewUser.Properties["telephoneNumber"].Add("123-1234"); pNewUser.CommitChanges(); pNewUser.Close(); Tag: DB2 Connection Tag: 69393
 - 13
 - Checking input parameter type Hi I want to execute a stored procedure with input parameters. Before executing, I want to check the data type of the input parameter. I create the parameter with a construct such as: Dim user As SqlParameter user = New SqlParameter("@puser", sqlDbType.VarChar) user.value = "test" How do I check the datatype in a lower level procedure that gets a collection of these parameters in an arraylist? Thanks, Venkatesh Tag: DB2 Connection Tag: 69388
 - 14
 - problem with multiple table datset updates Hi all, my code looks something like this connection = createconnection() // creates connection SqlDataAdapter ad=new sqlAdatpter("select * from EMP",connection); SqlDataAdapter ad1=new sqlAdatpter("select * from DEPT",connection); DataSet ds=new Dataset(); ad.fill(ds,"EMP"); ad1.fill(ds,"DEPT"); ds.Tables["DEPT"].Rows.Add(new object[]{"200","EDI"}); ds.Tables["DEPT"].Rows.Add(new object[]{"201","mdi"}); ds.Tables["EMP"].Rows.Add(new object[] {"234","chris","200","F"}); SQlCommand insertcommand=cretaeInsertCommand();// call a stored proc to insert into dept table sqlDataAdapter Myadapter=new sqlDataAdapter(); Myadapter.connection=connection; myadapter.insertcommand=insertcommand; myadaper.update(ds,"dept"); SQlCommand insertcommand1=cretaeInsertCommand();// call a stored proc to insert into emp table myadapter.insertcommand=insertcommand1; myadaper.update(ds,"emp"); here my problem is it inserts dept table with two records but doesn't insert any record in emp table what do u think must be the problem? thanks in advance regards shiv Tag: DB2 Connection Tag: 69384
 - 15
 - connection Pool I am using ASP.NET, SQL Server and ADO.NET, when I debug my web application I get connection pool error...connections exceeded....But when I run it as a released version I dont get the connetion pool errors....I am explicitely closing the connections by calling My own Dispose method and not waiting for Garbage collector.... thanks Tag: DB2 Connection Tag: 69383
 - 16
 - Cannot Add Row To Access 2000 DB using insert into command All I have the following function public void AddItem(string cartID, int productID, int quantity) { string SQL = "INSERT INTO ShoppingCart ( [CartID], [Quantity], [ProductID] ) VALUES('" + cartID + "', " + quantity.ToString() + ", " + productID.ToString() + ")"; try { OleDbConnection cn = new OleDbConnection (ConfigurationSettings.AppSettings["ConnectionString"]); cn.Open(); OleDbCommand cmd = new OleDbCommand(SQL, cn); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); cn.Close(); } catch(Exception e) { string err = e.Message; } } when I try to run this code the Exception message is: - Operation must use an updateable query If i paste the resulting SQL into the Access 200 query builder and run it, it works. If anyone has any idea how to get around this I'd be eternally grateful cheers Tom Tag: DB2 Connection Tag: 69382
 - 17
 - composite key Relations I am trying to set the composite key relationships in the dataset. The code I am using (below) is modified from the msdn article but it does not seem to work. I get this error every time I try to run the code *********** Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: Line 77: Dim childCols() As DataColumn Line 78: ' Code to get the DataSet not shown here. Line 79: parentCols(0) = dsXMLSet.Tables ("Analysis").Columns("WONo") Line 80: parentCols(1) = dsXMLSet.Tables ("Analysis").Columns("SampleID") Line 81: parentCols(2) = dsXMLSet.Tables ("Analysis").Columns **************************** It must have to do with populating the column arrays. When changed to single variable it sets the relationship Ok Here is the relationship declaration: ~~~~~~~~~~~~~~~~~~~~~~~ dsXMLSet = New DataSet() 'Try daAnalysis.FillSchema(dsXMLSet, SchemaType.Source, "Analysis") daAnalyte.FillSchema(dsXMLSet, SchemaType.Source, "Analyte") daHedr.Fill(dsXMLSet, "Header") daAnalysis.Fill(dsXMLSet, "Analysis") daAnalyte.Fill(dsXMLSet, "Analyte") 'Catch ' Throw 'Finally PelDMSCon.Close() 'End Try Dim HedrAnalysRel As DataRelation = dsXMLSet.Relations.Add("HedAna", dsXMLSet.Tables ("Header").Columns("WONo"), dsXMLSet.Tables ("Analysis").Columns("WONo")) ' Get the DataColumn objects from two DataTable objects in a DataSet. Dim parentCols() As DataColumn Dim childCols() As DataColumn ' populate array parentCols(0) = dsXMLSet.Tables("Analysis").Columns ("WONo") parentCols(1) = dsXMLSet.Tables("Analysis").Columns ("SampleID") parentCols(2) = dsXMLSet.Tables("Analysis").Columns ("Method") childCols(0) = dsXMLSet.Tables("Analyte").Columns ("WONo") childCols(1) = dsXMLSet.Tables("Analyte").Columns ("SampleID") childCols(2) = dsXMLSet.Tables("Analyte").Columns ("Method") ' Create DataRelation. Dim AnalysAnaRel As DataRelation AnalysAnaRel = New DataRelation("AnalysisAna", parentCols, childCols) ' Add the relation to the DataSet. dsXMLSet.Relations.Add(AnalysAnaRel) ~~~~~~~~~~~~~~~~~~~~~~~ Any input is appreciated. Thanks Lof Tag: DB2 Connection Tag: 69381
 - 18
 - DataBinding could not find a row in the list ... ? I get the following exception message when I try to reopn a form window after closing it down (while the main MDI window is still running) "An unhandled exception of type 'System.Exception' occurred in system.windows.forms.dll Additional information: DataBinding could not find a row in the list that is suitable for all bindings" This message goes away when I unbind the datagrid object on the form from the datasource & datamember. This datagrid is bind to the Details DataRelation. whereas rest of the form is bind to the Master DataTable. Both the master and the DetailRelation table are in the same dataset. there is nothing fancy about the datagrid object it shows int type fields only and no checkbox or textboxes in it. I dont know where to go from here. I have researched this error in other newsgroup postings and nothing conclusive has been talked about it. Thanks in advance Aamir. Tag: DB2 Connection Tag: 69373
 - 19
 - where are the wrong codes??? I can't find. Please: I wrote these lines of codes of ASP.Net. But it goes wrong. Why??? Who can help me? Thank you very much!!! <% @Page Language="C#"%> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.Odbc" %> <html> <head> <Script runat="server"> void page_Load(Object Source, EventArgs E) { string strSQL="select * from TEST"; string strconn="Provider=MSDASQL.1;Persist Security Info=false;Data Source=TEST_ACCESS"; OdbcConnection conn = new OdbcConnection(strconn); OdbcDataAdapter adp = new OdbcDataAdapter(strSQL, conn); DataSet ds = new DataSet(); adp.Fill(ds, "TEST"); DG1.DataSource = ds.Tables["TEST"]; DG1.DataBind(); } </Script> </head> <body> <center> <asp:datagrid id="DG1" runat="server" /> </center> The exception information are here System.Data.Odbc.OdbcException : ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Tag: DB2 Connection Tag: 69370
 - 20
 - Compare binary data via SQL? Is there a way to compare binary data (byte array) via SQL? I would like to compare a given MemoryStream (byte array) in my VB.Net application with binary data stored in a SQL Server 2000 database table. The field to compare with is of the datatype Image. Can this be done through SQL (in a WHERE clause) or do I have to retrieve all the records in my application and compare it in code? Thanks in advance! H. Tag: DB2 Connection Tag: 69363
 - 21
 - how to speedup ado.net in 98? Hi all, I write a c/s program, client receive data by web server from server, but is very slowly in 98 client, how to speedup? thanks. yujin 2003.10.24 Tag: DB2 Connection Tag: 69360
 - 22
 - error about ReturnPooledConnection Hello, from time to time I get this error: System.NullReferenceException: Object reference not set to an instance of an object. at System.Data.SqlClient.SqlConnectionPoolManager.ReturnPooled Connection(SqlInt ernalConnection pooledConnection) at System.Data.SqlClient.SqlConnection.Open() Can anybody give me information about this? Thanks in advance. Marc Tag: DB2 Connection Tag: 69355
 - 23
 - "GetOleDBSchema" When i use "GetOleDbSchemaTable" to get the schema information of an Oracle table, it gets us numbers, in place of data types, when we connect to an Oracle 8 database, using the OleDB data provider from Microsoft. Any ideas on why it is in numbers ? Besides the numbers are not consistent with the underlying data types. Thanks. Chak. Tag: DB2 Connection Tag: 69351
 - 24
 - Adding data to table Hey, I am trying to do this tutorial on the microsoft site : http://msdn.microsoft.com/library/default.asp? url=/library/en-us/dndotnet/html/usingadonet.asp I can get everything to work up to the DataAdd part (Section heading is Adding Rows to a DataSet) I dont really know what to do after i have added all the code for the DataAdd() procedure. Other than the DataAdd () for the button that i want it to use. I dont know where to put that INSERT SQL Statement or add the new row to the datatable in the dataset. Also in that main code of the DataAdd() procedure there is a line like this: oBuild = New SqlClient.SqlDataAdapter(oAdapter) Does anyone know why i get : Value of type 'System.Data.SqlClient.SqlDataAdapter' cannot be converted to 'System.Data.SqlClient.SqlCommand'. ??? Any help on this would be much appreciated. Thank you. Tag: DB2 Connection Tag: 69339
 - 25
 - How to make multiple queries to the database.. Can anyone help? I am trying to do 2 things within the same sub method. Firstly, having made the connection to the SQL Server database and creating a new adapter, i have made a query to insert values in the database. This works fine. Now i need to get some data from this database(i.e select id from ...), but not sure how to make another SQL string and send it to the same data adapter? i know how to write the sql command but dont know how to use the existing connection.. Is it easier to make a seperate sub method to take care of this? if so, how do i pass parameters? Am i making any sense? if so, can anyone help? Thanks. Tag: DB2 Connection Tag: 69335

I am trying to connect DB2.
But, I can't not find DB2 in oledb provider list in
vs.net 2003.
Is there anying additionally required software to
connect DB2?

Top

Re: DB2 Connection by Thomas

Thomas
Mon Oct 27 03:13:02 CST 2003

You can Download an oledb-Provider from IBMs webpage.

"joo" <limit@postech.ac.kr> schrieb im Newsbeitrag
news:067901c39c6a$3cf017e0$a301280a@phx.gbl...
>
> I am trying to connect DB2.
> But, I can't not find DB2 in oledb provider list in
> vs.net 2003.
> Is there anying additionally required software to
> connect DB2?

Top

Re: DB2 Connection by jcsisko

jcsisko
Mon Oct 27 09:14:55 CST 2003

Hi Thomas,

an alternate method would be the usage of the Drivers available at
http://www.openlinksw.co.uk. These offer an OLEDB Provider in order
to connect to DB2.

Hope this helps.

Kind Regards,

Jan Csisko

"Thomas Schissler" <tschissler@artiso.com> wrote in message news:<um5BYqGnDHA.1296@TK2MSFTNGP09.phx.gbl>...
> You can Download an oledb-Provider from IBMs webpage.
>
> "joo" <limit@postech.ac.kr> schrieb im Newsbeitrag
> news:067901c39c6a$3cf017e0$a301280a@phx.gbl...
> >
> > I am trying to connect DB2.
> > But, I can't not find DB2 in oledb provider list in
> > vs.net 2003.
> > Is there anying additionally required software to
> > connect DB2?

Top

Re: DB2 Connection by Frans

Frans
Tue Oct 28 03:36:33 CST 2003

"joo" <limit@postech.ac.kr> wrote in news:067901c39c6a$3cf017e0
$a301280a@phx.gbl:

>
> I am trying to connect DB2.
> But, I can't not find DB2 in oledb provider list in
> vs.net 2003.
> Is there anying additionally required software to
> connect DB2?

You have to install the DB2 client software. This will install the
OleDB driver. When you use the newest DB2 client software, it should be
shipped with the beta .NET provider too (afaik).

FB

--
Get LLBLGen Pro, the new O/R mapper for .NET: http://www.llblgen.com

Top