Database Management Systems
Really depends on which system you want to implement. Can you provide more details please? Here is a DBMS wiki and SearchSQLServer article if you need to choose one.

View Answer   |  May 31, 2013  2:51 PM
Database Management Systems, DBMS

How to add another Internet connection to a firewall
Hi, there: Usually you should have two ports on the firewall, WAN1 and WAN2, which will support two Internet connections. About how to separate the traffic between the two connections, there are several ways to do it: 1. Use port forward, there will be two different public address for two connections, use port forward to [...]

View Answer   |  March 24, 2009  2:26 AM
Dedicated lines, ERP, Firewalls, HTTP Traffic, Internet service providers, ISP connection, Networking, Oracle E-Business Suite, WatchGuard

Mainframe batch DB2 table I-O monitoring
Hi Michael, You’re absolutely right, you can’t monitor that I/O for DB2 tables – and this is because the DB2 subsystem is doing all the I/O for you. Most people aren’t as much interested in the actual I/O for DB2 calls, unless you’re a DB2 DBA. They’re more interested in the DB2 calls, and how [...]

View Answer   |  March 23, 2009  11:20 AM
DB2, DB2 Table, I/O Monitoring, JCL

Crystal Reports – combining two reports into one
In crystal report you may click on insert –> Subreport and attach the second report to this first report

View Answer   |  March 18, 2009  7:55 AM
Crystal Reports, Crystal Reports Subreport

Error while referencing external assembly in SQL Server 2005.
Does the assembly exist at the path specified on the SQL Server? You’d be better off placing the assembly in the GAC then calling it from there. What is the end goal of this assembly?

View Answer   |  March 16, 2009  7:22 PM
.NET Framework 3.5, Database programming, SQL Server 2005, SQL Server development, Visual Studio 2008, WCFServiceLibrary

Managing physical and electronic documents
Can you elaborate a little more regarding what you’re looking for? On the electronic side, It sounds like something <a href=”http://www.StoredIQ.com”>StoredIQ.com</a> may be able to help with.

View Answer   |  March 16, 2009  2:56 PM
Data management, Data management software, Document management, Document management software, Electronic Documents, Physical Documents

Crystal Reports last twelve months
A simple way in Crystal, I am assuming that the report date is restricted to a single full year, then: Make a formula extracting the month from the date field – MONTH(Subtotal) Then make a formula for each month – if {@Month} = 1 then {Subtotal} else 0 – do this for each month. Alternative [...]

View Answer   |  March 13, 2009  4:36 PM
Crystal Reports, SQL Database, SQL queries

ER Model
Plz check these links…will be helpful http://www.infocom.cqu.edu.au/Courses/spr2000/95169/Extra_Examples/ERD.htm www.sourcecodeonline.com/list?q=er_diagram_for_railway_reservation_system

View Answer   |  March 13, 2009  11:32 AM
Database programming, Entity-Relationship Model, ER Model

Reporting and Mirrored SQL2005 DB
No, the mirrored database is not available for reading. You would need to run your reports off of the active server.

View Answer   |  March 10, 2009  8:25 PM
Crystal Reports, SQL 2005, SQL 2005 Database, SQL Database, SQL Server Database Mirroring

Crystal Report Formula in-line
Did you try using a cross tab? What kind of data are you displaying? Are you using a formula to display the data in group 4?

View Answer   |  March 9, 2009  7:06 PM
Crystal Reports, Crystal Reports 10, Crystal Reports formulas

How to retrieve, add and update data from SQL Server 2005 manually using VB.NET 2005?
Have a look at the following page. You will find information and code samples on some of the topics you mentioned in your question. <a href=”http://www.exforsys.com/tutorials/vb.net-2005/access-and-manipulate-sql-server-data-using-ad-hoc-queries.html”>Access and Manipulate SQL Server data – Using Ad Hoc Queries</a>

