CliffDC's Q&A profile

• SQL Server DBTYPE of 130 at compile time and 5 at run time

  If any one can help OLE DB provider 'MSDAORA' supplied inconsistent metadata for a column. Metadata information was changed at execution time. [SQLSTATE 42000] (Error 7356) OLE DB error trace [Non-interface error: Column 'ATP' (compile-time ordinal 1) of object '"IGS"."ABCD"' was reported to have a DBTYPE of 130 at compile time and 5 at run time]. [SQLSTATE 01000] (Error 7300). The step failed. Thanks www.databasetimes.net this is an pain of an error we have it too, when converting data from Oracle 9.2 running financials across to SQL 2000 tables "openquery" seems to work best - also we found that upgrading OLE/DB and MDAC drivers had no effect !! also pulling the data fr ...Show All

• SQL Server Grouping Dimension Values

  I have a question about grouping values in a dimension. I have a dimension that relates to the age of a person. When I run my ETL we bring in the age as it was at the time of the load. When I display that age to my users in a report, I would like to group the ages according to internal usages. Example: Age 16, 17, 18 would be grouped into a group of 16 to 18, etc.... This provides to us a larger statistic sample set, plus it makes the reports much easier to read. I am using Reporting Services to generate reports, but I was looking to move the grouping logic away from the client to the Analysis Services server. I actually have several dimensions like this where I would like to perform grouping. I was considering using a Ca ...Show All

• .NET Development Custom extension for xml file containing records

  Hi. Can someone give me advice to implement my own file extension. My file is Records.xml and includes dataset with one table. I want it to be like Records.rcd and save and read like that. Thanks anyone who interested in Thank a lot Rizwan, easy and exact solution for me Just implement dsRecord1.WriteXML("C:\\my.rcd"); to save and dsRecord1.ReadXML("C:\\my.rcd"); how easy :) ...Show All

• Windows Forms Using data from gridview to pre-populate a field in a Fieldview Insert

  Ok I have 2 SqlDataConntions, 1 is for a users list, the other is for a list of items attached to the selected user. I use a multiview with 2 views to deal with this list of items. View 1 is a datalist control that displays the list View 2 is a Formview control that is only setup for insert mode. What I need to be able to do is when I add items with my Formview, I can draw one field ( the keyid of the selected item from the first SqlDataConntion) into my Formview so it populates a field on that Formview to link the data together. I'm sure it's somethign simple but I can't figure out how to do it. ...Show All

