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

Front End Development for AS400
Hi We have an application in AS400 for which we are thinking of developing a GUI front end for the users. The users will then be able to run the processes from their PC. I have not worked on any such application and so, I do not know anything of that. I have done some [...]

Answer Question   |  January 7, 2007  10:39 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development

Using two same files from different libraries in a RPGLE program.
Hi All, Please guide me for the following problem. I got stuck into it. I want to operate same file from two different libraries in a RPGLE program. Remember we are taking the file names at runtime.So we don?t know the structure of files. Like the record format name etc. Again somehow I retrieve the [...]

Answer Question   |  December 28, 2009  4:15 AM
CLP, DB2 Universal Database, RPGLE

Is it possible to reorganize a very big transaction in one night?
I want to reorganize a very big transaction file in day end process and it cannot finish within 1 night. The problem is RGZPFM command lock that file ,so the day after , user cannot use that file because it is locked. Do you have any ideas to help me?

Answer Question   |  December 28, 2009  4:43 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security

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

Commit utilization in SQL stored procedures
I need an explample of an SQL stored procedure running in an DB2 environment that uses commitment control. I don’t want use RPG. I would like to call it from QSQLSRC via LXISCH (AS400 scheduler) and update over 100,000 records in 20,000 row increments. Any Suggestions? Thanks!

Answer Question   |  December 28, 2009  1:08 PM
AS/400, DB2 Universal Database, RPG

SQL Logical Functions
Which is better to use and why? Also, which function is faster and why? Coalesce -or- IfNull

Answer Question   |  December 19, 2006  3:10 PM
Application development, AS/400, DB2 Universal Database

Moving into the InfoSec role
I work at a company that currently does not have a position dedicated to information security. I come from a background in networking with a good portion of my focus on firewalls and other security related technologies. I am interested in positioning myself into the role of InfoSec Admin at my compnay and was hoping [...]

Answer Question   |  December 22, 2006  1:36 PM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms

Authenticating a Domino application using LDAP
Hello, I have an online training application that allows users to connect anonymously but then requires them to authenticate with their Notes username and password after completing required courses. About 8% bomb because they enter their network username and password instead of the Notes username and password. Is there a way I could authenticate to [...]

Answer Question   |  December 15, 2006  10:52 AM
Application security, Database, Encryption, Exchange, Instant Messaging, Lotus Domino, Secure Coding

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

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

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

Db2/AS400 library connecting via oledb in vb.net
I have been trying to connect a vb.net datalink property to a specific library on a 400. When I fill in the field “Enter the initial catalog to use” I get the message that the catalog is invalid. I have thought it might be a path on the 400, such as QSYS/MyLib, but that errors [...]

Answer Question   |  November 25, 2006  8:40 PM
DB2 Universal Database, PC/Windows Connectivity

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

Using an array in embedded SQL in RPGLE
Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = dPart(01) C+ and TkQty01 = dQty(01) C+ and TkPart02 = dPart(02) C+ and TkQty02 = dQty(02) There’s more to it than that but that should give [...]

Answer Question   |  November 30, 2006  11:17 AM
Application development, DB2 Universal Database, Development, RPGLE, SQL