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

Exchange Server Messaging Solution
My requirement I need to log (Including mail content) the mail communications between certain group of users in the same Exchange server. Logging should be done in the central repository like SQL Server so that my application can be used to view the mail communications between the groups. Pls let me know is there a [...]

Answer Question   |  December 18, 2006  4:17 AM
Brightmail, CipherTrust, ClearSwift, Data warehousing applications, E-business, Ecommerce applications, Exchange, Exchange security, McAfee, MessageLabs, Microsoft Windows, Postini, Rockliffe, Spam, SpamAssassin, SurfControl, Symantec, TrendMicro

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

XML Publisher with Shipping Docs
We are trying to use rtf Templates for our shipping docs. When we launch the concurrent request individually they work great. But when we use Ship confirm (which launches the doc set automatically) the xml is generated but the pdf format is not. Looking at the submitted requests, the layout has not been applied so [...]

Answer Question   |  October 30, 2007  9:27 AM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

convert public folder IPM.POST to IPM.NOTE
i have an sbs 2003 with exchange runing on it and gut a public folder that i’ve created for general mail to the employee’s. i’ve routed all mail to that folder from specific account, the problem is that the mail’s arrived as a IPM.POST format mails and not like the traditional mails that is more [...]

Answer Question   |  December 4, 2006  6:56 PM
Application security, Availability, Bandwidth, Biometrics, Business/IT alignment, Database, DataCenter, Desktops, Digital certificates, E-business, Encryption, Exchange, Exchange security, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, Networking, OS, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Spam, SQL Server

Cold Fusion
Has anyone received this error on a fresh Cold Fusion Install of 6.0? 11/30 16:05:34 error [1]java.lang.SecurityException: Cannot set up certs for trusted CAs at javax.crypto.b.<clinit>([DashoPro-V1.2-120198])

Answer Question   |  December 4, 2006  4:30 PM
Content management applications, Software, Web site design & management

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

XML Publisher Issue
We can’t output a concurrent request via XML Publisher… We can create data definitions and link data templates (.rtf files) through the app, when we attach a data.xml preview file, we can preview the output correctly. When we actually attempt to run the concurrent request, the output shows the actual XML data, not the formatted [...]

Answer Question   |  December 4, 2006  3:09 PM
Business Intelligence, Data/Application Integration, Oracle, Oracle development, XML

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