SquishyPBJMom's Q&A profile

• SQL Server SQL Configuration settings being ignored?

  I am sure I'm being blind here (it wouldn't be the first time - and won't be the last time). I have a package that retrieves some values from SQL table to allow me to dynically create an email message, so it retrieves To Addresses, From Address, Header, Body from a table, populates variables, and uses expressions to assign those to the SEND MAIL TASK. That is working (after a bit of head/wall/banging to get my default virtual SMTP server running locally). Now I am trying to make the SMTP Server Name dynamic. The Property SMTPConnection specifies the SMTP Connection Manager to use, and not the server, so it doesn't seem as though I can configure a property on the SEND MAIL TASK to achieve this. Now I'm focussing on using SQL Package Configu ...Show All

• Visual Studio How to create a report from a collection of DataGridView rows

  Hi, I have a datagridview with a number of selected rows. What I need to do is be able to create a crystal report that shows the selected rows. Does anyone know where to start with this cause I'm at a loss, the only solution I could come up with is to create a table in a database and add each row and then create a report from the table, this is not idel. So if anyone knows where to start please do let me know. Thanks Jon I have a report that pulls data based on what is selected in a combo box. And believe me, I needed major help with this one and it is still pretty confusing but maybe it will at least give you a starting point. Here is my stored procedure (the '''' around the end date, are 4 sing ...Show All

• Visual Studio Tools for Office How can i extract my OLE Object(.xml file) from Excel and save as a file xml file programmatically?

  Hello, I have a one OLE Object(XML file) embed in Excel file. now how can i programmatically extract that OLE Object from excel and save as a .xml file. Any idea... well i used excel interope object in my code This way i can add OLE Object in excel file. oWorkSheet.OLEObjects.Add(Filename:=sTxtFileName, Link:= False , DisplayAsIcon:= False ) This way i can copy OLE Object from excel to Clipboard oWorkSheet.OLEObjects(1).Copy() But now i don't know what can i do with this clipboard data to extract data in a file. ...Show All

• SQL Server Localization of Report Manager to Portuguese

  Hello to all! I want to translate de interface of the Report Manager to Portuguese. I'm develop a class that implements Microsoft.Reporting.WebForms. IReportViewerMessages The class is in a file called "ReportViewerMessages.cs". The structure is like this, the project is called "PortugueseReportManager", there is a namespace named "PortugueseReportManager" and the name of the class is "ReportViewerMessages". So far so good, but when I change de web.config file in the report manager folder I'm getting over and over this error message when I try to see a report: The type PortugueseReportManager.ReportViewerMessages, PortugueseReportManager, Version=1.612.19.1, Culture=neutral, PublicKeyToken= ...Show All

• Software Development for Windows Vista Excel Addin does not create folders/Files at runtime on windows vista

  Hi, I am running an application on windows vista. This application is developed in VB 6.0 and is used as an Addin for MS Office Excel. I hav office 2003 installed on my machine. I login as a standard user ( UAC enabled). As part of the functioning of this Addin, 2 .avi files are created at runtime and a Debug folder is also created which will at runtime create file(s) containing debug info. When i run this application on windows vista, these avi files and debug folder is not created. And an error "File not found" is given for avi files. (VB error # 53). It also gives permission error for debug option as it cannot create Debug folder. Can anyone (especially microsoft guys) suggest a solution for this please. I need ...Show All

• SQL Server Incorrect Results with t-sql Query in SQL Server 2005

  I'm seeing some change in behavior for a query in SQL Server 2005 (compared to behavior in SQL Server 2000).  The query is as follows: ------------ create table #projects (projectid int) insert into #projects select projectid from tblprojects where istemplate = 0 and projecttemplateid = 365 Select distinct tblProjects.ProjectID from tblProjects WITH (NOLOCK)       inner join #projects on #projects.projectid = tblprojects.projectid        Inner join tblMilestones WITH (NOLOCK) ON tblProjects.ProjectID = tblMilestones.ProjectID              and tblProjects.projectID in (       &n ...Show All

• Visual Studio Express Editions Can't install VC++ Express from .iso on CD

  I downloaded the Visual C++ Express .iso file and burned a CD ROM so I can install it on a machine that is not connected to the network. The PC has VS6.0 on it but nothing after that. I successfully extracted all the files to a directory on my hard drive, then clicked on setup.exe. Part way through, a box pops up telling me to "insert disk" because setup is looking for dotnetfx.exe. It wants me to insert the "Microsoft Visual C++ Express Edition - ENU disk1" but all I have is the CD ROM with the .iso. The dotnetfx.exe file is there, under wcu\dotNetFramework\, so I don't know what's going on! The "insert disk" window will only accept a path to one of my CD ROM drives... if I try to point it to the location ...Show All

• Visual Basic How can I handle winsock..?

  Dear all, I want to develop a program for IP redirection. Some of famous Internet program haven't proxy setting configuration. I want to used those programs with my proxy setting. So, I need to redirect IP when those program send request to their parent site. I try to used some of WinSock API to handle the winsock. I could know winsock's status when a program is using winsock and opening port. But I don't know how to handle to redirect IP to my proxy server. Can anybody help me please.. (stupix) ...Show All

• Windows Forms URGENT: Install from CD and update from Internet

  I have a database application deployed using ClickOnce. I deploy 2 version with these settings: - Publishing location : C:\MyProject\Deployment\ - Installation URL : http://www.xxxxxx.com/Setup/ - The application is available offline as well I first deploy version 0.7.1.0, then I deploy 0.7.2.0. In my deployment folder, I have 2 different versions. I upload them to http://www.xxxxxx.com/Setup/ I install version 0.7.1.0 from my hard drive(or it could be a CD), on first run it creates the database in Data folder of course. I close the application and run it again from the start menu. It says there is an update available, I install it. Version 0.7.2.0 works fine... HOWEVER, the Data folder was not copied so it creates another blank database!! ...Show All

• Visual Studio 2008 (Pre-release) LINQ Console Application Problem

  Hi !!! I have installed LINQ on Windows Server 2003. I already have Express versions of Visual Studio on my machine. I wrote a simple program in C# using LINQ using System; using System.Query; using System.Collections.Generic; using System.Text; namespace LINQ1 { class Program { static void Main() { string[] names = {"Burke", "Connor", "Frank", "Everett", "Albert", "George", "Harris", "David" }; IEnumerable<string> expr = from s in names where s.length == 5 select s.ToUpper(); foreach(string item in expr) { System.Console.WriteLine( ...Show All

• SQL Server Dynamic queue receive sql ?

  Hi There My activation sp must be able to read of various queues. I load a variable with the queue name that activated the sp btu i cannot get the syntax working to receive or get a conversation group of a queue name that is a variable. I have tried: WAITFOR ( RECEIVE message_body , conversation_handle , message_type_name , message_sequence_number , conversation_group_id FROM @callingQueue INTO @msgTable WHERE conversation_group_id = @conversationGroup ), TIMEOUT 2000 ; But i get this error: Incorrect syntax near '@callingQueue' . Looks like you cannot use a variable. So i tried the following: SELECT @SQL = N' WAITFOR ( RECEIVE message_body, conversation_handle, message_type_name ...Show All

• Visual C# Run exe from command prompt

  Can i create a console application to run a exe in the ms-dos prompt, on a timer application Has anyone every done this before If so can someone shoot me a link thanks ok this is now getting a bit complicated. what is the aim of your program what you are doing right now in that output window is executing a vbscript file, not your application but perhaps passing a reference to your vbscript file, with the reference of your application Currently in this example you have, your application has nothing to do with anything except the vbs file what is the aim of your application what do you want your application to do ...Show All

• SQL Server Installing/Deploying a .dtsx package

  Hi, I used to write DTS Scripts in SQL Server 2000 and schedule them as jobs with out problem. This was normally done within SQL Server its self. Now that I've moved to using SQL Server 2005 I've been learning how to use SSIS. I've successfully developed a package and managed to create a .dtsx file. Now I have 2 large books on the subject of SSIS but none seem to go into any detail on what to do next. So here’s my newbie question (I apologise if I sound dumb!): I don't want to run my package manually as the books keep telling me how to do. I need to have my package added into SQL Server 2005 somehow and then schedule it as a reoccurring job. Can anyone point me in the right direction Thanks Matt. H ...Show All

• Visual C++ Question. Need help.

  I have been learning c++ so sooner or later i can learn to program with opengl. I have been learning how to program in c++ from 3dbuzz but I am a little confused. I don't quite understand pointers and I can't figure out how to override operators. Can someone show me example of how to override a operator #include<iostream> using namespace std; main() { /* I kind of know that *Two means it's A operator but don't understand the &, I think It is the memory address but not sure if i'm right */ char One = '1'; char *Two = &One; *Two = '2'; /* Is there a way to print a pointer out The part I really dont get is what is Two with out the * */ cout <&l ...Show All

• SQL Server Weird results when printing a diagram in SQL Server 2005

  Hi all, I have a diagram that I'm trying to print. I'm getting a weird result on paper. I have 3 tables on the same paper. I use the standard view mode in order to see "column name", "condensed type" and "nullable" columns. When the print comes out, the first 5 rows of the "column name" column are masked by some sort of drawing. It's as if there was another table on top of the one I'm printing, like you can see the bottom right corner of it just hiding the 5 rows of the "column name" column. What is even more weird is that have the exact same problem on the 3 tables I'm printing. This "drawing" appears to be of fixed size because as I increase the width of the first c ...Show All