Zapp's Q&A profile

• SQL Server Detailed description on creating a dynamic excel file

  Is it possible that i can create a dynamic excel file (destination) ex, i want to create a Dyanamic Excel destination file with a filename base on the date this will run on jobs. Is this possible 11172006.xls, 11182006.xls Ravi, I did indeed forget a step. Before the dataflow which writes to the dynamic excel target file, add in a Execute SQL task against the Excel connection manager to create the table (aka worksheet). This is what you suggested at the very end and it does work. For example, CREATE TABLE `Excel Destination` ( `GeneratedInt_1` INTEGER ) Then create the connection string variable on the connection manager as follows: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\tem ...Show All

• .NET Development XmlSerializer deadlock/timeout in .NET 2.0

  I have experienced problems with the XmlSerializer in my application. Instantiating it causes a 10 minute timeout because the csc process seems to be deadlocked. The error is new since .NET 2.0. The problem only occurs in a slave process, not in any of the main processes which are started directly as services or from the shell. So what special about the slave process It's a .NET console application started fom a .NET service with Process.Start(), ShellExecute = false and RedirectStandardInput = true. The slave process reads commands from the master process in a background thread with Console.ReadLine(). In another background thread an XmlSerializer is instantiated and it fails. The error seems to be certain on machines with only on ...Show All

• Visual Basic Multiple Instanced Unmanaged DLLs

  In VB.net unmanaged DLLs are implicitly shared using "declare" and must be explicitly shared using "dllimport". Is it possible to access unmanaged dlls through an instance rather than as shared routines I'm not sure what your getting at Sam ...Implictly or explicitly shared variables are still and instance of a variable...it just happens to be the only instance...Maybe if you explain what you are trying to accomplish we can better help you A shared instance is a single instance... ...Show All

• Software Development for Windows Vista Vista C:\Documents and Settings\All Users\Application Data installs

  I have an app that installs in C:\Documents and Settings\All Users\Application Data + Program files dir/. what would be a good solution for me not to have 2 different program installs for 2 different OS.. XP & Vista.. You shouldn't hard-code paths like that. Not only will your code fail on different versions of the OS, you'll also fail on different language versions of the same OS (e.g., French Windows XP does not have a "Documents and Settings" folder), and on systems where the users' folders are not on C: (roaming profiles, profiles on a different local hard drive, etc.). Search MSDN for the term "CSIDL_COMMON_APPDATA" for references on how to install to that location in a portable manner. ...Show All

• Visual C++ Guide me Frnds

  hi Friends i have to develop a project on wave to mp3 convertor in c++ but dont know where to begin pls help me start this project Also, a better place for such issues is the newsgroups at http://msdn.microsoft.com/newsgroups OTP Thanks, Ayman Shoukry VC++ Team ...Show All

• .NET Development Editing and Deleting nodes in VB

  Howdy, I'm working with a program using an XML file, and I'm trying to delete and edit nodes and attributes (well, delete nodes and edit attributes). I've looked around a fair bit, including through these forums, and simply can't find any good easy-to-use tutorial or documentation on this sort of thing. Does anyone know how I can edit or delete nodes using VB.NET, or any tutorials Any languages is pretty much fine (I can sort of try to translate it, but I would really prefer something about VB.net, if anyone has something of the sort). I've looked all over, and can't really find anything that I'm looking for. Thanks so much! Anything really is greatly appreciated. Thanks again! -Robert Sergey you are so right.... typically I would ...Show All

