Awais786's Q&A profile

• SQL Server Problem saving/retrieving unicode characters NVARCHAR with unicode collation (java jdbc)

  I'm connecting to a SQL Server 2005 database using the latest (beta) sql server driver (Microsoft SQL Server 2005 JDBC Driver 1.1 CTP June 2006) from within Java (Rational Application Developer). The table in SQL Server database has collation Latin1_General_CI_AS and one of the columns is a NVARCHAR with c ollation Indic_General_90_CI_AS. This should be a Unicode only collation. However when storing for instance the following String: €_￡_UUUUuuuu_AAOaaos￡CcNn_ _ _ _ . .. it is saved with for all unicode characters as follows (when looking in the database): €_￡_UUUUuuuu_AAOaaos￡CcNn_ _ _ _ The above is not correct, since all unicode characters should still be visible. When inserting t ...Show All

• Visual Studio Issues loading Add-Ins

  I get nuts trying to install Visual Studio .NET 2005 add-ins. E.g. I tried to install the VSFileFinder2005 add-in. Now it seems that VS.NET is loading the add-in, Filemon tells me the add-in is being accessed by VS: (Image file: http://magerquark.com/data/misc/vsfilefinder2005-01.png ) But in the options it tells it is broken: (Image file: http://magerquark.com/data/misc/vsfilefinder2005-02.png ) And in the Add-in Manager dialog it doesn't show up at all (only another add-in that is not installed through the xcopy deployment installation way): (Image file: http://magerquark.com/data/misc/vsfilefinder2005-03.png ) Question: Can someone help me solving this Any place to look for debugging (logfiles ) that VS.NE ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3D rotation help

  Hi everyone, i have a 3D model(it's the p1_wedge.fbx model from the spacewar game) and i'm trying to rotate it, example when i press left it rotates left, when i rotate it up it rotates upwards, but whenever i have 2 or more of "effect.World = Microsoft.Xna.Framework.Matrix.CreateRotationX(modelrotationx);"s(change the x to whatever axis)it only rotates left and right or only up and down or it doesn't rotate at all...here is my foreach code block: foreach (BasicEffect effect in mesh.Effects) { effect.EnableDefaultLighting(); effect.World = Microsoft.Xna.Framework.Matrix.CreateRotationY(modelrotationy) * mesh.ParentBone.Transform * Matrix.CreateTranslation(modelposition); eff ...Show All

• SQL Server Restore SQL Server Express Databases after a Disaster Recovery

  Hello, I would like to restore SQL Server Express and its databases from a tape backup to the same server. This is a disaster recovery senario. I backed up the Master, Model, MSDB and my own test database using SQLCMD scripts. I have no problem restoring these using task manager on the server before the disaster recovery. However, in my real disaster recovery testing, When the server is restored by tape drive (HP one button disaster recovery), I try to run my SQLCMD restore scripts in task manager and I cannot connect to the sql server. Also I cannot connect with Management studio. I have recieved the following error in event viewer. ---------------------------------------------------------------- Event Type: Error Event Sou ...Show All

• Visual Studio 2008 (Pre-release) Composite GoF pattern

  Hello! Can't you show how to make the Composite GoF design pattern using TPH: table-per hierarchy Particularly I obviously think of the three XML files needed! Best regards, Henrik Dahl Hello again! Isn't there actually the problem in your solution, that it's TeamComponent which aggregates TeamComponent and not Team which aggregates TeamComponent Best regards, Henrik Dahl ...Show All

• SQL Server What user is performing this code

  Hello, on one of the discussions i've foudn this code Private m_headerImage As Object Public Function GetHeaderImage() As object ' be sure to add appropriate error handling If m_headerImage = Nothing Then Dim adapter as new System.Data.SqlClient.SqlDataAdapter("Select ThumbnailPhoto From Production.Productphoto", "Data Source=localhost; Initial Catalog=AdventureWorks; Integrated Security=SSPI;" ) Dim ds as new System.Data.DataSet() adapter.Fill(ds) m_headerImage = ds.Tables(0).Rows(0)(0) End If Return m_headerImage End Function and then this code is called by a =Code.GetHeaderImage() at then image value property. In the Print preview from the devStudio it works, when publishing and running the repor ...Show All

• Software Development for Windows Vista Why IVMRMonitorConfig9::SetMonitor can not work

  I have two monitors with a graphic card with two DVI interfaces. In MSDN, it said The VMR-9 supports a maximum of 16 display devices. The interface IVMRMonitorConfig9 determines the display devices on the system. However, its SetMonitor method seems did not work. My code is: CComPtr<IGraphBuilder> pGB; CComPtr<IVMRMonitorConfig9> pMonitorConfig ; CComPtr<IBaseFilter> pVmr; HRESULT hr = CoCreateInstance(CLSID_VideoMixingRenderer9, NULL, CLSCTX_INPROC, IID_IBaseFilter, (void**)&pVmr); hr = pVmr->QueryInterface(IID_IVMRMonitorConfig9,(void **)&pMonitorConfig); hr = pMonitorConfig->SetMonitor(1); hr = pGB->AddFilter(pVmr, L"Video Mixing Renderer 9"); But, the MFC-dialog sti ...Show All

• Visual C# Need help converting VB to C#

  Hi Can someone help me by converting this VB to C#. Thanks a bunch. James Keele Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click MsgBox(Modulo10(TextBox1.Text)) End Sub Private Function Modulo10(ByVal strNummer As String) As Integer 'strNummer may only contain numbers between 0 und 9! Dim intTable(10) As Integer Dim intTransfer As Integer Dim intIndex As Integer intTable(0) = 0 : intTable(1) = 9 intTable(2) = 4 : intTable(3) = 6 intTable(4) = 8 : intTable(5) = 2 intTable(6) = 7 : intTable(7) = 1 intTable(8) = 3 : intTable(9) = 5 For intIndex = 1 To Len(strNummer) intTransfer = intTable((intTransf ...Show All

• Windows Forms Placing Shortcut That Can Be Accessed by All Users

  Hi ! I have created a Setup and Deployment project to install my application. I have a help file that I deploy into the Application folder which is under 'Program Files' folder and I place a shortcut to it in the User's Program Menu under a folder. The installation is done by the Administrator and the application is installed for 'ALL USERS'. Everything else is fine but when some other user logs on to the system and tries to access the help file from the User's Menu by accessing the shortcut, the help file does not open. Instead the application begins to reinstall somehow from the original location. I would like the help file to be accessible to all users. I know there is an option to use 'Custom Folder' during setup in the 'File Sys ...Show All

• Visual Studio Team System How to run run new tests in an existing team build?

  Hi All,   Been searching for a article or knowledge on how to run tests in a new test projects.  The new test project was created afterwards and has been added to an existing solution that has an existing Team Build already created.  I changed the team build property to "true" in the TFSBuild.proj file and ran the build, but no tests were run. < RunTest > true </ RunTest > The team build is not running the tests and completes successfully.  What am I missing   Thanks   Mike You can also run tests without using a test list (instead, you point the test tools task at the assemblies which contain the unit tests) using the sample ...Show All

• SQL Server SetDefaultInitFields fails for a Column using ExtendedProperties

  Hi, Using SetDefaultInitFields fails for a Column when specifying "ExtendedProperties" as a field. note: SetDefaultInitFields seems to be ok with "DataType" as a field. The exception is "unknown property ExtendedProperties". Thoughts on what might be the issue with loading the ExtendedProperties Thanks, Andy B Following is a snapshot of the test code: System.Data.SqlClient. SqlConnection dbConnection1 = new System.Data.SqlClient. SqlConnection (); dbConnection1.ConnectionString = "Data Source=.\\SQLExpress;Integrated Security=SSPI" ; dbConnection1.Open(); Microsoft.SqlServer.Management.Common. ServerConnection serverConnection1 = new Microsoft.SqlServer. ...Show All

• SQL Server Tracking Schema changes in SQL server 2005 db

  I wonder how can I track the changes in the columns whether added, deleted or their name is changed and how can I test that your help is appreciated I tried that and it only fires the trigger when changing the column type and not in the case of a column name. Our question is how to monitor a column name change . Thanks ...Show All

• Visual Studio Tools for Office Assembly location during debug differs from output folder

  Hello, I'm migrating a Word 2003 shared addin to a VSTO 2005 SE Word 2007 Addin. This addin uses some xml files which should be located in the same folder as the Addin is. In the previous version I looked these files up by using the System.Reflection.Assembly.GetExecutingAssembly.Location This worked perfect, but now If I debug the project all the required files are copied to the bin\Debug folder but the System.Reflection.Assembly.GetExecutingAssembly.Location give me a location that is comparable to C:\Users\ username \AppData\Local\assembly\dl3\RT5TDQVD.CGJ\T81B2ATH.YXM\65ce212f\0dea5369_3e50c701 This folder is created on every debug and it does not contain my xml files. Who knows a solution for this problem ...Show All

• SQL Server Relative date ---'Rolling 3 months' --help please

  Hi, I need to add special relative date categories in SSAS that similar to the functionality offered by Cognos/Powerplay. With Cognos, you can create relative time categories very easily-- like ‘Rolling 3 months’, ‘Prior Rolling 12 Months’ etc. I created Time Dimension with SSAS BI Studio, added a new named calculation ‘Rolling 3 Months’ to the Time Dimension. Below is calculation code: CREATE MEMBER CURRENTCUBE .[Time].[Rolling 3 Months].[Rolling 3] AS null , VISIBLE = 1 ; Scope ( { [Measures].[ORDERS] } ); // Rolling 3 Months ( [Time].[Rolling 3 Months].[Rolling 3], [Time].[M ...Show All

• Visual Studio Team System Build/Deploy Failure - inconsistent contents?

  Hi Using Visual Studion Team Suite 2005 we're unable to Build or Deploy a number of projects within a solution. The following error is produced at each attempt. Error: The internal state of the database project is inconsistent with its contents. Unload the project and then reload it to resolve the issue. Doing as advised, unloading and reloading the project, produces no improvement. Neither does creating a new solution with the same projects, nor deleting the local workspace copies of the projects and re-loading via the Source Control Explorer. The same projects can be deployed on an alternative PC, suggesting problems with the local copy, hence re-loading everything from source control. All other functionality works fin ...Show All