Windows Server 2003 Web Edition Configuration
I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from [...]

Answer Question   |  January 22, 2007  10:44 AM
Database, DataCenter, DB2, Desktops, Development, Interoperability, Management, Microsoft Windows, Oracle, OS, Security, Servers, Software, SQL, SQL Server, Tech support, Web development tools, Web site design & management

Oracle Database Issue
Hi all We have a 10g oracle server but the problem is that it keeps dying out every now and then. we are usind it on red hat. i tried opening the emctl dbconsole for oem . it opens up but the instance status shows the error ORA-12537: TNS:connection closed (DBD ERROR: OCIServerAttach) and on [...]

Answer Question   |  January 12, 2007  7:30 PM
Database, DB2, Linux, Oracle

Visual Basic 2005
My task is to write a program to take a input from a user which in this case is a name (forename & surname) and create a VB 2005 program to capitalise the first letter of the first name and surname although also ensure that the remainder of the name is lower case. How do [...]

Answer Question   |  January 11, 2007  9:27 AM
Database, DB2, Oracle

Count distinct rows on multiple columns
I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00 Dollars 104 Sarah 010C [...]

Answer Question   |  April 19, 2013  8:23 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows

database access
how can i connect to a ms access database which resides on other computer in a network using vb6.0

Answer Question   |  January 3, 2007  1:18 PM
Database, DB2, Oracle

iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]

Answer Question   |  October 14, 2010  10:35 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML

DB2/400 Stored Procedure Security
I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application. To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never [...]

Answer Question   |  December 27, 2006  8:42 AM
Database, DB2, Oracle, SQL

Converting datetime (time portion) to varchar
I have an issue with a report I am converting from Crystal Reports to SRS. The reports datasource is a SQL stored procedure, that converts a datetime column to a varchar column containing just the time portion of the data. The time is converted to 24 hr format. CR was able to with it’s built [...]

Answer Question   |  December 12, 2006  5:11 PM
Database, DB2, Oracle, SQL Server

RUN TIME ERROR 339
I have an application written in Visual Basic. The application runs on windows XP system with oracle 8i and Crystal report 8.5 The application suppose to interface with an oracle 8i database. In attempt to run the application it gives this error: ‘Run-Time Error 339 component ‘CRYSTL32.OCX’ or one of its dependencies not correctly registed [...]

Answer Question   |  December 8, 2006  11:42 AM
Data analysis, Database, DB2, Development, Interoperability, Oracle, Software, Tech support, Windows

Query
I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command — SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem FROM futdtalib/vlpasn [...]

Answer Question   |  December 6, 2006  9:56 AM
Database, DB2, Oracle, SQL

Delivery system
hi there, i was wonderinf if you guys have any codes in VB.6 about Delivery system. i’m using using it as a reference for my thesis. any help would be great! thanks!

Answer Question   |  December 6, 2006  6:54 AM
Database, DB2, Oracle, SQL

AMD Sempron
Hi all, I have one desktop running on AMD sempron 2200. In my home network. It?s clock speed is 1.5 GHz as per manufacture?s specification. but in system properties It showing only 800 MHz. OS is using XP SP2. But it working very smoothly. Anybody have any idea about why it likes this?

Answer Question   |  April 9, 2012  4:25 AM
390, Cabling, DataCenter, DB2, Desktop management applications, Desktops, Hardware, Hubs, Linux, Mainframe, Management, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches, Systems management software, Tech support

Database Tuning Advisor “not permitted” error on SQL Server 2005 DE
Hi! I’ve bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I’ve installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: “Tuning this edition of SQL Server 2005 is not permitted.” [...]

Answer Question   |  November 29, 2006  10:05 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server

Daylight savings – Change in politics
Greets to all, First off, where I live (WA, Australia) we have had a change in politics. We now have daylight savings starting in 1 week. The problem is as follows. Details * 3 Domains (not linked to each other) * Multiple external sites (not tied back to base) * Multiple DB systems and authentication [...]

Answer Question   |  November 28, 2006  9:34 AM
Database, DataCenter, DB2, Desktops, Hardware, Linux, Management, Microsoft Windows, Networking, Oracle, OS, Security, Servers, SQL Server

Oracle SQL and compare date
Hello! I need help. I want to compare two dates and count how many days its between them. Example: 2006-09-22 and 2006-10-06 results: 14 days Hope for help. Thanks!

Answer Question   |  April 18, 2013  3:36 AM
BPEL, Business Process Execution Language, Database, DB2, Oracle, Oracle 9i, SQL

Excel Spreadsheets
We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The masterlink does not update automatically, we have to open the individual [...]

Answer Question   |  May 9, 2011  2:42 AM
Data analysis, Database, DataCenter, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL Server

hi all
last day i installed one new xp theam on my xp system. recently i noticed that “RUN” option deleted from my start menu. can anybody help me in this problem ? thanks in advance

Answer Question   |  February 23, 2010  2:29 AM
390, Administration, Application and Web development, Cabling, DataCenter, DB2, Desktops, Exchange, Hardware, Hubs, Instant Messaging, Linux, Lotus Domino, Mainframe, Management, Microsoft Windows, Network management software, Networking, OS, Routers, Security, Servers, SQL Server, Switches, Systems management software, Tech support

Oracle Parse – Instr
I’m receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, ‘|’, 1, 1); v_meter2 := instr (pValueMeters, ‘|’, 1, 2); v_meter3 := instr (pValueMeters, [...]

Answer Question   |  November 15, 2006  9:59 AM
Database, DB2, Oracle, SQL

DB Migration from 8.1.7 to 10gR1
I want to migrate from 8i(8.1.7) to 10gR1 in a new server. I will shutdown 8i and run with 10gR1 in a new server. If any of my application not working with 10g ,i need to fall back to 8i in old server. Is it possible to take only the delta changes from 10gR1 which [...]

Answer Question   |  November 15, 2006  9:25 AM
CRM, Database, DB2, Oracle

MS SQL Server 2000
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

Answer Question   |  November 13, 2006  12:53 AM
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development