Issue with a sub procedure and its arguments.
I’m trying to build a sub procedure to create a list for a combobox.  Basically, the db has sererate fields in the client table for first and last names and I want to create a combobox that lists each in one line. The real point of the question is whether or not I can build [...]

Answer Question   |  November 20, 2009  4:24 PM
Access 2003 forms, arguments, byRef variables, ComboBox, sub procedure, VBA

CONNECTION VB WITH ACCESS
how to connect visual basic 6 and msaccess 2003 by using connection string

Answer Question   |  August 9, 2010  7:56 AM
Access 2003, VB 6.0, Visual Basic, Visual Studio 2005

CONVERT SIGNLE USER APPLICATION TO MULTIUSER APPLICATION
Sir, I made single user application in visual foxpro 5 now i want convert in multiuser. How can change it…Pl give solution . At present ‘file Acess Denied’ message display on screen when 2 user used this application. i also input set excl off command but error stil display on screen.  

Answer Question   |  November 25, 2009  5:33 AM
Visual FoxPro, Visual FoxPro 5, Windows XP

Msg 102, level 15, State 1, Line 14
Hi, I’m ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the ‘ON’ on the line “SET ANSI_NULLS ON”. Could you please help me? I can’t see what’s wrong. Here’s my code:  CREATE PROCEDURE InsertDBTables  AS  BEGIN  SET NOCOUNT ON;  SET ANSI_NULLS [...]

Answer Question   |  November 19, 2009  6:54 PM
CREATE TABLE statement, SQL, Stored Procedures

The IT Blog Top 10: Nov. 19, 2009
10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for users of Sun’s VirtualBox. 8. Success [...]

Answer Question   |  November 19, 2009  6:46 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Going mult-tier
I have a bunch of webservers which connect to databases directly (2tier).  I need to go multi tier to remove the security issues associated with direct db links to systems from outside the firewall… What’s the best way of accomplishing this, given that I don’t have dedicated app servers, i guess i am looking at [...]

Answer Question   |  November 19, 2009  4:07 PM
ASP.NET, Tier architectures, Web server administration

PHP and MS Access Database
I’m trying to access an access databse located in my LAN thru php. When I run the script, I get the below error in Apache’s error log file: “[strong]PHP Fatal error: Uncaught exception ‘com_exception’ with message ‘Source: Microsoft OLE DB Provider for ODBC Drivers Description: Operation was canceled.’ in C:\WAMP\httproot\x1.php:6nStack trace:n#0 C:\WAMP\httproot\x1.php(6): com->open(‘DRIVER={Microso…’)n#1 {main}n thrown [...]

Answer Question   |  January 22, 2010  5:22 AM
Access Database, Microsoft Access, PHP

How to develope a Lotus Notes web form with rich text field ?
I need to convert my Lotus Notes application running in Client mode to web. I am facing problem where LN web development tools does not allow me to have a rich text field as provided by LN client development tools. Such feature is important as the newly develope web form will shall the document created [...]

Answer Question   |  December 3, 2009  2:02 AM
Lotus Notes, Lotus Notes Web Forms, Rich Text Format, Web development

as/400 query printing with DBCS data
We are having some problems printing query reports since a software upgrade. The upgrade now has DBCS file data and print files. The strange thing is the reports will print on some select printers and not on others. It is very strange, some printers and set-up as *VRT Client Access and others are *LAN. The [...]

Answer Question   |  November 24, 2009  9:00 PM
AS/400, DBCS, Printing, Query

SQL
is it possible to have a where sql statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have.  Is it possible  with SQL to be able to have a box pop up that would ask for a specific input to [...]

Answer Question   |  February 27, 2010  4:40 PM
Access 2000, Access Datasheet, Microsoft Access 2000, SQL, Windows Server 2000

Sequel ViewPoint
I am using Sequel ViewPoint. I have a script with variables defined. I would like to check the variable value to see the value and based on the value I would like to display different views. How would I code the script to do this?

Answer Question   |  November 18, 2009  4:08 PM
Scripting languages, SEQUEL ViewPoint, Viewpoint

Most efficient cron command to call a php script?
Any thoughts on the most efficient Cron command to call a php script? Basically, I want to trigger a page to run the script, so I’m currently using Lynx after I was worried my previous command (wget -O – -q -t 1 http://www.example.com/cron.php) was creating extra files in some dark corner of my server. It [...]

Answer Question   |  January 25, 2010  9:04 PM
cron jobs, PHP Coding, PHP scripts

How to encrypt a big list of sp’s at once
I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn’t be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I’ll like to know if there is a way [...]

Answer Question   |  November 18, 2009  7:52 PM
Encrypt, SQL, SQL stored procedures, Stored Procedures Optimization

To trap the item name of more than one item selected in list control
1)Is it possible to trap the item name of more than one item selected in the list control?Then how?I wish to trap the item name of more than one item selected in the list/combo control with/without the help of index numbers of the item selected. 2)And then use this item name to pick up data [...]

Answer Question   |  November 19, 2009  7:40 PM
Microsoft Access, SQL, Visual Basic 6.0

Datasheet view sorting question
Using the datasheet view, when sorting on a field with or without a dropdown menu, select a choice and then no data appears, even when there is data in the list.  This is a repeatable problem.  Has anyone else experienced this problem?

Answer Question   |  November 17, 2009  4:16 PM
Datasheet View, SharePoint 2007, Sorting

Upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
How does one upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?

Answer Question   |  November 18, 2009  3:42 PM
Oracle, Oracle 10i, Oracle 8.1.5, Oracle upgrades, QTP Automation

foxpro 2.6 on windows 98
I am developing a software in foxpro 2.6. on windows 98 When i run the project after every 16 trasactions it gives an error as follows :-      ” DO NESTING IS TOO DEEP “ there is no logical or syntax error in the project. But still it gives this error. Anybody can tell me [...]

Answer Question   |  November 20, 2009  11:31 AM
FoxPro, FoxPro 2.6, Windows 98

Test management tools
Is there any test management tool that tracks live metrics?

Answer Question   |  November 17, 2009  5:56 AM
Test management, Test management tools

jsp(NetBeans) in xampp
can u tell the steps for executing the project in XAMPP. the project is in NetBeans and the coding is jsp.how to link it correctly

Answer Question   |  November 17, 2009  2:10 AM
JSP, NetBeans, xampp

data search using popup window
Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF?

Answer Question   |  November 17, 2009  12:44 AM
CL, iSeries, Physical Files, RPG, SQL