ODBC slow 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
    - Can't addnew in child grids Can't addnew in child grids. Haven't been progressing on this lately because of the Holy Days in Israel and the call of other work. Kevin Yu has been instrumental in helping me so far. Have a keywordset table bound to textboxes and a checkbox, with the usual buttons for moving position, adding, deleting, updating the dataset and updating the database through the data adapter. All work fine. There are two child tables, keywords and searchphrase, related in the dataset's xsd file and in the database itself. Each of the grids in which the data is displayed have edit, add and delete buttons. The grids are read only. When the add or edit button is clicked a small editkeyword or editsearchprhase form is opened up, tied to the main form by a currency manager. Delete works fine. Edit works fine. But add doesn't work. So I decided to catch errors, the edit form doesn't open up at all. Without errors it does, but the add doesn't work. Here's some code. Private Sub frmFullWord_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try cnWKS.ConnectionString = gstrconn cm = CType(BindingContext(dsWKS1, "KeyWordSets"), CurrencyManager) AddHandler cm.ItemChanged, AddressOf cm_ItemChanged AddHandler cm.PositionChanged, AddressOf cm_PositionChanged AddHandler daWKS.RowUpdated, AddressOf OnRowUpDated cmK = CType(BindingContext(dsWKS1, "KeywordSets.KeywordSetsKeywords"), CurrencyManager) cmSP = CType(BindingContext(dsWKS1, "KeywordSets.KeywordSetsSearchPhrase"), CurrencyManager) daWKS.Fill(dsWKS1, "KeywordSets") Me.dsWKS1.KeywordSets.ActiveColumn.DefaultValue = True daWK.Fill(dsWKS1, "Keywords") daWSP.Fill(dsWKS1, "SearchPhrase") Catch ex As OleDbException If ex.Errors(0).SQLState = "3022" Then MsgBox(ex.Errors(0).Message & s & "Please try again") dsWKS1.Clear() daWKS.Fill(dsWKS1, "KeywordSets") daWK.Fill(dsWKS1, "Keywords") daWSP.Fill(dsWKS1, "SearchPhrase") Exit Try Else Dim errorMessages As String Dim i As Integer = 0 errorMessages += "Index #" & i.ToString() & ControlChars.Cr _ & "Message: " & ex.Errors(i).Message & ControlChars.Cr _ & "NativeError: " & ex.Errors(i).NativeError & ControlChars.Cr _ & "Source: " & ex.Errors(i).Source & ControlChars.Cr _ & "SQLState: " & ex.Errors(i).SQLState & ControlChars.Cr _ & "StackTrace: " & ex.stacktrace & ControlChars.Cr _ & "" MsgBox(errorMessages) End If Catch ex As NullReferenceException Exit Try Catch ex As InvalidCastException Exit Try Catch ex As DBConcurrencyException MsgBox(ex.Message & s & "The dataset will be refreshed." & s & "Then you can navigate to the row and update it again.") dsWKS1.Clear() daWKS.Fill(dsWKS1, "KeywordSets") daWK.Fill(dsWKS1, "Keywords") daWSP.Fill(dsWKS1, "SearchPhrase") Exit Try Catch ex As Exception MsgBox(ex.GetType.ToString & s & ex.Message & s & ex.HelpLink & s & ex.StackTrace & s & ex.Source & s & "The form will be closed") '& s & ex.TargetSite) 'Me.Close() End Try SetEditMode(False) End Sub and the add buttons for keywords ( searchphrase is similar) Private Sub btnAddK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddK.Click If cm.Count > 0 Then Try cmK.AddNew() Me.dsWKS1.Keywords.ActiveColumn.DefaultValue = True Dim frmEditKeyword As New frmEditKeyword With frmEditKeyword .EditKeyword(cmK) .KeywordSetID = Me.KSID .txtKeywordSetID.Text = frmEditKeyword.KeywordSetID .ShowDialog() End With frmEditKeyword.Dispose() Catch ex As Exception MsgBox(ex.GetType.ToString & s & ex.Message & s & ex.HelpLink & s & ex.StackTrace & s & ex.Source & s & "The form will be closed") '& s & ex.TargetSite) Finally End Try Else MessageBox.Show("No Current KeywordSet!", "Add Keyword", MessageBoxButtons.OK, MessageBoxIcon.Error) End If End Sub Here are excerpts from the error message when I click the keyword add button: system.invalidcastexception object cannot be cast from dbnull to other types ... at system.windowsforms.unsafenativemethods.intcreatewindowex ... at fullword.vb line 967 With frmEditKeyword .EditKeyword(cmK) .KeywordSetID = Me.KSID .txtKeywordSetID.Text = frmEditKeyword.KeywordSetID .ShowDialog() End With line 967 is .showidialog. The error message on add searchphrase: ... edit fullword.vb line 991 line 156 is line 988 is .showdialog if i comment out the try..end try lines and show dialog, then when I click addK or addSP I get another row in the respective grid, but can't edit the keyword or searchphrase, because the grid is read-only. However, the edit boxes work fine, even with the .showdialog and without the try..endtry, etc. can somebody help me? dennis Tag: ODBC slow connection Tag: 96423
  - 2
    - Duplicate record with wrong exception I've found my program got exception as follows:- ---------------------------------------------- Exception: System.ArgumentException Message: The SqlParameter with ParameterName 'XXXXX' is already contained by another SqlParameterCollection. Source: System.Data at System.Data.SqlClient.SqlParameterCollection.Validate(Int32 index, SqlParameter value) at System.Data.SqlClient.SqlParameterCollection.AddWithoutEvents(SqlParameter value) at System.Data.SqlClient.SqlParameterCollection.Add(SqlParameter value) at System.Data.SqlClient.SqlParameterCollection.Add(Object value) at GotDotNet.ApplicationBlocks.Data.AdoHelper.AttachParameters(IDbCommand command, IDataParameter[] commandParameters) at GotDotNet.ApplicationBlocks.Data.AdoHelper.PrepareCommand(IDbCommand command, IDbConnection connection, IDbTransaction transaction, CommandType commandType, String commandText, IDataParameter[] commandParameters, Boolean& mustCloseConnection) at GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteNonQuery(IDbConnection connection, CommandType commandType, String commandText, IDataParameter[] commandParameters) at GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, IDataParameter[] commandParameters) at GotDotNet.ApplicationBlocks.Data.AdoHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) ... ---------------------------------------------- when I find out the problem I've found that my database already has that record. So I wondor that why it does not throw exception like another duplicate record something like ".... PK_XXXX ...." (duplication key). I've got this exception in sometimes (the most is SqlException with violation key). Someone may be wonder that why I do not post this to the board at GotDotNet. Because I've already posted it and may be someone in this place can figure out of my problem. Thanks in advance, Thana N. Tag: ODBC slow connection Tag: 96422
  - 3
    - Connection string Dim conn As New SqlConnection Dim comm As New SqlCommand conn.ConnectionString = "Data Source =(local);Initial Catalog=Olympia;Integrated Security=True;" conn.Open() comm.Connection = conn Is there anything wrong with the above codes? Are there any solutions to the stated error? Because when I run the program, I receive the following error, which points to line 4 of the above codes (conn.Open()): "An unhandled exception of type 'System.Data.sqlClient.sqlException' occurred in system.data.dll'. Additional Information: System error." Tag: ODBC slow connection Tag: 96421
  - 4
    - XMLDataDocument question-- appending/removing nodes Hi, I'm porting a VB 6 app to .Net, and wanted to use an XMLDataDocument to store information that had previously been kept in XML Recordsets. Unfortunately, I'm not too familiar yet with .Net's XML Namespace and was wondering if someone could help with something....in the VB 6 application, we would append two extra nodes to the XMLRecordset-- an error message, and error number. Then, when it came time to reconstruct the recordset we'd remove those nodes and go to it. I'd like to do the same thing in .Net, but I'm not sure how to append new nodes to existing XMLDataDocuments, nor how to search for and remove the two nodes when the time comes. I've been reading over the msdn docs but was hoping someone could point me in the right direction, or even paste a little code on how to create and append nodes to an XMLDataDocument, and how to search for particular nodes and remove them? Thanks very much. -Jim Tag: ODBC slow connection Tag: 96417
  - 5
    - DataRelation Using WHERE Clause in sql I am trying to create a DataSet with DataRelations. The problem is I don't want all the rows in the related tables. A sql statement of what I'm looking for is: SELECT ParentTable.*,ChildTable.* FROM ParentTable INNER JOIN ChildTable ON ParentTable.inner_package_size = ChildTable.inner_package_size WHERE ParentTable.Key = 5 Trying to do the ado.net way with seperate querys and DataSet: DataSet ds = new DataSet(); string sql = "SELECT Key,inner_package_size FROM ParentTable WHERE Key=5"; System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sql, conn); da.Fill(ds,"ParentTable"); sql = "Select inner_package_size,cost FROM ChildTable"; da = new System.Data.SqlClient.SqlDataAdapter(sql, conn); da.Fill(ds,"ChildTable"); DataRelation rel = new DataRelation("Relation1", ds.Tables["ParentTable"].Columns["inner_package_size"], ds.Tables["ChildTable"].Columns["inner_package_size"]); ds.Relations.Add(rel); This is a more simple version of the talbes & fields involved. I only want the ChildTable rows that link to the ParentTable. I can't put the field on the Where clause for the child table because I don't know what the inner_package_size field value will be. If I query all for the child table I get exceptions when adding the relation about not all the values have corresponding parent values. Tag: ODBC slow connection Tag: 96413
  - 6
    - Will a connection opened in a using block automatically close before being disposed We are having problems where connections in a connection pool are being exausted. We are using the Microsoft Application Block SQL Helper class and are seeing the failure in the following method: public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters) { if( connectionString == null || connectionString.Length == 0 ) throw new ArgumentNullException( "connectionString" ); using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); return ExecuteNonQuery(connection, commandType, commandText, commandParameters); } } The application is Client/Server and it is difficult to understand why we are running out of resources in the connection pool unless there is something about the using block rather than explicity calling close that may be causing the problem. Tag: ODBC slow connection Tag: 96403
  - 7
    - DateTime data displaying I am getting data from a SQL Server 7 table and binding it to a grid. I have a field that is supposed to represent a date, and two fields that are supposed to represent time. When I look at the grid the date value is just the date (because I guess I didn't enter a time, but just a date), but the time value only displays the date and not the time, but when I look at that column in the Admin it shows that data there with today's date (date I entered the time value). What am I missing here? I just want the time value to be displayed and kept in the time column, and the date to be the only value in the date column. Do I have to do formatting commands on my Select statement to load the data, and on my update and insert statements? I haven't tried that yet, I'm hoping I don't have to, that seems excessive. I'm used to just date, just time, or datetime. Anyway, thanks for any replies in advance. Thad Tag: ODBC slow connection Tag: 96391
  - 8
    - Connection object versus Connection String At work, we have built a Director object that fires off processes. Any number of jobs can be run at the same time through its own Director instance. Currently, there is a philosophical discussion about either passing in a Connection String or a Connection object to the individual processes. I am siding with Connection String, but do not have anything to support this direction over the other. According to books, Connections are pulled from the underlying pool with Open() and released with Close() rather than Object instantiation and Dispose(), so you should still be able to pool with a set of passed objects. Is there anything I am missing that would swing the decision one way or another? -- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA *************************** Think Outside the Box! *************************** Tag: ODBC slow connection Tag: 96390
  - 9
    - shared methods in data access I am noticing that the methods in MS's data application block are all shared. Any implications for performance with this? Seems like if users are sharing methods, we could take some sort of hit if they are accessing the same methods. Thanks, Dan Tag: ODBC slow connection Tag: 96388
  - 10
    - Updating data using DataView Hi all, I am using DataSet to store Sql Server Data in my ASP.Net application and use it in several .aspx forms by saving it in Cache. In one of the forms, I need to filter one of the tables in DataSet and display the result in an Editable grid. I do this by creating a DataView by filtering the table in the DataSet. The problem is saving the data from DataView back to the table in DataSet. Do I need to loop through each row and see what changes have been made or there is an easier way? Thanks. Tag: ODBC slow connection Tag: 96385
  - 11
    - Re: General Network Exception (SqlException) with typed dataset This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C4A6F8.24550B70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Whoops...left out the call stack: " at System.Data.SqlClient.SqlConnection.OnError(SqlException = exception, TdsParserState state)\r\n at = System.Data.SqlClient.SqlInternalConnection.OnError(SqlException = exception, TdsParserState state)\r\n at = System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()\r\n at = System.Data.SqlClient.TdsParser.ReadNetlib(Int32 bytesExpected)\r\n at = System.Data.SqlClient.TdsParser.ReadBuffer()\r\n at = System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32 offset, = Int32 len)\r\n at = System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32 length, Encoding = encoding)\r\n at = System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32 = length)\r\n at System.Data.SqlClient.SqlDataReader.SeqRead(Int32 i, = Boolean useSQLTypes, Boolean byteAccess, Boolean& isNull)\r\n at = System.Data.SqlClient.SqlDataReader.SeqRead(Int32 i, Boolean = useSQLTypes, Boolean byteAccess)\r\n at = System.Data.SqlClient.SqlDataReader.GetValues(Object[] values)\r\n at = System.Data.Common.SchemaMapping.LoadDataRow(Boolean clearDataValues, = Boolean acceptChanges)\r\n at = System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping = mapping)\r\n at System.Data.Common.DbDataAdapter.FillFromReader(Object = data, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 = maxRecords, DataColumn parentChapterColumn, Object = parentChapterValue)\r\n at = System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable, = IDataReader dataReader, Int32 startRecord, Int32 maxRecords)\r\n at = System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 = startRecord, Int32 maxRecords, String srcTable, IDbCommand command, = CommandBehavior behavior)\r\n at = System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 = startRecord, Int32 maxRecords, String srcTable, IDbCommand command, = CommandBehavior behavior)\r\n at = System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)\r\n ------=_NextPart_000_0014_01C4A6F8.24550B70 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.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Whoops...left out the call = stack:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>"   at=20 System.Data.SqlClient.SqlConnection.OnError(SqlException exception,=20 TdsParserState state)\r\n   at=20 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException = exception,=20 TdsParserState state)\r\n   at=20 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()\r\n &nbsp= ; at=20 System.Data.SqlClient.TdsParser.ReadNetlib(Int32 = bytesExpected)\r\n  =20 at System.Data.SqlClient.TdsParser.ReadBuffer()\r\n   at=20 System.Data.SqlClient.TdsParser.ReadByteArray(Byte[] buff, Int32 offset, = Int32=20 len)\r\n   at = System.Data.SqlClient.TdsParser.ReadEncodingChar(Int32=20 length, Encoding encoding)\r\n   at=20 System.Data.SqlClient.TdsParser.ReadValue(_SqlMetaData md, Int32=20 length)\r\n   at = System.Data.SqlClient.SqlDataReader.SeqRead(Int32 i,=20 Boolean useSQLTypes, Boolean byteAccess, Boolean& = isNull)\r\n   at=20 System.Data.SqlClient.SqlDataReader.SeqRead(Int32 i, Boolean = useSQLTypes,=20 Boolean byteAccess)\r\n   at=20 System.Data.SqlClient.SqlDataReader.GetValues(Object[] = values)\r\n  =20 at System.Data.Common.SchemaMapping.LoadDataRow(Boolean clearDataValues, = Boolean=20 acceptChanges)\r\n   at=20 System.Data.Common.DbDataAdapter.FillLoadDataRow(SchemaMapping=20 mapping)\r\n   at=20 System.Data.Common.DbDataAdapter.FillFromReader(Object data, String = srcTable,=20 IDataReader dataReader, Int32 startRecord, Int32 maxRecords, DataColumn=20 parentChapterColumn, Object parentChapterValue)\r\n   at=20 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable,=20 IDataReader dataReader, Int32 startRecord, Int32 = maxRecords)\r\n   at=20 System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 = startRecord,=20 Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior=20 behavior)\r\n   at = System.Data.Common.DbDataAdapter.Fill(DataSet=20 dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, = IDbCommand=20 command, CommandBehavior behavior)\r\n   at=20 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)\r\n</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT size=3D2> </DIV></FONT></BODY></HTML> ------=_NextPart_000_0014_01C4A6F8.24550B70-- Tag: ODBC slow connection Tag: 96384
  - 12
    - General Network Exception (SqlException) with typed dataset This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C4A6F7.E3650D40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I've seen people have this issue before, but it has always been = intermittent for folks. Mine isn't (some students do work, but several = cause the exception every single time). What goes on is that I try to = pull up data on a student, but when DbDataAdaptor.Fill is called, I get = the exception. It's buried so deep, I can't figure out the cause. I'd = even be happy with some nudge in the right direction on where to look, = as it's just too deep in the system for me to figure out. Every single = time I grab the same Here's my code: SqlConnection con =3D null; StudentProfileDS _studentDS =3D new StudentProfileDS(); SqlDataAdapter da =3D null; try { con =3D new SqlConnection(ObjectConnectString); con.Open(); cmd.Connection =3D con; da =3D new SqlDataAdapter(); da.SelectCommand =3D cmd; da.TableMappings.Add("Table", "Detail"); da.TableMappings.Add("Table1", "EnrollmentHistory"); da.TableMappings.Add("Table2", "AtRiskHistory"); da.TableMappings.Add("Table3", "LEPHistory"); da.TableMappings.Add("Table4", "GradesHistory"); da.TableMappings.Add("Table5", "Attendance"); da.TableMappings.Add("Table6", "Schedule"); da.TableMappings.Add("Table7", "Stanford"); da.TableMappings.Add("Table8", "RPTE"); da.TableMappings.Add("Table9", "HFW"); da.Fill( _studentDS ); // Here's where the exception occurs return _studentDS; } catch (Exception ex) { throw ex; } finally { con.Close(); con.Dispose(); con =3D null; da.Dispose(); da =3D null; } ------=_NextPart_000_0006_01C4A6F7.E3650D40 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.2900.2180" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV>I've seen people have this issue before, but it has always been=20 intermittent for folks.  Mine isn't (some students do work, but = several=20 cause the exception every single time).  What goes on is that I try = to pull=20 up data on a student, but when DbDataAdaptor.Fill is called, I get the=20 exception.  It's buried so deep, I can't figure out the = cause.  I'd=20 even be happy with some nudge in the right direction on where to look, = as it's=20 just too deep in the system for me to figure out.  Every single = time I grab=20 the same</DIV> <DIV>Here's my code:</DIV> <DIV><FONT size=3D2> <P>SqlConnection con =3D </FONT><FONT color=3D#0000ff = size=3D2>null</FONT><FONT=20 size=3D2>;</P> <P>StudentProfileDS _studentDS =3D </FONT><FONT color=3D#0000ff=20 size=3D2>new</FONT><FONT size=3D2> StudentProfileDS();</P> <P>SqlDataAdapter da =3D </FONT><FONT color=3D#0000ff = size=3D2>null</FONT><FONT=20 size=3D2>;</P> <P></FONT><FONT color=3D#0000ff size=3D2>try</P></FONT><FONT size=3D2> <P>{</P> <P>con =3D </FONT><FONT color=3D#0000ff size=3D2>new</FONT><FONT = size=3D2>=20 SqlConnection(ObjectConnectString);</P> <P>con.Open();</P> <P>cmd.Connection =3D con;</P> <P></P> <P>da =3D </FONT><FONT color=3D#0000ff size=3D2>new</FONT><FONT = size=3D2>=20 SqlDataAdapter();</P> <P>da.SelectCommand =3D cmd;</P> <P>da.TableMappings.Add("Table", "Detail");</P> <P>da.TableMappings.Add("Table1", "EnrollmentHistory");</P> <P>da.TableMappings.Add("Table2", "AtRiskHistory");</P> <P>da.TableMappings.Add("Table3", "LEPHistory");</P> <P>da.TableMappings.Add("Table4", "GradesHistory");</P> <P>da.TableMappings.Add("Table5", "Attendance");</P> <P>da.TableMappings.Add("Table6", "Schedule");</P> <P>da.TableMappings.Add("Table7", "Stanford");</P> <P>da.TableMappings.Add("Table8", "RPTE");</P> <P>da.TableMappings.Add("Table9", "HFW");</P></FONT><FONT size=3D2> <P>da.Fill( _studentDS );    // Here's where the = exception=20 occurs</P> <P></FONT><FONT color=3D#0000ff size=3D2>return</FONT><FONT size=3D2> = _studentDS;</P> <P>}</P> <P></FONT><FONT color=3D#0000ff size=3D2>catch</FONT><FONT size=3D2> = (Exception=20 ex)</P> <P>{</P> <P></FONT><FONT color=3D#0000ff size=3D2>throw</FONT><FONT size=3D2> = ex;</P> <P>}</P> <P></FONT><FONT color=3D#0000ff size=3D2>finally</P></FONT><FONT = size=3D2> <P>{</P> <P>con.Close();</P> <P>con.Dispose();</P> <P>con =3D </FONT><FONT color=3D#0000ff size=3D2>null</FONT><FONT = size=3D2>;</P> <P>da.Dispose();</P> <P>da =3D </FONT><FONT color=3D#0000ff size=3D2>null</FONT><FONT = size=3D2>;</FONT></P> <P><FONT size=3D2>}</P></FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C4A6F7.E3650D40-- Tag: ODBC slow connection Tag: 96383
  - 13
    - DataSet Merge Fails with no error set in datatables or datarows. ? Hello, I am trying to merge into a dataset and It fails with the following exception. I would like to know what table is causing this problem. It looks like one of the data columns names is the source of the problem. I thought I could catch the merge failed exception but it is not raised. I also check the ds.HasErrors property after the exception is raised and there are no errors set in the dataset. What do I have to do to identify specifically what column in what table in my dataset is causing the problem? I am simply doing this ds.Merge( anotherDataSet ); Here is the error. System.InvalidCastException: Specified cast is not valid. at System.Data.DataColumnCollection.get_Item(String name) at System.Data.Merger.MergeSchema(DataTable table) at System.Data.Merger.MergeTableData(DataTable src) at System.Data.Merger.MergeDataSet(DataSet source) at System.Data.DataSet.Merge(DataSet dataSet, Boolean preserveChanges, MissingSchemaAction missingSchemaAction) at System.Data.DataSet.Merge(DataSet dataSet) at Diversa.DeNovoDataAccessLayer.DeNovoDAC.LoadPeptideItem(String FileName) in d:\cvs_root\denovoviewer2\denovodataaccesslayer\denovodac.cs:line 126 Tag: ODBC slow connection Tag: 96376
  - 14
    - How to pass a table array to an Oracle stored procedure I have an Oracle SPROC which takes as one of its IN parameters a table array (e.g. type charArray is table of varchar2(255)...) How can I call that SPROC and pass it the table array from ADO.NET? Thanks. Tag: ODBC slow connection Tag: 96374
  - 15
    - This type of Filtering possible? The DataTable has a column containing integers. Filtering it as "Where ColName=12" filters fine. Here is the problem. I want to filter the integer column using "Like". For a string column the following will work "Where StrColName Like '12%'". I need the same effect on the integer column. Thanks for any pointers. Tag: ODBC slow connection Tag: 96367
  - 16
    - meaning of max pool size ? I'm having a hard time finding something explicit which indicates whether Max Pool Size is intended to mean 'maximum number of connections within a pool, where distinct connection strings means distinct pools' or 'maximum total number of connections which can be pooled, regardless of how many different strings have resulted in different pools'. Can anyone clarify this for me? The former seems to make more sense. Thanks, Chris Tag: ODBC slow connection Tag: 96365
  - 17
    - hit a design roadblock OK, I am developing a client application that will present data to the user. Nothing fancy. I had intended to retrieve pretty much all the data in a DataSet, then filter and sort locally on the client to cut back on trips to the DB. I also had decided to abstract my data from the DataSet by maintaining collections of business objects that would represent the various records retrieved from the DB. Each business object has a reference to the DataRow in the DataSet that is represents. The class is basically a set of properties to access the data in a typed fashion as well as a collection of methods to simplify interaction with the various records and the many tasks that a user will perform(open files, print, etc, etc) I started development of the migration tool that will migrate our existing database from a flat, binary file format into a relational DB. Basically I parse the binary file, then loop through the records and for each one I create all the required records in the rel. DB and move on, pretty straight forward..... until I realized that my business object are really crippled when not constructed in the context of a Query - When I query the DB, I pass the current DataRow from the result DataSet to the business object constructor, then that object is ready to go. My assessors can safely assume that there is, for example a column named "TakeNr" since "TakeNr" was returned from the original query. I hit a roadblock. When created a business object out of the query context, for example in the migration tool mentioned above, I have not queried the rel. DB yet, so I don't have a DataTable to create a new DataRow from. I found myself creating a DataTable, adding DataColumns(the ones that I could think of) then making a call to DataTable.NewRow() to finally get that DataRow that will hold the data. This whole last step seems really lame. It made me thing that my original approach of having a reference to the base data inside the business object isn't quite as slick and powerful as I once thought it was. I am now in a design tailspin, not sure what to do. If anyone has any thoughts, experiences or tips, please share. Thank You, Steve Klett Tag: ODBC slow connection Tag: 96360
  - 18
    - IErrorInfo.GetDescription failed with E_FAIL(0x80004005) This is a multi-part message in MIME format. ------=_NextPart_000_00A0_01C4A706.62151E10 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am developing a custom application for Microstation v8. My app = connects to an Access database (I haven't yet hooked it up to = Microstation). Within my code I have two very similar functions to query a database for = a particular record. They are: Public Function GetProjCfgFromDb(ByVal lProjID As Long) As String Try 'connection stuff Dim Conn As New OleDbConnection(sConnString & dbFullPath) Dim strSQL As String =3D "SELECT proj_cfg FROM tbl_projects = WHERE proj_id =3D " & lProjID Dim Cmd As New OleDbCommand(strSQL, Conn) Conn.Open() GetProjCfgFromDb =3D CType(Cmd.ExecuteScalar(), String) 'cleanup Conn.Dispose() Conn =3D Nothing Cmd.Dispose() Cmd =3D Nothing Catch ex As Exception MsgBox(ex.Source & ex.Message, MsgBoxStyle.Critical) End Try End Function Public Function GetProjIDFromDb(ByVal sProjCfg As String) As Long Try 'connection stuff Dim Conn As New OleDbConnection(sConnString & dbFullPath) Dim strSQL As String =3D "SELECT proj_id FROM tbl_projects = WHERE proj_cfg =3D " & sProjCfg Dim Cmd As New OleDbCommand(strSQL, Conn) Conn.Open() GetProjIDFromDb =3D CType(Cmd.ExecuteScalar(), Long) 'cleanup Conn.Dispose() Conn =3D Nothing Cmd.Dispose() Cmd =3D Nothing Catch ex As Exception MsgBox(ex.Source & ex.Message, MsgBoxStyle.Critical) End Try End Function =20 =20 This first function is called like this: Dim sProjConfig As String sProjConfig =3D GetProjCfgFromDb(CLng(Me.cboProjects.SelectedValue)) and works perfectly, but the second function is called like this: Private Sub CheckForProject() If IsProcessExecuting("ustation") =3D False Then projectForm =3D New frmProj projectForm.ShowDialog() Else 'process is executing so get the project 'configuration file currently selected 'and set project ID from database oMSTN =3D New MicrostationDGN.Application Dim sConfigName As String sConfigName =3D = oMSTN.ActiveWorkspace.ConfigurationVariableValue("_USTN_PROJECTNAME") lProj_ID =3D GetProjIDFromDb(sConfigName) End If End Sub where = oMSTN.ActiveWorkspace.ConfigurationVariableValue("_USTN_PROJECTNAME") = returns a string (eg "SRA 1957 BGS Lower School"). =20 GetProjIDFromDb() fails ion this line: GetProjIDFromDb =3D CType(Cmd.ExecuteScalar(), Long) I have checked all the obvious things but I cannot see what is causing = the error. Please help Russ ------=_NextPart_000_00A0_01C4A706.62151E10 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.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I am developing a custom application = for=20 Microstation v8. My app connects to an Access database (I haven't yet = hooked it=20 up to Microstation).</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Within my code I have two very similar = functions to=20 query a database for a particular record. They are:</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>    Public Function=20 GetProjCfgFromDb(ByVal lProjID As Long) As=20 String<BR>       =20 Try<BR>           = =20 'connection=20 stuff<BR>          &nbs= p; Dim=20 Conn As New OleDbConnection(sConnString &=20 dbFullPath)<BR>         &nbs= p; =20 Dim strSQL As String =3D "SELECT proj_cfg FROM tbl_projects WHERE = proj_id =3D "=20 &=20 lProjID<BR>          &n= bsp;=20 Dim Cmd As New OleDbCommand(strSQL,=20 Conn)<BR>          &nbs= p;=20 Conn.Open()</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial=20 size=3D2>          &nbs= p;=20 GetProjCfgFromDb =3D CType(Cmd.ExecuteScalar(), String)</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial=20 size=3D2>          &nbs= p;=20 'cleanup<BR>          &= nbsp;=20 Conn.Dispose()<BR>         &= nbsp; =20 Conn =3D=20 Nothing<BR>          &n= bsp;=20 Cmd.Dispose()<BR>         &n= bsp; =20 Cmd =3D Nothing</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial = size=3D2>        Catch ex=20 As=20 Exception<BR>          =  =20 MsgBox(ex.Source & ex.Message,=20 MsgBoxStyle.Critical)<BR>        End=20 Try<BR>    End Function</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>    Public Function=20 GetProjIDFromDb(ByVal sProjCfg As String) As=20 Long<BR>       =20 Try<BR>           = =20 'connection=20 stuff<BR>          &nbs= p; Dim=20 Conn As New OleDbConnection(sConnString &=20 dbFullPath)<BR>         &nbs= p; =20 Dim strSQL As String =3D "SELECT proj_id FROM tbl_projects WHERE = proj_cfg =3D "=20 &=20 sProjCfg<BR>          &= nbsp;=20 Dim Cmd As New OleDbCommand(strSQL,=20 Conn)<BR>          &nbs= p;=20 Conn.Open()</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial=20 size=3D2>          &nbs= p;=20 GetProjIDFromDb =3D CType(Cmd.ExecuteScalar(), Long)</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial=20 size=3D2>          &nbs= p;=20 'cleanup<BR>          &= nbsp;=20 Conn.Dispose()<BR>         &= nbsp; =20 Conn =3D=20 Nothing<BR>          &n= bsp;=20 Cmd.Dispose()<BR>         &n= bsp; =20 Cmd =3D Nothing</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial = size=3D2>        Catch ex=20 As=20 Exception<BR>          =  =20 MsgBox(ex.Source & ex.Message,=20 MsgBoxStyle.Critical)<BR>        End=20 Try<BR>    End=20 Function<BR>    <BR>    </FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>This first function is called like=20 this:</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Dim sProjConfig As = String<BR>sProjConfig =3D=20 GetProjCfgFromDb(CLng(Me.cboProjects.SelectedValue))</FONT></DIV> <DIV> </DIV><FONT face=3DArial size=3D2> <DIV><BR>and works perfectly, but the second function is called like = this:</DIV> <DIV> </DIV> <DIV>Private Sub CheckForProject()<BR> If = IsProcessExecuting("ustation") =3D=20 False Then<BR>  projectForm =3D New=20 frmProj<BR>  projectForm.ShowDialog()<BR> Else<BR> &n= bsp;'process=20 is executing so get the project<BR>  'configuration file = currently=20 selected<BR>  'and set project ID from = database<BR>  oMSTN =3D=20 New MicrostationDGN.Application</DIV> <DIV> </DIV> <DIV>  Dim sConfigName As String<BR>  sConfigName = =3D=20 oMSTN.ActiveWorkspace.ConfigurationVariableValue("_USTN_PROJECTNAME")</DI= V> <DIV> </DIV> <DIV>  lProj_ID =3D GetProjIDFromDb(sConfigName)<BR> End = If<BR>End=20 Sub</DIV> <DIV> </DIV> <DIV><BR>where=20 oMSTN.ActiveWorkspace.ConfigurationVariableValue("_USTN_PROJECTNAME") = returns a=20 string (eg "SRA 1957 BGS Lower School").  </DIV> <DIV> </DIV> <DIV><BR>GetProjIDFromDb() fails ion this line:</DIV> <DIV> </DIV> <DIV>GetProjIDFromDb =3D CType(Cmd.ExecuteScalar(), Long)</DIV> <DIV> </DIV> <DIV><BR>I have checked all the obvious things but I cannot see what is = causing=20 the error.</DIV> <DIV> </DIV> <DIV>Please help</DIV> <DIV> </DIV> <DIV>Russ</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_00A0_01C4A706.62151E10-- Tag: ODBC slow connection Tag: 96355
  - 19
    - Can we insert all data in the DataSet once a time into Sql Server I want to append data into Sql Server from xml file in tree step 1. A user uploads an xml file in a Web Form 2. A Dataset object read the xml file with the ReadXml method. 3. The Dataset append its record into SqlServer one by one in a loop. But can we insert all data in the DataSet once a time into Sql Server? Tag: ODBC slow connection Tag: 96352
  - 20
    - UpdateRule disappears when using WriteXmlSchema Hi, I am writing an app which reads a SQL Server schema, configures a dataset with that information and finally writes the xsd schema to a file. The problem is that the resulting xsd file does not have the "UpdateRule" value, so when I build a new Dataset from that file this value is lost. I use the DataSet.WriteXmlSchema(filename) method to write the file, and the constraints of the relations of the dataSet have appropiate values in the UpdateRule property. Has anyone experienced the same behaviour in this method? Now I am introducing the attributes in the xsd file using the XmlDocument class, which in my opinion is not very elegant. Does someone resolve this issue in other way? Thanks in advandce. Jose Antonio. Tag: ODBC slow connection Tag: 96346
  - 21
    - Informix+ODBC+ADO.NET - problem Hi! I'm developing an application using informix DBMS and .Net. I came across following problem, when I form a query with too many clauses in WHERE part and try to execute it with Fill command I get an exception "Connection is dead". Removing one of the clauses creates no problem at all. I have Informix ODBC drivers ver. 3.33, before that version exception was "Error - no info..". It isn't DBMS problem, because when I'm using non WinSQL with the same query everything works fine. //An example of a query, creating the problem: SELECT k.winien AS konto, SUM(wartosc) AS wartosc_wn, 0 AS wartosc_ma , SUM(wartosc_w_walucie) AS wartosc_wn_wal, 0 AS wartosc_ma_wal, waluta AS waluta FROM ksiega_bis04 k WHERE (k.d_dekretacji < 'A4/01/31' ) AND (k.d_dekretacji >= 'A4/01/01' ) AND (k.winien > '') AND ( stan = '0' ) AND (k.winien BETWEEN '201' AND '202') GROUP BY winien, waluta Thx in advance Marek Aleksander Dabek Tag: ODBC slow connection Tag: 96345
  - 22
    - OracleParameter.IsNullable using VS2003 Question:- If OracleParameter.IsNullable = False and OracleParameter.value = DBNull.Value what does oracle recieve? Bug?:- OracleParameter.Isnullable does not appear with Intellisense, however it can be typed in guy Tag: ODBC slow connection Tag: 96344
  - 23
    - Cannot perform '>=' operation on System.DateTime and System.String I have noticed this problem coming up in newsgroups before I have a slightly different variation on it. I have a dataview (dv) that I am filtering: e.g. strFilter = "EndDateTime >= '" + txtEndDateFrom.Text + "')"; dv.RowFilter = strFilter Now, on my computer and one one of my servers this works fine and the filter filters as requested. However, on our production server, I get the message "Cannot perform '>=' operation on System.DateTime". I've tried many things including having the filter being strFilter = "EndDateTime >= " + Convert.ToDateTime(txtEndDateFrom.Text).ToShortDateString()) + "')"; strFilter = "EndDateTime >= #" + txtEndDateFrom.Text + "#)"; strFilter = "EndDateTime >= #" + Convert.ToDateTime(txtEndDateFrom.Text) + "#)"; strFilter = "EndDateTime >= '#" + Convert.ToDateTime(txtEndDateFrom.Text) + "#')"; For the ones above I tend to get String not recognised as valid datetime. So, I've got 2 servers that'll happily run this code and the production one doesn't. The only obvious difference in these servers is although the production server has the .Net framework installed (same version as the other 2), the production server doesn't have Visual Studio .Net installed on it. I really can't see why this would matter and would rather take the task of installing VS.Net on the server as a last thing to try. So, anyone out there got any suggestions as to why the code runs differently? Thanks, Ieuan Roberts Tag: ODBC slow connection Tag: 96343
  - 24
    - AcceptChanges and IndexOutOfRangeException When using an accept changes on a specific dataset I get an IndexOutOfRangeException (on a column) I added one column and removed some. if i don't remove column on a specific table it works any one got an idea? (i have no constraint on this table) thanks Tag: ODBC slow connection Tag: 96340
  - 25
    - Get the users's permisions for each table Hi, I have a protected Access Database (with different tables) and an user with different permisions for every table. How can I get the user's permisions for every table? Daniel Tag: ODBC slow connection Tag: 96339
- Next
  - 1
    - Occasional error opening a connection I'm using VS.Net 2003 and C# to write an app that connects to an Oracle 9i database. I have a button on a form that takes username/password/service name information, creates a connection string and issues an open command. From time-to-time, I get an error "ora-12154 tns:could not resolve service name". The problem is that it doesn't happen all the time. Any idea's about what may be going on? Here's my code: //Create a string builder to put together the connection string from the user input // Provider=MSDAORA.1;UserID=xx;Password=xx;Data Source=dev9 StringBuilder sb = new StringBuilder(); sb.Append("Provider=MSDAORA.1;User ID="); sb.Append(txtUserName.Text); sb.Append(";Password="); sb.Append(txtPassword.Text); sb.Append(";Data Source="); sb.Append(txtDatabase.Text); try { //Create connection object using the connection string connString = sb.ToString(); oConnection1 = new OleDbConnection(connString); oConnection1.Open(); <==== this line sometimes generates an error //check to make sure the connection was opened if (oConnection1.State == ConnectionState.Open) { //write a status to the display rtbConnect.AppendText("Opened connection \n"); rtbConnect.Refresh(); ... I'm really perplexed why the open command generates an error from time-to-time. The connection string seems to be correct. I can paste it into a test.udl file and it always works. dev9 is declared in my tnsnames.ora file and I have no problems creating ODBC connections using it. Tag: ODBC slow connection Tag: 96334
  - 2
    - SQL Server 7 and ADO.NET I am starting a .NET project and am wondering if anyone has experience with using ADO.NET to access a SQL Server 7/NT server. If so, were there any issues? Tag: ODBC slow connection Tag: 96333
  - 3
    - BeginLoadData EndLoadData LoadDataRow, Events still fire I am trying to figure out how to get the events for a table to NOT fire. Please take a look at the example code below. No matter how I do it the event still fire. What am I doing wrong? Please someone respond, this is killing an arch. design in a application I am working on. DataSet ds = new DataSet(); //FIRST TRY ds.Tables.Add(new DataTable()); ds.Tables[0].RowChanged +=new DataRowChangeEventHandler(Form1_RowChanged); ds.Tables[0].BeginLoadData(); DataRow dr = ds.Tables[0].NewRow(); ds.Tables[0].Rows.Add(dr); ds.AcceptChanges(); ds.Tables[0].EndLoadData(); ds.Clear(); //CLEAR //START SECOND TRY ds.Tables[0].Clear(); ds.Tables[0].BeginLoadData(); dr = ds.Tables[0].NewRow(); ds.Tables[0].LoadDataRow(dr.ItemArray,true); ds.Tables[0].EndLoadData(); Tag: ODBC slow connection Tag: 96328
  - 4
    - Developing using ce Hi I am new to sql server ce and am trying to get my head round how to develop using sql ce as opposed to sql server 2000. I want to develop for hand held devices using windows mobile. The vs.net 2003 ibuyspy compact framework sample runs fine on the handheld when compiled and run. My problem is how to setup a vb.net project which uses sql server ce as backend and how to move/install to handheld when needed. Thanks Regards Tag: ODBC slow connection Tag: 96325
  - 5
    - ExecuteNonQuery() says I have bad SQL Here is the SQL statement that I'm trying to execute INSERT INTO Tbl_NameCharacter(Character, Code) VALUES('Rebel Generic', 'Rbl') My database has a table name 'Tbl_NameCharacter' it has 3 fields, the PK is an autonumber 'CharacterID' the second is a 'text' field named 'Character' and the third is also a 'text' field named 'Code' I don't get it. Here are the details from the OleDbException System.Object {System.Data.OleDb.OleDbError} System.Object Message "Syntax error in INSERT INTO statement." string message "Syntax error in INSERT INTO statement." string NativeError -529993134 int nativeError -529993134 int Source "Microsoft JET Database Engine" string source "Microsoft JET Database Engine" string SQLState "3000" string sqlState "3000" string Any ideas? Tag: ODBC slow connection Tag: 96314
  - 6
    - newbie ~ View or Stored Procedure sql server / ado.net / vb.net What is the better approach to populating a subset of table data to a datagrid or form of controls - a view or a stored procedure? Tag: ODBC slow connection Tag: 96313
  - 7
    - Dataview column values I need to obtain an mean value of Width column in a Dataview. I can walk through the Dataview (see below). How do I extract the values from Width column in the Dataview so they can be added together? Would it be better to use a datatable? If so same question. Dim dt As DataTable = ds.Tables("tblWidths") Dim dvWidths As New DataView(dt) dvWidths.RowFilter = "FishSurveyID = " + Me.FishSurveyIDWidths.Text + "" Dim x As Integer = 0 For Each drv2 As System.Data.DataRowView In dvWidths x += 1 Next Tag: ODBC slow connection Tag: 96312
  - 8
    - Reloading DataSet Hi, What's the best way to reload a DataSet? I have a DataSet object with multiple tables in it, I would like to refresh a table(reloading the data from sql server) in this dataset when a user click a refresh button. Thanks for your help. david Tag: ODBC slow connection Tag: 96310
  - 9
    - webservice deployment problem I have a webservice built and tested on my dev machine (with .net sudio, xp). Everything seems working fine for me in this environment. Then I tried to deploy it (I tried manual copy and setup project) to another server (win2k server with IIS and .net frmwk 1.1 but w/o .net studio). Of course I did not forget to create the application in IIS Manager. The service is world accessible. I can browse it by url http://myserver/myws/myws.asmx I can see the page listing all its service methods in myws. So far so good. But problems come out. I click on one of methods, put a parameter and click 'invoke'. A request is posted to http://myserver/myws/myws.asmx/mymethod But the reponse is "Page cannot be displayed". I also tried http://myserver/myws/myws.asmx/mymethod?param=1 which gets me same error. I also tried to access the web service from a asp.net client. I got an exception (see P.S.). All the stuff I tried above works on my dev box. I am wondering what is wrong. Please offer your thoughts and expertise. Thanks! -Jerry [SoapException: Server was unable to process request. --> Object reference not set to an instance of an object.] System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) .... Tag: ODBC slow connection Tag: 96308
  - 10
    - Raw Excel Export? I have a DataSet with 3 named DataTables. What is the fastest way to create a new workbook and spit each DataTable to a new worksheet? Thanks. Tag: ODBC slow connection Tag: 96295
  - 11
    - Newbie help with Datasets Hello, I am new to this and i am experimenting with Datasets and ADO.NET. I am trying to go smooth so for now so I created all my Adapters and Datasets etc. visually. However when i simply delete one of them from the visual panel, under my form, and then i create another one with a different name, I see that the create-Dataset-wizard list contains as options datasets that were there before but (are supposed to) have been deleted !!!??? Very weird ! Is it a VS 2003 bug? Do I have to go to the VB-generated code and delete them internally? I think this is probably dangerous.... Also, a dataset is a snapshot of a table(s) which does not contain relationship information from the database (?), but the user has to create it explicitly with myDataSet.Relations.Add. If this is true and i want to Bind (and synchronize) a whole bunch of controls, do i HAVE to recreate the relationships explicitly? Then what is the point of accesing a relational database? Thanx for any feedback in advance! -steve Tag: ODBC slow connection Tag: 96294
  - 12
    - system.exception can't open Oracle 10g connection Hi, I am a total loss. I have VS 2002, Microsoft Oracle data provider and Oracle 10g client installed. I am trying to open a connection but keep getting a system.exception error. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. I have Oracle 10g installed! I can't open a connection. It's very frustrating because i have uninstalled, reinstalled the Oracle client and Microsoft Oracle data provider. If anyone has any ideas or help that would be great. Thanks, a very frustrated developer. Tag: ODBC slow connection Tag: 96290
  - 13
    - OleDbConnection does not release Access database I have seen a few threads mentioning this problem, but none of them have offered a solution that works for me. I have an application that creates an OleDbConnection to a Microsoft Access 2003 database. When the application is done with the connection, I call the Close() method on the connection to free up the database resource. After reading other threads, I even added "OLE DB Services=-4;" to my connection string to prevent connection pooling, although I gather that it should have no effect on a local MDB data source. In any case, the application then attempts to move the database file (in preparation for a JDO.CompactDatabase call, which seems to be necessary for some reason), and I get an error because the database file is supposedly still in use. I tried adding calls to OleDbConnection.Dispose() and GC.Collect() in desperation, but nothing seems to work. Here's the offending code: dbConn = new OleDbConnection(); dbConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;OLE DB Services=-4;Data Source=" + dbPath; dbConn.Open(); // // Use the connection here... // // Disconnect from the database dbConn.Close(); Debug.Assert(dbConn.State == ConnectionState.Closed); dbConn.Dispose(); dbConn = null; GC.Collect(); // Prepare to repair the database (due to occasional complex join problems) File.Move(dbPath, "c:\\temp_location.mdb"); <---- ***** Error occurs here ***** Oddly enough, the error indicates that the target file for the move cannot be accessed: The process cannot access the file "c:\temp_location.mdb" because it is being used by another process. I can see that an LDB file is created when I call dbConn.Open, but it does not disappear until the application is closed, no matter what I do to that dbConn object. Does anyone have any suggestions? Thanks, Jon Tag: ODBC slow connection Tag: 96289
  - 14
    - Weird problem in dataset - Bug? Hi all, Visual Studio Enterprise 2003 and DotNet Framework 1.1. I have a strongly typed dataset (generated by the Schema Designer). This dataset has a table called Category and one of the columns in this table is called "ParentCategoryId". There are no explicit relationship set between this column and any other column. Here are some non-contiguous lines of code: MainDS.CategoriesRow r = ds.Categories.NewCategoriesRow(); //create a detached row r.ParentCategoryId = -1; // set the ParentCategoryId....this is the problem column r.CreatedBy = -1; // set the CreatedBy.....this column is perfectly OK. ds.Categories.AddCategoriesRow(r); // Add the row to the table. The problem is when the AddCategoriesRow(r) method is executed, the the value in ParentCateogyId immediately changes to 1 instead of -1. This only happens if the value in this column happens to be equal to or less than zero. Any value < 0 is changed to 1. As long as the value is > 0, everything works as expected. The "CreatedBy" column is identical in characteristics to "ParentCategoryId" column. The above problem does not occur in CreatedBy column. Whatever value I assign to CreatedBy stays put. But not in ParentCategoyId column. I have tried every trick in the book to no avail. I even deleted the table from the schema and re-added the same to force a recompile of the XSD file. The only conclusion I can come to is that there must be some bug in the framework or the column name ParentCategoryId is used internally in ADO.NET which is causing some name conflict or something. Has anybody ever seen this problem before? Any help is highly appreciated. Babu. Tag: ODBC slow connection Tag: 96285
  - 15
    - Adding AutoIncrement column to table does not increment After retrieving a table from SQL. I wanted to add a column to the table with a record id. After retrieving the data and then I add the column and set the following properties: dt.Columns.Add("NewColumn", GetType(Int32)) dt.Columns("NewColumn").AutoIncrement = True dt.Columns("NewColumn").AutoIncrementSeed = 0 dt.Columns("NewColumn").AutoIncrementStep = 1 Nothing happens. I looked through the records for this column and there is nothing there. I am using ADO.NET 1.0 and Visual Studio.NET 2002... I have seen examples for this and I am wondering if its not supported with the earlier version of ADO.NET. Or I am doing something wrong. Thanks. Tag: ODBC slow connection Tag: 96284
  - 16
    - Update Dataset with Access Hi, I used OleDb.OleDbDataAdapter to retrive and modify the access i used merge function to combin another dataset, then update Access DB but i can't update the database by using pDataAdapter.Update(ds_data) the result is always 0 Here is my code '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '' pDataAdapter.SelectCommand = New OleDb.OleDbCommand(Sql, mConn) pDataAdapter.Fill(ds_data) Dim Key1() As DataColumn = {ds_data.Tables(0).Columns("item"), ds_data.Tables(0).Columns("desc")} ds_data.Tables(0).PrimaryKey = Key1 ds_data.AcceptChanges() ds_data.Merge(datainfo, True, MissingSchemaAction.AddWithKey) pDataAdapter.Update(ds_data) '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''' I am not sure what is problem, any suusgestion for updating Access with dataset ??? Thanks Percy Tag: ODBC slow connection Tag: 96282
  - 17
    - DataRelation CaseSensitive String Field I'm creating a DataRelation between two datatables of a single dataset. One of my relationship columns is a string field and I notice that the DataRelation is case sensitive. Therefore, If my parent table contains a record in with a value of 'name' only records in my child table with the value of 'name' will be included in the DataRelation. If the child table has a record with a value of 'Name' this will not be seen or included in the relationship. Is there any way to turn off case sensitivity in the Data Relation? I've gone through and set the CaseSensitive property of the dataset and all it's individual datatables to false before i apply the data relation and that doesn't seem to work. Any help is appreciated. Thanks, -Rick Tag: ODBC slow connection Tag: 96281
  - 18
    - DataBinding to a DataView -- only getting first row This is a multi-part message in MIME format. ------=_NextPart_000_0014_01C4A609.EE559880 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I'm creating my first "real" Windows Forms application. I'm having some = difficulty binding a DataView to my custom control. I can do it just = fine if I bind directly to the DataTable, and it behaves as I want. = (Multiple controls on the screen, each one bound to a different row in = the database.) Essentially, I'm making a datagrid-like interface, but = using textboxes, etc. This code works (code simplified) For iRow =3D 0 To 2 dlg =3D new DataLine.Generic ... Dim cm As CurrencyManager =3D = CType(dlg.BindingContext(TCE.db.TheDataset.Personnel), CurrencyManager) cm.Position =3D iRow Next It works great -- each DataLine (my custom control) is bound to a = different row in the Personnel table. However, when I try to change it to use a dataview instead, which is = pointing at the Personnel table, each data line comes out exactly the = same -- they are all bound to the first row. The view is being filtered = correctly, because when I check the number of rows in the DataView, it = is the smaller number that I am expecting. dv.Table =3D TCE.db.TheDataset.Personnel dv.RowFilter =3D "SubTabID =3D 1" For iRow =3D 0 To 2 dlg =3D new DataLine.Generic ... Dim cm As CurrencyManager =3D = CType(dlg.BindingContext(dv), CurrencyManager) cm.Position =3D iRow Next Any ideas? Does the Currency Manager not support a Position when = connected to a dataview?? Thanks, Beverley ------=_NextPart_000_0014_01C4A609.EE559880 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.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I'm creating my first "real" Windows = Forms=20 application.  I'm having some difficulty binding a DataView = to my=20 custom control</FONT><FONT face=3DArial size=3D2>.  I can do it = just fine if I=20 bind directly to the DataTable, and it behaves as I want.  = (Multiple=20 controls on the screen, each one bound to a different row in the=20 database.)  Essentially, I'm making a datagrid-like interface, but = using=20 textboxes, etc.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>This code works (code = simplified)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>        =  For=20 iRow =3D 0 To=20 2<BR>           &n= bsp;       =20 dlg =3D new=20 DataLine.Generic<BR>        &nbsp= ;          =20 ...<BR>           =         =20 Dim cm As CurrencyManager =3D CType(dlg.BindingContext(<FONT=20 color=3D#ff0000>TCE.db.TheDataset.Personnel</FONT>),=20 CurrencyManager)<BR>        &nbsp= ;          =20 cm.Position =3D=20 iRow<BR>         Next</FONT>= </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>It works great -- each DataLine (my = custom control)=20 is bound to a different row in the Personnel table.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>However, when I try to change it to use = a dataview=20 instead, which is pointing at the Personnel table, each data line comes = out=20 exactly the same -- they are all bound to the first row.  The view = is being=20 filtered correctly, because when I check the number of rows in the = DataView, it=20 is the smaller number that I am expecting.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial color=3D#ff0000 size=3D2><FONT=20 color=3D#000000>        </FONT>&n= bsp;dv.Table=20 =3D TCE.db.TheDataset.Personnel<BR><FONT=20 color=3D#000000>        </FONT>&n= bsp;dv.RowFilter=20 =3D "SubTabID =3D 1"</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT><BR><FONT face=3DArial=20 size=3D2>         For iRow = =3D 0 To=20 2<BR>           &n= bsp;       =20 dlg =3D new=20 DataLine.Generic<BR>        &nbsp= ;          =20 ...<BR>           =         =20 Dim cm As CurrencyManager =3D CType(dlg.BindingContext(<FONT=20 color=3D#ff0000>dv</FONT>),=20 CurrencyManager)<BR>        &nbsp= ;          =20 cm.Position =3D=20 iRow<BR>         Next</FONT>= </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any ideas?  Does the Currency = Manager not=20 support a Position when connected to a dataview??</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>  = Beverley</FONT></DIV></BODY></HTML> ------=_NextPart_000_0014_01C4A609.EE559880-- Tag: ODBC slow connection Tag: 96280
  - 19
    - Retrieving Oracle Procedures ResultSet I'm trying to use fill a table using DataAdapter::Fill with a Oracle procedure or function result. When I call a SP (with a simple select query) from SQLServer I don't put return value on the Command's Parameters. There's any way to do the same with Oracle database, but without passing the Cursor Output datatype. Thanks in advance, JosÃ© Tavares Tag: ODBC slow connection Tag: 96279
  - 20
    - Querying a DataTable Hi, I have the following method, which sends an array of integers to another method. The array is obtained as follows: 1. Select rows from a datatable where boolColumn has been checked in a datagrid. Dim dRows() As dataRow = myDataTable.Select("boolColumn = True", "", DataViewRowState.ModifiedCurrent) 2. Initialize array and set capacity Dim arrayMyInts(dRows.Length) As Integer 3. Populate array by looping through the array of datarows returned by .Select method. For n As Integer = 0 To dRows.Length - 1 arrayMyInts(n) = dRows(n).myDataTableIntColumn1 Next n The datatable has a key that consists of two integer columns, myDataTableIntColumn1 and myDataTableIntColumn2. Therefore, the potential exists that the array I populate in step 3 (arrayMyInts) is going to have some duplicated values in it, as it could be that two or more datarows that are returned by my Select methods criteria will have identical myDataTableColumn1 values. My question: How do I get at only the UNIQUE myDataTableColumn1 values? Can this be done by refining my Select method? Could I query the array to return only unique values? Any suggestions would be great. Thanks. John Tag: ODBC slow connection Tag: 96272
  - 21
    - Editing still possible when AllowEdit = False I'm using a bound control, a textbox bound to a column in a dataview. Despite setting the AllowEdit property to False, changes in the text in the textbox are saved to the dataview and underlying dataset. When using the update command of the dataadapter these changes are saved to the database. When editing a value in code AllowEdit has to be set to True. So AllowEdit seems not to work for bound controls, Is this true or am I missing something. I find it rather strange that when AllowEdit = False you can still edit values in the dataview table Thanks Erik Tag: ODBC slow connection Tag: 96271
  - 22
    - DataColumn Expression returns rows on XP, but not Win2K? I'm at a complete loss on this problem. I'm using a DataColumn = Expression with the DataTable Select method to return rows matching a = data. Rows are returned on my Windows XP Professional computer at home, = but no rows are found on the client's Windows 2000 computers. I have checked the regional settings' date format on both machines, and = they are identical. The expression used in both locations are = identical, and the data used in both locations are identical. Here is the code: 01: string expr =3D "FileName LIKE '" + pattern + "*'"; 02: string latestFileDate; 03: latestFileDate =3D dtFiles.Compute("MAX(LastModified)", = expr).ToString(); 04: expr =3D expr + " AND LastModified =3D #" + latestFileDate + "#"; 05: DataRow[] foundRows =3D dtFiles.Select(expr); 06: string latestFile =3D foundRows[0]["FullPath"].ToString(); DataTable dtFiles contains a list of files with information in four = columns; FileName, FileSize, LastModified, and FullFilename (includes = path). Let's say the files are all files with the ".log" extension. = Let's say string pattern equals "KB". String expr is first used on line 03 to obtain the last date and time = any log file beginning with "KB" was modified. On line 04, I append the computed date and time onto String expr as an = additional filter on the LastModified column. Line 05 ALWAYS returns one row at home, on Windows XP, but no rows are = returned on the client's Windows 2000 computers. String expr is = identical on Line 04, on both computers. Any help is greatly appreciated. - carl Tag: ODBC slow connection Tag: 96268
  - 23
    - Cannot change ReadOnly property for the expression column Hello All. I am using a strongly typed data set in a C# application. Some of the tables contain columns that are computed values by means of the Expression attribute in the data schema. I get the above exception on an update via the data adapter. I have seen some references to this problem as a known bug with work arounds but none seem to work (I have tried erasing the expression, doing update then re-adding expression and also deleting the column doing update and re-adding it to the table after execution with little success). Please note that some columns are referenced via Parent() expressions in child tables. My question is this, Is there a recommended work around for this issue (if it is indeed an issue)? Thanking you all in advance Aido. (Extremely disillusioned .NET hacker). Tag: ODBC slow connection Tag: 96260
  - 24
    - Connet to SQL Server? I am a newbie to both .Net and Sql Server and I am trying to access the database by using the ADO.Net data reader. This is actually one of the execises in a book that I am reading. However, when I run this program, there is an error saying that "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection." Are there some settings I have to change in the Sql Server? Please help me! //-------------------------------------------------------------- using System; using System.Data; using System.Data.SqlClient; class MyApp { static void Main() { try{ SqlConnection conn = new SqlConnection("server=localhost;uid=sa;pwd=;database=pubs"); conn.Open(); SqlCommand comm = new SqlCommand("select * from titles", conn); SqlDataReader reader = comm.ExecuteReader(); while(reader.Read()) Console.WriteLine(reader.GetString(1)); conn.Close(); } catch(Exception e){ Console.WriteLine(e.Message); } } } //-------------------------------------------------------------- Tag: ODBC slow connection Tag: 96258
  - 25
    - Connection pool in WinForms app using Data Access Block is exhausting I have an application that is using Microsoft's Data Access Application Block in a WinForms Client/Server configuration. Recently, we have been having problems where an application is timing out and throwing an error stating that the connection pool is exhausted, requiring a restart of the application. Is there a bug in the Application Block? Tag: ODBC slow connection Tag: 96257

Hi,
in my ASP.NET application I've a problem with an ODBConnection.
It is very slow (about 30 seconds) on first connection.
I've tryed differents DBMS, postgres and sql server.

Do you have any idea or suggestion?

thanks in advance and sorry for my english.
Franco

Top

Re: ODBC slow connection by William

William
Fri Oct 01 13:59:20 CDT 2004

I expect ODBC is having trouble resolving the location of the server and
establishing the conversation. How are you connecting?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Franco" <frtorrin@tin.it> wrote in message
news:ermuVd5pEHA.2032@TK2MSFTNGP10.phx.gbl...
> Hi,
> in my ASP.NET application I've a problem with an ODBConnection.
> It is very slow (about 30 seconds) on first connection.
> I've tryed differents DBMS, postgres and sql server.
>
> Do you have any idea or suggestion?
>
> thanks in advance and sorry for my english.
> Franco
>

Top

Re: ODBC slow connection by Franco

Franco
Tue Oct 05 06:12:45 CDT 2004

I'm using this connection string:
Driver=PostgreSQL;Server=192.168.0.33;Port=5432;Database=testdb;UID=postgres;PWD=;

I'm working on Windows XP SP2.
The problem does not apper installing web application on Windows 2003 Server
Web Edition.
I will try to install it on Windows 2000 Server Standard + .Net framework.

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> ha scritto nel
messaggio news:O7IoDj%23pEHA.3592@TK2MSFTNGP09.phx.gbl...
>I expect ODBC is having trouble resolving the location of the server and
>establishing the conversation. How are you connecting?
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "Franco" <frtorrin@tin.it> wrote in message
> news:ermuVd5pEHA.2032@TK2MSFTNGP10.phx.gbl...
>> Hi,
>> in my ASP.NET application I've a problem with an ODBConnection.
>> It is very slow (about 30 seconds) on first connection.
>> I've tryed differents DBMS, postgres and sql server.
>>
>> Do you have any idea or suggestion?
>>
>> thanks in advance and sorry for my english.
>> Franco
>>
>
>

Top