ESX luns allocated on Symmetrix will not format.
Recently we allocated Symmetrix space for an ESX cluster. Some of the LUNs format fine but one or two come up with an error message that says “unable to read partition information from this disk.” All of the luns were exactly the same capacity. The ESX is currently attached to a Symmetrix array as well [...]

Answer Question   |  February 15, 2009  3:07 PM
Array, Clustering, EMC Symmetrix, LUN, Symmetrix, VMware ESX, VMware ESX Cluster

Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)
CREATE OR REPLACE PACKAGE trigger_api AS PROCEDURE tab1_row_change (p_id IN ae_dt526.field1%TYPE, p_action IN varchar2, p_field13 IN varchar2, p_blanket_ind IN varchar2 ); PROCEDURE tab1_statement_change; END trigger_api; / CREATE OR REPLACE PACKAGE BODY trigger_api AS TYPE t_change_rec is record ( field1 ae_dt526.field1%TYPE, action tab1_audit.action%TYPE, field13 tab1_audit.field13%TYPE, blanket_ind tab1_audit.blanket_ind%TYPE ); TYPE t_change_tab is table of t_change_rec; g_change_tab t_change_tab [...]

Answer Question   |  February 2, 2009  11:39 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers

Crystal Reports OBDC (Oracle)
I created an OBDC on the client to link into the Oracle server, and using it in Crystal report, I can only see the system tables, but not the database table. Using the same obdc in Access application, I can see and am able to link all the tables. Do anyone know why is that [...]

Answer Question   |  February 2, 2009  11:06 PM
Crystal Reports, Database connectivity, ODBC, Open Database Connectivity, Oracle connectivity

Notes rich text field to BLOB/Memo field in SQL Server using ADOdb
I have an agent that uses ADODB to connect and insert a row into a SQL Server database. I want to store the contents of the Body field in the memo (rich text) into a Memo field in the SQL Server database (or Blob field). I’m finding examples of reading this kind of data back [...]

Answer Question   |  February 2, 2009  7:40 PM
ADO, ADOdb, Binary Large Object, BLOB, Database programming, Memo fields, MySQL, SQL Server development

Access 2007 – How to include option group on report
Hello, I’m new to Access so please consider this when forming your response. This has been driving me crazy and I’ve looked high and low on the ‘net for a solution. I look forward to your response. I have a form with an option group. I’ve wish to have this display on my report. Take [...]

Answer Question   |  February 2, 2009  5:55 PM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 Reports

Connecting to Oracle with Visual Basic 2005?
what are “oracle” version to connect “visual basic 2008″,”visual basic 2005″ and “visual basic 6.0″ ? whether it’s possible to connect “oracle9i” and “visual basic 2005″ ? please solve my Q……….

Answer Question   |  March 13, 2012  10:20 AM
Database connectivity, Oracle connectivity, Visual Basic 2005, Visual Basic 2008, Visual Basic 6

Reports go blank with Oracle 10g using JReport (work perfect with Oracle 9i)
HI, I have upgrade oracle database from 9i to 10g via export/import, My application is using Jreport. When I was using oracle 9i Reports were working perfect but after upgrading to 10g when I fetch reports it goes blank.

Answer Question   |  February 8, 2009  10:47 AM
JReport, Oracle 10g import/export, Oracle 9i import/export, Oracle 9i migration, Oracle reporting, Oracle Reports 10g

ODBC on Linux
A user on Twitter, @garyvee, has a question for the community: Whats the best solution for ODBC on Linux ? And is anyone actively working with it? The direct link to his question is here.

Answer Question   |  January 30, 2009  5:57 PM
Linux, ODBC, ODBC on Linux

How to call trigger stored in database using Oracle Forms
how to call trigger stored in database using oracle forms

Answer Question   |  November 12, 2011  9:47 AM
Oracle development, Oracle Forms, Oracle triggers, Triggers

Sending a message from Access thru Lotus
Error message comes up: “A stored from can not contain computed subform” and my message comes out unformated on Lotus 6.5 but it is fine on 8.0 (or is that really the reason?) All our users are on 6.5, what do I do to fix this?

Answer Question   |  February 3, 2009  3:48 PM
Lotus Notes 6.5, Lotus Notes 8.x, Lotus Notes email error, Lotus Notes error messages, Microsoft Access

Monthly Average in Access 2007
Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible – my VB sucks Thanks Riaan

Answer Question   |  January 30, 2009  11:53 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average

Changing field format in Access 2003
We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don’t need to go into now, we have to change all of them to a different format – yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of [...]

Answer Question   |  January 28, 2009  8:23 PM
Access 2003, Microsoft Access, Microsoft Access forms

AS/400 to SQL Server 2008
Hi, Is there a way to pull an AS/400 File into SQL server 2008? From within SQL 2008 we do not see an ODBC connection that will work for the 400(??) I am not familiar with SQL server and we need to get some data to it. Can anyone shed some light on what I [...]

Answer Question   |  January 30, 2009  6:28 PM
AS/400, AS/400 to SQL Server 2008, ODBC, SQL Server 2008

Career Advice
I currently have an MBA and 10 years experience in managing profit and revenue (financial analysis) of software development projects. I decided to go back to school for an MIS degree. I want to manage infrastructure projects; particularly data center consolidations. I am thinking I can leverage my business experience and degree in project management. [...]

Answer Question   |  January 28, 2009  4:30 PM
Certifications, IT careers, MIS

SAP for Marketing & QA Guy
Hi, I moved from marketting(boitech products) to Quality assurance.My Markeeting exp is abt 6.5 year & in QA 7 yrs.Which module of SAP will be useful to me,if I want to improve my prospect.btw ,I am an MBA

Answer Question   |  January 28, 2009  11:05 AM
Career development, IT careers, IT jobs, SAP careers

redord retrieval in SQLRPG
Hi, can anybody tell me how to retrieve a record randomly using cursors…(say 8th record) using SQLRPG(Embedded sql)

Answer Question   |  February 10, 2009  8:11 PM
Embedded SQL, SQLRPG

Format CSV file column width.
I converted a dataset to a CSV file and found when opening the file, all the column widths are fixed. This causes most of the columns to be truncated. Is there a way (not manually) of making the columns auto-fit. Language: Cobol.

Answer Question   |  August 31, 2009  8:01 PM
CSV, CSV file format

Permissions for writing stored procedures in MySQL
Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I got [...]

Answer Question   |  January 27, 2009  12:31 PM
Database Backup, Error 1044, Java development, MySQL, MySQL Access Denied error, MySQL backup, MySQL Stored Procedures, Navicat, SQL stored procedures, Stored Procedures, Web development

Need help with Oracle query
how to display the third highest salary from an employees table thanks in advance

Answer Question   |  January 26, 2009  6:46 AM
Oracle development, Oracle queries, Query optimization

Vertical text in MS Access 2003 report
I’m trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle — on a slant would be nice too. When I make a label (or text box) and change the properties to [...]

Answer Question   |  January 23, 2009  9:09 PM
Access 2003, Access Database Format, Microsoft Access