Al33327's Q&A profile

• Visual Studio Team System New Schema import does not import extended proprities of the Tables

  New Schema import does not import extended proprities of the Tables although the "Ignore Extended Proprities" check-box in the Options Setup was not cecked. I did this with the most innocent "Adventure Works" DB. Please advice. I will like to refer to Jamie Thompson's blog regarding mapping between TFS builds and different DataDude releases. It seems that there is no other way than his mapping to find out what Data Dude Release you're running: http://blogs.conchango.com/jamiethomson/archive/2007/01/17/VSTS4DBP_3A00_-Datadude-build-version-numbers.aspx ...Show All

• SQL Server Unable to remote connect, SQL Server, Error: 1326

  SQL Express running on Server 2003 SP1, not a domain controller - but prior to installing SQL Express, I did dcpromo promote and then demoted it back to a workgroup server. Connecting with Vista build 5600, Studio express 9.00.2047 with MDAC 6.00.5600.1638. Server 2003 MDAC is 2.82.1830. I came across this article on the net: http://www.developersdex.com/sql/message.asp p=1867&ID=%3C309C7496-F36B-4398-9C52-322E6CB8DE3B%40microsoft.com%3E Is my mis-matched versions of MDAC causing me this grief Otherwise, I have remote set up for TCP and Named Pipes, I've run sp_configure 'remote admin connections', 1; my login is set to SQL Authentication with everything granted. I've tried running the service as network, local and Machi ...Show All

• Visual C# Sending email using enduser's default mail settings

  Hi, I need to add simple email capability to my app but I don't want to bump into issues like end user smtp authentication, etc. Is there a simple way to automate end users default email client to send email Thanks ! unfortunately not - you need to supply the SMTP class the correct credential details as well as SMTP gateway, or use your own :-) The end user may not have a default email client, or if they do then you could probably use the email client to send an email but they would have to hit the "send" button. You could use the outlook COM interop approach but again, it may not work as the end user may not have outlook installed. Take a look at this for programmatically compos ...Show All

• SQL Server dynamic mdx

  Hello i'm new user, i have a calculated member the function LINREGSLOPE juste calculate the  slope ( ie: a ) of the equation Y= a *X+b calculated member Name= Gain LINREGSLOPE ( [ TIME].[Month].&[2006-02-01T00:00:00] : [TIME].[Month].&[2006-06-01T00:00:00] ,[ Mesures].[NumofCustomer],[TIME].[Month], [TIME].[Rank])  i write the formula do the job veru well. What i want to do now is to transform the expression to be dynamic with two parameter  I hope this will help. I seen in this forum that this is possble. how to extract this information. How can i concat the parametre!month.value with the string i see idea of solution here but i dont k ...Show All

• SQL Server Dynamic Database Connection - EXCEL to SQL Server

  Hi *, is there a way to connect Excel to SQL Server so that Excel serves as a frontend to SQL Server I heard rumors that this is possible with the 2007 release. I'm looking for a product that helps me storing massive data outside an Excel file. Right now, I'm using Palo (open source multidimensional database). Regards, Steve Visual Studio Tools for Office focuses on the scenario that you describe...you can find a good article that walks through the same basic scenario at: http://msdn2.microsoft.com/en-us/library/aa192473(office.11).aspx If you can't use Visual Studio Tools for Office, you could potentially use a poor man's version of what it does under the covers. By adding an "Update" column and using the code in the li ...Show All

• SQL Server Runtime Error! SQL Management Studio Express

  We recently installed SQL Management Studio Express in our class rooms. For some classes, we want to hide the "Object Explorer" and start a "New Query" window when it is opened. This opion is under Tools, Options. When we do this config, we get a Runtime Error! Program:...\SQL Server\90\Tools\Binn\VSShell\Commom7\IDE\ssmsee.exe R6025 -pure virtural function call Then the program closes. There is no way to get back in. Uninstalling and re-installing using both Add and Remove programs and manually does not seem to work. Any ideas Please file a defect report at http://connect.microsoft.com . Defects reported at this site go directly into our internal issue tracking sys ...Show All

• Software Development for Windows Vista standard user cant write to admin created file

  Hi, I used to have a file on XP under Documents and Settings\All Users\Application Data\AppName that contained info for all users by having each user add a section to it. On Vista I need to store All Users data under C:\ProgramData\AppName. I am using the ShGetFolderPath with CSIDL_COMMON_APPDATA, so that works out fine and I dont need to change anything. However if the first time I use my app and create that file is under the administrator account I can not write to that file while logged in as another user, a standard limited user. I can create a new file under that limited account, but I cant write to a file created by an admin. Is there any way to get passed that, besides having a different file for each user stored i ...Show All

