Joe Smugeresky's Q&A profile

• SQL Server New Guy Question 2: SQL on-the-fly at package runtime?

  Here I go again...thanks for your patience... I'm trying to create a single, all-purpose SSIS package that would move data from a source database table to a matching target database table. The requirement is to create the package such that the SQL statement used by SSIS could be supplied at runtime. This would allow a single package to be used for different SQL statements, representing different tables, rows and columns, etc. as needed. The data ...Show All

• .NET Development Error 454 5.7.3 Client was not authenticated

  In my VB.Net application i am sending email using MailMessage object of System.Web.Mail, using following code '**************************************************************** Message = New MailMessage Message.To = strEmailAddress Message.From = strMailFrom Message.Subject = strSubject Message.Body = MailBody Message.BodyFormat = MailFormat.Html SmtpMail.SmtpServer = strMailServer SmtpMail.Send(Message) '*** ...Show All

• Visual Studio Express Editions patterns of delegates

  Hai, What are patterns of delegates Thanks in advance. Hi, Do you need any help on how to go about with delegates If yes, then could you please post more info about the same. Because, these forums deal with only programming issues. Thank you, Bhanu. ...Show All

• .NET Development .NET Framework 2.0 question

  I appologize in advance if some of my  questions to the forum is a little out of place. I am not a programmer or developer, just a gamer, system builder, and network administrator of a home network. After installing .NET Framework 2.0, Direct X9.0c's Diagnostic shows that one of the two system.dll files is missing. The one that is listed belongs to 1.1, so logic dictates that it is the one for 2.0 that is missing. However it is in ...Show All

• .NET Development Download accelarators

  For example flashget.It can download different parts simultaneously.I wonder this.How can it achieve this If there is no avaliable api.General algorithm will enough for me.. Thanks for all answers.I think ergin and JonCole(AddRange) answers are what i am looking for.Also @Mike Flasko now i don't know what ServicePointManager class is.But i will search it. Also more advices for  download accelara ...Show All

• .NET Development how i can cancel a regex.ismatch() when it's working

  Regex re = new Regex(text, RegexOptions.IgnoreCase); if (re.IsMatch(text)) //it will be working for long time if the regex is not very right ..... i can't have a timeout property for the regex member,so how i can solve this I am not sure and maybe it is a silly answer but try to do it in thread. So you can suspend it ...Show All

• .NET Development Making databases in code

  does anyone know how to make a database completely out of code Visual Basic has a COM object named ADOX.Catalog which could do this. what im looking for is a .NET namespace to implement this into my C# application. Hi, It really depends on what DBMS that you're using. If your using a SQLServer then you could create a connection to the master database then execute a CREATE DATABASE t-sql command. After the database creation just reconnect t ...Show All

• Visual Basic Not Quite Curried Functions

  Hello, I’m new (today) to VB 2005. I’m wondering if there is a shorter way to write the following kind of code. ' This is used to give me a predicate of one argument for ' List(Of T).Find Class StringFinder     Dim s As String     Function CompareString(ByVal x As String) As Boolean         If x = s Then Return True Else Return False     End Function  &n ...Show All

• SQL Server VB6 and SQL Server "Year, Quarter Year Dates"

  Hi every one. Vb6 and Access is the format I used to retrive records in a graph from an access.mdb. I have tried changing it to SQL Server. Int is not recognized. On line help talks about "Q4 FY 2004" but don't know if i'm in the right direction. Any help would be appreciated. ...Show All

• Visual C++ VS and side-by-side installations of PSDK?

  Hello all, I'm currently evaluating VS 2005 C++ (Express Edition) and I'm planning to install the new Platform SDK Windows Server 2003 SP1. However, I'm still running VS 6.0 on my computer which is still needed to build a number of old projects. On the PSDK download page however it says that side-by-side installations of the new and older PSDKs are not supported, which doesn't sound nice at all meaning, as I understand it,&nb ...Show All

• Visual Studio Tools for Office VSTO and OLE Automation

  Hi, I have a VSTO-enabled Excel spreadsheet which works just fine when I open it standalone. I use the VSTO Startup event to add some document actions. Now I am trying to open the spreadsheet programatically using the following code: Excel.Workbook wkb = _app.Workbooks.Open(strFileName, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type ...Show All

• SQL Server SQL DMO - Backward Compatibility Components Redistributable

  I need to update our applications install program so it installs the latest SQL DMO.  I've downloaded the "Microsoft SQL Server 2005 Backward Compatibility Components" MSI from http://www.microsoft.com/downloads/details.aspx familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en . This MSI will not install on Windows 98.  This is surely a problem   Client machines running Windows 98 can still connect to SQL Server 2 ...Show All

• Windows Forms tutorial on treeview

  Hi can anyone direct me to a good site where i can learn how to use the treeview control I want to be able to covert this code  With tvwMediaCategory         .Nodes.Add , , "ROOT", "My Media", "CDMUSIC", " ...Show All

• Microsoft ISV Community Center Forums (0x800A03EC): Paste method of Worksheet class failed

  I just recieved this error message when i try to copy and paste some text using the right click method in excel. Any ideas why (0x800A03EC): Paste method of Worksheet class failed Hi Mike, The engineer needs additional information before he can investigate your issue: As there is too little error information of the issue, we can’t find useful information to resolve the issue. Would you please ask our ISV t ...Show All

• Visual Basic AllUsersApplicationData not working when application has been published

  It seems that My .Computer.FileSystem.SpecialDirectories.AllUsersApplicationData is not working... : when you debug the application : everything is fine, but when you publish it. It points to the application folder. Which means that if you want to put a configuration file there ... it will be deleted during the next update !! Any ideas The same problem happens with : Application.CommonAp ...Show All