sql_variant is incompatible with xml

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
    - MSDataShape and Transactions A SHAPE command, executed via MSDataShape-provider connection is not able to participate implicitly in ongoing (ambient) transaction. Trying to explicitly enlist the connection into the ambient transaction throws the following exception: "The ITransactionLocal interface is not supported by the 'MSDataShape' provider. Local transactions are unavailable with the current provider." Is there a way to make MSDataShape-provider connection participate in a transaction? It seems pretty strange to me that MSDataShape-connections cannot participate in transactions. I must be doing something wrong. Thank you Tag: sql_variant is incompatible with xml Tag: 146109
  - 2
    - Comparing DataSets We're trying to minimize the number of postbacks to the server in our web application by allowing users to change rows in a grid on the client side. When they click the submit button, we need to update the changes to the database. I have the original DataSet and I have the updated one which is built off the current grid. I now need to compare and find out what was updated, deleted and inserted before proceeding with the database updates. Both have the same schema and a uniqie index. Other than looping for each row and comparing the two, is there an easier and simpler way to get the changes? I tried merge but it didn't pick up the changes at all. Here is the code I'm using. All the records are unchanged so dsDifference is always empty. // Get from session. DataSet dsOriginal = (DataSet)Session["ds"]; // Create a DS using grid data. DataSet dsChanged = base.GridToDataSet(UltraWebGrid1); // Add primary keys. dsOriginal.Tables[0].PrimaryKey = new DataColumn[] { dsOriginal.Tables[0].Columns["ObjId"] }; dsChanged.Tables[0].PrimaryKey = new DataColumn[] { dsChanged.Tables[0].Columns["ObjId"] }; // Merge. dsOriginal.Merge(dsChanged); // Create the delta DS. DataSet dsDifference = new DataSet(); dsDifference = dsOriginal.Clone(); foreach(DataRow row in dsOriginal.Tables[0].Rows) { if(row.RowState == DataRowState.Modified) dsDifference.Tables[0].Rows.Add(row); } Thanks Alex Tag: sql_variant is incompatible with xml Tag: 146108
  - 3
    - ORA-22275 error Hi, I'm trying to pass DOCX to an Oracle procedure, the procedure should save it in the database. But I'm getting this error: ORA-22275: invalid LOB locator specified Here's my code: [code] Public Function SaveTemplate(ByVal Template As TemplateProxy2. CTemplateObject) As TemplateProxy2.CErrorCode() Dim objConnection As OracleConnection Dim objCommand As OracleCommand Dim objParameter As OracleParameter Dim objAdapter As OracleDataAdapter Dim dsReturn As New DataSet Dim objError As New TemplateProxy2.CErrorCode Dim objResponse As New TemplateProxy2.CObjectResponse ' objResponse.ErrorCodeList is returned Try 'objConnection = New OracleConnection(System.Configuration. ConfigurationSettings.AppSettings("dbConnect")) objConnection = New OracleConnection("Data Source = DEV051; User Id = ACS_DEV02; Password = ACS_DEV02;") ' Create Command objCommand = objConnection.CreateCommand() objCommand.CommandType = CommandType.StoredProcedure objCommand.CommandText = "TEMPLATE_PKG.saveTemplate" objAdapter = New OracleDataAdapter(objCommand) ' Map Parameters objCommand.Parameters.Add(New OracleParameter("p_Template_Code", OracleDbType.Varchar2, Template.TemplateCode, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Template_Name_EN", OracleDbType.Varchar2, Template.Title_EN, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Template_Name_FR", OracleDbType.Varchar2, Template.Title_FR, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Template_Description_EN", OracleDbType.Varchar2, Template.Description_EN, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Template_Description_FR", OracleDbType.Varchar2, Template.Description_FR, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter("p_Version_Number", OracleDbType.Int32, Template.VersionNumber, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter("p_Language_ID", OracleDbType.Int32, 1, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter("p_Release_Date", OracleDbType.Date, Template.ProdStartDate, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Recipient_Type_ID", OracleDbType.Int32, Template.RecipientTypeID, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter("p_Cc_Ind", OracleDbType.Int32, Template.SendCopies, ParameterDirection.Input)) ' MAP ARRAY Dim p_ProgramGroup_IDs As New OracleParameter p_ProgramGroup_IDs.ParameterName = "p_ProgramGroup_IDs" p_ProgramGroup_IDs.OracleDbType = OracleDbType.Int32 p_ProgramGroup_IDs.CollectionType = OracleCollectionType. PLSQLAssociativeArray p_ProgramGroup_IDs.Size = Template.ProgramGroups.Length p_ProgramGroup_IDs.Value = Template.ProgramGroups p_ProgramGroup_IDs.Direction = ParameterDirection.Input objCommand.Parameters.Add(p_ProgramGroup_IDs) ' MAP ARRAY Dim p_Template_Category_IDs As New OracleParameter p_Template_Category_IDs.ParameterName = "p_Template_Category_IDs" p_Template_Category_IDs.OracleDbType = OracleDbType.Int32 p_Template_Category_IDs.CollectionType = OracleCollectionType. PLSQLAssociativeArray p_Template_Category_IDs.Size = Template.TemplateCategory.Length p_Template_Category_IDs.Value = Template.TemplateCategory p_Template_Category_IDs.Direction = ParameterDirection.Input objCommand.Parameters.Add(p_Template_Category_IDs) ' MAP ARRAY Dim p_DeliveryMode_IDs As New OracleParameter p_DeliveryMode_IDs.ParameterName = "p_DeliveryMode_IDs" p_DeliveryMode_IDs.OracleDbType = OracleDbType.Int32 p_DeliveryMode_IDs.CollectionType = OracleCollectionType. PLSQLAssociativeArray p_DeliveryMode_IDs.Direction = ParameterDirection.Input p_DeliveryMode_IDs.Size = Template.DeliveryModes.Length p_DeliveryMode_IDs.Value = Template.DeliveryModes objCommand.Parameters.Add(p_DeliveryMode_IDs) objCommand.Parameters.Add(New OracleParameter ("p_Default_Delivery_Mode_ID", OracleDbType.Int32, Template. DefaultDeliveryMode, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter("p_Requested_By", OracleDbType.Int32, Template.RequestedBy, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter("p_Reason", OracleDbType.Varchar2, Template.Reason, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter("p_Status_ID", OracleDbType.Int32, Template.StatusID, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Sensitivity_Level_ID", OracleDbType.Int32, Template.SensitivityId, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Privacy_Level_ID", OracleDbType.Int32, Template.PrivacyID, ParameterDirection.Input)) ' MAP ARRAY Dim p_Component_IDs As New OracleParameter p_Component_IDs.ParameterName = "p_Component_IDs" p_Component_IDs.OracleDbType = OracleDbType.Int32 p_Component_IDs.CollectionType = OracleCollectionType. PLSQLAssociativeArray p_Component_IDs.Size = Template.ComponentList.Length p_Component_IDs.Value = Template.ComponentList p_Component_IDs.Direction = ParameterDirection.Input objCommand.Parameters.Add(p_Component_IDs) objCommand.Parameters.Add(New OracleParameter ("p_Template_Type_ID", OracleDbType.Int32, Template.TemplateTypeID, ParameterDirection.Input)) ' MAP ARRAY Dim p_Attachment_IDs As New OracleParameter p_Attachment_IDs.ParameterName = "p_Attachment_IDs" p_Attachment_IDs.OracleDbType = OracleDbType.Int32 p_Attachment_IDs.CollectionType = OracleCollectionType. PLSQLAssociativeArray p_Attachment_IDs.Direction = ParameterDirection.Input p_Attachment_IDs.Size = Template.AttachmentIDs.Length p_Attachment_IDs.Value = Template.AttachmentIDs objCommand.Parameters.Add(p_Attachment_IDs) ' MAP ARRAY Dim p_Attach_Optional_INDs As New OracleParameter p_Attach_Optional_INDs.ParameterName = "p_Attach_Optional_INDs" p_Attach_Optional_INDs.OracleDbType = OracleDbType.Varchar2 p_Attach_Optional_INDs.CollectionType = OracleCollectionType. PLSQLAssociativeArray p_Attach_Optional_INDs.Direction = ParameterDirection.Input p_Attach_Optional_INDs.Size = Template.AttachmentIDs.Length p_Attach_Optional_INDs.Value = Template.AttachmentIDs objCommand.Parameters.Add(p_Attach_Optional_INDs) 'objTemplate2007Content = System.Text.Encoding.ASCII.GetBytes (Template.Template2007Content) objCommand.Parameters.Add(New OracleParameter ("p_Template_Content_DOCX", OracleDbType.Blob, Template.Template2007Content, ParameterDirection.Input)) objCommand.Parameters.Add(New OracleParameter ("p_Template_Content_WML", OracleDbType.NClob, Template.Template2003Content, ParameterDirection.Input)) objParameter = New OracleParameter("ERROR_CODE_LIST", OracleDbType.RefCursor, Nothing, ParameterDirection.Output) objCommand.Parameters.Add(objParameter) objAdapter.TableMappings.Add("Table", objParameter.ParameterName) ' Call storedproc objConnection.Open() objAdapter.Fill(dsReturn) objConnection.Close() 'objResponse.HandleErrorCodeList(dsReturn.Tables ("ERROR_CODE_LIST")) Dim c As TemplateProxy2.CErrorCode = New TemplateProxy2. CErrorCode If (dsReturn.Tables("ERROR_CODE_LIST").Rows.Count > 0) Then c.ErrorTypeCode = dsReturn.Tables("ERROR_CODE_LIST").Rows(0) (0) c.ErrorMessage = dsReturn.Tables("ERROR_CODE_LIST").Rows(0)(2) End If Return New TemplateProxy2.CErrorCode() {c} Catch ex As Exception MessageBox.Show(ex.ToString) 'objResponse.HandleException(ex) Finally If objConnection.State <> ConnectionState.Closed Then objConnection.Close() End If End Try Return objResponse.ErrorCodeList End Function [/code] Can somebody help? Marc. Tag: sql_variant is incompatible with xml Tag: 146107
  - 4
    - Optimized Merge Algorithm for ETL-Process? Hi out there, I've developed an ETL-Like application which fetches data from our SAP system incrementally and merges it with an MSSQL database. For this merge process I can't use the DataTable.Merge Method, because the method simpley uses the DataRowState to merge. For this I developed an own method, which compares the content and then adds/modifies or deletes the rows. Because this thing is not very, very fast: Is there an optimized method for this already existing? Thank you very much, Frank Tag: sql_variant is incompatible with xml Tag: 146106
  - 5
    - UpdatePanel update web page title tag Hello, Is it possible to update web page Title tag without reloading web page? I don't find way to do it with UpdatePanel, not sure is it possible. I am waiting for any help or idea. Thank you. Regards, Tomas Tag: sql_variant is incompatible with xml Tag: 146104
  - 6
    - Data Controls Suck: No Vertical Layout? Jees, it really seems to be non-existent to find controls in the framework or documentation or hacks that will help me get an editable grid or editable datalist in vertical format. Isn't there somebody who has done this that can help me out? I want and need two columns, the left is a LinkButton with text property that has the name of the database field (column) and the right the TextBox that contains the data in from the database that CRUD can then function with. When the LinkButton in the left column is clicked the TextBox in the right column becomes active and there are linked Update and Cancel links to the right side of the TextBox so each field in the database can be edited just like we see in editable DataList and GridView controls: ONLY VERTICAL ORIENTATION! WTF? I'll do all the work but could use some pointers or whatever comes along with code examples or documents as I have to think others have done this already and figured out how to do it. Label = Editable List/Grid LinkButton ----- ======================================================= Field Name | Field to Edit ======================================================= First Name | [TextBox with Data] Update Cancel ----------- ------ ------ Last Name | [TextBox with Data] Update Cancel ----------- ------ ------ Postal Code | [TextBox with Data] Update Cancel ----------- ------ ------ ... ... ... Tag: sql_variant is incompatible with xml Tag: 146090
  - 7
    - Dataset Creation Using Programmatically Hi friends, I wish to create a dataset programmatically with it's columns and rows be able to view it graphically using the xsd file. Is this possible? If possible will you please give me a few instructions How to do it. Thanks, Cypher Drive Tag: sql_variant is incompatible with xml Tag: 146075
  - 8
    - Keeping multiple users in sync - overall strategies? Does anyone have a comment on how best to design for multiple users in a winforms application using disconnected datasets? Specifically how (and when) to have the multiple users see their colleagues' changes appear on their screen? With a single bindingsource connecting a user's various forms and datagrids it's easy to build an app (even a complex app) which keeps his several screens all in sync with each other. That's neat. But if he's working with other colleagues how and when should that bindingsource go back to the database for a refresh? What strategies have people evolved in complex apps? "Refresh" buttons everywhere, so that the user has to do it himself? Or sprinkling refreshes all over the code - presumably most of the time redundant (since nothing changed)? Or some kind of notification/trigger system so a refresh only occurs when the underlying data has changed? Any thoughts or relevant links are welcome. I am not even sure if I have used the correct terminology, but I hope my question is clear enough. Thanks Harry Tag: sql_variant is incompatible with xml Tag: 146066
  - 9
    - problem retrieving output value from StoredProc I am trying to use parameters for a storedproc with C# and MySQL and I am getting a null return value. when I try to run the following snippet I find that the output value is null. If I run the storedproc in the mysql query app I get a valid return value. Is there something wrong with the code. btw I also have found that parameters must be prefixed with '?' instead of '@'. statement = "my_sqrt"; using ( MySqlCommand command = new MySqlCommand(statement, conn) ) { command.CommandType = CommandType.StoredProcedure; MySqlParameter param = new MySqlParameter(); param.ParameterName = "?input_number"; param.MySqlDbType = MySqlDbType.Int32; param.Value = 9; param.Direction = ParameterDirection.Input; command.Parameters.Add(param); param = new MySqlParameter(); param.ParameterName = "@l_sqrt"; param.MySqlDbType = MySqlDbType.Int32; param.Direction = ParameterDirection.Output; command.Parameters.Add(param); command.ExecuteNonQuery(); if ( command.Parameters[ "?l_sqrt" ].Value == null ) { Console.WriteLine("null"); } thanks for the help john Tag: sql_variant is incompatible with xml Tag: 146061
  - 10
    - parameter prefix '@' vs "?' with MySql I have found that when I use parameters I must prefix the parameter name with an '?', but I have 2 books that show '@' as the prefix. Is there a reason for this? I am using C# with Mysql v5.1. the following snippet works statement = "select * from limbs where arms = ?arms"; using ( MySqlCommand command = new MySqlCommand(statement, conn) ) { MySqlParameter param = new MySqlParameter(); param.ParameterName = "?arms"; param.Value = 0; param.MySqlDbType = MySqlDbType.Int32; param.Direction = ParameterDirection.Input; command.Parameters.Add(param); } thanks for the help Tag: sql_variant is incompatible with xml Tag: 146060
  - 11
    - TableAdapter vs. DataAdapter: Ad Hoc Queries Dear group, Am I right in my understanding that when using strongly typed table adapters I am limited to the (select) statements defined in the various .FillBy... and .GetDataBy... functions? I'd like to build a flexible select statement on a table based on a filter set by the user. He should be able to restrict the data by setting the conditions on different table columns (WHERE clause), where the filter can be any comparison operator like =, <, <=, etc, or a predicate like BETWEEN, LIKE, etc. As I understand, a select statement built this way can not be passed to a strongly typed table adapter. Many thanks for your suggestions, Etienne Tag: sql_variant is incompatible with xml Tag: 146050
  - 12
    - how to return 1 field (just 1 field) by Linq? Hi Colleagues, I return Lists in my linq querys when I need to return a lot of rows and fields etc. But this time I only want to return 1 field... Input is a name of BusinessUnit and output should be BusinessUnitGuid. both are in a table called tblCostCenter. But I don't know how to return 1 field... Can someone help with the syntax? - I don't even want the container busGuid (result of projection). so can someone send me #2 correct syntax one with busGuid container and return busGuid and another one w/o. - but should be in field in in ????????? my linqtable is called. costcenter and full namespace is : Linq.Costcenter table Linq.CostCenter fields BusinessUnit type String BusinessUnitGuid type Guid Description type String etc. etc. etc. - why can't I put as return type Linq.Costcenter.BusinessUnitGuid as function result parameter???? thanks, mesut //GetCostCenter - INPUT: BusinessUnit OUTPUT: BusinessUnitGUID public ???????? GetBusinessUnitGuid(string businessUnit) { //connection to the Linq objDataContext = DatabaseFactory.GetLinqConnection(); var busGuid= (from CostCenter in objDataContext.tblCostCenters where CostCenter.BusinessUnit == businessUnit select CostCenter.BusinessUnitGuid); return busGuid; } Tag: sql_variant is incompatible with xml Tag: 146047
  - 13
    - TableNames with ExecuteDataSet We are using Enterprise Library 3.1 Data Access Aplication Block. We pass a Common.DbCommand to it's ExecuteDataSet. The DbCommand has parameters attached and calls a stored procedure. Several of our methods in our Data Access Layer return Datasets which contain several, up to 16, tables. We'd like to return the DataSet with the tables named instead of having to name them after the ExecuteDataSet. For example: select id, name, active from employees active_employees where active = 1 select id, name, active from employees inactive_employees where active = 0 would make the following possible: sting tableName = ds.Tables[0].TableName; // tableName would equal "active_employees" without setting the table name with ds.Tables[0].TableName = "active_employees" Is this possible? Tag: sql_variant is incompatible with xml Tag: 146046
  - 14
    - Syntax error on update command Hi I have a vs2008 generated DataSet which contains a number of tables. When I use the below statement on a forms; Me.MyTableAdapter(Me.MyDataSet.MyTable) I get the error 'Property access must assign to the property or use its value.'. 'MyTable' in is defined as a property in MyDataSet.Designer.vb. I have used the same statement as above for other tables on the same form without a problem which is weird. What is the problem and how can I fix it? Thanks Regards Tag: sql_variant is incompatible with xml Tag: 146040
  - 15
    - SQL Express Edition Network Deployment Error Guys and Gals, Have a problem... Here it goes... The file ..... is on a network path that is not supported for database files.. an attempt to attached an auto named database for a file failed. A database with the same name exist or specified file cannot be opened. What we did was we copied our entire vb.net program with an mssql express edition database to another computer on a network and then we shared the folder as a full access folder and then .. we copied our entire vb.net program on another machine and then... we changed the connection string to an unc path using \\vbnet\program etc.. The error above appeared. What was wrong? Does it mean we need to have another license of an sql server express edition run on that machine? Is there another way to deploy them and install only .net framework and copy the mdf file? Thanks, Cypher Drive. Tag: sql_variant is incompatible with xml Tag: 146039
  - 16
    - ADO.NET Entity Framework I am migrating from a mainframe and evaluating whether or not to use the ADO.NET Entity Framework. My question is...How can I mark each entity property as a [DataMember] for use with WCF? I'm sure I can go directly into the code, but will it be later changed by the designer? Also, can I put two entities existing in the same Model into different namespaces? and can I create relationships between entities in two different Models? Thanks. -- g Tag: sql_variant is incompatible with xml Tag: 146038
  - 17
    - Which data control gives this view? I want to get a logged in website user's properties into a vertical template ============================================= FieldName Label | FieldValueToEdit Label ============================================= LinkedFieldToEdit | ValueToEdit ... | ... ... | ... ============================================= I've started with review of QuckStarts [1] which does not clearly explain which control support vertical orientation like the Windows Propertygrid control. Which data control in the framework should be used and if more than one choice is available using templates a quick comment on which is fastest and easiest to use in vertical orientation please... [1] http://quickstarts.asp.net/QuickStartv20/aspnet/doc/ctrlref/data/default.aspx Tag: sql_variant is incompatible with xml Tag: 146037
  - 18
    - Sorting results from get child rows? I have a data table with a reference between two tables, I call get child rows from the parent row to get its children, this works of course and returns an array of data rows... now the problem is I need to sort this result! I thought LINQ might work but never used it... (I am in VS2008 and .NET 3.5) any ideas on how to do this? thanks! Tag: sql_variant is incompatible with xml Tag: 146036
  - 19
    - problem using parameters with mysql and C# I am trying to use parameters with mysql and I am not getting any results returned. In the following example the "legs" column is defined as INTEGER. For a simple test I am using the following snippet: MySqlConnection conn; conn = new MySqlConnection(connStr); conn.Open(); statement = "select * from limbs where legs = @legs"; MySqlCommand command = new MySqlCommand(statement, conn); MySqlParameter param = new MySqlParameter(); param.ParameterName = "@legs"; param.Value = 2; param.MySqlDbType = MySqlDbType.Int32; command.Parameters.Add(param); MySqlDataReader reader; reader = command.ExecuteReader(); while ( reader.Read() ) { Console.WriteLine("{0}|{1}|{2}|", reader[ "thing" ], reader[ "legs" ], reader[ "arms" ]); } reader.Close(); } catch ( MySqlException mysql_e ) { Console.WriteLine(mysql_e.Message); } No results are returned and no error is generated. I am using MySql 5.1 with MySql Connect Net 1.0.7 and .Net Framework 3.0. thanks for any help Tag: sql_variant is incompatible with xml Tag: 146031
  - 20
    - DAL technique - which is better hello, in my DAL here is how i typically fetch a single DataTable (for biz layer consumption): SqlConnection conn = new SqlConnection(connStr); SqlCommand command = new SqlCommand("GetFoo", conn); command.CommandType = CommandType.StoredProcedure; //do it - dataset & adapter DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(command); da.Fill(ds); return ds.Tables[0]; but recently i came across something that suggested using a DataReader: SqlConnection conn = new SqlConnection(connStr); SqlCommand command = new SqlCommand("GetFoo", conn); command.CommandType = CommandType.StoredProcedure; //do it - datareader conn.Open(); SqlDataReader dr = command.ExecuteReader(CommandBehavior.CloseConnection); DataTable dt = new DataTable(); dt.Load(dr); //closing DataReader auto-closes the Connection due to above dr.Close(); return dt; ...the idea being that since DataReaders are faster, this would fetch & fill a DataTable faster than using a SqlDataAdapter to fill a DataSet. any thoughts? thanks! sm Tag: sql_variant is incompatible with xml Tag: 146030
  - 21
    - Table Adapter Multi-Column KEY/Foreigh Key I posted following on MS Forum. Post it here also to see anyone have a solution. Thanks. -------- I am using VS2008, SQL Compact 3.5. I have following tables: Divisions (CountryID smallint, DivisionID smallint, DivisionName) (PK on CountryID and DivisionID) Regions (CountryID smallint, RegionID smallint, RegionName, DivisionID) (PK on CountryID and DivisionID) Regions has a Cascading foreign key to the Divisions. I am simply adding Table adapters for Divisions and Regions. When I say 'Finish' to RegionsTableAdapter. I got error: An unexpected error has occurred. Please record the following ..... Source:Microsoft.VSDesigner ErrorCode:-1 AdditionalInfo: It looks to me that it is caused by the Foreign Key (Multi Column). And it SQL Compact 3.5. Following are some test I did: Change the Division table has the PK only for Divisions and NO PROBLEM using SQL Server 05 (still multi-column key) and NO PROBLEM. Now I am stuck. Any workaround? Thanks John Tag: sql_variant is incompatible with xml Tag: 146029
  - 22
    - Can't insert record into SQL server express from ADO.NET inside IIS Hi, All: I am trying to insert records into SQL server express 2005 from ADO.NET (sql client) inside IIS. I am able to do every things correctly from visual studio 2005 with help of asp.net development server. However, when I publish code into IIS at localhost machine, code does nothing without any error message if I shown down asp.net development server. What a trick do I need to know??????? Thanks Tag: sql_variant is incompatible with xml Tag: 146022
  - 23
    - Process recycling in an auditing system I have created an Audit system, which is using triggers to saves changes to my tables. All that works great, my problem is the user. I my application I have an application User Id and I would actually like to use that user in the audit system. Right now I am using the SQL user which not is good enough, because they might not be the same as my application user. Especially not if the application use a connection string with a sql user, or if the data is being updated through a service. I am thinking of creating a table which pairs the application user id with the @@SPID and the login_time from master.dbo.sysprocesses. Then I am able to lookup the application user in my triggers using the current @@SPID and its login time. My problem is that if I have inactivity in my application the process get recycled after 4-8 minutes. After that the @@SPID and the login_time is invalid. The user might get a new @@SPID but for sure gets a new login time. I somehow either want to keep the @@SPID/login_time as the same for the lifetime for my application. Or I want to map the old process to the new somehow. Any ideas? Cheers Henrik. Tag: sql_variant is incompatible with xml Tag: 146021
  - 24
    - TableAdapter parameterized query I'll start off by saying I'm very new to VS2005 and the DB tools. I am developing an app for Mobile 6 using SQL CE. I have a table with a datetime field and I want to be able to query this table for a given year. I have designed a query in the table's tableadapter with the following SQL statement: select date, ... from table where datepart(year, date) = @param1 When my code runs the FillBy method of the tableadapter it returns an exception stating that there was an error parsing the query (basically the "(" in line 3 of the sql statement is the culprit token). I guess the question are: Can I filter by year of a datetime field? Is this a limitation of SQL CE? Am I doing something wrong? Thanks, Jeremy Tag: sql_variant is incompatible with xml Tag: 146016
  - 25
    - Primary key vs unique Give What is the difference in the primary key from unique? http://www.alvas.net - Audio tools for C# and VB.Net developers Tag: sql_variant is incompatible with xml Tag: 146014
- Next
  - 1
    - how can we perform Distrubute transaction between SQL Server and Hi ,all can we perform Distrubute transaction between SQL Server and Oracle, and how can we do that? any advise is welcome, thank you best regard, Ares Tag: sql_variant is incompatible with xml Tag: 146005
  - 2
    - DataSet.ReadXml() I've been toying with DataSet.ReadXml(). I'm able to call this method and load an XML file. However, my data is hierarchical as follows: <Categories> <Category Name="XXX1"> <Subcategory>...</Subcategory> <Subcategory>...</Subcategory> <Subcategory>...</Subcategory> <Subcategory>...</Subcategory> </Category> <Category Name="XXX2"> <Subcategory>...</Subcategory> <Subcategory>...</Subcategory> <Subcategory>...</Subcategory> <Subcategory>...</Subcategory> </Category> </Categories> When I examine the returned rows, I only have the categories and not the subcategories. I'll be reading more about this and will eventually understand it better. But if anyone know a fairly simple way to make this work, that would be much appreciated. Thanks. Jonathan Tag: sql_variant is incompatible with xml Tag: 146003
  - 3
    - search a row with a criterium Hi, I am using method Find of RowCollection (of a DataTable object) to search for a record (row) with criterium "ID = x" (x is a number). ID is Primary Key in the table "table1". The DataTable object contains data of a View, which retrieves data from diferent tables (main table is table1). at the line DataRow l_oRow = l_oRowCols.Find(oID); //oID oID is object, had value 5 (x) exception MissingPrimaryKeyException occurs What can I do? I think, the column ID is automatic the primary column of the view, because the view retrieves any primay column from other tables. May I manually defines, tell my program that ID is primary column? Thanks for help Nhan Tag: sql_variant is incompatible with xml Tag: 146000
  - 4
    - SqlConnection not closing My brain must be going to sleep but can anyone tell me why after running this code the database connection remains open? I am testing some code and, after running these lines, when I try to drop the database I cannot because this retains a connection. Shouldn't this connection be dropped automatically? If not, how can I force the connection to close? using (SqlConnection testConnection = new SqlConnection()) { testConnection.ConnectionString = string.Format("Data Source={0};Initial Catalog={1};Integrated Security=SSPI;", server, database); testConnection.Open(); } Tag: sql_variant is incompatible with xml Tag: 145993
  - 5
    - SqlDataReader.GetOrdinal() question Hi... I came to a company with great volumes of legacy code, and I found an odd pattern. They use SqlDataReader for a lot of queries, but the reader is rather unfriendly with GetOrdinal(); if the column isn't there, it throws an exception, rather than returning -1 or some other friendlier value. In several places in the code, they've simply put a try/catch around the GetOrdinal() to make it less nasty, but given the expense of exceptions, that seems pretty onerous. Would SqlDataReader.GetSchemaTable().Columns.IndexOf ("name"); be cheaper? I don't know if GetSchemaTable() is returning the DataTable it has internally, or if it has to cobble one together from scratch, which would cut into the time. As an aside, what's the reason SqlDataReader.GetOrdinal() is so unfriendly? I mean, I suppose it requires the reader users to have more explicit knowledge of their queries, but as I've found, people can still come up with rather expensive alternatives to keep vague about the details of their data. Thanks Mark Tag: sql_variant is incompatible with xml Tag: 145991
  - 6
    - Data field format when writing to Excel with ADO.Net I'm currently working on an application that reads/writes data from/to Access and Excel. Other databases will probably be added in the future. This is in C#, so I've been reading up on ADO.NET and using this to do all the data I/O. So far this has been working well. I have hit an "inconvenience" for Excel, though. Most of the output fields are numeric, but the user can select text or number fields. For the text field I simply convert the number to a string first before writing it. That works fine, except Excel is not as strongly typed as the usual relational databases. Therefore a user might expect a column to be numeric, but in reality Excel thinks the field is text. Is there a way to write a number to Excel through ADO.Net that forces the cell to be a number, and not text? (I know a priori if the connection is an Excel one or not) Richard -- Richard Marsden Winwaed Software Technology LLC http://www.winwaed.com Tools and Add-ins for MapPoint - http://www.mapping-tools.com Tag: sql_variant is incompatible with xml Tag: 145990
  - 7
    - SQLDataAdapeter to XML Document Hello All, I'd like to run this scenario by us all and see if you think this is a viable solution or yet how might you do this better. I want to build an xml document of this type of nature Customer Locations Location My recordset looks as follows: Customer Location ABC North ABC South ABC East FGD SouthEast XYZ NorthEast XYZ West I find myself have to loop over the recordset and in this case store the current Customer name that i'm on. Create the node and child location node and move to next record. Then I check to see if its still the same Customer name and repeat. But this would only work when the recordset is alphabetized and also keep in mind this is 100% my real scenario. I'm curious if I would return multiple recordset with say a Select Distinct Customer and build that part of the document first. Then the second recordset with all the locations. This is something I haven't really gotten my head around with data access layers completely as far as best practive. This scenario deals with building an xml document but what if these were parent objects with collections? That's really what im after is how to best retrieve and build these hierachies. Thanks alot! -mike Tag: sql_variant is incompatible with xml Tag: 145989
  - 8
    - Logging and emailing errors Hi I would like to be able to log as much info as possible about an error in my app and the critical ones to be emailed to me. Is there a pre-built library/control that would do that? Many Thanks Regards Tag: sql_variant is incompatible with xml Tag: 145979
  - 9
    - is this group only for ADO ???? hi colleagues, I've got a question: I would like to post some questions regarding LINQ. I couldn't find any LINQ group. Is this the group also for the LINQ questions? e.g. LINQ to SQL. thanks mesut Tag: sql_variant is incompatible with xml Tag: 145976
  - 10
    - COMException on cloned recordset.update method I'm using VB2008 to create and clone a recordset this way: m_db = New Connection m_db.Provider = "Microsoft.Jet.OLEDB.4.0" m_db.Mode = ConnectModeEnum.adModeShareExclusive + ConnectModeEnum.adModeReadWrite m_db.Open(dbname) m_rst = New Recordset m_rst.Open("SELECT * FROM thumbs ORDER BY orden", m_db, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockOptimistic) m_gtRst = m_rst.Clone(LockTypeEnum.adLockOptimistic) and then i create a thread that gets all records (one by one) from the cloned recordset m_gtRst in a class, storing the recordset bookmark in it. The application also creates another thread that when requested uses the stored bookmark property to find a recordset in m_rst (the original recordset). This works ok, but if i tryt retrieve data in this thread from the main recordset using: Dim tsize As Long = m_rst.Fields("data").ActualSize Dim ms As New MemoryStream ms.Write(m_rst.Fields("data").GetChunk(tsize), 0, tsize) Then the first thread that is reading the cloned recordset gives a ComException when i try to update the cloned recordset. If iI either do not update the cloned recordset or I do not read data from the original recordset then all goes ok without any errors, but doing both things in most cases raises this error. The full error message is: No se controlÃ³ System.Runtime.InteropServices.COMException ErrorCode = -2147418113 Message = "Error catastrÃ³fico" Source = "Microsoft JET Database Engine" StackTrace: en ADODB.RecordsetClass.Update(Object Fields, Object Values) en xPlorer.FileBrowser.BrowseDatabase() en C:\Documents and Settings\David Saez\Mis documentos\Programacion\xPlorer.net\xPlorer\FileBrowser.vb:lÃnea 102 en System.Threading.ThreadHelper.ThreadStart_Context(Object state) en System.Threading.ExecutionContext.runTryCode(Object userData) en System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData) en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state) en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) en System.Threading.ThreadHelper.ThreadStart() InnerException: Tag: sql_variant is incompatible with xml Tag: 145975
  - 11
    - Rapid Development in VB2005 Hi guys and gals, We'd like to do a Rapid Development using VB.NET 2005 and SQL Express Edition 2005. Please comment on this approach. 1. Develop Reference Tables and Programs/ Forms using Strong Typed Dataset. (As demo by Ms. Beth Massi) - Rapid Development. 2. Develop Transaction Tables Programs/ Forms using Weak Typed Dataset. (Since there can be debugging is easier and is more complicated) 3. Use Crystal Report ??? Is it safe to say that this is faster than creating programs using weak typed dataset???? ---- End ---- Tag: sql_variant is incompatible with xml Tag: 145971
  - 12
    - TableAdapter not Refreshing on configure I've had trouble with project DataSet objects created by VS.Net. If I go into my database and change my table structure or modify my Select store procedure the TableAdaptor does not make the adjustments. I read that "Configure" is supposed to refresh the TableAdpater after VS2005 SP1. I've tried VS2005 SP1 and VS2008. I "configure" the tabledadapter and it does not help. If I do to DataSet1.xsd and right-click on my TableAdapter and click PreviewData, I see the adjusted datastructure in the query result. But, If I go and create a new ObjectDataSource and gridview. The changes that I have made do not appear. The ObjectDataSource still only sees the original structure and parameters. I have found the only way for the TableAdaptor or its resulting DataSources to reflex any changes I make to my data structure or stored procedures is if I completely delete the DataTable from the Dataset and recreate it. So, what am I missing why is the dataset not being refreshed or reconfigured? Is there a chache I need to clear? Tag: sql_variant is incompatible with xml Tag: 145970
  - 13
    - Linq Is the Linq feature upgraded with .net 3.5 sp1? Does it work just the same? -- Arne Garvander (I program VB.Net for fun and C# to get paid.) Tag: sql_variant is incompatible with xml Tag: 145969
  - 14
    - Access to microsoft works files Hi, It's possible to access to microsoft works files (*.wdb) with ado.net (VS2003)? regards Jan Tag: sql_variant is incompatible with xml Tag: 145962
  - 15
    - Analysis Service SQL 2000 Hi All, I'am working on VB.net project with Analysis Services SQL 2000. And we tryed to setup the software on Client machine. the problem is we have to install Analysis Service on all client machines to get the software working . I ask if there is a way to Add Analysis Services in the deployment package instead of installing Analysis services in each machine. i hope get help from you. please feel free to ask questions if you need more information about that. thanks in advance Tag: sql_variant is incompatible with xml Tag: 145954
  - 16
    - SqlDataReader do I need to call close? Connection.Open(); The execute and command and read something. Before reading is complete, I decided to call: Connection.Close(); Question: Must I call DataReader.Close() before closing the connection? Thanks in advance. Tag: sql_variant is incompatible with xml Tag: 145946
  - 17
    - ObjectDataSource typedObject Insert error "parameterless construct I am using a gridview [only to view(select)] and a formview [to insert] some data. My gridview displays information correctly, but clicking on insert button for the formview gives me error: "No parameterless constructor defined for this object". Data are persisted in a hiddentextbox as Xml and are used to create a globally declared Dataset on page_load(). I have a dataObjectType class "DataSetWrapper" and a static data access class "TendersDataSetAccessMethods" [ofcurse, methods have parameter of type "DataSetWrapper"]. I add the insert parameter on formview's itemInserting event (objdataSource's Inserting event seems to be too late). can someone tell me please which object has no parameterless constructor?!! my data access class is static and I have added a parameterless constructor to my dataObjectType class (though I still call the parameterd one in itemInserting event). note: I placed breakpoints in parameterless constructor and datasource's objectCreating event; the error comes before the breakpoints are even reached. Tag: sql_variant is incompatible with xml Tag: 145935
  - 18
    - When using System.IO.FileStream, I write 8 bytes, then seek to the start of the file, does the 8 bytes get flushed on seek and the buffer become a readbuffer at that point instead of being a write buffer? When using System.IO.FileStream, I write 8 bytes, then seek to the start of the file, does the 8 bytes get flushed on seek and the buffer become a readbuffer at that point instead of being a write buffer? Tag: sql_variant is incompatible with xml Tag: 145926
  - 19
    - How do I measure the size of a dataset? Hi, How do I measure the size of a dataset (including data in data tables and rows)? Thank you, Max Tag: sql_variant is incompatible with xml Tag: 145922
  - 20
    - Bind large table to grid in UI In a VB6 WinForms application we used a ComponentOne grid that was bound via DAO or ADO to a SQL Server table. Via the grid the user can do all the standard insert/delete rows and modify the data in a row. It was not a significant problem if the table contained LOTS (e.g. millions) of rows because the grid handled cursor management via the always-connected DAO or ADO recordset. Life was good and relatively simple. Now we want to accomplish the same thing using ADO.NET in a .NET WinForms application and things don't look so straightforward. ADO.NET uses the disconnected model. So what is the grid going to be bound to in .NET? It doesn't seem like a good idea to read all the data from the table (e.g. millions of rows) into a DataTable (or DataSet), bind the grid to the DataTable, etc. I would think that a good solution would be some sort of "automatic paging" object that sits between the grid and the table. This "automatic paging" object implements the proper interface so that the grid can bind to it. But the object would handle connecting to the database, presenting the proper rows of data to the grid, and updating data in the table as the user makes changes via the grid. Does such an object exist? Question: What are the "best practices" for solving this problem under ADO.NET? Please don't suggest that we re-think the feature and do away with the grid - we are certain that our users REALLY need to edit potentially large data tables via a grid. We are not locked into the ComponentOne FlexGrid, we can use something else if we need to. Tag: sql_variant is incompatible with xml Tag: 145904
  - 21
    - System.Transactions and oramts.dll Hello I need to perform a local distributed transaction on my ASP.NET 2.0 web site. The two affected data sources are MSMQ and Oracel 10g: I need to store, transactionally, data to both of these. Unfortunately, I get the error below. I have used depends.exe and confirmed that all of the required DLLs are on my machine. "Unable to load DLL 'oramts.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)" The really strange thing is that I also have a Windows Service (written in .NET) that also needs to perform transactional writes to Oracle and MSMQ and that works without any errors!!! Any ideas? Tag: sql_variant is incompatible with xml Tag: 145902
  - 22
    - Any Option to Save Changes to Database? Okay, I finally got databases working with my ASP.NET projects. Now, I'm back to WinForms so here we go again. I understand that when creating a database file in my project, the default settings is to silently wipe out any existing data each time I run my project. (Brilliant!) So I'm creating a test project in VS 2005 that uses a SQL Server Express database. I then created a Windows form and bound my edit controls to a table in the database. I'm able to add any number of records and browse through them. But, again, if I terminate and restart the project, all the data is gone. SQL Server databases don't have a "Copy to Output" option so I'm not sure where to go on this. I guess Microsoft just assumed anyone working with WinForms wouldn't want to keep any data they created. Does anyone know the trick to making my database changes permanent? Thanks. -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: sql_variant is incompatible with xml Tag: 145901
  - 23
    - OT: Online data/app repository Hi I need to provide access to my several clients to their apps and some data so they can download it as needed. Obviously I need separate logins (username/password) for each client. Is there a service provider that provides such a service? If not this is a nice business idea for some genius out there. :) Thanks Regards Tag: sql_variant is incompatible with xml Tag: 145897
  - 24
    - Finding type of data row Hi I have below code to update data; Try Me.TableAdapterManager.UpdateAll(Me.MyDataSet) Catch ex As DBConcurrencyException End Try The exception ex returns ex.row as the data row with concurrency issue. As there are several tables in dataset, how can I find which table the data row belongs to and then typecast ex.row to the relevant data table's data row type? Many Thanks Regards Tag: sql_variant is incompatible with xml Tag: 145892
  - 25
    - lifetime management If I was going to cache some sqlconnection and sqltransaction objects for lookup from multiple functions...how would you recommend handling the clsoing and disposing? i.e. something like the following (shortened for brevity)... class DBObject : IDisposable { public SqlConnection Connection {get; set;} public SqlTransaction Transaction {get; set;} public void Dispose() { if (Connection != null) Connection.Dispose(); if (Transaction != null) Transaction.Dispose(); } } class DBManager { private static HashTable<int, DBObject> _dbobjects; public static DBObject GetDBObject() { DBObject dbo = _dbobjects.find(Thread.CurrentThreadID); if (dbo == null) { dbo = new DBObject(); _dbobject.Add(Thread.CurrentThreadID(), dbo); } return dbo; } } call comes into server... void Method1() { DBObejct dbo = DBManager.GetDBObject(); ...do stuff with it... Method2(); } void Method2() { DBObject dbo = DBManager.GetDBObject(); ...do stuff with it... } there are many methods so I can't pass DBObject directly so I need a lookup method...problem is when it will be removed from the manager list and disposed of...i suppose i could reference count it but wanted to see if anyone had other ideas... Tag: sql_variant is incompatible with xml Tag: 145891

Hello,

I have a table. One of it's fields is of Xml type. I'm using a Stored
Procedure in order to perform the update on this table. When I'm trying to
set the xml field in the "updating" event, I'm getting the following error
"operand type clash: sql_variant is incompatible with xml". The code that
I'm using in the "updating" event is something like:
e.Command.Parameters["@MyXmlField"].Value = null;
Does anybody know how to correct the error?

Regards
Dimitris

Top

Re: sql_variant is incompatible with xml by Dimitris

Dimitris
Mon Aug 11 17:31:36 CDT 2008

Hello,

I forgot to mention that I'm using a SqlDataSource to access the table and
the "updating" event belongs to the SqlDataSource.

Regards
Dimitris

"Dimitris Milonas" <info@randomwalk.gr> wrote in message
news:uru8Ef$%23IHA.4124@TK2MSFTNGP05.phx.gbl...
> Hello,
>
> I have a table. One of it's fields is of Xml type. I'm using a Stored
> Procedure in order to perform the update on this table. When I'm trying to
> set the xml field in the "updating" event, I'm getting the following error
> "operand type clash: sql_variant is incompatible with xml". The code that
> I'm using in the "updating" event is something like:
> e.Command.Parameters["@MyXmlField"].Value = null;
> Does anybody know how to correct the error?
>
> Regards
> Dimitris
>
>

Top