lucerias's Q&A profile

• SQL Server Package fails when I schedule it.

  Two scenarios, 1 worked, 1 didn't: First package I execute SQL (select top 10 * from MyTable) in my SQLServer2005 database. I scheduled it and it ran sucessfully. I changed the execute SQL to run against an external Oracle database. (Select * from SomeOracleTable where rownum <= 10). I preview to make sure the query works and it does return a result set. I execute the package in the Visual Studios IDE and it works. I save with encryptAllWithPassword to the SQL server. I go into the scheduler and select the package from SQL Server (as opposed to the file system). I set the step to execute the package off the server. I enter the security key by clicking on the configuration tab. I assume it saves the password to the package. I cl ...Show All

• Visual C++ CreateThread vs _beginthreadex

  Hello. There is a hot discussion on one Russian developers forum about correct threads creation. _beginthreadex is more correct way because it initializes CRT for the newly created thread. But there is one great "BUT"!!! For example we have any callback function which uses CRT (like an exported function from dll). This function could be invoked from any thread including threads, that was created via CreateThread (i.e. CRT was not initialized for this thread). So this call can cause an undefined behaviour! But there is not way to determine CRT initialization status and initialize CRT manually It looks like a potential source of great troubles. Brian Kramer wrote: Its not clear. _beginthreadex and _ ...Show All

• .NET Development CryptoStream problem: managing a wrong key - padding

  Hi, I think I've found a "design" problem in CryptoStream class. It's a generic issue related to the padding made by a Symmetric Algorithm (e.g. Rijndael) implementation used by a CryptoStream object. When a wrong key is passed to a decryption routine (for files, strings, etc) a CryptoException stating "padding is invalid and cannot be removed" is fired. This is OK because decrypted data are obviously corrupted so that the padding mechanism (e.g. PKCS7) fails. BUT then HOW can a "wrong password inserted" trapping system be implemented ( => means 'implies') Wrong key => Corrupted padding => CryptoException This exception happens after trying to call Close( ), FlushFinalBlock( ) methods of CryptoStrea ...Show All

• SQL Server export to PDF (reporting services)

  Greetings!, Does anyone here know where to configure the document properties/security settings of PDF files generated by reporting services thanks! Thanks Brad. Any suggestions on other 3rd party components where I can do export to PDF (asp/htm to pdf) programatically ...Show All

• Visual Studio Express Editions How I..............

  Hi, i got a Toolstrip with buttons on it how can i program it such that will perform the following: For Example i have a two pages , when i press button1 on the toolstrip page 1 appear on the form and when i press button2 on the toolstrip page 2 appear on the same form replacing page 1. Hi, I'm not sure what you mean by "page". If you're referring to tab pages, use tabcontrol's SelectedPage or SelectedIndex property to set the appropriate tab. Andrej ...Show All

