G socket error in Lotus Notes
I have a user who launched Lotus Notes and the user got a g socket error

Answer Question   |  April 2, 2008  3:16 PM
Lotus Notes, Socket error

CSV data into Excel 2007
Here’s the issue. I have a .csv file that I want to import into Excel. This .csv came originally from Access. It has things like access database color values in it. I want to be able to do the following: 1. Change each “chr” value into it represented ascii equivalent. Example: chr(58) is a “:”. [...]

Answer Question   |  April 3, 2008  3:14 PM
Access 2007, CSV, Excel 2007

which course should i go for?
Hi, I am currently having a experience of around 3 years of software development and support. Currently I am working for a banking company. I want to do an MBA program. I want to stay in IT. What should i do? should I go for MBA programme (part time) or some other professional course. If [...]

Answer Question   |  April 2, 2008  6:50 AM
Career change, Career development, IT careers

referential integrity
quick question about referential integrity: let’s say i have 4 tables: A table has NAME B table has NAME, CODE C table has CODE D table has NAME, CODE, ELSE A (NAME) is referenced by B (NAME)and C (CODE) is Referenced by B (CODE) if i reference B (NAME, CODE) from D, do i need [...]

Answer Question   |  April 1, 2008  3:29 PM
Database, Referential integrity

Data transfer from DB2 (AS400) TO SQL SERVER 2005
I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by my self (perhaps using ODBC) Thinks all for help. Abdou

Answer Question   |  November 28, 2011  3:03 PM
AS/400, AS/400 DB2, Data transfer, DB2, ODBC, SQL Server 2005

Problem occuring while performing Mirroring
Hi, I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType–Full–Ok created FinalMirror.bak 4. Right clicked on the database Tasks-backup-BackupType–Transactional Log–Ok created FinalMirror-Transaction Log [...]

Answer Question   |  April 18, 2008  11:46 AM
Database mirroring, SQL Server, SQL Server 2005

Export to CSV or dump file
can any body guide how to export from command line in oracle 10g tables or db to CSV or dump file.

Answer Question   |  June 15, 2010  12:07 PM
CSV, Export, Oracle 10g

Need career advice for Network Communications Management
I am attending school currently, and will graduate with a Bachelor of Science degree in Network Communication Management. I am wondering if this degree is enough to be successful or if I should consider obtaining my Master’s degree prior to entrance into the workforce. I am also working towards my CCNA, and am curious to [...]

Answer Question   |  March 28, 2008  3:39 PM
CCNA, Certifications, IT careers, Networking certifications, VoIP jobs

Moving oracle database
HI, We have planned to move our oracle 10g production database from Solaris to Aix bix. So experts, please suggest any best practices that you follow or any scripts that should be run before moving it or any documentation or case study that will help us to do the work more efficiently. Thanks a lot.

Answer Question   |  March 28, 2008  8:38 AM
AIX, Database, Oracle 10g, Oracle migration, Solaris

How are H-1B visas impacting your company?
The debate surrounding H-1B visas is raging in Congress again. Tech businesses are looking to have the number of foreign workers allowed into the country raised. There has been almost predictable backlash, but employers still believe they are entitled to have the best talent available working in their shops, regardless of where it comes from. [...]

Answer Question   |  April 1, 2008  2:23 PM
Career development, CIO, H-1B visas, IT careers, Midmarket businesses, Staffing

Entry level
I’m about half way through my associates degree in Information Technology. I live in the Washington DC area but my prior work experience is unrelated to the info tech field (aircraft maintenance). Any suggestions on how I can get work in this field so I can begin building experience before I get my degree?

Answer Question   |  March 26, 2008  10:26 AM
IT careers, IT jobs

Oracle Installation on Portable Media
Hello Friends, I am working on Oracle 9i (Rel – 2). I am thinking of developing an application in which I can install Oracle on a portable media (Eg. Portable Hard Disk) and create a databse on the same. First of all, I want to know whether it is possible to install the Oracle on [...]

Answer Question   |  March 25, 2008  9:47 AM
Database, Oracle 9i, Oracle development

Oracle 10g on Windows 2003 virtual server
We have installed a SQL server on Windows 2003 virtual server and there were performance issues. Will oracle 10g make a significant difference in terms of performance? Are there known issues concerning 10g DB running on Microsoft 2003 virtual server? thanks

Answer Question   |  May 17, 2008  9:45 AM
Database, Microsoft Virtual Server, Oracle 10g, SQL Server

select only duplicate employee numbers
How does one select only duplicate employee numbers to be printed? Sounds simple?

Answer Question   |  March 24, 2008  6:34 PM
Database

Migrate an Oracle database to SQL2005
I need to migrate an Oracle database to SQL2005. How many users have done this and what tool did you use? How effective was it? I know Microsoft has a migration tool, but just want to cover my bases as this is a very high profile project. Thanks all!!

Answer Question   |  May 14, 2008  12:37 PM
Database, Database migration, Oracle, SQL Server, SQL Server 2005

DB2 Web Query- Change Report Layout
I have a report which contains all the information I require. The problem is, there are two totals (automatically produced after a break) that I would like to move down to another section of the report. Any way of doing this?

Answer Question   |  April 2, 2008  6:17 PM
DB2, DB2 Web Query

Job Change
I have been a coder for 6 years now mainly into ASP.Net, C# and sql server 2005. I have a job offer for e-business Assistant Manager role would be Vendor Management. Should i go for it? Is it the right path. I am currently a Project Lead.

Answer Question   |  March 21, 2008  11:11 AM
Developers, IT careers, IT jobs

Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases?
In SQL Server 2000, you can use a backdoor to create your own view in INFORMATION_SCHEMA… In SQL Server 2005, I get a permissions error though. Is there a way to create a view in Master in SQL Server 2005 that is accessible from all databases like the INFORMATION_SCHEMA views? Thanks…

Answer Question   |  September 20, 2008  11:55 PM
INFORMATION_SCHEMA views, SQL Server 2005, SQL Server schema

Running different versions of MySql on same machine?
Is it possible to run different versions of MySql on the same server machine?

Answer Question   |  March 19, 2008  7:37 PM
Database, MySQL

HOw to Find Duplicate Geometry in Oracle Spatial
If anyone knows a SQL statement for Oracle spatial on how to find duplicate geometry for area, line and point features, I would much appreciate it if shehe can share this with me. A million thanks in advance… Regards, Sam

Answer Question   |  March 18, 2008  2:42 PM
Database, Oracle Spatial, PL/SQL, SQL