insert an access image into a crystal report
A .bmp in a field on my access db; I want to display the image in my crystal report. I’ve looked at some forums but the suggestions don’t getg me anywhere. any help would be much appreciated. Thank you

Answer Question   |  December 15, 2009  10:29 PM
Access 2007, Crystal Reports, Crystal Reports XI, Microsoft Access

embedded sql update
I have a prog that should update all KY cust master records with the new code AR. I run the program but nothing happens. The file remains unchanged. I am new to embedded sql so what am I doing wrong ?? D OLDWH           S              2    INZ(‘KY’)    D NEWWH           S              2    INZ(‘AR’)                                                        * Get all [...]

Answer Question   |  December 15, 2009  2:55 PM
Embedded SQL, RPGLE, SQL

best solution for integrating longitude and latitude into another Database in mySQL
I have databases with longititude and latitude and one with Business Info – What is the best solution for getting the longitude/latitude into the Business Database? or Do I even need to merge them?

Answer Question   |  December 17, 2009  8:26 PM
Database management, MySQL, MySQL Database

The IT Blog Top 10: Dec. 10, 2009
10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. What is Changed Block [...]

Answer Question   |  December 11, 2009  10:09 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

What is difference between RDBMS & ORDBMS?
What is difference between RDBMS & ORDBMS?

Answer Question   |  June 2, 2012  8:49 PM
ORDBMS, RDBMS

Triggers to Populate Geometry of a Feature
Hi, Has anyone created a trigger that populates a field with the geometry of that table, where the table contains spatial geometry?  For example, I would like to create a trigger to automatically populate an area (AREA_SQM) or perimiter (PERIM_M) field of a building area feature (AREA_BUILDING) once the feature has been created. Thanks in [...]

Answer Question   |  December 9, 2009  7:38 PM
Database, Oracle

The most-watched IT questions this week: Dec. 8, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs into trouble Converting date values [...]

Answer Question   |  December 9, 2009  8:07 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Want to be a Sun Solaris Administrator.
I am Varun Malhotra. I am going to join a course in Sun Solaris Administration. This year I completed my BCA degree and currently I am working in a call centre. What is the future scope of Solaris administrators? Is it a good area to work in? Will I be getting a good job after [...]

Answer Question   |  May 12, 2010  8:18 PM
IT careers, Solaris certifications, Sun Solaris

Edit .accdb from multiple workstations
How can I input data in to a database file using microsoft access 2007 from multiple computers at the same time. From my understanding I need to have SQL Server running in order for me to do this, correct ? Also if I do need Sql server can it be installed on a Windows Xp [...]

Answer Question   |  December 12, 2009  3:14 AM
Access 2007, Access Database, Microsoft Access, Windows XP, Windows XP SP2

export VB6 report in pdf format.
i am making a project in vb 6 using ms access as a database. i am making report in crystal report and want to export that repot in pdf format.

Answer Question   |  January 21, 2010  4:47 AM
Access Database, Crystal Reports, Microsoft Access, VB6, Visual Basic

Reconnecting to databases in SharePoint after server wipe
My Windows Server 2003 box died which had WSS 3.0 on it. The server has been wiped and I still have the SQL Server intact. Everything is reinstalling now; can I just reinstall SharePoint and “reconnect” to the databases that already are there or do I need to start all over?

Answer Question   |  December 4, 2009  7:33 PM
Database administration, Servers, SharePoint, Sharepoint installation, SQL Server, Windows Server 2003, WSS 3.0

SQL Query to return a single value for each record based on max FIELD, not max record
I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc [...]

Answer Question   |  December 24, 2009  7:59 AM
Access 2007, Microsoft Access, SQL, SQL Query

which is the best among DBA and CCNA for career in all aspects
Hi All, presently i’ve one year of exp. in network field. i want change my domain to DBA, now iam cofused whether to ontinue with CCNA or to change to DBA. please can anyone suggest me which will be the best for my career in all aspects. please help me out

Answer Question   |  July 23, 2011  5:51 AM
Careers, CCNA, Certifications, DBA, IT careers

VB6.0 Connectivity to Oracle
How to connect oracle 9i to vb6.0 using active X data objects? please mention the code.. Thnx …  Saurabh

Answer Question   |  May 20, 2011  5:18 AM
ActiveX, Activex connectivity, ODBC, Oracle 9i, VB6.0, Visual Basic

The most-watched IT questions this week: Dec. 1, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. CompEng asked about open-ended SQL statements, and Mrdenny and Meandyou delivered the goods. 2. Kalpana queried Networking certifications, and where the best place is to get certified. XENOPHON22, Schmidtw and KevinBeaver all chimed in [...]

Answer Question   |  December 11, 2009  6:21 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

About MCSE
Is there any chance to get high profile job after completing the MCSE exam conducted by Microsoft ?

Answer Question   |  December 4, 2009  8:26 AM
Careers, IT careers, MCSE

Building an xml in java
Please give me an example of building an xml with multiple child nodes, in java. I want something like : <Parent> <Child1>something</Child1> <Child2>something else</Child2> </Parent> Now, the values for Child1 and Child2 must be picked using SQL from AS400. Picking values is where i think i am failing. My program constructs something like : <Parent> [...]

Answer Question   |  November 30, 2009  7:20 AM
AS/400, Java, JDBC, SQL Query, XML

Microsoft Access Report
I am able to alter one of my access reports, but everytime i try to exit and save it the report will not close untill i say no to save changes has anyone got any ideas as it is driving me insane

Answer Question   |  November 30, 2009  10:49 AM
Microsoft Access

Best way to create a large access databases.
I am new to access databases, as I am sure everyone says there first time. One thing I do know is that the database I will create will be very large and I Would like to know is it better to break up the database in to several linked databases together or just have one and live [...]

Answer Question   |  November 30, 2009  7:40 PM
Database, Microsoft Access

Data Dynamic Activ Report Version 2.0
I Have Data Dynamic Active Report Activex, When I load designed Report from vb6 I can show a evaluation message in yellow backgroun How to remove it and also when I give print 1 page printer will print 2 page (With blank page) How to solve this problem or how to hack this proble

Answer Question   |  November 23, 2009  6:43 AM
Access 2003, ActiveX, data dynamic active report, VB 6.0, Visual Basic 6, Windows XP