• SQL Server PDF creation automation

  hello is it possible to generate PDF files from reports programmatically Yes it is, although you might have to go to great lengths to accomplish it. And if you do it enough, it might be worth your while to create a class to speed things along. We took this approach when trying to auto-export a report to a PDF file with our system. The following code was adapted from Chris O'Connor's Channel9 blog (http://channel9.msdn.com/ShowPost.aspx PostID=87032) First off, we created a separate Reporting Service Exporter class to use from anywhere inside our enterprise system. This required adding a web reference, which we added to the Objects portion of our project. Import that namespace, and create the class: Impo ...Show All

• SQL Server Confusion over SQL 2005 Standard CPU Support

  I'm a little confused over the maximum CPU count supported by SQL 2005 Standard Edition (this particular edition supports four CPUs). Does the figure refer to four physical CPUs regardless of whether they are dual-cored or hyperthreaded, or does the figure refer to the number of logical CPUs available to the OS Let me cut to the chase - if I purchase a server containing four dual-core CPUs and install SQL Server 2005 Standard, will SQL Server see the eight CPUs and utilise a maximum of four of these, or will it be able to use all eight (because there are actually only four physical CPUs) Thanks, Chris. It's per processor regardless of the number of cores. See the link below. Doug http://download.microsoft.com/dow ...Show All

• SQL Server String Lookup Error

  I'm creating my first SSIS package. The data source is a csv file and the destination is a SQL server table. I have several lookups. The date and time lookups are working fine. The string lookups are failing. I can see the records when I open the table in SQL Server. Do I need special handling for strings Truncating Here are the error messages. I'd appreciate any input and help. Thanks. [Lookup Commodity [2560]] Error: Row yielded no match during lookup. [Lookup Commodity [2560]] Error: The "component "Lookup Commodity" (2560)" failed because error code 0xC020901E occurred, and the error row disposition on "output "Lookup Output" (2562)" specifies failure on error. An error occurred on the ...Show All

• SQL Server Will SQL Express be Shipped in Vista if so what versions and other questions.

  1. The title of this post says it all. My app will have a very small footprint to down load. I don't want to user to have to download 50 + MB just to try my little $15 app:-) So QUESTION 1 - Will SQL Express be in the Vista bits If so which versions 2. Once SQLExpress is installed by whatever means, are there rules about how the instance is used I have no problems playing well with others so I would be more than happy to create my DB in .\SQLExpress. QUESTION 2 - Are there any rules governing who can play in the Express instance How should dtabases should be named to avoid collisions with the other kids 3. I'd love to be able to work in in ClickOnce / user never has to have admin password environment. QUESTION 3 - Besides U ...Show All

• Visual Studio Express Editions xcopy help

  hi, can someone tell me how to get the files being copied into a list box for display the code Dim ProcID As Integer ' start xcopy. With ProcID = Shell( "xcopy C:\DOCUME~1\*.dbx/s/h c:\backup\" , AppWinStyle.Hide) End With xcopy is a weird program. I finally found the fix by adding this line: .RedirectStandardInput = True That took a few hairs... There's a minor problem with the Split() function, none of the overloads accepts a string. I fixed it like this: Sub ProcessFileIntoIndividualLines(ByVal str As String) Dim crlf() As String = {vbCrLf} Dim sa As String() = str.Split(crlf, StringSplitOptions.None) For Each x As String In sa Me. ...Show All

• Visual C++ Wide character versions of ecvt, gcvt, and fcvt

  Hello all, I wanted to know if there are there wide character versions of the functions ecvt, gcvt, and fcvt (or _ecvt_s, _gcvt_s, and _fcvt_s) in Visual Studio 2005 (I couldn't find anything on MSDN or by googling.) Also, are there wide character versions defined by C99 Many thanks, Kevin Hall It seems for me there are no wide-character equivalents for such functions, therefore you have to convert them using additional code. You can try the general-purpose MultiByteToWideChar function or others. But since the digits have the same code in both ANSI and Unicode encodings, if the speed is critical I think you can use a simple copy operation in a loop. For instance: double d = 1234.567; int de ...Show All

• SQL Server configuration and deployment questions

  I've been doing some VB6 app development against a SqlExpress database, but have confusion with issues of deployment and configuration. It's my intention to distribute the app and db to client installations, both as stand-alone and network-ready shared access. Here's basically what's occurred thus far: The database originated as an Access mdb file. Downloaded and installed SqlExpress, Tools, Manager, and sample database(s). Used the Upsizing Wizard in Access to create a SqlExpress db. Attached to the database in Express Manager so I could examine and access the table data. Hit the data through the application with the following connection string: Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=.\sqlexpr ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to setup view and perspective matrices, please?

  I can't find a way to set the matrices for the device, could someone enlight me, please Wow thank you it really works!!!! its actually a really coo idea !!!! Thank you xna team will upload for VB.NET users tonight!!!! ...Show All

• Visual Studio Team System TF82001: MS Project can't connect to Team Foundation Server

  I have a weird issue. If I right click on a work item and click "open selection in MS Project" the selected work item appears in MS Project. BUT, if I save this file and then open it again I get the error: "TF82001: Cannot connect to the Team Foundation server. Please contact your server administrator." I'm going to reinstall the TFS client again to see if that resolves the issue. Jason, We are still working on the problem. Can you try the following as a workaround and let us know if that helps 1. Select a few workitems in Visual Studio. Right-Click and open in MS project. Then try both of these: 2a. Now, in this instance of MS Project that you just opened, go to file -> new and then connect the new project plan to the ...Show All

• Visual C++ How to use com in VC++2005

  I am a new guy about vc++, i want to run some vbscript in my c++ code ,so maybe i should import a suitbale com to surpport that. What should i do Thanks Sahir Shah wrote: Terax wrote: Ii want to run some vbscript in my c++ code ....What should i do You need to download the Windows Script Control From : http://www.microsoft.com/downloads/details.aspx familyid=D7E31492-2595-49E6-8C02-1426FEC693AC&displaylang=en And here is an article about how to use the script control http://www.microsoft.com/mind/0799/script/script.asp This tutorial is for a pre .NET version of Visual Basic but it gives you a fairly good idea about how to use the scripting control. ...Show All