Excel to Access conversion
When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?

Answer Question   |  December 10, 2008  4:11 PM
Access 97, Excel 2003, Excel to Access Conversion, Microsoft Access, Microsoft Excel

What are the possible situations where DB2 server FORCES to close the applications connected to it?
Possibile situations where DB server forces to close the applications connected to it? Some of the situations can be : DB2 restart, DB2 stop, DB2 suspend. What else situations in DB2 server forces to close the applications connected to it? Your help is greatly appreciated !

Answer Question   |  June 29, 2011  11:00 AM
DB2, DB2 restart, DB2 stop, DB2 suspend, DB2 Universal Database, DB2 Update Query, DBFO, IBM DB2

How to limit the number of application connections in DB2?
I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?

Answer Question   |  September 23, 2009  10:54 AM
DB2, DB2 administration, DB2 configuration, DB2 connectivity, DB2 Universal Database

SAP training materials?
i dont have idea about sap. i am mechanical engineer presently orcle is our ERP, just i am using the fronthand application as assembly engineer. What is the dif beween sap and erp. what are the programing languages is a must to sap. wht r the basic book material need to learn. And can i [...]

Answer Question   |  April 15, 2011  6:37 PM
Certifications, IT careers, Oracle ERP, Recommended reading, SAP careers, SAP certifications, SAP developers, SAP development, SAP ERP, SAP jobs, SAP training

Transform Data task properties not opening.
In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

Answer Question   |  March 10, 2009  6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task

How to fill Combo Box at runtime in VB 6.0 …I’ve used RecordSet object but rec.count of rs obj returns (-1).I hv enough data in the DB
[Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL, Conn, adOpenDynamic, adLockOptimistic Dim i As Integer For i = 1 To rs.RecordCount cboSpare.AddItem rs("Spare_Name") rs.MoveNext Next MsgBox "Successss", vbOKOnly End Sub]

Answer Question   |  December 8, 2008  7:49 PM
ActiveX Data Objects, ADO, ADO Recordset Object, ComboBox, Database connectivity, Database programming, Recordset Object, RunTime, VB 6, Visual Basic, Visual Basic 6

Bulk Collect vs Cursor in Oracle
Hi, I have to process some records in some work table. The no. of records in work table may vary from 100,000 to 4,000,000. To process records in this work table i have to loop through it 1 by 1. So please tell me which is the better option out of these two: 1. Create [...]

Answer Question   |  April 18, 2013  3:38 PM
BULK COLLECT statement, Collection Loop, Cursor Loop, LOOP statement, Oracle Cursors, Oracle development, Oracle queries

About the SAP Certification
What is meant by SAP certification?Presently am working in MNC firm as manual tester.What is the advantage of this certification in y carrer growth? Really interested in this certification even though not knowing the scope.

Answer Question   |  June 15, 2009  7:04 AM
Career development, Certifications, IT careers, SAP careers, SAP certifications, SAP training

Can’t manually enter data any more; get Error Message: String or binary data would be truncated.
Three databases that were forced restored now do nor allow manual entry, even one single character, although using an update statement works. This is not a matter of changing the length of the datatype, but something else. For the life of me, I can’t figure out why this mere attempt at manual data entry generates [...]

Answer Question   |  December 6, 2008  6:23 PM
Binary data, SQL Server 2005, SQL Server 2005 SP2, SQL Server errors

Combo box question when developing a SQL database in Visual Basic 6
I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options – yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I [...]

Answer Question   |  December 5, 2008  6:20 PM
ADO, Microsoft Access, SQL Server database, Visual Basic, Visual Basic 6

Rights to Exchange Information Store
I am running an ERP webapplication Exact eSynergy in which I can schedule appointments. I also use Exchange to schedule appointments and setup a synchronisation between Exchange and eSynergy so I can use either application to see all appointments. The synchronisation job is setup in the SQL job scheduler (running as ADMSRV) and executes an [...]

Answer Question   |  December 5, 2008  12:43 PM
ADMSRV, ERP, Exact eSynergy, Exchange Information Store, Exchange synchronization, MAPI, MAPI_E_LOGON_FAILED, SQL job scheduler, SynergyExchange.exe

CMake – Automatically regenerate a file using an external tool and custom target upon “make”
Hi. I’m working on a project and I use cmake for generating “projects”, that is, under Linux, a Makefile. I also use an external tool (re2c) to generate the scanner, and an included tool to generate the parser (lemon, part of sqlite). The problem is I need to “cmake” every time I change something in [...]

Answer Question   |  December 8, 2008  11:01 AM
C, CMake, Lemon Parser Generator, Linux, Makefile, re2c preprocessor, Software development, SQLite

Conditional processing in embedded SQL
I’d like to conditionally control the host variable into which the data from an SQL select statement is retrieved. This is for flexibility, so that I can use the same code in my program more than once. Here is a code sample: C/EXEC SQL C+ If :ResultName = ‘AgtMaster’ C+ Then C+ Fetch Next From [...]

Answer Question   |  December 4, 2008  6:25 PM
Conditional expressions, Embedded SQL, SELECT statement, SQL

SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I’m trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the column names in [...]

Answer Question   |  November 3, 2009  8:13 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL

Referential integrity and AS/400
Can anyone please explain what refrential integrity means and how does it relate to AS/400? Regards, Shaddy

Answer Question   |  December 8, 2008  6:42 AM
Database, DB2, DB2/400, Oracle, RDBMS, Referential integrity, SQL Server

How can I join 3 tables using JOIN keyword
Hi Experts, Pls hlp me with my query How can i join 3 tables using JOIN Keyword inside PL/SQL block in SELECT … WHERE clause Query 3 Tables namely Reg,ROOTS,ME and the select statement takes both parameter variable and local variable Thanks!!!!!

Answer Question   |  December 8, 2008  6:20 AM
JOIN statement, PL/SQL, SELECT statement, SQL, SQL Query, WHERE statement

Access/Word Mail Merge Currency lost digits
I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 …Even worse $700.60 appears as 700.6 How do I get the decimals to show?

Answer Question   |  January 27, 2009  8:42 PM
Access 2007, Database issues, Mail merge, Microsoft Access, Microsoft Word

Navigation Pane
In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?

Answer Question   |  December 5, 2008  8:02 PM
Access 2003, Access 2003 Navigation Pane, Access Database, Access Navigation Pane, Microsoft Access

Professional certification versus a postgraduate degree in telecommunications
I’ve just completed an IT degree, but I’m keen on starting a career in telecommunications. I now need to decide whether to go for a postgraduate program in telecom or to take professional telecom certification exams. My concern right now is time; I’m getting on the late side of thirties and I’m quite worried about [...]

Answer Question   |  December 7, 2008  7:51 PM
Career change, Career development, Careers in networking, Certifications, Degree, IT careers, Networking, Telecommunications

New member contest: ASK, Answer and Win a $50 Amazon gift card
As 2008 winds to a close, IT Knowledge Exchange has one more fun contest to end the year. From today until December 23rd, you can enter to win one of ten $50 (US) Amazon.com gift cards. There are two things, however, that you must do in order to enter: 1. Ask 2 questions 2. Answer [...]

Answer Question   |  June 22, 2012  3:45 PM
AS/400, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, Virtualization, VoIP