den2005's Q&A profile

• SQL Server Is it possible that I change the data's type when I create the DSV in the Visual Studio 2005?

  Hello everyone: Recently, I was responsible for creating a analysis services project with the SQL Server Business Intelligence Development Studio in Visual studio 2005. I encountered a error that the data type is not supported when I tried to add the table from a remote Oracle server. I can not modify the data type in the oracle server. Is it possible that I change the data's type when I create the DSV in the Visual Studio 2005 (if I have known the table's name) Help me Please! tell me the steps or some references if it is possible Thanks While I don't think you can change the data type of the column within the DSV, what you can do is add a named calculation to the table within the DSV and use a snippet of Oracle to cast t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any XNA books on the horizon?

  Hi. I was wondering if Microsoft (or any other publishers) are planning on releasing an XNA guide for the final release Such a book will encourage many more XNA coders by making it more accessible.  I personally think it's a must.  Even an electronic version would be fine.  Learning from forums or the odd tutorial you find around the net is great, but it can't replace a good solid well thought out book by your keyboard. Otherwise, XNA could go down the road of Dark Basic.  Plenty of keen bedroom coders frustated by the lack of a good comprehensive nuts and bolts guide. If there is one, I hope it doesn't try to cover the fundamentals of C#, there lots of books for that.  Here's a ...Show All

• Visual Basic Problem whit publishing

  When publishing program to a computer thet don't have internet access and framework i found thet i have to include prerequisites. Becose prerquisites can't be downloaded from web in properties i specify thet prerequisites download from the same location as my application. When publishing start i got three errors: Error 1 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX\instmsia.exe' in item '.NET Framework 2.0' can not be located on disk. Error 2 The install location for prerequisites has not been set to 'component vendor's web site' and the file 'DotNetFX\WindowsInstaller-KB893803-v2-x86.exe' in item '.NET Framework 2.0' can not be located on disk. See Help for more info ...Show All

• SQL Server Problem with Updatable Subscriptions

  Hi all, I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg " Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this. Quick question: how much update are you doing on your subscriber and how frequent Here is a direct quote from BOL http://msdn2.microsoft.com/en-us/library/ms152570.aspx The following types of replication and replication options allow you to make changes at a Subscriber and have those changes flow to the Publisher: Type of replica ...Show All

• Visual Studio 2008 (Pre-release) svcutil.exe datacontract only is not generating minOccus='1'

  Call "C:\Program Files\Microsoft SDKs\Windows\v1.0\Bin\svcutil.exe" /dconly /out:..\..\DataContractXSD.cs /t:code "$(ProjectDir)Data.xsd" Data.xsd file has < xsd:complexType name =" AccessInfo "> < xsd:sequence > < xsd:element name =" User " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" Password " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" ApplicationID " type =" xsd:string " minOccurs =" 1 " maxOccurs =" 1 "/> < xsd:element name =" ClientIPAddress &quo ...Show All

• Visual Studio Team System Data Generation - skipping a table should be a warning and not an error

  1) Currently, if an error occurs during data generation in one table, many other tables have a red error sign in their status field because "table was skipped because other tables could not be completed". The problem is that it is difficult to see/find the table which has an issue. If skipping a table would be a warning, maybe a yellow sign in the status field, it might be easier to find the "problematic" table. 2) Double clicking the error has no effect. However, maybe it should open the column definition of this table. 3) a user modifies a dgp. He clicks on run dgp without saving it first. Wouldn't it be possible to ask a user, if he wants to save the dgp first 4) constraints: at this point the automatical ...Show All

• SQL Server SQLCMD VS BCP

  Hello, I have the following BCP bcp.exe "SELECT * FROM LAW.dbo.A" queryout "C:\Test\Test.txt" -c -q -C1252 -T -S "SEA2-LawrenceB1" -t "," ResultSet Seattle,Lawrence,1 New York,Jeanette,2 However, my issue is that BCP DOES NOT include Header in ResulSet. Ideal ResultSet (first row is Header) City,Name,Num Seattle,Lawrence,1 New York,Jeanette,2 I would like to use SQLCMD to include Header info. However I am not able to find the correct switches to accomplish this. The current format which I DO NOT desire includes - "..........." on the second time, "<rows> are effected" message is returend. Let me know if any of you could help me with this ideal format in ...Show All

