Mike Blaszczak's Q&A profile

• SQL Server Help with Connections

  Hi everybody, I need a little help... I created several packages, that after their creation should not be changed again; that's why I created a Package Configuration File in which I set all the Connections I need, so that this is the only file I have to modify. I set there also the path of the connections for my log file and for my error files (which are both text files), but if I change their paths in the configuration file this change doesn't affect the package, and the path of the log remains the same. That's an image of one of those packages.... The fact is that I cannot change the ConnectionString of the connection c ...Show All

• SQL Server USING the IN in STORED PROCEDURE

  I have a problem in passing parameters on stored procedure using the IN in the were clause as below ALTER PROCEDURE SELECT_MULTIPLE @MULTI VARCHAR(54) AS SELECT MSISDN, IMSI, HLR_NO FROM HLR WHERE MSISDN IN (@MULTI) ORDER BY MSISDN WHEN I EXECUTE THE PROCEDURE ON QUERIES ON MSACCESS NO OUTPUT WHERE PRODUCED AND data entered is as follows '639229380968','639229485075','639229346127','639229416465' I remove the quote but I can get an output only when one value is entered. What I am missing please help Vic Hi, arrays (as you posted them below) are not supported as an input varia ...Show All

• SQL Server Select Permission Denied on object

  Hello all, I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error - Server Error in '/phonebook' Application. The user that you are using for connecting to the database, which is specified in the connectionstring is not granted access to the table. By default users don’t have access to any objects, because their only role membership is "public". Grant either dedicated permissions to the user or put him in a SQL Server which has the appropiate perm ...Show All

• SQL Server SQL Server Integration Tutorial- Lesson1 -Customers.xls

  Hi, I'm fairley new to SQL Server 2005. I've started to work with the tutorials to get a grip of it all... but when I'm running the wizard to create a packade I cannot find the folder Samples in the 90-folder... and the file Customers.xls is nowhere to find in any of the folders in MS SQL Server 2005 folder... I downloaded and ran BOL from april2006 and also SP1 for SQL Server 2005... Where can I find the right material to run the tutorials regards maggi Thanks Jamie, for being so quick!! I also just now found a download of SQL Server Samples!! ~maggi ...Show All

• Visual C++ Why does VC2005 always rebuild all files??

  I am using VC2005 IDE with VC2003's excutables, includes and libraries. Becuase my project( orinally VC6.0 project ) have many library compiled with single thread runtime, I can't use VC2005's excutables, includes and libraries. Anyway I suceeded to compile my project. My problem is the follwing. Let's suppose I am building "MyProject". Whenever I choose "Build Only MyProject", VC2005 always rebuild all files in the MyProject even though MyPrjoect already was compiled and linked succesfully. How can I fix this problems I have a feeling that the t ...Show All

• Visual Studio Express Editions BalloonTipText on NotifyIcon1 Hover over?

  I've been looking at how to use BalloonTipText, and I found this small section of code: NotifyIcon1.BalloonTipTitle = "Balloon Tip Title" NotifyIcon1.BalloonTipText = "Balloon Tip Text." NotifyIcon1.BalloonTipIcon = ToolTipIcon.Error That isn't working for me though, in the test app I made to try it out. I put it in the NotifyIcon1_Click event and nothing showed up. I'd really like to be able to display something when the user hovers over the notify icon too, and I couldn't find a hover over event. Also, can I use a variable for the text in the balloon tip Any help would be appreciated. ...Show All

