Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers

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
    - BUG? OleDb AccessMdb Localization I think I found a bug in .NET 1.1 using the OleDb classes using: .NET 1.1 Access MDB file (2000 format) Localization set to Dutch (or probably any localization where the , is used for decimal and . is used for thousands) steps to reproduce problem: Create a OleDbCommand with a sql statement like INSERT INTO [TABLENAME] ( [DECIMALFIELDNAME] ) VALUES( ? ) Then use the Parameters.Add on the OleDbCommand to add a number for the ? variable, that uses a decimal. For example 2.75m After the insert executed the record appears as if no decimal sign was there, in this case it would be 275 instead of 2.75 probable cause: I think oledb (or access?) expects the value in local format, while OldDbCommand.Parameters supplies the InvariantCulture version. Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74770
  - 2
    - Object reference not set to an instance of an object What's wrong with this code? it would work perfect in vb. VB.net seem to be filled with error triggers... <script language="VB" runat="server" src="/scripts/main_lib.vb"></script> <script language="VB" runat="server"> Public PollMode As string = "vote" ' ***** the code below fails as object reference not set! Public urlRedirect As String = Request.ServerVariables("SCRIPT_NAME") </script> Please help. Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74753
  - 3
    - filtering child records How can you get the child records of a master record and then further filter the returned array down to more specific records? For instance, I search the array containing the child records for rows that have a value of "Today" in the Date column. I then want those identified rows copied to another array. Thanks for all responses. Regards, Martin Williams Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74752
  - 4
    - Unleash XML support from native Oracle Database driver Download Oracle Data Provider for .NET (ODP.NET) (http://otn.oracle.com/tech/windows/odpnet/index.html) today to empower your .NET applications with the Oracle Database! Try out the new features for XML support like: - Store XML data natively in the database server as the Oracle database native type, XMLType. - Access relational and object -relational data as XML data from an Oracle database instance into Microsoft .NET environment, process the XML using Microsoft .NET framework - Save changes to the database server using XML data. - Apply XSL Transformations while querying and retrieving relational data as XML from Oracle 8i or higher database into .NET Developers get started, learn about ODP.NET XML support features using comprehensive sample applications available at http://otn.oracle.com/sample_code/tech/windows/odpnet/index .html For providing feedback please use discussion forum at ODP.NET: http://forums.oracle.com/forums/forum.jsp? forum=146 Sample Code: http://forums.oracle.com/forums/forum.jsp? forum=133 Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74750
  - 5
    - Problem w/ SQL server's default value Hi all, I have a problem when creating a new record in SQL database when the column is Non-Nullable w/ default value. What I did was create SqlDataAdapter and DataSet, filled the DataSet w/ data AND schema. However, when I try to create a record with those default columns empty (i.e. not assigning value to them), the Update method of Adapter raises an exception that I am trying to creating a record w/ the non-nullable column set to null, even tho I have create a default value for them in Sql server. Any help would be appreciated. Calvin Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74748
  - 6
    - SqlServer: How to know if a a column is a primary key ? I have a database-generic application. CommandBuilder is not satisfactory. I try to generate my own command automatically but: I can't get PrimaryKey information ! I create a IDbCommand cmd;. cmd.CommandText = SELECT * FROM Table IDataReader dr = cmd.ExecuteReader(CommmandBehavior.SchemaOnly) and then I analyse dr.GetSchemaTable() the column "IsKey" is always set to DBNull.Value, at last on the PocketPC (with the compact framework) I know there is plenty of meta table in SqlServer. which one should I query to get primary key information ? Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74737
  - 7
    - SqlServer schema table erroneous ? I have a very basic test SqlServer table: Key ID Name DataType X id_0 int X id_1 int id_3 char I use the DataReader's method: GetSchemaTable() to get this information from the database in my .NET program (on the PPC, I use the compact framework) the column "IsIdentity" seems to be correctly filled. whereas the column "IsKey" seems to be not in fact I run the method in the debugger, querying manually all the column, I have no particular info on the "id_0" column, absolutely no way to know it's a primary key column !.... is it a bug of SqlServer in general ? or on the Compact frameqork in particular ? is there an other way to know a column is a primary key ? Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74734
  - 8
    - to make datetime nullable Dear all, how can i pass an null or empty-value to datetime object? I need to use a datatable to update an oracle table, and the datatable contains a datacolumn, e.g. orderdate, which is of type datetime. Any suggestion will be appreciated. Alex Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74733
  - 9
    - Importing XML data into SQL Server table. I just converted an Access 2002 application into VB.NET (don't ask). VBA in Access has a nifty command for importing XML into an Access table called, unsurprisingly ImportXML(). It works like this: Application.ImportXML ([XML Filename]). The table name is a field in the .xml file. So, my question is, how do I do this in VB.NET using ADO.NET into SQL Server? There's a DataSet command called ReadXml that (supposedly) loads a DataSet with data from a .xml file. But how do I save that data in my SQL Server database? I've tried this: Dim da As DataAdapter = New DataAdapter("SELECT * FROM [tblName]", sqlDBConn) Dim ds As New DataSet ds.ReadXml([XML Filename]) da.Update(ds) ...to no avail. And I've tried: Dim da As DataAdapter = New DataAdapter("SELECT * FROM [tblName]", sqlDBConn) Dim ds As New DataSet Dim dt As DataTable = ds.Tables.Add"([tblName]") ds.ReadXml([XML Filename]) da.Update(ds) ...also to no avail. Please help. Thank you. Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74732
  - 10
    - Bulk Copy Does ADO .NET have a feature like BCP? Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74712
  - 11
    - Oracle stored procedure from ADO.NET Hi All, Here is the oracle sp... procedure budget_report(report_cursor out rdsrefcur.genrefcur, report_teva_id varchar2, report_year number, report_start_month number default 1, report_end_month number default 12) ************************************************************************* Here is the vb code... Dim cn As New OleDbConnection("connect string") cn.Open() Dim cm As New OleDbCommand cm.Connection = cn cm.CommandType = CommandType.StoredProcedure cm.CommandText = "TN_ADMIN.REPORTS.BUDGET_REPORT" Dim parmReport_id As New OleDbParameter parmReport_id.DbType = DbType.AnsiString parmReport_id.Direction = ParameterDirection.Input parmReport_id.ParameterName = "report_id" parmReport_id.Value = "A001987" Dim parmReport_year As New OleDbParameter parmReport_year.DbType = DbType.Double parmReport_year.Direction = ParameterDirection.Input parmReport_year.ParameterName = "report_year" parmReport_year.Value = 2003 Dim parmReport_start_month As New OleDbParameter parmReport_start_month.DbType = DbType.Double parmReport_start_month.Direction = ParameterDirection.Input parmReport_start_month.ParameterName = "report_start_month" parmReport_start_month.Value = 2 Dim parmReport_end_month As New OleDbParameter parmReport_end_month.DbType = DbType.Double parmReport_end_month.Direction = ParameterDirection.Input parmReport_end_month.ParameterName = "report_end_month" parmReport_end_month.Value = 11 cm.Parameters.Add(parmReport_id) cm.Parameters.Add(parmReport_year) cm.Parameters.Add(parmReport_start_month) cm.Parameters.Add(parmReport_end_month) Dim rdr As OleDbDataReader = cm.ExecuteReader DataGrid1.DataSource = rdr DataGrid1.DataBind() cn.Close() ************************************************************************* When I run this thing I get... ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'BUDGET_REPORT' ORA-06550: line 1, column 7: PL/SQL: Statement ignored ************************************************************************* Does anyone have any idea what is wrong? This thing is driving me nuts. Thanks, Jeff Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74710
  - 12
    - Initializing ADO.Net SQL connection in Windows Service. I am trying to initialize an ADO.Net SQL connection to an sql server in my Windows service and I'm getting the following exception while trying to initialize the SqlConnection Object. The language is C#. System.ArgumentException: Unknown connection option in connection string: user. at System.Data.SqlClient.ConStringUtil.ParseStringIntoHashtable(String conString, Hashtable values) at System.Data.SqlClient.ConStringUtil.ParseConnectionString(String connectionString) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at NotifyExpiredResume.NotifyExpiredResume.OnStart(String[] args) in c:\documents and settings\carlo razzeto\my documents\visual studio projects\notifyexpiredresume\expiredresume.cs:line 111 Here is what my connection string looks like and initializer looks like: private string ConnectionString = "Data Source=(local); User=sa; Password=****; Initial Catalog=JobSite"; public SqlConnection SQLConnection; try { SQLConnection = new SqlConnection(ConnectionString); } catch(Exception ex) { EvntLog.WriteEntry("There has been an exception trying to init SQLConnection:\n" + ex.ToString(), EventLogEntryType.Error); EvntLog.Dispose(); return; } Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74698
  - 13
    - ADO.NET Behavior Hello, I am developing a web-based application for filtering rows of data in a datagrid and am running into a problem with deployment of the app. The application has a DropDownList that is populated from an SQLReader from a SQL 2000 Database. Once an item is selected from the DropDownList, the web site performs a postback then populates a DataGrid from another SQLReader that is filtered on the SelectedItem.value from the DropDownList. It is a fairly simple application and it works fine on my test box. However, when I copy the project to the server and try to execute it, the DropDownList does not populate, it is just blank, I do not get any warnings, errors, etc... My Machine is a 3.2Ghz, 1GB Ram, Windows XP Pro SP1 with Visual Studio .NET 2003, Framework 1.1. It also has an installation of Macromedia ColdFusion 5 Server, but that is not used often. It also has VirusScan 7.1 Enterprise for Scanning. The server is Dual 1Ghz with 2GB Ram, Windows 2000 server, .NET Framework 1.1, and ColdFusion 5 Server. Unlike my box, this version of ColdFuction is highly utilized. It also has VirusScan 4.5.1 for Scanning. I am stumped since the configurations are so similar. Also both boxes are at the latest system patches and have ADO 2.7 SP1 and the Microsoft SQL 2000 Client tools installed. If anyone has any ideas, I would greatly appriciate any input. Thanks in advance, Nathan The server Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74696
  - 14
    - Many records in ADO.NET Hi ! Has anyone any idea how can I do paging with ADO.NET, or any other way. I want to use it in a project that it has to load approx. 9000 records and they would grown up. Chris Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74694
  - 15
    - This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row. I receive this message when I try to execute a valid delete command against a dataset for which I have marked a row as Deleted. I have been struggling with this for a couple of days, and every bit of the documentation say that it should work. The sql is generated with an OleDbCommandBuilder object and populated using the original values of the columns in the row to delete (like this:) System.Guid linkToID = (System.Guid) curLinkRow[0]["LinkToID", DataRowVersion.Original]; . . . objectObjectsAdapter.DeleteCommand.Parameters["@p3"].Value = linkToID; Anyone found a way around this? Scott Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74681
  - 16
    - How to get list of all databases on a SQL Server? Can anyone tell me how to query a SQL Server for a list of the databases hosted by that server? Also, is there a method in the .Net Framework to query the network for a list of SQL Servers that are available? Thanks! Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74676
  - 17
    - Thoughts/advice on select optimizations I'm looking for thoughts/advice on how to build the fastest search + (paged) results-page in an .NET + SQL Server 2000 environment. I hope this is the proper group for this, otherwise i appologize for the spam. I have one table with around 100.000 records containing some text fields. What i need to do is free-text search through these records, and return a paged result to the client. The user should be able to select which field to sort by. I'm estimating 10.000 concurrent users on the system. My initial approach to this would be to do the initial search once (selecting records using a full-text indexing), and throw the result into a TEMP table. Each paged result the user requests would then be taken from this table, using DataAdapter.Fill(DataSet, startRecord, numberOfRecords) I am, however, not sure if this is the right approach. Not using a TEMP table would probably increase performance on the first results page, but I would assume the TEMP table helps decrease system load a lot on subsequent page requests. Also, I'm not completely sure if DataAdapter.Fill with startrecord, numberofrecords does only transfers the selected records to the web server, or if the entire resultset is transfered to the webserver, and the dataset THEN populated with the selected records. Does anyone have any thoughts on the best way to implement a system like this? Cheers, Thomas Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74671
  - 18
    - More XML Miha, First, thanks for your help. Without it, I would still be running in circles. I created the date datatypes as varchar(10) in the dataset. Of course in the table they are datetime. The problem I am having is I cannot get the dates to insert. All it does is put in null values. The XML document looks fine. Below is a date row that inserts as a null instead of a date. <LastPaidDate>06/19/2000</LastPaidDate> How much is this appreciated???? Well, if I ever get married again, you can dance at my wedding. How is that? J Thanks so much, Roy Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74669
  - 19
    - System.Data.OracleClient Problem: Could not create an environment: OCIEnvCreate returned -1 Below is the error message I am receiving on a production server with the Oracle 9.2 client installed. However, on a Oracle 9.0 client installation on the development server the problem does not occur. System.Exception: Could not create an environment: OCIEnvCreate returned -1. This occurs when trying to connect. using System.Data.OracleClient this.connection = new OracleConnection("Data Source=" + ConfigurationSettings.AppSettings["db_orac"] + ";User ID=" + ConfigurationSettings.AppSettings["db_user"] + ";Password=" + ConfigurationSettings.AppSettings["db_pass"] + ";"); this.connection.Open(); this.command = new OracleCommand(); this.command.Connection = this.connection; ds = new DataSet(); command.Parameters.Clear(); command.CommandText = "MyTableSpace.MyPackage.get_list"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new OracleParameter("io_cursor", OracleType.Cursor)).Direction = ParameterDirection.Output; this.da = new OracleDataAdapter(this.command); this.da.Fill(ds,"List"); this.connection.Close(); I am desperately trying to find a solution. Any help would be much appreciated!! Regards, Ben Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74667
  - 20
    - Unspecified error: E_FAIL(0x80004005) I apologize for the duplicate post in Data Access NG. I get Unspecified error: E_FAIL(0x80004005) when trying to update Deleted and Modified Dataset records using the OleDB Command Builder. I have been successful with insert objects. The target database is DB2/400 with Client Access v5r2. Here is the partial code: dr = dsAs400.Tables("RSSC").Select("SCID = " & ScId) ''Resulting array length = 1 dr(0)("NAME") = "TEST" cnAs400.Open() Try Dim cmdBuilder As New OleDbCommandBuilder(daRssc) daRssc.UpdateCommand = cmdBuilder.GetUpdateCommand daRssc.Update(dsAs400, "RSSC") Catch ex As Exception Console.WriteLine(ex.Message) End Try cnAs400.Close() Thanks for any help. Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74666
  - 21
    - Row deletion and DataRowVersion.Original Sort of a newby question... I have a read only list view that is populated with information from a dataset. If the user selects a listview item and presses the delete button, then the item is removed fromt he list, and the underlying dataset is marked as delete (all conditional and error checking has been removed for this post): expr = "RelationshipName ='" + relationshipName + "' AND LinkFromID = '" + linkFromID + "' AND LinkToID = '" + linkToID + "'"; DataRow[] rows = this.objectObjectsTable.Select(expr, relationship.LinkFromIDColumn, DataViewRowState.Unchanged); rows[0].Delete(); According to all of the ADO.NET references I have seen, this does not physically remove the data from the dataset, but simply marks its RowState as deleted. And true to its word, when I interogate it in the quick-watch window, it is marked as deleted. Later in the session, I want to update the database to reflected the deleted row. This is done as follows: .. Method Name .. curTable = this.dataSet.Tables[relationship.TableName]; curAdapter = new OleDbDataAdapter(); OleDbCommand deleteCmd = this.deleteRelationshipCmds[0]; deleteCmd.Connection = oleDbConnection; deleteCmd.Transaction = dbTransaction; curAdapter.DeleteCommand = deleteCmd; DataView relationshipView = new DataView(curTable, "", "", DataViewRowState.Deleted); IEnumerator enumRelationships = relationshipView.GetEnumerator(); while (enumRelationships.MoveNext() && !bAbort) { DataRowView curRelationshipView = (DataRowView) enumRelationships.Current; objUpdateRows[0] = curRelationshipView.Row; try { if(objUpdateRows[0].RowState == DataRowState.Deleted) { curAdapter.DeleteCommand.Parameters.Add(relationship.Name, objUpdateRows[0][relationship.Name, DataRowVersion.Original]); curAdapter.DeleteCommand.Parameters.Add(relationship.LinkFromIDColumn, objUpdateRows[0][relationship.LinkFromIDColumn, DataRowVersion.Original]); curAdapter.DeleteCommand.Parameters.Add(relationship.LinkToIDColumn, objUpdateRows[0][relationship.LinkToIDColumn, DataRowVersion.Original]); } rowCount += curAdapter.Update(objUpdateRows); } catch { ... } } The building of the delete statement is done like this: private static OleDbCommand GenerateDeleteCommand(Elsinore.Engine.ClassRelationship objRelationship) { OleDbCommand cmd = null; if (objRelationship != null) { string relationshipTableName = objRelationship.TableName; if (relationshipTableName != null && relationshipTableName.Length > 0) { if (objRelationship.TableName == "Object_Objects") { string sqlText = "DELETE FROM " + Constants.DbOwner + Constants.DbEscapePrefix + Constants.DbNamePrefix + objRelationship.TableName + Constants.DbEscapeSuffix; sqlText += " WHERE RelationshipName=? AND LinkFromID=? AND LinkToID=?"; cmd = new OleDbCommand(sqlText); cmd.Parameters.Add("@p1", OleDbType.Char, 64, "RelationshipName"); cmd.Parameters.Add("@p2", OleDbType.Guid, 16, "LinkFromID"); cmd.Parameters.Add("@p3", OleDbType.Guid, 16, "LinkToID"); } } } return cmd; } So, what I want to do is during the OleDBAdapter.Update call, is remove the rows that are marked as Deleted. Since the current version of the Row's ItemsArray is inaccessible (I assume because it is marked as deleted), then I ask each column in the row to return me the original version of the data for which I can manually add as parameters to my delete command. Alas, this does not work, the original version of the row does not support access to the items array. So, does anyone have a suggestion about this problem that they could share with me? Thanks in advance. Scott Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74665
  - 22
    - Building parameters type conversion question. Im attempting to use the datareader.getschema table in order to create the schema table which supposedly produces a reference to the essential values. I will be able to map most of the SQLparameters using the values from the "DataType" and ColumnSize" but will not be able to differentiate between the char and nchar, varchar and nvarchar, and text and ntext values. I notice the "ProviderType" column probably refers to the sql data type and hesitate to use it for fear of changes down the road. Any way to truly map the required SqlParameter.dbtype or sqlparameter.sqldbtype from the datareader.getschema values or from a datatable created with fillschema using a dataadapter? Any info appreciated. Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74662
  - 23
    - Executing Master Stored Procedures I am going to run of the "Master" stored procedures, say "sp_sproc_Columns". It has a parameter with a datatype of "sysname". What exactly do I map this column to in the SqldbType? If some parms are set up in the procedure as accepting nulls, do I have to create an entry in the command.Parameter collection for these parms if I do not plan to pass any values? Thanks in advance for your assistance!!!!!!!! Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74661
  - 24
    - Problem with DBNull values for binary images Hi ! I´ve this code in my application for checking null values when inserting a [BinaryArray] (picture) into my SQL DB: If (ImageFile.PostedFile.ContentLengt =< 0) then sqlCommand.Parameters.Add("@Bild", sqlDbType.Image).Value = System.DBNull.Value Else sqlCommand.Parameters.Add("@Bild", sqlDbType.Image),Value = byteData End If I get a errormessage. Any suggestions how to solve this I would be much greatful..! The code works fine if I apply it to ordinary textfields controls like name.txt but not with the ImageFile - Why ? OM "Myggan" *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74657
  - 25
    - An error occured after loading the page when i use the RequiredFieldValidator object... i tried to use RequiredFieldValidator the page gives a alert after loding.. alert("Unable to find script library '/aspnet_client/system_web/1_0_3705_288/WebUIValidation.js'. Try placing this file manually, or reinstall by running 'aspnet_regiis -c'."); i have located the folder "aspnet_client" at desired location, but nothing is changed. i couldn't run the "aspnet_regiis -c" command from the command line from c:> what is the problem ? thanx... Sedat Eyuboglu www.bestflashdesigns.com www.18reklam.com Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74654
