Crystal Report Query – Birthday Formula
What I would do is create an if statement that adds a year to the year if the date is before the current date. For example if Date(year(CurrentDate),month({driver_details.drd_dob}), day({driver_details.drd_dob})) >= Date() then Date(year(CurrentDate),month({driver_details.drd_dob}), day({driver_details.drd_dob})) else Date(year(CurrentDate)+1,month({driver_details.drd_dob}), day({driver_details.drd_dob})) end if Hope this helps, Dustin

View Answer   |  December 23, 2008  6:12 PM
Birthdays, Crystal Reports, Crystal Reports formulas, Formula Workshop

What are the possible situations where DB2 server FORCES to close the applications connected to it?
If your refering to the IBM System i or AS400 server, closing Qbatch or the jobq that the application is running in will stop the application.

View Answer   |  December 23, 2008  5:58 PM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2

Native database implementation on AS/400
I’m not sure that I understand the question. If you have an AS/400 you have DB/2 .. DB/400 its name’s changed a few times. It’s ready to use. Tables can be created using SQL or by creating a program like description of the file (called DDS) Tables on the 400 can be accessed in native [...]

View Answer   |  December 23, 2008  4:05 PM
AS/400 database, AS/400 database administration, DB2, DB2/400, Open source databases

Crystal Reports – Duplicating labels
I asked this same question in a newsgroup a while ago and the answers I got were: 1) I create a temporary file and duplicate the record for as many times as I need the label 2) Use Crystal Data Object 3) Another solution by Ido Millet @ http://www.tek-tips.com/faqs.cfm?fid=3226 Hope these help.

View Answer   |  December 23, 2008  3:26 PM
Crystal Reports, Crystal Reports labels, Crystal Reports printing, Duplicate records

What is the use of primary files in DB2/400?
Hi, Primary files are used to force the RPG program to use the program cycle – these days they are very rarely used. Using the program cycle can be very confusing to people used to structured programming – best to avoid it as much as possible – in other words don’t use it unless you [...]

View Answer   |  December 19, 2008  3:00 PM
DB2, DB2/400, DB2/400 primary files

PHP question
This is a bit of apples and oranges, as PHP is a scripting language and Joomla is a content management system (CMS). PHP is basically a Perl-like (though with significant differences) language specifically designed to integrate with HTML. Is your website in static HTML code? If so you may wish to research the CMS offerings [...]

View Answer   |  December 18, 2008  3:09 PM
CMS, Content Management Systems, Joomla, PHP, Web design, Web development, Website maintenance

Generic host process for WIN 32 processes – has to close down -
I’m not sure I would fully trust the results of the virus scan. I would run another scan using Sophos, McAfee or other online scanning tools – if the machine can stay online that long. Did this happen just recently? Could you go to a previous restore point? I would also recommend applying all latest [...]

View Answer   |  December 18, 2008  1:04 PM
interupt, overactivity, Overheat, Shutdown

Specific content migration in Microsoft Office SharePoint Server
Hi Praj09, Third party solutions, such as ROSS from RepliWeb, now exist that allow for replication of select components (or comprehensive) within Sharepoint, either multi-stage (dev to UAT to prod) or multi-site. Only deltas are moved. Select components can include: structure, features, data, galleries, look & feel, security, etc. Brad

View Answer   |  December 17, 2008  6:36 PM
Content management, Content migration, ImageList, Microsoft Office SharePoint Server, MOSS, SharePoint

How to configure the database instance to respond slowly for any request?
You can try starving the system of memory. Set the database server to only have access to a few megs of memory. This should make the system very unresponsive.

View Answer   |  December 17, 2008  8:40 AM
Database configuration, Database instance, Database testing, DB2, Oracle, SQL Database, SQL Query, SQL Server

How to output a text file and separate the data into different fields using VB 2005
Use System.IO.StreamReader class to establish connection to a text file. And then use System.IO.StreamReader class to read from the file and store into a string. Then parse the string into 3 different variables. <pre>’Here’s how you’d get the first line Dim FirstLine as String Dim oFile as System.IO.File Dim oRead as System.IO.StreamReader oRead = oFile.OpenText(“C:MyFile.txt”) [...]

View Answer   |  December 14, 2008  5:31 PM
Comma-delimited, String manipulation, Text manipulation, VB, VB 2005, Visual Basic, Visual Basic 2005