• SQL Server How do I return a TRUE or FALSE using a Stored Procedure?

  How do I return a TRUE or FALSE using a Stored Procedure This is my SQL Server Code: All I need it to do is return a TRUE or FALSE response (in integer, string, I don't care what manner) as to whether or not the given select statement returned with data (in other words, if something met the criteria). The criteria is "Do any records nameKey = 52 and were they posted on today's date " --------------------------------------- CREATE PROCEDURE udspCheckForMilestoneUpdates AS IF EXISTS     (     SELECT *     FROM storyData     WHERE nameKey = 52        ...Show All

• Visual C# how to send email to multiple email addresses

  I am having a problem sending email to multiple email addresses using System.Net.Mail in C#. It works when there is only one email address like so: toEmail = "xxxx@someco.com"; toAlias = "emailalias"; MailAddress to = new MailAddress(toEmail, toAlias); But, would fail when there are more than one email separated by ";" delimiter. The email just will not go through: toEmail = "xxxx@someco.com; yyy@someco.com"; toAlias = "emailalias"; MailAddress to = new MailAddress(toEmail, toAlias); Do I need to do some escape for the ";" delimiter: If so, how thx, ...Show All

• Visual Basic why so many issues with ADO to load databases! Help

  I have logged many hours trying to do something so simple I used to do with Access database macros, that is to automatically read a text file and load it into a table inside the database Access, but now I installed SQL database express and in VS 2005, I created a database with one table called Stat and it looks like is up to me to write code to load it. Here is the simple code I managed to dig up and it has several issues. Issue; why does the line “ currentRow = MyReader.ReadFields” reads from the text file 1 more character, “” in this case, than it should, In other words there should only be 20 delimited data things for one ROW and ...Show All

• Smart Device Development Reading Blocks from Removable Storage Disk

  Hi, I need to read the disks blocks from a FAT file system on a removable storage device. I've not been able to find any classes part of .NET so far that allows me to do this. I simply want to read from the first block, or byte, to the last to create an image of the disk. Can anyone suggest a method or classes on how to do this I wasn't sure where to post this, sorry if this is the wrong forum... Thanks. This forum is for Compact Framework which runs on CE, so sure, it is for CE. You can P/Invoke from C#. Correct, that's the storage driver which exposes device as a bunch of sectors to the OS. ...Show All

• .NET Development Help With Vb.net 2005 MS Access UPDATE command

  I am making a program for my company. I am using a MS Access Database. The Table has 236 field, which i have just found out that the 'UPDATE' command only does 127 field. So can you make a query that only does so many of the table field and then another to do others in the table. I have tried but i get this error {"No value given for one or more required parameters."} Here is my code for the update. HcPhase2CompleteTableAdapter.UpdateCoverSheet(Row.Abstraction_ID, Row.Provider_ID, Row.UHC_Key_ID, Row.Member_ID, Row.Service_Date, Row.RDB_HMO_Location, Row.Provider_Name, Row.Provider_Address1, Row.Provider_Address2, Row. ...Show All

• Visual Studio Is it possible to have Secondary Axis in a Line Chart?

  Hi, I need secondary axis to reverse it in one graph then user can compare data based on the timestamp which is the same for both axises. Is this possible Thanks. Robert Bruckner MSFT wrote: Secondary y-axis is not supported at this point. -- Robert This bug, it's fixed in sql 2005 reporting services ...Show All

• Windows Forms User control

  Hi, I have a user control , that contain a datagrid a few buttons. i want attach a property, which is a collection like an items collection in combobox. And want to enter values in design time. how to do this .. thanks in advance. ...Show All

• Software Development for Windows Vista InkCanvas (WPF) and StylusPlugIns

  I have created my own StylusPlugIn that I am using in conjunction with the System.Input.Controls.InkCanvas. I have placed my plug in before the DynamicRenderer in the PlugIns collection. When I create strokes with my pen (Tera M4) I get the expected behavior where my plugin is applied to both dynamically rendered Ink and created strokes. When I create a stroke using the mouse my plugin is applied to the dynamic rendering but not to the created strokes. In addition, it seems that even with the pen the first (one or few) StylusPoints or the first stroke are not passed trhough the plugin, so I end up with a funny looking end ...Show All

• .NET Development How to create MSP and TSP for USB handset device and for CTI (computer telephony) board device with multiple connection lines

  How to create MSP and TSP for USB handset device and for CTI (computer telephony) board device with multiple connection lines Main questions are: What assembly do we have to implement – COM object, DLL with specific methods or something else What interfaces do we have to inherit What methods do we need to implement in MSP and TSP How to work with audio stream inside MSP How to work with control information inside TSP How to register our hand-written MSP and TSP to use in TAPI Please, include some sample code to illustrate answers. This forum is geared towards ...Show All