store image from a directory into oracle database using sql
i have a directory containing 1000s of photos which i have to upload into oracle 9i db. i need to use only sql plus for this. i want a simple material to upload all those photos..

Answer Question   |  July 17, 2009  10:40 AM
Image databases, Oracle image storage, SQL, SQLPlus

SQL Server 2005 Query Very Slow in the first run
Hi, I have an sql query which takes 8 seconds in the first run. The next run there after takes 0.5 seconds and all consecutive runs take 0.5 seconds. Is the plan getting cached? How do i make this query run in 0.5 second in the first run itself? Please find the query below. select [...]

Answer Question   |  July 24, 2009  10:15 AM
SQL queries, SQL query optimization, SQL Server 2005

Xml Reader in oledb
how can i get ExecuteXmlReader() in OLEDB? i used sql server databse in my project. but now i want to change it to OLEDB. but ExecuteXmlReader() is not in OLEDB. what can i do to solve this? pls reply.

Answer Question   |  July 17, 2009  5:22 AM
ASP.NET, ASP.NET 3.5, ExecuteXmlReader, OLE DB, Web development, XML

Modify MS Access using iSeries RPGLE
I have to intergrate a third party product that uses an MS Access database with my AS/400 machine and be able to both update the Access data as well as read data from the Access database to use on the 400. Does anyone know how I can do this?

Answer Question   |  August 15, 2009  5:01 PM
iSeries RPG programming, Microsoft Access, RPGLE

new to IT looking to improve & make career in networking
hello expetise , myself being a student of 3rd yr computer engineering , actually i m not good @ language so suggest me course detials in network or system management ,what kind of basic should i have that will help me in course + referr me some books online to bulit my base? , hope [...]

Answer Question   |  July 24, 2009  8:12 AM
IT careers, Network administration, Networking careers, Systems administration

Access Switchboard Problem
The title of the switchboard changes to the title of one of the items. I can’t figure out why.

Answer Question   |  July 17, 2009  3:22 PM
Access 2007, Access Switchboard, Microsoft Access

certification help
hi which certification done is to be better either Oracle or Red Hat Linux? I dont have interest in programming so Is Administration is only field for me? please guide me Thanks

Answer Question   |  September 4, 2009  7:19 AM
Certifications, IT careers, Linux certifications, Oracle certifications, Red Hat Enterprise Linux

select parent where more than one child
I want to select a row from the parent table based on whether there are two or more rows in a child table. What is the best way to do that?

Answer Question   |  September 2, 2011  1:01 AM
SELECT statement, SQL, SQL queries

We are runing V5R1 OS400, how do I write to CSV file
We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

Answer Question   |  August 18, 2009  9:47 PM
AS/400 CSV, AS/400 import/export, CSV format, OS/400, V5R1, write csv file AS400

External document used as an Access Form?
I remember in Access 2000 you used to be able to import an external document and use it as a Access form after overlaying the table fields. We use a “User Request form” that I would like to use but I do not see where or how to accomplish this with Access 2007(??) If this [...]

Answer Question   |  July 14, 2009  2:46 PM
Access 2007, Microsoft Access

table from gridviewwith sql vs2008
hello, help, i have a access database with menu items–id, food items, description, price. with vs2008 i have connected to this database. and displayed on a aspx webpage using gridview, i can manipulate it with certain sql statements showing only certain things from the database, but the headings of the titles keep showing this is [...]

Answer Question   |  July 13, 2009  4:27 PM
Access Database, Microsoft Access, Visual Studio, Visual Studio 2008

Slow SQL Query
when i run below all SQL Query simulataneously against 1500000 Rows its take 10 minutes i put the non-clustered index on the columns TATCallType ,CallTo the data type of both columns is varchar select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType is null and substring(AuditData.CallTo,1,convert(int,0))=” and len(AuditData.CallTo)=10 select ID,AuditMaster_ID,CallTo,CallTypeTag into Auditdata_callto from auditdata where AuditData.TATCallType [...]

Answer Question   |  July 14, 2009  10:00 AM
Slow SQL Query, SQL queries, SQL query optimization

Connection of Crystal Report 2008 with VB6.
Plz let me know the procedure to bring the controls of Crstal Report 2008 in VB6? What control has to be select and what coding should be use for the same??am using sql 2000 as a back-end.plz help..

Answer Question   |  July 14, 2009  9:28 AM
Crystal Reports 2008 controls, Database connectivity, SQL Server 2000, VB 6, Visual Basic 6

How would be the opportunities for AS400 in future
Hi, I’ve been working as an AS400 Professional in one of India’s largest MNCs for the past 2 years. Now i have a chance of shifting into MAINFRAMES in same organization. Most of my friends telling me that MAINFRAMES had lot of opportunities compared to AS400. Can anyone please suggest me how bright AS400 would [...]

Answer Question   |  June 17, 2011  8:42 AM
AS/400 careers, Career development, IT careers, Mainframe

Inner join Solution
i write the following Query to execute against the 1500000 in SQL Server 2000 DECLARE Cur_Prefix CURSOR FOR SELECT PrefixNo,PrefixLen,AfterPrefixLen FROM NoSeriesMaster_Prefix WHERE PrefixType=’SMS’ order by ID OPEN Cur_Prefix FETCH NEXT FROM Cur_Prefix INTO @PrefixNo,@PrefixLen,@AfterPrefixLen WHILE @@FETCH_STATUS = 0 BEGIN SET @SQLStatement = ‘update ‘+@TABLE+’ set AuditData.TATCallType=”12”, AuditData.TATCallUnit=”1” ‘ + ‘from ‘+@TABLE+’ AuditData ‘+ ‘inner [...]

Answer Question   |  July 29, 2009  2:51 PM
INNER JOIN statement, SQL

Need Help Regarding Network Security Certifications?
Hi guys I have just finished my graduation and i am looking for a certification course in Network Security but don’t know where to start. Any Help would be great. Thanks.

Answer Question   |  July 15, 2009  10:43 AM
Certifications, IT careers, Networking careers, Networking certifications, Security certifications

networking
hi my name is udit gupta m a student of t.y. computer engineering , i would like to know that student not intrestead in programing field can jump to another feilds like networking & what course they should do that may help such student in final year .let me inform you that my interest field [...]

Answer Question   |  November 30, 2010  5:04 AM
IT careers, IT education, Networking careers

php and mysql
How can we create a family tree map using php and mysql?

Answer Question   |  April 3, 2010  12:45 PM
MySQL, PHP

How do I overcome the “Could not find installable ISAM. Excel 2007″ Error? Ex
I got the “Could Not find installable ISAM error” while uploading an Excel file in my application.This seems to be happening at the “connection.Open()” code line. – Web Application – .Net 2.0 – Testing using IIS 7.0 on Vista Ultimate – Office 2007 Enterprise Installed on machine. Code works successfully when used in a Windows [...]

Answer Question   |  July 9, 2009  10:06 AM
.NET 2.0, ISAM, Microsfot Office 2007, Microsoft Excel, Microsoft Excel 2007, Microsoft Windows Vista, Web development

Access Subform Blank
Subform doesn’t appear in either form view or design view. Can move database to another computer running Access 2003 and subform works perfectly linked to the same tables.

Answer Question   |  July 11, 2009  1:54 PM
Access 2003, Microsoft Access, Microsoft Access subforms