Accessing a MySQL database using Visual Basic.
I am trying to write an application in Visual Basic and need to connect to a MySQL database running on the same computer. I would like to use a Provider to connect to MySQL rather than use ODBC. The reason being this application will be deployed on 100 computers and I don’t want to go [...]

Answer Question   |  October 13, 2004  5:23 PM
Development

Finalize
Does Finalize on an object trigger in visual studio vb dot net debug mode when the session times out? I set a break point and it never showed up. Any thoughts?

Answer Question   |  October 12, 2004  2:19 PM
ASP.NET, VB.NET

Datawarehouse building – datamart specification: how would you engage a scattered userbase?
We are currently building a datawarehouse and will need to engage the customers in order to successfully specify the datamarts, a search functionality, etc. All of the technicalities are scoped and being put in place. The question hence directs itself to successfully engaging the customer base, without whose input this could never be successful. Some [...]

Answer Question   |  October 12, 2004  10:43 AM
Data analysis, Data warehousing applications, DataCenter, ERP, Financial services applications, Implementation, Information risk management, Knowledge management applications, Remote users, Transaction Systems Architects

database design-2
sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like s,m,l,xl,xxl. example: mens brief-bule-s-1000 nos. mens brief-bule-m-1000 nos. mens brief-bule-l-1000 nos. [...]

Answer Question   |  October 11, 2004  6:16 AM
Development, J2EE, Java, JavaScript, JSP, SQL, XML

database design
sir, i am developing the order-process mgt (3-tier intranet app)using jsp,java,javascript and mysql as backend. i have to store the data from the customer order-sheets. in this business, they organize the garments(product) according to the colour.then each color is divided in to sizes like s,m,l,xl,xxl. example: mens brief-bule-s-1000 nos. mens brief-bule-m-1000 nos. mens brief-bule-l-1000 nos. [...]

Answer Question   |  October 12, 2004  6:07 AM
Development, J2EE, Java, JavaScript, JSP, SQL, XML

Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

Answer Question   |  June 15, 2010  1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS

Source code recovery from an object
How can I recover source code from an object? Is there a utility that will convert an RPGLE *PGM object to an RPGLE source member in QRPGLESRC? Is there a utility that will convert a PRTF *FILE object to a PRTF source member in QDDSSRC? I lost the source for 3 objects during !!!!$%#@ ftp. [...]

Answer Question   |  October 11, 2004  8:46 PM
Development

View scheduled jobs in a data file
When using the WRKJOBSCDE command on the AS400, you can see information regarding jobs in the scheduler. Is this information contained in a file which can be accessed for query?

Answer Question   |  October 18, 2009  3:40 PM
COBOL, Development, RPG, SQL

Data dictionary find time of long running query
Howdi All, I’m trying to figure out a way to find queries running longer than X minutes in the data dictionary. It’s been difficult to limit it to a specific query. Sessions are no problem. Here’s the latest query I’ve come up with. SELECT sess.status, sess.username, sess.machine, sess.program, sess.process, s.optimizer_cost, ops.message, round(ops.elapsed_seconds/60), TRIM (s.sql_text), ops.time_remaining [...]

Answer Question   |  October 18, 2004  10:53 AM
SQL

ORA-01033 Oracle Initialization or Shutdown in progress & cannot log into sqlplus.
My Database is in limbo at the moment and i’m trying to get it shut down properly and restarted. I’m getting the ORA-01033 and from I understand from reading posts..i’m to log in as sys/password as sysdba. When I do this, sqlplus is returning the error message: ORA -01031 Insufficient privileges. I’ve tried several different [...]

Answer Question   |  October 8, 2004  7:21 PM
DataCenter, Development, Oracle, Storage, Tech support

ADO DSN ACTIVE DIRECTORY
Need DSN driver to connect ado to active directory – is there such a thing?

Answer Question   |  October 7, 2004  9:22 AM
VBScript

Grpahs/Charts
I am looking for a fast, free method to create graphs for a web page using javascript,java, html or applet or any thing that will work on a web page

Answer Question   |  October 12, 2004  3:15 AM
ActiveX, HTML, Java, JavaScript, LotusScript

Updation of Oracle tables
Dear Sir/Madam I have a table t1 with 5 million records I have to update col2 of the table t1 as follows: update t1 set col2=1 where col2=a; update t1 set col2=2 where col2=b; update t1 set col2=3 where col2=c; update t1 set col2=4 where col2=d; update t1 set col2=5 where col2=e; and so on [...]

Answer Question   |  October 7, 2004  10:22 PM
Development, Tech support

Mpeg video streaming problem with Windows Media Player
I have two mpeg video files on a web site (http://petrolrem.com). The problem is with Window Media Player and streaming the video file over the Internet. The Windows Media player plays the entire mpeg movie on a local machince but does not play the whole movie over the Internet from the web site. Other media [...]

Answer Question   |  October 12, 2004  10:35 AM
Web development tools

Variable Report Heading in Query/400
I use Query/400 to produce a report which has a “control number” in the report heading. This number is stored in a one-record file and also in a data area. The number is used for information only; it does not control data selection. Is there any way to access this information and put it in [...]

Answer Question   |  October 18, 2009  8:34 AM
AS/400, Development, Tech support

Issue with SQL Query from two tables that have a 1 to many relationship
Thanks all for your help to my question last week. I did manage to get two of the totals I needed for the query. I am still having problems getting the second total and realize now the tables I am pulling the data from have a 1 to many relationship. I am trying to print [...]

Answer Question   |  October 7, 2004  4:39 AM
SQL

Software Development in Java
Could someone please advise me (and my team) on which development tools and resources to use for rapid development of java (or java-based) business software packages such as inventory management systems, payroll packages etc. We have been developing using Oracle 6i Developer suite and now intend to switch to Java to gain some flexibility with [...]

Answer Question   |  October 8, 2004  3:46 AM
C, Development, Dreamweaver, HTML, J2EE, Java, JavaScript, JSP, PHP, SQL, XML

Updating a number field when one record is deleted
In access (2003) I am setting up a table with Employee # (Pri. Key), senority numbers..and so on. However I cannot figure out how to reset the senority numbers when one leaves. For example Bob is #235 senority and leaves (By retiring, quits or gets fired)..well Mary was #236 and now should be #235 (because [...]

Answer Question   |  October 6, 2004  4:49 PM
Development

.Net/C# Roundtrip code generator
I am looking for a complete roundtrip software development tool that would cut down the time of the repeatitive writing of codes.

Answer Question   |  September 30, 2004  1:59 AM
Lifecycle development

BAI Transfer using CL Program
My co. is about to start on-line transactions with our bank(s), and I need to churn out CL programs that will dial the bank(s), recv. data in BAI (BAI2) format, and pass on to our ERP program. I’m looking for tips/examples/templates so I dont have to reinvent the wheel (and risk inventing a square wheel [...]

Answer Question   |  September 29, 2004  10:17 AM
Online transaction processing