Certification recommendation?
I have a Bachelor’s in Business Administration and have worked in the field of office administration for over 10 years. I have recently been given the option to move over to IT Compliance as a Risk Analyst. My boss the CIO feels this would be a great field for me to get into. The only [...]

Answer Question   |  June 3, 2009  12:09 AM
Certifications, CISA, Information security careers, IT careers, IT Compliance, Risk Analyst, Security certifications

Are network certification courses worth the money?
Hello. I am 39 years old. I have no degree and am currently considering a change of career. I am looking at IT as I have had some limited experience in the field of Web page maintenance (html) and flash development (action script) for an online holiday bookings company. However, this experience was nearly 10 [...]

Answer Question   |  June 3, 2009  9:57 PM
Certifications, IT careers, Network administration, Networking, Networking certifications, Training and Certification

CA Database Command Center — good competitors?
Please note: The following question was recently submitted via e-mail by a user. We’re looking to use CA’s Database Command Center, but I want to know if there are any good competitors we should be looking into as well.

Answer Question   |  May 28, 2009  9:20 PM
CA, CA Database Command Center, Database administration, Database Administration Software

i need MCQ’s in principle of distributed database system
MCQ’s on query processing/ MCq’s on trancation managment?

Answer Question   |  May 28, 2009  12:49 PM
Distributed database, MCQ

Populate Access 2007 object in form
I am trying to populate a form object based on the value from a combo box. I have tried FindRecord and SetValue and so far nothing is working. Please help.

Answer Question   |  June 1, 2009  6:56 PM
Access 2007, ComboBox, Microsoft Access

Rebuilding Logical Files
What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?

Answer Question   |  May 27, 2009  4:57 PM
AS/400 database, AS/400 database administration, Database maintenance, iSeries, iSeries database, Logical File, Rebuilding Logical Files, Recompiling Logical Files

Connectivity between Oracle BI Publisher and Microsoft Access
I need to make a connection from BI Publisher to an MS Access database. Anyone can help me with the connect string and database driver class details for setting up a JDBC?

Answer Question   |  May 27, 2009  11:52 AM
Database connectivity, JDBC, Microsoft Access, OBIEE, Oracle BI Publisher, Oracle Business Intelligence

SQL Server query
how would I write an SQL statement to view the number of purchases for each month in the year of 2008..?

Answer Question   |  May 27, 2009  6:24 AM
SQL queries, SQL Server administration

CCNA vs Jobs?
Hi there,can i get a job after completing CCNA?

Answer Question   |  May 16, 2011  11:16 PM
CCNA, Certifications, IT careers

Windows ODBC driver for IBM DB2 database
I’m looking for a windows ODBC driver to access a DB2 database on the AS400. Does anyone have a link or suggested vendors?

Answer Question   |  May 26, 2009  9:24 PM
AS/400, DB2, ODBC drivers

Database Issues – Trying to prove that something has to be done
Hello Everyone, I’m currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major changes happen, we won’t see [...]

Answer Question   |  September 20, 2010  2:16 PM
AS/400, Database, Database issues, Indexes, iSeries, iSeries Navigator, Logical File, PF, SQL, SQL tables

Runtime Error 2147217900 (80040e14) – Syntex Error (Missing Operator) in query expression
Sir, I am using VB6 as fronthand and Access database as backend. Now in my project i want to display only those records which match selected value through combobox. but when executing system giving error as “Runtime Error 2147217900 (80040e14) – Syntex Error (missing Operator)in query expression ” My code is as under Private Sub [...]

Answer Question   |  May 26, 2009  10:09 AM
Error 80040e14, Microsoft Access, Syntax errors, VB 6, Visual Basic 6, Visual Basic runtime errors

The IT job market – Linux vs Windows?
I got A+ certification and coursed network+.Im studying Linux administration now but Im not sure if Im doing the right decision. I would like to know what path will be better(for salary and job opportunity). Keep going with Linux or go back to Windows for networking administration career? Thank you

Answer Question   |  August 26, 2009  9:19 AM
IT careers, IT Job Market, IT jobs, Linux administration, Linux vs Windows, Windows administration

Crystal Reports database
I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase’s name is “Database.mdf” . Why i am not able to see it ? My connection [...]

Answer Question   |  October 28, 2011  8:48 AM
Crystal Reports, Crystal Reports Database, Database applications, Database connectivity, Database programming

Bulk Insert with collation change
Hi, One of our client wants to change the collation of the database and the collation of the columns from SQL_Latin1_CP1_CS_AS to SQL_Latin1_CP1_CI_AS to match the SQL Server setting. So we are moving the data from one database to another database on the same server. We are re creating the database with the database and [...]

Answer Question   |  May 30, 2009  1:48 AM
Bulk Inserts, Database collation, Database migration, SQL Server 2000, System tables

Missing Database Name and toolbar
Why does the name of the database and the associated toolbar not show up when I look at the list of tables IN that data base. It does for most of my databases but not for one of them. How do I fis this?

Answer Question   |  May 25, 2009  3:54 PM
Database name

skills
how to improve my hardware and networking skill. how to get good job in it. how to prepare to that. my qualification is bsc degree.am present am working as a hardware i will looking to good job so how to improve skill.

Answer Question   |  May 23, 2009  10:27 AM
IT careers

Making two records into one
I was not sure on how to word the title of my questions, so it is better if I simply give you my query and result: SELECT DISTINCT PJ.EMPL_NUM, (CASE WHEN PAY_TYPE = 1 THEN RATE ELSE 0 END) AS REG_RATE, (CASE WHEN PAY_TYPE = 3 THEN RATE ELSE 0 END) AS OVR_RATE FROM dbo.tblPayrollFlashJobDetail [...]

Answer Question   |  May 26, 2009  7:16 PM
CASE statement, SQL Records

master-detail forms
In a master-detail form when I query the master it returns the data, then I query for the detail records and it returns the detail data. When I try to add a detail record the application is also trying to add the master. I only want the new detail record. The master already exist.

Answer Question   |  January 8, 2010  6:23 PM
Database, forms

Changing BCP format file collation
Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. [...]

Answer Question   |  May 22, 2009  5:28 AM
BCP Utility, Collation, Format file, import/export