(Le0) I had been searching for some good code that allows a programmer to export a Crystal Report programmatically, without using the (not always) functional buttons that come with Crystal Reports. This is a short, straight forward article on how to export a Crystal Report in the most common formats
Other News
FIX: The description for the Dimension field is not set in the local cube file when you use the CREATE LOCAL CUBE statement in SQL Server 2005
When you use the CREATE LOCAL CUBE statement in Microsoft SQL Server 2005, the description for the Dimension field is not set in the local cube file. Additionally, the description for the Measure field is not set in the local cube file.
Making SQL Server 2005 Integration Services Packages Portable
(Narayana Vyas Kondreddi) Many of us have used UDL files (Universal Data Link files) in SQL Server 2000 Data Transformation Services packages (DTS packages). UDLs allowed us to make our DTS packages portable.
DB2 9 Application Development exam 733 prep, Part 9: User-defined routines
(Ted J. Wasserman) Learn how to create and use user-defined routines in IBM DB2 9. This is the last tutorial in a series of nine tutorials that you can use to help prepare for the DB2 9 Application Development certification exam (Exam 733). (R)
UDR enhancements in IBM Informix Dynamic Server V10
(Vinayak Shenoi) This article explores the following enhancements to the user-defined routine (UDR) feature available in Informix Dynamic Server: –Multiple OUT parameters (Dynamic Server 9.4 and above) –Multiple INOUT parameters (Dynamic Server 10.00 and above) –Named return parameters (Dy
ASM Enhancements
(Sreeram Surapaneni) ASM enhances the performance that raw disks provide, without the pain or difficulty of administrating the raw disks. Moreover, ASM provides storage mirroring policies that can be configured on a file level rather than at the volume level that traditional volume managers provide.
Define and Store MySQL ADO Connection String in VB.NET 2005
(Ernest Bonat) In Windows and Internet web business applications development the connection to the MySQL database server is critical and requires high-level of security. In ADO.NET database technology the connection is defined in the Connection String property of the connection object. Defining and
SQL Server Security Workbench Part 1
(Robyn Page and Phil Factor) SQL Server Security is sometimes rather a blind spot to application developers. This has been widely illustrated by the success of very simple attacks on database-driven websites, which would have been prevented by even moderate security measures>
Special: A Methodology for Troubleshooting and Tuning SQL Server 2005
Pro-Center Video Programming for IT Professionals
SQL Server 2005 Integration Services – Part 44 – Bulk Insert Task
(Marcin Policht) In the recent installments of our series dedicated to SQL Server 2005 Integration Services, we have been discussing individual Control Flow tasks, focusing on their unique functionality and characteristics. One of the few remaining items in this category is the Bulk Insert task, whi