- Next
  - 1
    - Possible bug in AdomdDataReader?? Hi, I'm having problems with the AdomdDataReader's Read() Method. I'm trying to get a large query back from a cube and it seems to blow up after it reads a large amount of records(between 2,221,588 - 2,221,592 usually). The exception I got was this: Index was outside the bounds of the array. Here's the stack trace I got out of the exception: " at System.Xml.XmlScanner.GetChar(Int32 offset) at System.Xml.XmlTextReader.SetElementValues() at System.Xml.XmlTextReader.ParseElement() at System.Xml.XmlTextReader.Read() at Microsoft.AnalysisServices.AdomdClient.XmlaXmlTextReader.Read() at System.Xml.XmlReader.MoveToContent() at Microsoft.AnalysisServices.AdomdClient.XmlaXmlTextReader.MoveToContent() at System.Xml.XmlReader.IsStartElement() at Microsoft.AnalysisServices.AdomdClient.XmlaXmlTextReader.IsStartElement() at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.SequentialReadXmlValue(Int32 ordinal) at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.GetRowXmlValues(Object[] xmlValues) at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.Read() at Microsoft.GotDotNet.MdxWorkbench.MainForm.btnAdoReaderDbg_Click(Object sender, EventArgs e) in c:\\documents and settings\\troyb.firesteel\\desktop\\mdxworkbenchnet\\cubebrowser\\mdxquery.cs So I went in with Anakrino and decompiled the System.XmlScanner.GetChar(Int32 offset) method which has a single line of code: return this._achText[offset - this._nAbsoluteOffset]; Where _achText is a char[] that I believe is causing the exception. Here's my code snippet: object[] objects=new object[adoreader.FieldCount]; this.m_numRecs=0; //Read our results try { while(adoreader.Read()) //Line where exception occurs { adoreader.GetValues(objects); StringBuilder sb=new StringBuilder(); foreach(object o in objects) { if(o==null) { sb.Append("(null)"); } else { sb.Append(o.ToString()); } sb.Append(","); } //Remove last comma from the string sb.Remove(sb.Length-1,1); //Write the string out to disk sw.WriteLine(sb.ToString()); this.m_numRecs++; } } catch(Exception ex) { string zz=ex.Message; } adoreader.Close(); Basically I'm taking a row from the AdomdDataReader and writing it out to a comma delimited file because the results I receive will be too big to fit into memory all at once. I believe I'm using the latest beta build of AdoMD.Net dated 6-18-03. At first I thought it was our data, but I'm seeing different values for the number of records I'm at when it exceptions at the adoreader.Read() method. Anybody have any ideas or know of a bug in the adomddatareader that might be causing this ? Thanks, Troy Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74652
  - 2
    - DataGrid Cell: Custom Font/Backcolor/Format cell by cell (VB.NET) Hi, I'm looking for a nice way to format the cell of my datagrid according to some predefined 'rules'. I found a lot on the site of George shepherd, but it wasn't really what I was looking for: I found there: How can I change the font used in a Gridcell on a cell by cell or row by row basis. Wih this code I am able to change the Font/Background/... based on the position of the field (column and row). The problem is: it only changes the font etc, and not the format of it. http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp#q927q Another usefull thing: How can I perform custom formatting on the cells in my datagrid: This changes the format of a cell: like "1234" becomes "12-34" and stuff like that. http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp#q881q BUT (and now it comes): I'm not able to make something liek a 'merge' of these two things. What I actually need is being able to change Font, Backgroundcolor, Format, etc based on the entire row!! For example: If the value in one field is zero, another Field has to get marked in a specific Color (in the same record offcourse). Anybody got any idea? Or better: A nice working example, or somewhere a Class that takes care for all this stuff. Thanks a lot in advance! Pieter Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74647
  - 3
    - Ole Db Hi all folks When does this Ole Db message error occur???? <<The given type name was unrecognized>> Regards Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74646
  - 4
    - Writing XML Hi All, I am using a typed dataset to write XML to a document. I have two issues that need resolving. 1. The command : ds.name = "root" results in <root xmlns="http://www.tempuri.org/dsAPPAR.xsd"> Is there any way to have it write <root> without the = etc? 2 I am populating the dataset using a datarow. The data is coming from a text file. I populate a date column as follows: Note: ssb is a string builder and sline is a string holding the line of text ssb.append(sline.substring(198,2) & "/" ssb.append(sline.substring(200,2) & "/" ssb.append(sline.substring(196,2) & "/" ssb.tostring would return the following: mm/dd/yyyy dr.PaidThruDate = ctype(ssb.tostring,date) In the XML documents the date would appear as: <PaidThruDate>2000-06-19T00:00:00.0000000-05:00</PidThruDate> I need it to be 06/19/2000. I cannot tell you how much I would appreciate an answer to these two issues. Thanks, Roy Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74642
  - 5
    - ADO.NET and single quotes not being handled Hi, Got a question for you all regarding ADO.NET and single quotes ? I am creating stored procedure parameters, assigning them to a ADO Command object then executing the Stored Procedure. All works wonderfully, but when I need to insert the line: US,Chicago O'Hare Airport-Ord,IL It complains about the single quote in O'Hare. Now I know ADO.Net is supposed to handle this for me, but it clearly isn't. I have also tried escaping it myself using another ' so the string becomes: US,Chicago O''Hare Airport-Ord,IL But this generates the same error message below. Error message: Line 1: Incorrect syntax near 'Hare'. Unclosed quotation mark before the character string ',1)'. .Net SqlClient Data Provider Code: DBAccess.DBAccess oDB = new DBAccess.DBAccess(); oDB.SP = "CDR_Add"; // Stored Procedure name oDB.setConnection(); oDB.setCommand(); SqlParameter oP6 = new SqlParameter("@Location",SqlDbType.VarChar,50); oP6.Value = "US,Chicago O'Hare Airport-Ord, IL"; oDB.oCommand.Parameters.Add(oP6); oDB.oConnection.Open(); oDB.oCommand.ExecuteNonQuery(); oDB.close(); oDB = null; DBAccess is my own wrapper which I use to simplify connections to the database and ensures that all connections have been closed etc. I've exposed more of its functionality than is necessary so you can see what is going on. Let me stress this works perfectly well for strings that don't have the have the apostrophe. With regard to adding a parameter to a ADO Command object can anybody seen this behaviour before? Thanks in advance John Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74633
  - 6
    - Data Reader and Stored Procedure I am trying to figure out at what point I can read my parm values from a stored procedure. I know (think) that I can not read the parms until I have processed al of the records. If I am binding my datareader to a datagrid, can I then access the parms after the databind? Can I not read my parms if I am binding to a datagrid? Thanks in advance for your assistance!!!!!! Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74625
  - 7
    - Composite Primary Keys in XSD I'm using an XSD DataSet and i've put all the DataRelations into it. A nunber of my table use composite (in particular, 2 column keys). This is reflected by the following Constraint in the xsd: <xs:unique name="Installation_Constraint1" msdata:ConstraintName="PrimaryKey" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Installation" /> <xs:field xpath="mstns:Company" /> <xs:field xpath="mstns:Name" /> </xs:unique> Which has the side effect of requiring both feilds to be Unique. This is not the case, which is why they are a composite key. I can drop the constraint but that damages the data model and ignoring the error with exceptions is ineffcient as this will likly mean 10-20 exceptions a second in standard operation. Does anyone know an alternate constraint syntax? Or another (cleaner) way for dealing with this kind of issue? Thanks in advance Jan Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74621
  - 8
    - .Net Oracle Managed Data Provider Q330126???? hi all.. The problem am facing is similar to connection leak.. i am working on 3T application with middle T is remoting objects.. one of the objects is SingleTon having method whihc will be called every 1 minute and will take lots of data from oracle server the application is designed to work continuosly as there is problem we receive ORA-01000 exception i came to know @ Q330126 fix to down load but i am not getting it on microsoft if any one would tell detail step by step method to down load it it will be highly helpful.. thanks ... Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74620
  - 9
    - BUG: Binding-error with NumericUpDown on TabPage This is a multi-part message in MIME format. ------=_NextPart_000_097D_01C3C3CA.80022460 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, Binding the Value-Property of a NumericUpDown-Control (using = DataBindings): Dim bndNBRtechniciansForService As Binding =3D New Binding("Value", = Me.dvInstallations, "NBRtechniciansForService") AddHandler bndNBRtechniciansForService.Format, AddressOf NullToIud AddHandler bndNBRtechniciansForService.Parse, AddressOf IudToDB = Me.iudNBRtechniciansForService.DataBindings.Add(bndNBRtechniciansForServi= ce) produces the following exception: 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 occurs only if you close (dispose) the form (instance 1) and = re-open it (new instance 2) AND you didn't activate the tab (on instance = 1) containing the NUD-Control. If you just click the tab containing that control before you close the = form and then re-open a new instance of the form, there is not problem = at all. I think it has something to do with the TabPageControl re-binding but = can't seem to find any input on that. The controls are bound to a DataView I use vb.NET 2003 ent. arch XP SP1a Any suggestions (like a work-arround) wuold be very nice, Michael ------=_NextPart_000_097D_01C3C3CA.80022460 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1276" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hello,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Binding the Value-Property of a=20 NumericUpDown-Control (using DataBindings):</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV><FONT face=3DArial = size=3D2><FONT=20 color=3D#0000ff size=3D2> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV><FONT color=3D#000000>Dim</FONT></FONT><FONT size=3D2>=20 bndNBRtechniciansForService </FONT><FONT size=3D2>As</FONT><FONT = size=3D2> Binding=20 =3D </FONT><FONT size=3D2>New</FONT><FONT size=3D2> Binding("Value", = </FONT><FONT=20 size=3D2>Me</FONT><FONT size=3D2>.dvInstallations,=20 "NBRtechniciansForService")</DIV> <DIV></FONT><FONT color=3D#0000ff size=3D2>AddHandler</FONT><FONT = size=3D2>=20 bndNBRtechniciansForService.Format, </FONT><FONT color=3D#0000ff=20 size=3D2>AddressOf</FONT><FONT size=3D2> NullToIud</DIV> <DIV></FONT><FONT color=3D#0000ff size=3D2>AddHandler</FONT><FONT = size=3D2>=20 bndNBRtechniciansForService.Parse, </FONT><FONT color=3D#0000ff=20 size=3D2>AddressOf</FONT><FONT size=3D2> IudToDB</DIV> <DIV></FONT><FONT color=3D#0000ff size=3D2>Me</FONT><FONT=20 = size=3D2>.iudNBRtechniciansForService.DataBindings.Add(bndNBRtechniciansF= orService)</DIV></BLOCKQUOTE></FONT></FONT> <DIV><FONT face=3DArial size=3D2>produces the following = exception:</FONT></DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV><FONT face=3DArial size=3D2><EM>An unhandled exception of type=20 'System.Exception' occurred in = system.windows.forms.dll</EM></FONT></DIV> <DIV><FONT face=3DArial size=3D2><EM>Additional information: = DataBinding could not=20 find a row in the list that is suitable for all=20 bindings</EM></FONT></DIV></BLOCKQUOTE> <DIV><FONT face=3DArial size=3D2>This occurs only if you close (dispose) = the form=20 (instance 1) and re-open it (new instance 2) AND you didn't = activate the=20 tab (on instance 1)  containing the NUD-Control.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>If you just click the tab containing = that control=20 before you close the form and then re-open a new instance of the form, = there is=20 not problem at all.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I think it has something to do with the = TabPageControl re-binding but can't seem to find any input on = that.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>The controls are bound to a = DataView</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I use vb.NET 2003 ent. = arch</FONT></DIV> <DIV><FONT face=3DArial size=3D2>XP SP1a</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any suggestions (like a work-arround) = wuold be very=20 nice,</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Michael</FONT></DIV></BODY></HTML> ------=_NextPart_000_097D_01C3C3CA.80022460-- Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74613
  - 10
    - bound controls won't fill I have a form named Authors.vb. It connects to HasbaraSample.mdb through cnHasbaraSample. I've read in many places that if the database isn't given a path, ado.net first looks in the folder of the solution. This works in other places in my application. The connect string is Provider=Microsoft.Jet.OLEDB.4.0;Data Source=HasbaraSample.mdb; All the adapters and datasets are dragged from the data component tab of the toolbox; after the wizard, I change the connect string of cnHasbaraSample. I might add that the columns include several comboboxes. None of these are filled by the adapters that I create for them, using cnHasbaraSample as the connect string. This works perfectly elsewhere in my application. None of the textboxes or comboboxes fill. Yet, I get no error telling me the connection cannot be made. On the other hand, I have a form POV.vb. In this form I leave the full path in the connect string. Not surprisingly, the comboboxes and textboxes fill perfectly. In real life you can't deploy an application like this, because the user may not use the same path as I do, particularly drive H:, for example. Any help somebody can give me will be much appreciated. By the way, I've looked at the location of the mdb in a message box in Authors.vb, and it is correct. dennist Provider=Microsoft.Jet.OLEDB.4.0;Data Source=HasbaraSample.mdb; Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74611
  - 11
    - how to display all the table name(in database) in a page? thanks! netbee Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74606
  - 12
    - NEWBIE: Data Grid Formatting Hello and thanks for taking a minute. I am just getting into ado.net and still at the "experiment with wizard generated code" phase of self-teaching, so please bear with any stupid mistakes. I am trying to write a simple contact manager with an interface similar to Act's opening contact screen. I've got enough down to pull data from various data adapters into my datasets and bind to the form. However, I am having a real problem with managing concurrency. I would like my application to only write those records that are either additions or have updates. The following code partially works in that it writes changes made to the dataset. However, even when I do not update any data, the dataset always records at least one change (as witnessed by the firing of the message box indicating how many records were updated) and overwrites. Here is what happened: 1. I populated datasets in my vb.net build 2. I used SQL Enterprise Manager to change values in several rows of the database table in question (simulating another user's work) 3. I edited one record in the vb.net build (simulating this user's work) 4. Ran update procedure in the vb.net build, which promptly updated the entire table back to the data from my dataset (this user's work wiping out another user's work). What I need to have happen is that at step 4, only those records that were edited in the vb.net build would be overwritten, not the entire dataset (this user's work not affecting another user's work) Below are two snippets of code that I used to populate the datasets and to update the database, respectively. If somebody could point me in the right direction, I would be very grateful. Thank you very much.  System.InvalidOperationException: There is already an open DataReader associated with this Connection which must be closed first. at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean executing) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Comman dBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74574
  - 18
    - Programming Excel Effiviently - HELP! My head is exploding with the 500 different ways shown on Microsoft's site to program Excel (Office) Can anyone offer the best solution to the following: I want to program a couple of Excel reports for both Mac Users and PC users and have them access from a web site. These users not only have different platforms (Mac and PC) but many have different versions of Excel (XP, 2002, 2003, 2000). What does Microsoft have out there that would be compatible with all of the above differences?? I am open to VBA, VB.Net, ASP.NET, etc........ Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74562
  - 19
    - Sorting an XML file Hello, I need to sort an XML file and then display the result in a drop-down list on an ASP.NET WebForm. What should I use? DataSet, DataReader, something else? Right now I have the following code: DataSet ds = new DataSet(); ds.ReadXml(Server.MapPath("categories.xml"), XmlReadMode.InferSchema); cboType.DataSource = ds; cboType.DataBind(); Thanks for any help, Leszek Taratuta Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74556
  - 20
    - Non fatal SP error causes ADO recordset to be nulled? Greetings, Here is the problem: We have a stored procedure that selects a set of candidate rows. It then attempts to lock the candidate rows via inserts into a lock table. If a row is already locked we handle the pk insert error within the stored procedure and remove the candidate from the result set. The stored procedure side works great. However, in the C++ client the command.execute method which is wrapped in a try block catches the exception normally but there is no result set returned! For the life of me I can't figure out why ADO would eliminate the result set when the execute returns an error, it is nulling out the pointer even though the select in the stored procedure returned results. Anyone seen this before? Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74555
  - 21
    - DataTable.Clear() throws System.ArgumentOutOfRangeException Clearing a datatable of all data, I would think be a simple task. Does anyone have an idea why the DataTable.Clear() method could throw a System.ArgumentOutOfRangeException. Also, this problem doesn't seem to be consistent or 100% reproducable. Perhaps it depends on the data in the table. Any suggestions? Sorry the description is so vague, but there really is anymore info I can think to add. Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74554
  - 22
    - Inserting a new row in merged dataSets Has anybody come across this? I have a dataset with records of items and depending on itemID, I get price of each item from another table. I am merging two datasets with the primaryKey constraint. I have read all articles on this group to see how to insert a new row in the item and then add a corresponding price in another table when I have not inserted the data in the database. i.e. I don't have the itemID when I insert the price. I want to add more than one row and then commit the changes to the database when user selects to save data. Thanks, Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74551
  - 23
    - sproc DataTable question Hi- I was just preparing to use some of the Stored Procedures that I've been working on for my asp.net application. it appears that you can't get a DataTable or DataSet back from SqlCommand.Execute(). Why? I can get a DataReader, but I don't want to have the connection still open. How do we execute a stored procedure and return DataTable or DataSet? This must be a common question... Thanks, Steve Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74548
  - 24
    - time entry in date field in ado .net, problem i have an access 2000 database, in which i log incoming calls by their date and time, so they can be retreived according to the order they were called in. in the date-time field, i can store a date-time by typing "1/1/2002 1:13:00 PM" directly into the table when i open it in Access. if i then ascendingly sort the table on this field i get the log in the order they were called in. when i use ado .net, and set this field to 'Now' in code, and i make a breakpoint right after the line of code that does it. ds.Tables("tblLog").Rows(ClientRowId).Item("LogDate") = Now, and print out the field in the command window, it shows me the date and time. so i know my code correctly got the DATE AND TIME into the field. however when it gets updated in the database, by DataAdapterLog.Update(ds.Tables("tblLog")) and i then look into the database itself in Access the time is droped out, and only the date is updated, and it sorts only by date and not by date and time. why is this happening, and how do i get the DATA AND TIME to get updated? thanks for any help, ray please respond to the list Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74547
  - 25
    - Adding information to a dropdownlist from a dataset Hello. i have tree dropdownlist that i want to add some information from a databas. The sql questions is like this for the tree dropdownlist´s SELECT distinct eventuser FROM syslog..tblsecurityEvents where eventuser like 'PHONERA%' and eventuser not like '%$' SELECT distinct eventuser FROM syslog..tblsecurityEvents where eventuser like 'PHONERA%' and eventuser like '%$' SELECT distinct eventuser FROM syslog..tblsecurityEvents where eventuser not like 'PHONERA%' but.. I don't want to make 3 dataset. Can I just do one dataset like this. SELECT distinct eventuser FROM syslog..tblsecurityEvents And the use some type off dataview or something else to sort the information on the right dropdownlist. The code I am using right now is something like Dim show_users As SqlDataAdapter = New SqlDataAdapter("SELECT distinct eventuser FROM syslog..tblsecurityEvents where eventuser like 'PHONERA%' and eventuser not like '%$'", connect1) show_users.Fill(PortalData, "eventuser") DropDownList1.DataSource = PortalData DropDownList1.DataMember = ("eventuser") DropDownList1.DataTextField = ("eventuser") DropDownList1.DataBind() // Lennie Phonera.se Tag: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers Tag: 74546

The driver and provider lists (below) have recently been updated and moved to a
new web site (www.SQLSummit.com):

ODBC drivers
http://www.sqlsummit.com/ODBCVend.htm

.NET Providers
http://www.sqlsummit.com/DataProv.htm

OLE DB Providers
http://www.sqlsummit.com/oledbven.htm

JDBC drivers
http://www.sqlsummit.com/JDBCVend.htm

DB2 Extenders
http://www.sqlsummit.com/extenven.htm

Top

Re: Updated lists of ODBC drivers, .NET providers, OLE DB providers, JDBC drivers by Miha

Miha
Wed Dec 17 04:39:13 CST 2003

Hi Ken,

Nice list.
You might add Firebird .NET provider
http://firebird.sourceforge.net/index.php?op=devel&sub=netprovider

and MySql .net provider
http://www.mysql.com/articles/dotnet/

--
Miha Markic - RightHand .NET consulting & software development
miha at rthand com

Top