View Answer   |  March 9, 2009  5:19 PM
Data Junction, Extract Transform Load, INSERT statement, SELECT statement, SQL Server 2005, SQL Server connectivity, VB.NET 2005, Visual Basic .NET, Visual Basic 2005

Migration
We have lots of experience in this field. We have tools that adapt LiveLink to Documentum and perform export-mapping-import-file transfer functions, either en-mass or selectively and also two way in manual, scheduled or dynamic modes. Open Text has two main interfaces for this. You can use the query language and API to export the objects [...]

View Answer   |  March 7, 2009  4:13 PM
Documentum, Livelink, Livelink to Documentum Migration

Integration of Jasper with Documentum Content Server
Your best bet is to use <a href=”http://www.emc.com/products/detail/software/reporting-services.htm”>Documentum Reporting Services</a>. While this includes a lot of functionality that you might not need, it includes some important changes (deployed through a docApp or .dar) that allow for complete reporting. Combined with <a href=”http://www.emc.com/products/detail/software/jdbc-services.htm”>JDBC Services</a>, this will allow any reporting tool to connect to your docBase(s) in [...]

View Answer   |  March 6, 2009  3:43 PM
Documentum, EMC Documentum, Integration, Jasper, Jasper Reporting tool, JasperServer

How to implement One-to-One and One-to-Many class associations using VB.NET 2005?
You might want to show us what you have done so far (class definitions, etc…), and provide more detail about the relations you want to implement, so we can provide more specific help. Are you going to use databases ? how and where are you going to save system data ? are you talking about [...]

View Answer   |  March 6, 2009  3:00 PM
class associations, Data modeling, Object-oriented programming, One-to-Many Relationships, One-to-One Relationships, VB.NET 2005, VB.NET classes

SAP on iSeries
SAP released SAP on Iseries, and IBM approved – have you looked at their respective web sites? trolled through the various other sappy forums? You should talk to your software vendor for a contact list of other customers who are running SAP in iSeries. I know of a couple of shops in the Milwaukee area [...]

View Answer   |  March 6, 2009  2:55 PM
ERP, iSeries, SAP

Crystal Reports XI – Showing records when setting criteria
I am assuming that the notes are held in a different table to the orders, and that you have an inner join connecting the orders table to the notes table. You need to have an outer join to the notes table. e.g. select o.id, n.notes from orders o left outer join notes n on o.id [...]

View Answer   |  March 6, 2009  2:41 PM
Crystal Reports, Crystal Reports XI, SQL

db2/400
There’s no way you don’t impact something 1. Add field to DDS – generally fields are added to the end of files, this my avoid a few errors. and 1.1 CHFPF pointing at the lib/QDDSSRC/Member or 1.2. Add the field using SQL ALTER Table command 2. The Format Level Identifier will be changed and this [...]

View Answer   |  March 6, 2009  1:50 PM
AS/400 DB2, CHGPF, DB2, Physical File

Transfer of an computer with OEM XP to a new user.
You are right. AS Long as u keep the original Proccessor, and HDD. A Windows XP OEM license lets you install Windows XP on that system only. You can reinstall the OS as many times as you want, but you cannot use the CD-Key on any other Factory installed OS systems like DELL or Gateway [...]

View Answer   |  March 6, 2009  3:02 AM
eula, OEM, OEM keys, OEM Transfer, Windows XP

database
Try SQLite. Its a widely used free compact database that you don’t need to install on a computer as you would SQL or MySQL.

View Answer   |  March 5, 2009  10:52 PM
Database Management Systems, Database software

Oracle database and Crystal
in Crystal XI after opening a new blank report to create a connection to Oracle Database, - right click on Databse Fileds –> Database Expert (or menu Database –> Database Expert) - click on create new connection - one of the option is Oracle where you can defne the server from which you need to [...]

View Answer   |  March 5, 2009  8:42 PM
Connecting Oracle Database to Crystal XI, Crystal Reports XI, Oracle Database