• Visual C++ Computing for large matrices

  I tried to write a file for 1e6 by 1e6 and it literally crashed. Double is too small to handle. How should I code so that I could begin to write and compute my matrices I am looking along the lines of computing values larger than 1e6. Is that realistic Also, how can I optimize on the memory space using MV.Net 2003 I am starting with a simple code, see below. Thanks. [code]int main() {    int i, j, nmat;    double *b, **a4;    nmat = 1000000;    Init_Matrix(a4, nmat);    Init_Vector (b, nmat);    for (i = 0; i<nmat; ++i) {       if (i%2 == 0) a4 = 4;       if (i%2 == 1) a4 = 4;       if ((i-1)%1 ...Show All

• Windows Forms Where can I access the commandTimeout property in a DataAdapter

  It boggles me that I found this same question in the forums twice and noone from MS has commented on this BUG. I went into the Generated code and found this procedure and added the commandtimeout line. But this is not the way to do it because it gets written over anytime the dataset designer is updated. Private Sub InitCommandCollection() Me ._commandCollection = New System.Data.SqlClient.SqlCommand(0) {} Me ._commandCollection(0) = New System.Data.SqlClient.SqlCommand Me ._commandCollection(0).Connection = Me .Connection Me ._commandCollection(0).CommandText = "dbo.spRaChecks" Me ._commandCollection(0).CommandTimeout = 0 Me ._commandCollection(0).CommandType = System.Data.CommandType.StoredProcedure Me ._comm ...Show All

• SQL Server Date query problem

  Why there’s a problem with the folloe select statement: SELECT * FROM table1 WHERE ISNULL(DATE_FIELD) DATE_FIELD is a datetime field of the table table1. There’s an error that this function need 2 arguments, but I find in th help that is only one of them. How can I do that hi, ISNULL(a, b) is a function to replace "a" with "b" in case of "a" being NULL.. it's equivalent to CASE WHEN col_A IS NULL THEN b END operation.. what you are looking for is the .... WHERE DATE_FIELD IS NULL .... comparison... http://msdn2.microsoft.com/en-us/library/ms191270.aspx regards ...Show All

• Visual Studio Express Editions disappeard items in designer

  I have a program with a menu-bar and a statusbar. Ther were a lot of items in these bars, but suddenly they have disappeard. In Designer you can't see them, but in the Code you can still use them and while compiling, there isn't a fault. In debugging-mode they also have disappeared. How can I get all these items back Thx! I had the same problem numerous times and I have discussed a solution for it in one of my posts. Even if you're already rebuilding the project I'll leave here my solution for reference. In the Form1.designer.vb file, you should have this piece of code for the MenuStrip (the names and values may differ): ' 'MenuStrip ' Me .MenuStrip.Location = New System.Drawing ...Show All

• .NET Development question about sending mail ...

  I want to build a webpage which can sending mail to user when they are forget their password user only have to enter ID and MAIL ADDRESS. and then will compare which data user input with DB, if math and then sending password to user. I just wrote these code ... but it's obviously there is no data in my array.. is anything wrong with my connect string please help many thanks... my code is below... protected void BtnSubmit_Click(object sender, EventArgs e) { string Id = TxtId.Text; string Mail = TxtMail.Text; string pwd = ""; string StrConn = "Data Source=x.x.x.x;user id=sa;password=1234 ;initial catalog=member"; string StrSQL = "select Member_id,Member_mail,Member_p ...Show All

• SQL Server Create element names from data in "FOR XML PATH" query?

  Hi, all. I am writing a stored procedure to create an XML-formatted export from a relational database. I am succeeding for the most part with "FOR XML PATH" queries, thanks to help from these forums, but I've hit a new issue. I have a table we'll call "facet", and here is a subset of the table's columns: - facet_id (nvarchar(10)) - facet_type (nvarchar(3)) - facet_value (nvarchar(255)) Part of the XML schema requires that I list these facets, and the element ID is the facet ID. I need to create this: <facet_id>facet_value</facet_id> <facet_id>facet_value</facet_id> ...with, of course, both "facet_id" and "facet_value" populated from the database columns ...Show All

• Windows Forms Running a nested message loop

  I'm looking for a way to start a nested windows message loop in order to perform blocking calls which keep the GUI active and responding. ShowDialog is not appropriate because I'm not interested in the Modal behaviour but only the blocking call... Any ideas It isn't equivalent because as long as there are no messages in the message queue the thread remains in a suspended state (which meens it isn't getting any CPU time) until a message is queued. Have you tried running a loop and calling DoEvents The difference is notable. ...Show All

• Visual Studio Express Editions Academic Licence?

  Ok, i am a student in the UK and have seen this: (Visual studio 05 academic edition) http://www.dabs.com/productview.aspx Quicklinx=3YHK&CategorySelectedId=11164&PageMode=1&NavigationKey=11164,4294957493,4294956218,50310,11 can i just buy this and use it or do i need to speak to my college i didnt need to for office 2003 student and teacher.. thanks In order to purchase this proof of academic enrollment is required. I would consult your college deparatment for more information. It's quite possible that your school might be under the MSDNAA which will net you free copies of VS. ...Show All

• Visual C++ Error C3767 : why ?

  Hi, I'm moving a big project from VS2003 to VS2005 right now. I have solved almost all my problems but not this one. I have an assembly (azurCfrUtils.dll, compile with /clr) with this header : Yes, I could reproduce this and that was what I was afraid of. I forgot to test this, I just passed a null to my test method. There's something weird going on with the way the compiler treats native classes exported by the assembly. The object browser clearly shows the PublicIStorage type, IntelliSense sees it but yet when I reference it in code (like ClassLibrary1::PublicIStorage), I get C2039, 'PublicIStorage' is not a member of 'ClassLibrary1'. I found a workaround by going old school. I created a header file that looked like this: ...Show All

• SQL Server Sorting a table with numbers and letters

  I have a field (varchar) in a list that contains numbers and letters. I want to sort this table but I have only two functions that will work to convert the values: Val The Val function sorts the numbers in the string, but the letters are not sorted CStr The CStr function sorts the letters, but the numbers are not sorted How can I sort the numbers and letters I have renamed the numbers in the table (10 -> 0010) so all the numbers have 4 characters. Because I only need the numbers I have set a filter "BETWEEN 0 AND A". The sorting is no problem anymore. ...Show All

• Microsoft ISV Community Center Forums VSTA support

  Will a VSTA help forum be added here Or replace this forum ...Show All