Spring Cleaning: Free IT Book(s) Giveaway!
This week’s IT book giveaway is a little bit different: 1. Answer two of the five questions listed below. Link to your answer in the discussion area of this question. 2. Ask five questions between May 2 and May 8. Link to your questions in the discussion area of this question. 3. Approve three answers [...]

Answer Question   |  May 3, 2011  2:24 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Visual Basic Login form and second form load
I am building an application that uses a username/passworm form for login and want to load from a flat file info relevant to the username entered in the login form.    Will the code for the reading of the flat file go in the form_load of my second form this is the code I am trying [...]

Answer Question   |  September 26, 2011  9:28 AM
Flat files, Visual Basic, Visual Studio, Visual Studio 2010, Windows 7

Embedded SQL in rpg for subfile build SQLCOD
My fetch next in sql is getting sqlcod = -000000181 and sqlstt = ’22007′.  I looked this up.  It says invalid date or time. Pointing to date data types in the file I am trying to read. The records contain two date fields and two time fields. How can I get around this?   Thanks [...]

Answer Question   |  May 10, 2011  6:07 PM
RPG, SQL, SQLCOD, SQLRPGLE

Tell your friends about IT Knowledge Exchange, earn 100 points!
Tell your friends about IT Knowledge Exchange, and get 100 knowledge points closer to winning our latest contest. Simply send out this tweet to earn your points!

Answer Question   |  May 27, 2011  7:55 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server

Adding a MySQL user when no MySQL users have admin rights?
I’m working on a MySQL installation that has a user already created (“admin”), but that user doesn’t have a password, and doesn’t have any permissions, so I can’t create new users or even reset the password of that user. I’m using Ubuntu Server, and after looking through the help files I still can’t find a [...]

Answer Question   |  April 28, 2011  6:33 PM
Database administration, MySQL, SQL, Ubuntu

ODBC connection to the SQL server from the iSeries
Is there a way on the iSeries to establish an ODBC connection to the SQL server?

Answer Question   |  May 5, 2011  6:14 PM
iSeries Access, ODBC, ODBC Permissions, SQL Server, SQL Server connectivity

How do I add a local admin account via script?
We have just recently joined to our parent companies domain, and as such our old local admin account “administrator” name is not being used as an login anymore. Most of our machines have administrator as the local admin account. Since we want to get away from that name, we would like to add a local [...]

Answer Question   |  May 2, 2011  7:06 PM
Group Policy Objects, Local Administrators Account, Local Administrators Group, Visual Basic, Windows 7, Windows Server 2003, Windows XP

iFrame and IE 8 and Windows 7
I have an application that uses iFrame to access form field value. With the IE8 the form field value can’t be accessed by iFrame or it comes up blank. Is there a way to make form field available to the iFrame? Thanks  

Answer Question   |  May 2, 2011  12:17 PM
Domino Designer 7.x, iFrame, Internet Explorer 8, Lotus Notes 7.x, Windows 7

How to connect Visual Basic 6 to Lotus Notes 7?
Please advise that step by step, thanks

Answer Question   |  May 3, 2011  7:57 AM
Lotus Domino, Lotus Notes 7, VB 6.0, Visual Basic 6.0

Desktop Application in cloud computing.
Can we add our desktop based application created in Visual studio 2008/2010 in cloud server(Azure) ?

Answer Question   |  May 25, 2011  5:14 AM
.Net 4.0, Azure, Cloud Computing, Visual Studio 2008, Visual Studio 2010

Dynamic SQL query
Hi! I’m making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let’s say is…in a form the user can search for records thru 1) [...]

Answer Question   |  May 5, 2011  5:59 PM
Access Database, Dynamic SQL, SQL Query, VB.NET

10 Chances to Win $100
Starting today (April 25th) and running through May 31st, you have 10 chances to win a $100 Amazon.com gift card. The 10 IT Knowledge Exchange members with the most Knowledge Points earned between today and May 31st will win. Learn how to earn points in the Community Blog, or start answering questions and earning points.

Answer Question   |  May 2, 2011  1:30 PM
Amazon.com, AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE Community, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

unable to create a connection to DB from SQL developer
Hi, I was using SQL developer since 2 years, suddenly lost all the existing connections.Tried creating new connections, provided all mandatory fields and clicked “Test”, it was success. But when tried connecting, no response. Also tried importing the connections, but throwing “java.lang.NullpointeException”. What might be the issue?

Answer Question   |  May 2, 2011  6:46 AM
SQL Database, SQL Developer, SQL development

Source name and location for RPGLE
I want to find out the source name and location for all objects within a library – The source types are RPGLE and CLLE. Kindof like we use the DSPOBJD for RPG sources. Thanks.

Answer Question   |  May 2, 2011  8:38 AM
CLLE, DSPOBJD, RPG Source, RPGLE, Source Code Analysis

Regression On Large Systems – How To Test
So, I ahve been working at a company that has struggled with transitionaing into an Agile. The product we work on invovles accounting at a commercial level…very large in scope. Quality has been slipping and the organization has no regression testing in place. We have currently been given the task to bring up some sort of [...]

Answer Question   |  January 15, 2012  10:26 PM
Agile, Agile adoption, Agile testing, Automation Test, Regression

CISCO UCS Manager related.
Hi,  This is Manoj Wadile. I have one doubt related to UCS manager xml API. When we subsribe any event using even subscription api using java code and if we modified any properties of chassis/blades via UCS manager, currently i am not gettting response from UCS manager but when i checked .ucs log file that [...]

Answer Question   |  May 2, 2011  5:43 AM
Cisco Unified Communications, Unified Communications, XML

Save high volume xml transactions to db
I’m not a DB developer, I know basic select statements but that’s about it. We have a high volume xml web service that takes roughly 200K transactions per day. Each transaction request has a corresponding response so that’s about 400k transactional xmls per day to save. Each request xml is anywhere from 20k to 80k [...]

Answer Question   |  May 2, 2011  12:43 AM
SQL Server, SQL Server 2008, XML

Journaling on i5 when updating from .net
We need to update some i5 files (under v6r1) from SQL in a .NET environment. Can I control this process via SQL or will I need to call CL commands from .NET to start/stop journaling & commitment control?

Answer Question   |  May 2, 2011  3:41 PM
.NET, AS/400 journaling, CL Commands, i5, iSeries V6R1, SQL Server

Control which form opens up first in VB6 app
Developing an ap in VB6 for the first time. I need my “control Panel” to be the first form to pop up. Where do I set this?

Answer Question   |  May 2, 2011  6:47 PM
Application development, VB6 default screen, Visual Basic, Windows 7

Blocking access to our website based on IP address
How can we block access to our website based on IP address? It is hosted on IIS on a Windows Server 2003 R2 standard.

Answer Question   |  April 21, 2011  2:32 PM
IIS, IIS Server, IP address, Website accessibility, Windows Server 2003 R2, Windows Server 2003 Standard R2