How to secure MySql server?
How to secure a MySql server for webhosting?

Answer Question   |  November 17, 2010  5:20 PM
MySQL, MySQL functions, Security management, SQL Server, Web hosting

Why aren’t the Crystal Reports indexes showing since loading V6R1?
I use Crystal reports via ODBC to the iSeries and have for years.  After loading V6R1 when I go in to create a report, the files aren’t showing any indexes like they used to.  The used to show indexes based on the file definitions but now there are no indexes showing. I have even pointed [...]

Answer Question   |  November 8, 2010  6:45 PM
Crystal Reports, iSeries, ODBC, OS/400, V6R1

We’ll trade you an Xbox 360 for your knowledge!
The holidays are approaching and so is your next chance to win an Xbox 360 by simply doing what you do around IT Knowledge Exchange. Between today and December 15th, the three members who accumulate the most knowledge points will win some great prizes:   1st Prize: Xbox 360 with 250GB hard drive & Kinect [...]

Answer Question   |  December 1, 2010  3:12 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Knowledge Point Challenge, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server, XBOX Contest

Copy Table in SQLPLUS
How to copy a table from an access database using sqlplus

Answer Question   |  November 8, 2010  2:18 AM
Access, Access Database, SQL tables, SQLPlus

Advice needed on “DB2 DBA for Z/OS career”
Hello there, I am a mainframe professional with over 6 years of experience. I worked mainly in IDMS database throughout my career. However, i am interested to learn database administration in DB2. I did clear initial DB2certification long back. 1>  To do DB2 DBA, how difficult is it for me as i am from IDMS back [...]

Answer Question   |  October 28, 2011  4:37 PM
Database administration, DB2, DB2 DBA for Z/OS, z/OS

How do I count specific numbers in an Access 2003 database table?
I have over 6700 numbers in one field. No other fields in database. I want to find out how many times there is a number 1, 2, 3, 4, etc. in this list of possible numbers. I am not proficient in Access like you all are and am lost on creating a report with the [...]

Answer Question   |  November 18, 2010  2:16 PM
Access 2003, Access Database, Access Database Design, Access Database Filters

Put date time into 15 interval value in MySQL
does any one know if mysql have a function where I can convert datetime value into : 15 mins interval for example : 03NOV2010:00:00:02 –> 0-15 03NOV2010:00:16:02 –> 15-30

Answer Question   |  November 4, 2010  10:19 PM
MySQL, MySQL admin, MySQL Database, MySQL functions

Access 2000 Database Entry Question
When creating a table is there a way to set the first entry as a drop down menu and the associated entry as a currency entry on the same line? We are trying for an employee database that has several extra jobs that we would like in a drop down menu and then be able [...]

Answer Question   |  November 3, 2010  6:47 PM
Access 2000, Access Database, Access database permissions, Database query

SQL Server error 7125: Updated driver to get around?
I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs: #7125: The text, ntext, or [...]

Answer Question   |  November 2, 2010  5:32 AM
Access, ODBC, SQL Server, SQL Server error messages, SQL Server errors, SQLSRV32

Using Excel 2010 to pull data from SQL Server?
How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

Answer Question   |  November 1, 2010  9:05 PM
Excel 2010, Excel Database, ODBC, SQL Server, SQL Server database

Free IT Book: Why New Systems Fail
This week’s free IT book is Phil Simon’s Why New Systems Fail: An Insider’s Guide to Successful IT Projects. Simon provides the necessary framework to “minimize the chance of system failure before, during, and after beginning IT projects.” Win this book for some real-world and specific tips, tools and insight. You know the rules: Answer [...]

Answer Question   |  November 8, 2010  2:03 PM
DDL, DOS, Exchange 2003, Giveaways, IT answers, IT Books, Leased line, Linux, MPLS, RMAN, RMAN backup

Choosing a correct combination with ABAP for job opportunities
Hi, I am Debashish from Kolkata.I was till recently working as IT Manager with one MNC.I have 12yrs of experience in IT and IT support function ranging from technical to techno managerial profiles.However due to some unavoidable issues regarding job profile and enviornment there, I have quit and now have decided to move with SAP.I [...]

Answer Question   |  December 7, 2010  6:31 AM
ABAP, DC_ABAP, IT careers, SAP careers

DB2 or Websphere- for good career in IT
Out of IBM DB2 and IBM Websphere, which is a better technology to study in terms of career option????

Answer Question   |  November 1, 2010  4:32 AM
DB2, IBM DB2, IBM WebSphere, IT careers, WebSphere

Corrupted log file on Exchange still needs to be restored.
How would you recover Exchange server when the log file is corrupted?

Answer Question   |  June 3, 2012  8:36 PM
Corrupted database, corrupted log, Exchange 2010, Exchange errors, Windows

Old Recovering Access database password
A client of mine worked on a database 5 years ago for a research project, but she had to quit for a while for cancer treatments. She’s now responded well enough to go back to the project but her database, done probably in Access 2003 (perhaps even an earlier version, but certainly not a later [...]

Answer Question   |  November 5, 2010  1:08 PM
Access, Access 2003, Database security, Password recovery, Windows XP SP3

College For Information Security and Risk Management
Hi im about to begin my goal in computer information secuirty and risk management….im just curious as to 1) the types of jobs this bachelors would allow me to get 2) what is a starting salary? and 3) what else would you reccomend that i take in the IT Field (school wise) to further excell [...]

Answer Question   |  October 30, 2010  4:00 AM
Information risk management, Information security, Information security careers, IT careers, IT salaries

Recommend a Simple Data Input & Editing Tool
[strong]Please[/strong] recommend a simple to use data input, text editing tool that will create a “flat file” with data fields that are in specific starting positions of the flat file.

Answer Question   |  November 4, 2010  5:05 PM
data input, Database, Database software, Flat files, Input

ACCESS 2007 setting up repetitive entry form
I’m doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?

Answer Question   |  November 19, 2010  6:24 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP

Creating Automatic Notifications in Access 2007
I am building a volunteer database. I have a table tracking hours that each volunteer has put in, and would like to be notified when they reach certain milestones, (eg, 25 hours, 50 hours, 100 hours), so that we know who to thank appropriately. I believe that I will need a query totaling the hours [...]

Answer Question   |  October 27, 2010  5:47 PM
Access 2007, Access 2007 functions, Access query, Automated notifications

How do I copy an Access 2003 database and table?
I’m using Microsoft Access 2003. How do I copy a database and table? They were set up by someone that’s no longer with the company.

Answer Question   |  October 27, 2010  5:29 PM
Access 2003, Access Database, Access Functions, Access Tables