failed to open rowset
The answer you are looking for might be <a href=”http://forums.devarticles.com/asp-development-3/crystal-report-failed-to-open-a-rowset-problem-3250.html”>here</a>. Another possible solution is in this <a href=”http://www.codeguru.com/forum/showthread.php?t=362146″>thread </a> Good Luck! -Flame

View Answer   |  December 10, 2008  6:08 PM
Crystal Reports, Crystal Reports 10, Crystal Reports Errors

VB6 and Crystal Reports – Error 20599 SQL not found
From what I found, the problem seems to be related to password protected tables in your database. Here’s a possible solution. Microsoft Visual Basic: “Runtime error 20599 – Can’t Open SQL Server” This issue occurs on all Active Data reports which have been created using the Active Data driver, P2smon.dll version 60046 or higher and [...]

View Answer   |  May 9, 2013  3:29 PM
Crystal Reports, Error 20599, VB 6, Visual Basic, Visual Basic 6

Migrating from SQL Server 2000 to SQL Server 2005 on DTS packages
Hi there, You might want to have a look at <a href=”http://www.ssis360.com”>http://www.ssis360.com </a> they are the DTS to SSIS Migration Experts and quite cheap as well. Much cheaper than to hire a contractor I guess. Good luck

View Answer   |  December 9, 2008  1:41 AM
DTS packages, Dynamics GP, Microsoft Dynamics GP, SQL Server 2000, SQL Server 2000 to SQL Server 2005 migration, SQL Server 2005, SQL Server migration

Rights to Exchange Information Store
Sounds like the job uses the locally logged on user credentials when it runs. Open Services and change the Log On properties of the services that the job uses to the ADMSRV profile. Another option is to keep the server logged in as ADMSRV, and lock the desktop if your have security concerns.

View Answer   |  December 5, 2008  7:28 PM
ADMSRV, ERP, Exact eSynergy, Exchange Information Store, Exchange synchronization, MAPI, MAPI_E_LOGON_FAILED, SQL job scheduler, SynergyExchange.exe

Can I use ND8client application to integrate with EMC Documentum 6.5?
I have no idea. I would contact my IBM sales rep. and ask to have one of his/her technical consultants to look into it. Same on the Documentum side. Between them, you should be guided to the correct solution.

View Answer   |  December 5, 2008  3:56 PM
EMC Documentum, EMC Documentum 6.5, Lotus Domino 8.x, Lotus Domino integration, Lotus Domino interoperability

SQL Server 2005 or 2008?
Others may have more information; but an article that I read indicated that standard edition 2008 has no additional benefits over 2005. The enterprise edition does have newer features however. I wanted to provide a link to that article; but I couldn’t find it. I’ll add to the discussion if I find it. ************ technochic [...]

View Answer   |  December 4, 2008  5:19 PM
Microsoft Access, SAS, SQL, SQL Server 2005, SQL Server 2005 vs SQL Server 2008, SQL Server 2008, SQL Server Version Comparison

Referential integrity and AS/400
<a href=”http://en.wikipedia.org/wiki/Referential_integrity”>referential integrity</a> Shaddy - It is a concept that relates to any database. It’s not specific to the AS/400. MIS

View Answer   |  December 4, 2008  1:46 PM
Database, DB2, DB2/400, Oracle, RDBMS, Referential integrity, SQL Server

How to test whether the Database tables designed to avoid deadlock occurence?
I am not aware of any database table design that will tell if the system will be “dead lock” proof. Avoiding “deadlock” is more a function of the particular database system – Oracle, DB2, SQL and the resources available (pool, cache, threads, memory), number of users, etc. Check with the particular DBMS (database management system) [...]

View Answer   |  December 4, 2008  11:04 AM
Database deadlock, Database design, Database Failover, Database modeling, Database security, DB2, DBFO, Oracle, SQL Database, SQL Query, SQL Server

SAP
Go for SAP Basis.

View Answer   |  December 4, 2008  6:54 AM
ERP, SAP ERP

Converting a varchar to a numberic in SQL query
Does this do it? dec(odptn ) How about using SQL functions: INTEGER(varchar_column) The same can be done to other DB2 numeric data types.

View Answer   |  December 4, 2008  2:04 AM
AS/400, DB2, DB2/400, SQL Query, VARCHAR