• Windows Forms Help with Login Coding

  I could really use some help on making a login form for my C# program. I am attempting to make an organizer for a Trading card game that will require using a database for each user involved. the only way that I know of to call the correct database for each user is to create a login form. I am having trouble doing so. If I could get some help or a template or something it would be GREAT!!! P.S. I am a beginner at C# programming without unlimited Internet access. I am going to need either 1) links or 2) direct help over this forum. thanks in advance MattDude The approach that I usually take is before your main form is shown, show a login form. Code the login form to be able to us ...Show All

• SQL Server Using Variable in SQL IN Clause

  I have a table name emp(empid) having one record as emp1. Now i am writing DECLARE @EmpID VARCHAR(8000) SET @EmpID = '''Emp1'',''Emp2''' Select * from emp where empid in(@empid) But there are no rows returned can't i use variable in IN Clause. I have to achiev this backend only. Hi You can happily use variables in any clause including 'in' You can use a simple statement Try the following statement: DECLARE @EmpID VARCHAR(8000) SET @EmpID = '''Emp1'',''Emp2''' Exec('Select * from emp where empid in(' + @empid + ')) ...Show All

• Visual C# Listing files and folders, TreeView usage problem.

  There is problem with the Nodes.Add, What i need to create treeview as it should be Here is the code, try run it if you dont see the problem. private void Form1_Load(object sender, EventArgs e) { // Dirs foreach (string dirs in Directory.GetDirectories(@"C:\")) { if (dirs != "C:\\System Volume Information") { TreeNode node = new TreeNode(); node.Text = dirs; treeView1.Nodes.Add(node); // this works // Subdirs foreach (string test in Directory.GetDirectories(dirs)) { TreeNode subdirs = new TreeNode(); subdirs.Text = test; treeView1.Nodes.Add(subdirs); // here it is. Should be &qu ...Show All

• SQL Server There's just no escaping it... data containing quotes ruining CSV files

  Much to my surprise and dismay, after burning hours and hours developing various SSIS packages to extract data from my SQL 2005 DB to CSV flat files, I found out the hard way that SSIS doesn't properly escape quotes (") in the data (my output file is required to have quotes as text qualifiers). It seems like I'm pretty much forced to create derived columns to test for the existence of quotes in my data, then either escape them or replace them with another character. This is really NOT COOL. Not only will this significantly hinder performance, it makes my packages a heck of a lot more complicated (especially when I'm exporting lots of text columns). Am I doing something wrong, or does SSIS really not escape the text qualifier ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Game Components, Game.GameServices and GraphicsDevice

  I've been working on some Game Components and was following an article by Mitch Walker about exposing GraphicsDevices between Game Components through Game.GameServices . I thought I'd try it out as it would make things so much easier.So, I went through the article and implemented what was needed, but I still can't get at the GraphicsDevice for some reason. Inside my Game Component, I have: private IGraphicsDeviceService GraphicsDeviceService; public override void Start() { // TODO: Add your start up code here GraphicsDeviceService = this.Game.GameServices.GetService<IGraphicsDeviceService>(); GraphicsDeviceService.DeviceCreated += new EventHandler(GraphicsDeviceService_DeviceCreated); GraphicsDeviceService.DeviceReset + ...Show All

• SQL Server SQL 2005 Express New Login

  Hello all Im new to SQL 2005 express so please bare with me, I have set up wireless peer to peer network and I am trying to access an express database from one machine to another. I can transfer files no problem. When I try to create a new login, I am forced to only select logins local to the machine with the database. When I try and create a new login by typing <machinename><windows account > of the second PC, SQL can not see it. I have tried both Windows authentication and mixed mode... no success. Any ideas Thanks That is standard Windows behaviour: either use accounts or groups from the local machine or make the machine member of a domain to allow domain users to get ...Show All

• Visual Studio Team System Items missing fron Web Forms Toolbox

  Hi I am working on a web project in Visual Studio .Net 2002 Service Pack 1. In the Web Forms Toolbox TextBox and SummaryValidation items are missing, these items were there and i used them also but when i next opened the project the items were missing. Pls help Hi, This is a forum for VS2005 questions reguarding the Team System Edition for Testers. Based on your quesiton it seems like you are asking about VS 2002, and I'm not even sure what forum would handle previous releases. You might need to consider contacting customer support. Regards, David R. Williamson ...Show All

• Silverlight (formerly WPF/E) XAML caching issues

  Whenever I change the contents of a WPFE XAML file I have to delete the previously cached file from the Temporary Internet Files directory in order to see the change reflected in the browser. Is this a known issue I’m using IE 7, but Firefox seem to have the same problem. Any comments on this would be greatly appreciated! Thanks a lot! /Billy PS: For debugging purposes, I attempted to write a console app that would automatically remove all the XAML files in the Temporary Internet Files directory upon recompiling my solution. However, since that directory isn’t an actual directory but rather an “illusion” provided by the Windows shell, this is not an easy thing to do. I'm having the same proble ...Show All