• SQL Server Calc Measure - aggregation behaviour differs between cube and mdx

  Howdy, I have a calculated measure for a division that is calculated something like this (simplified): MEMBER [Measures].Grade AS [Measures].Metal / [Measures].Tons This measure is persisted in the cube. Normally, the measure correctly aggregates (ie shows Sum(Metal) / Sum(Tons)), but when I put it in MDX as follows, it incorrectly shows Sum(Metal / Tons): WITH MEMBER [Date].Calendar.YTD AS SUM (YTD( [Date].[Calendar].[Date].&[2006-03-26T00:00:00] ) SELECT [Date].Calendar.YTD ON COLUMNS, [Measures].Grade ON ROWS FROM [TheCube] I assumed that this behaviour was because I was aggregating the measure via the SUM() and YTD() functions, but when I take this measure out of the cube and place it in ...Show All

• Visual Basic Help on making a Defragmenter

  Hi, not sure if this question goes here, but, I would like to try make my own defragmenting program, any info on how to or where to start to be able to make this in visual basic 2005 pro, I know the theory, but not sure how I can get the info from a disk, and start putting the files togheter, I would like to start this small project using the basic floopy disk (less risk of ruining my Hard drive) so if anybody can give me a hand or guide me some sample code or in the correct direction, I would appreciate it a lot. In advance I want to thank the people that answer me. Have a nice day Is there any way I can do it in Visual Basic .NET 2005, my future plan is develop my own recovery software, defrag ...Show All

• .NET Development Update SQL database...Please help

  I have set up a button that when pressed the data that is present in the textboxes is supposed to update to the SQL server database. I cant see anything wrong with my code and my stored procedure. Is there anything anyone can see Grateful for any advice. The page that I am trying to use to update my database is being populated by a querystring. Here is my code: Private Sub Page_Load (This is working fine...page is loading) Dim cnn As SqlConnection = New SqlConnection("etc.etc") If Not IsPostBack Then Dim ds2 As DataSet Dim dr2 As DataRow Dim adpt As SqlDataAdapter Dim cmd2 As SqlCommand Dim Id As Integer Id = CInt(Request.QueryString("CustomerID")) ds2 = New DataSet cmd2 = New SqlCommand("GetCustomer", cnn ...Show All

• Visual Studio 2008 (Pre-release) how to move ResourceDictionary into separate assembly?

  In a windows app I got a custom control. This custom control has its own style which resides in a separate ResourceDictionary. This does work like it should! Now when I move this control and it's style into a separate assembly, it does not work anymore. The control is still found (using the right namespace in xaml), but the Style is not (and without the style the control does not show anything). I wonder what I need to do to move a ResourceDictionary to a separate assembly. Does it need to be loaded manually Thanks, Sam Zhou Yong wrote: I think what you are trying to do is to make a theme assembly, right honestly, no, I didn't want to make a theme assembly - it's just the only ...Show All

• .NET Development datetime insertion problem

  i'm using sql server 2005 under asp.net 2.0. when i try to insert values of table columns , i get the error : {System.Data.SqlClient.SqlException: Incorrect syntax near '.2007' when i debug the sqlQuery, i see it is : INSERT INTO ASILTER_INBOX (tarih_saat,kimden,kime,konu,govde,atac,okundu,silindi) VALUES (16.02.2007 17:44:18,'ALISNMZ','ASILTER','Naber','OOo o 0o0 o OO oooo!','','false','false') the tarih_saat column is datetime at the database. could anyone reply to me, i need a quick help. thanks. Hi, You can try for cast function. INSERT INTO ASILTER_INBOX (tarih_saat,kimden,kime,konu,govde,atac,okundu,silindi) VALUES (cast('16.02.2007 17:44:18' as datetime),'ALISNMZ','ASILTER','Naber','OOo o 0o0 o OO ...Show All

• Visual C++ Deployment issue (XCopy)

  Hi, I wrote an application in native C++ with Visual Studio 2005, and now I'm trying to deploy it. I have a problem with Side by Side libraries. If I use Windows Installer for deployment, no problem. It detects the dependant runtime library (Microsoft.VC80.CRT ) and copies it in the C:\Windows\WinSxS directory. It works well this way. But my program must be able to run in a totally independant way, on a CD-ROM, without installing anything on the client PC (Windows directory might be potentially locked). So I'm looking for a way to use Microsoft.VC80.CRT in the local directory of my executable. It was possible with VS 6.0, by copying some DLLs beside the program, but now... I looked on the web and found an interesting notion : private assem ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Riemers.net -- 4th Series finished: Final screenshots

  Hi all -- I've been working on a 4th Series of XNA Tutorials, which deals with advanced terrain rendering. This series is completely new; it is not a translation of one of my MDX series. The graphical part of the series has been finished, so you can already have a look at some screenshots: XNA Tutorials Series 4: Advanced terrain You can expect the first chapters somewhere next week. I first have to clean up some code and get the skydome exported to a .x file! If you have some experience with this, head over to this thread please.   ps: you can find links to 2 larger screenshots in the 3rd paragraph. Just a quick suggestion for an alternative to using .x. Could you serialise it to your own (simple) ...Show All

• SQL Server In SQL Server 2005, is there any equivalent of taskpad of SQL Server 2000

  In SQL Server 2005, is there any equivalent of taskpad of SQL Server 2000. (in Express Edition ) I found it. From SQL Server 2005 (SSMS), select the database & goto Summary tab (F7). Click on Report drop-down & select the report you want to see...... ...Show All