• SQL Server Need help with a view ...

  I’m trying to create a Student Master view for reporting purposes. declare @date smalldatetime set @date = getdate() SELECT studemo.suniq AS suniq, studemo.ssid AS ssid, studemo.ident AS ident, studemo.lastname AS lastname, studemo.firstname AS firstname, studemo.middlename AS middlename, studemo.birthdate AS birthdate, track.schoolc AS schoolc, track.schyear, studemo.lastname, studemo.firstname, studemo.middlename, studemo.genderc AS gender, primlangc AS [Native Lang], homelangc AS [Parent Lang], stustat.graden AS graden, stustat.stustatc AS stustatc, zstustat.descript AS status, studemo.ethnicc AS ethnicc, lep, spec_ed, low_income, facdemo.lastname AS advisor_last, facdemo.firstname AS advisor_first, stustat.funiq AS funiq, @date AS [Lo ...Show All

• Visual Studio Tools for Office add in problem in outllok editor

  hi Experts, i created a add-in for MS Outlook. its working fine on outllok but its not dispplaying when i go to compose a mail. how to do that Try a cross-post to the Outlook programming and office.developer.addins newsgroup. You're more likely to find a number of people who work on a daily basis with the technologies http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.com.add_ins&lang=en&cr=US http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.office.developer.outlook.vba&lang=en&cr=US ...Show All

• .NET Development WebBrowser control

  I am using a WebBrowser control to automate login to a VPN through a web site. The software works except for one problem. When I use Outlook Web Access open an email causes a new window to popup. This new window goes back to the login screen, I guess since it is not associated with the WebBrowser process from my application. Is there a way for me to receive an event and open the new url myself The NewWindow event for the WebBrowser does not include the URL for the new window. Harry Kuhar I think I found a solution. private void Browser_NewWindow( object sender, CancelEventArgs e ) { Popupbrowser temp = new Popupbrowser( ((WebBrowser)sender).StatusText ); temp.Show(); e.Cancel = tr ...Show All

• SQL Server Grouping record based on a condtion

  Technology Type Size XYZ A 200 XYZ1 A 200 XYZ2 A 300 XYZ3 A 300 ABC1 X 238 ABC2 X 238 PQR B 320 MNO C 330 I have written a query on a table whose output will look like the above. I need to know if i should store this in a record set or create a temp table to get the following fuctionality. Now I need to concatenate the Technology based on Type and size. As you can see in Type A we have two sizes 200 and 300. We need to group the Technology of type A wi ...Show All

• SQL Server Package Configurations not so portable?

  I'm still struggling with finding a sound approach to creating configurations that are truly portable.  For instance if you use XML files to store configuration information, the path to the XML file that stores the configuration is baked into the package.  This would require the same file system structure on all machines that could host the package. Store in SQL server - one key thing that is valuable to configure is Data Sources - but how can you configure a data source at runtime by storing it as a config in SQLServer, when the data source itself is used to specify the server that stores the config information Environment variables or registry entries seem to be the most practicle because they truly are machine specific. ...Show All

• Visual C# Error in performing Fulltext search query.....

  Hai, I am trying to perform FREETEXT search on database. Here is the sample code, private void Button1_Click(object sender, System.EventArgs e) { try { sqlDataAdapter1=new SqlDataAdapter ("select * from Student where freetext (*,@srch",sqlConnection1); sqlDataAdapter1.SelectCommand.Parameters.Add("@srch",SqlDbType.VarChar,20); sqlDataAdapter1.SelectCommand.Parameters["@srch"].Value=TextBox1.Text; sqlDataAdapter1.Fill(dataSet1,"Student"); DataGrid1.DataSource=dataSet1; DataGrid1.DataBind(); } catch(Exception ex) { Label2.Text=ex.ToString(); } but am stuck with the following error- Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '@srch' . Source Error: Line 98: sqlDat ...Show All

• Visual Studio Tools for Office "Microsoft Visual C++ Runtime Library" error

  Since yesterday, my document customization created using VSTO 2005 causes an error to pop up in Word 2003 whenever I close the customized document: ------------------------- Title: "Microsoft Visual C++ Runtime Library" Body: "Runtime Error! Program C:\Program Files\Microsoft Office\OFFICE11\WINWORD.EXE This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information." ------------------------- With an OK button. If the document is saved before I close it, all of my changes are saved (including [Cached] fields), but if I choose "Yes" to save an unsaved document after clicking close, the save process is interrupted and the d ...Show All

• Visual Basic XML in Treeview

  OK , I have looked and still can't find the right stuff. SO I am working on this project, that takes an XML record and displays only the parent node in the treeview. That part I got but where my problem is when you click on the parent node it is supposed to navigate to a web page related to the node. Also by hoveing over the node I am supposed to have a tooltip description appear.My XML is as follows.... <title>Herbs</title> <link>C:\Documents and Settings\HP_Owner\My Documents\Dominion\Content\Database\herbs.html</link> <description>a book on herbs</description> In the tree view only the <title> wil;l display, when I hover over the node it should display the <description> and ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DX9 version of DXviewer.exe and/or complete code to load a .x mesh

  This project is a C++ DX9 app, i have a set of .x files i wish to load. I have several sample applications that load .x files, but they do not load all of them, however, the dxviewer.exe program works for all the files i need. My assumption is that the code and samples i have are missing something that is present or handled correctly in dxviewer. Since the dxviewer source was included in the DirectX SDK, so i figured that would have the answer. The problem is that the source code does not run, it looks for d3dx10d.dll which does not exist (WinXP), the source refers to dx9 and 10, and the actual dxviewer.exe program with the sdk works fine. So i'm assuming there is some way to make the viewer not dependent on dx10. I tried removing the ref ...Show All