Daily Question and Answer Update for Feb 23, 2009

New questions and answers have been added to the community for the following tags: - CRM - Database - DataCenter - DataManagement - Developm...

New questions and answers have been added to the community for the following
tags:
- CRM
- Database
- DataCenter
- DataManagement
- Development
- Linux
- Microsoft Windows
- Mobile
- Networking
- Oracle
- SAP
- Security
- SQL Server
- Storage
- Virtualization
- VoIP
Continue the conversation. Answer or discuss a question and earn Knowledge
Points.

-----------------------------------------------------------------------
CRM UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all CRM related Questions and Answers
http://go.techtarget.com/r/5927356/4946246/1
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Active Dir. Web Based Password Reset Tool?

ANSWER from Sharepointfan:
Take a look at [A
href="http://www.sharepointboost.com/passwordchange.html"]Sharepoint Password
change[/A]. this may help you.
You should know if you are using Sharepoint there is no such feature to let
them change passwords.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927357/4946246/2

-----------------------------------------------------------------------
NEW QUESTION on:
save a siebel answers report

QUESTION from Funtimes:
I would like to make a small change on a siebel answers report, and put it into
a software tracking system (like PVCS tracker), but I don't want to save the
entire repository.
Howwould I do this?
thanks

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927358/4946246/3

-----------------------------------------------------------------------
DATABASE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5927326/4946246/4

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5927326/4946246/5

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5927326/4946246/6

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5927326/4946246/7

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5927326/4946246/8
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Using Access query data in Excel

DISCUSSION from Findsarfaraz:
Excellent SbElectric ,

seems you too like MS Excel like me...

Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help [/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927383/4946246/9

-----------------------------------------------------------------------
NEW DISCUSSION on:
unrecognized data base format

DISCUSSION from Indira23:
There are known issues when connecting to Access 2000 on certain localized
versions of Visual Basic 6.0 Service Pack 4. This is scheduled to be fixed in
Visual Basic 6.0 Service Pack 5. However, this bug is fixed for the English
version (North America) of Visual Basic 6.0 Service Pack 4.

You can ...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927456/4946246/10

-----------------------------------------------------------------------
NEW ANSWER on:
Install QMF V9

ANSWER from Starwars975555543:
there is a lot here

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927457/4946246/11

-----------------------------------------------------------------------
NEW DISCUSSION on:
How do I run Excel Reports?

DISCUSSION from Findsarfaraz:
Can you clarify if the data is lying in MS Access? if yes, there is an option
to export the data from MS Access to MS Excel using macro.

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help[/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927385/4946246/12

-----------------------------------------------------------------------
NEW DISCUSSION on:
What questions should I expect for a Network Engineer interview?

DISCUSSION from Flow:
Thanks for all your input i would appreciate if you can give me answer to the
qyestions you posted pls

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927360/4946246/13

-----------------------------------------------------------------------
NEW DISCUSSION on:
i want to create trigger to avoid user when he update data using db2 command
editor

DISCUSSION from Technochic:
Can you help us provide an answer by providing us with more details please?
What application or database is it you are asking about please? What version
and patch level? Thanks!

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927458/4946246/14

-----------------------------------------------------------------------
NEW ANSWER on:
Website and database connection

ANSWER from Mrdenny:
You'll need to use the information you have to create the connection string.
[A href="http://www.connectionstring.com/"]Connectionstrings.com[/A] has all
sorts of good info on getting up the connection string.

You'll then need to open the [A
href="http://www.devhardware.com/forums/programming-8...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927354/4946246/15

-----------------------------------------------------------------------
UPDATED ANSWER on:
How do I get started in the IT Job market

ANSWER from Mshen:
If you went to college or a trade school check and see if they have job
placement services. You could also try looking for a job with the [A
href="http://www.geeksquad.com/"]Geek Squad[/A] they are in many areas around
the country and while the pay might be a bit low, you can really rack up some
ex...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927361/4946246/16

-----------------------------------------------------------------------
NEW DISCUSSION on:
IT career requirements for Java?

DISCUSSION from Carlosdl:
I agree with Mshen; there are fields in which you will probably not need it,
but based in my experience, it is always good to have some programming skills,
and I think Java is a good option, since it can be used in a variety of
environments.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927364/4946246/17

-----------------------------------------------------------------------
NEW ANSWER on:
How can I compare fields on two databases

ANSWER from Carlosdl:
You will need to specify what database and programming language you are using,
in order to get some useful responses.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927459/4946246/18

-----------------------------------------------------------------------
NEW DISCUSSION on:
Update one database from another database with ASP.NET

DISCUSSION from Mrdenny:
Assuming that you are using SQL Server you can use an UPDATE statement like
this using the remote objects three part name.

[CODE]UPDATE OtherDatabase.dbo.YourOtherTable
SET Column1 = LocalTable.Column2
FROM LocalTable
WHERE LocalTable.Column1 = YourOtherTable.Column4[/CODE]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927460/4946246/19

-----------------------------------------------------------------------
NEW DISCUSSION on:
Sending more then 1 Access Report to Outlook

DISCUSSION from JulieSandra:
Thanks for replying. I am exporting the Reports as .pdf files in two emails.
I just thought it would be better to have one email with 2 attachments. It
dosnt look like I am going to be able to do this without some major coding.

Thanks again

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927378/4946246/20

-----------------------------------------------------------------------
DATACENTER UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Data Center related Questions and Answers
http://go.techtarget.com/r/5927359/4946246/21
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Active Dir. Web Based Password Reset Tool?

ANSWER from Sharepointfan:
Take a look at [A
href="http://www.sharepointboost.com/passwordchange.html"]Sharepoint Password
change[/A]. this may help you.
You should know if you are using Sharepoint there is no such feature to let
them change passwords.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927357/4946246/22

-----------------------------------------------------------------------
NEW DISCUSSION on:
What questions should I expect for a Network Engineer interview?

DISCUSSION from Flow:
Thanks for all your input i would appreciate if you can give me answer to the
qyestions you posted pls

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927360/4946246/23

-----------------------------------------------------------------------
UPDATED ANSWER on:
How do I get started in the IT Job market

ANSWER from Mshen:
If you went to college or a trade school check and see if they have job
placement services. You could also try looking for a job with the [A
href="http://www.geeksquad.com/"]Geek Squad[/A] they are in many areas around
the country and while the pay might be a bit low, you can really rack up some
ex...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927361/4946246/24

-----------------------------------------------------------------------
NEW DISCUSSION on:
Building a Data Center from the ground up

DISCUSSION from SbElectric:
I agree , if budget is available, then engaging both Construction PM and IT PM
will bring diverse but complementing skill sets for better construction of the
Datacenter.

After all a Data center should last 30 years or more. Generally IT PM will
bring in IT Security (physical and logical) and Op...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927362/4946246/25

-----------------------------------------------------------------------
NEW DISCUSSION on:
iNotes

DISCUSSION from Asudoh:
Correction to myself - Firefox on Mac browser support began with 7.0.2
release.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927363/4946246/26

-----------------------------------------------------------------------
NEW DISCUSSION on:
IT career requirements for Java?

DISCUSSION from Carlosdl:
I agree with Mshen; there are fields in which you will probably not need it,
but based in my experience, it is always good to have some programming skills,
and I think Java is a good option, since it can be used in a variety of
environments.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927364/4946246/27

-----------------------------------------------------------------------
NEW DISCUSSION on:
Server 2003 memory performance configuration

DISCUSSION from Labnuke99:
Will adding memory above 4GB to a 32-bit machine really help? We were not
planning on moving the servers to 64-bit architecture.

Since it is an n-tier architecture, I am thinking that there could be problems
at several points along the path creating the slow performance being reported
by users. I...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927355/4946246/28

-----------------------------------------------------------------------
DATAMANAGEMENT UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Data Management related Questions and Answers
http://go.techtarget.com/r/5927463/4946246/29
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
Install QMF V9

ANSWER from Starwars975555543:
there is a lot here

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927457/4946246/30

-----------------------------------------------------------------------
NEW DISCUSSION on:
How do I run Excel Reports?

DISCUSSION from Findsarfaraz:
Can you clarify if the data is lying in MS Access? if yes, there is an option
to export the data from MS Access to MS Excel using macro.

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help[/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927385/4946246/31

-----------------------------------------------------------------------
NEW ANSWER on:
As400 File Transfer to Windows

ANSWER from Mshen:
Use the iSeries Navigator which should have been installed with Client Access
or FTP the file.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927332/4946246/32

-----------------------------------------------------------------------
UPDATED ANSWER on:
Single Page subfile for duplicate records

ANSWER from Philpl1jb:
Hi S22

You've chosen to create tricky little piece of code.

The duplicate records make it impossible to find your place if you move the
record pointer in other processing.
So any other processing should be by another access path.

When you initially load the subfile you probably read one ex...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927334/4946246/33

-----------------------------------------------------------------------
DEVELOPMENT UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Development related Questions and Answers
http://go.techtarget.com/r/5927464/4946246/34
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
.net

QUESTION from Minal:
System.IO.Stream stream =
GetType().Assembly.GetManifestResourceStream("logo.ICO");

gives me an error like "Value of 'null' is not valid for 'stream'"


VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927465/4946246/35

-----------------------------------------------------------------------
NEW DISCUSSION on:
QMQRY not a valid Query Management variable.

DISCUSSION from Sivu:
Norm,

Try this!!!

STRQMQRY QMQRY(JCCSTREP2) OUTPUT(*PRINT) +
QMFORM(*QMQRY) SETVAR(JOB &JOBA)

Regards,
Siva

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927329/4946246/36

-----------------------------------------------------------------------
NEW DISCUSSION on:
unrecognized data base format

DISCUSSION from Indira23:
There are known issues when connecting to Access 2000 on certain localized
versions of Visual Basic 6.0 Service Pack 4. This is scheduled to be fixed in
Visual Basic 6.0 Service Pack 5. However, this bug is fixed for the English
version (North America) of Visual Basic 6.0 Service Pack 4.

You can ...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927456/4946246/37

-----------------------------------------------------------------------
NEW QUESTION on:
SQL query and design -help needed

QUESTION from Rohit3312:


Need help in designing the SCHEMA below and then the questions below

There is a COMPANY(STAR INTERNATIONAL*) WHICH has many divisions/departments in
it.
These divisions has employees.

(1)one employee can be in many departments(1 TO MANY) and and each department
has one manager.(1 to 1)
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927348/4946246/38

-----------------------------------------------------------------------
NEW QUESTION on:
SQL query and Databse design -help needed

QUESTION from Rohit3312:
Sorry for all the confusion with the questions.So let me clear myself,i am
doing this not as assignment or homework,but something
which interests me and trying to leran.Earlier as I stated that its a part of
my school(** well frnakly speaking, it was my plan if i could
put this as an item of the s...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927349/4946246/39

-----------------------------------------------------------------------
NEW QUESTION on:
java.lang.NoClassDefFoundError

QUESTION from Scottlinn:
Hi,
I need some serious help here..I use OAS 10.1.2.0.2.. I deployed my ear file to
the OC4J container. And everytime I access the webpage
I get this error.

500 Internal Server Error
java.lang.ExceptionInInitializerError at
com.experio.common.util.AppUtil.getInitialContext(AppUtil.java:71) at ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927350/4946246/40

-----------------------------------------------------------------------
NEW QUESTION on:
vbscript that logs in a user to server

QUESTION from Razz:
Hello,

I'm working in server 2003, remotely.
I have a few schedule tasks, each running a business program i'm working with
and a vbscript which checks that the program ran successfully and suppose to
send an e-mail report.

All of this happens during the night, when i'm logged off from the ser...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927466/4946246/41

-----------------------------------------------------------------------
NEW QUESTION on:
SSIS and Excel

QUESTION from Cathryn:
I have a road block that I need to find a work around for. I work on a system
where the Databases reside on a soley database server (SQL 2005).

I need to run a stored procedure on a nightly basis and export the results into
a template excel file and put out on shares. Sounds simple right? Here's...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927353/4946246/42

-----------------------------------------------------------------------
NEW ANSWER on:
Website and database connection

ANSWER from Mrdenny:
You'll need to use the information you have to create the connection string.
[A href="http://www.connectionstring.com/"]Connectionstrings.com[/A] has all
sorts of good info on getting up the connection string.

You'll then need to open the [A
href="http://www.devhardware.com/forums/programming-8...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927354/4946246/43

-----------------------------------------------------------------------
NEW ANSWER on:
.NET DataTable

ANSWER from Mshen:
You need to declare the datatable as a public static datatable. Then you can
reference the datatable using ClassName.DatatableName.

For instance, in class Program you have the following:

static class Program
{
public static datatable dTable;
static void Main()
{......}
}

You can...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927467/4946246/44

-----------------------------------------------------------------------
UPDATED ANSWER on:
Does anybody knows any API, which will extend the size of Display File in
AS/400 (making bigger than 132), like Excel ..

ANSWER from Mshen:
Hi,

I don't think there is such a thing. The display sizes on the AS400 are based
around the 5250 data stream - I don't think there's ever been 5250 based
hardware that could handle more than 132 columns. How would you format the
data on the AS400? Using a display file?

You may be able to a...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927331/4946246/45

-----------------------------------------------------------------------
NEW DISCUSSION on:
Rollover image swap and onclick image w/ javascript

DISCUSSION from Mshen:
Do you have any code to start with? It would be easier to integrate our code
if you posted the URL of your site.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927468/4946246/46

-----------------------------------------------------------------------
NEW DISCUSSION on:
Need guidance in starting my career in SAP

DISCUSSION from FredMackie:
Even while you are looking, keep busy with online resource such as [A
href="http://www.microsoft.com/events/series/mbserp.aspx"]Enterprise Resource
Planning[/A] to keep you up to date.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927396/4946246/47

-----------------------------------------------------------------------
NEW DISCUSSION on:
Conditional Formatting Excel 2003

DISCUSSION from SbElectric:
Good Job, Sarfaraz!
Yes, to consider 1 month or 3 moths away one should use your formula.

I just browsed thru your web-site. Nice site for someone who is interesting in
broadening Excel knowledge. I recommend to others.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927397/4946246/48

-----------------------------------------------------------------------
NEW ANSWER on:
ProC under Oracle 10g

ANSWER from Kccrosser:
It would help if you would post your code. Knowing which tables are being
accessed, and the syntax of the query could help diagnose the problem.

I assume you copied and ran the query and it works outside the Pro-C routine.

Things that usually cause behavior problems between versions (with "no...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927352/4946246/49

-----------------------------------------------------------------------
NEW ANSWER on:
Toggle text between red and black

ANSWER from Flame:
Not sure if this is what you are looking for, but it might get you started in
the right direction:
[CODE]
With Me.Button1
If .BackColor = Color.Black Then
.BackColor = Color.Red
.Text = "RED"
Else
.BackColor = Color.Black
.Text = "BLACK"
End If
E...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927469/4946246/50

-----------------------------------------------------------------------
NEW DISCUSSION on:
Remote RSOP gives RPC server unavailable

DISCUSSION from NetSupport:
Yes, Yes, and Yes

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927376/4946246/51

-----------------------------------------------------------------------
NEW DISCUSSION on:
Macros in a drop down list

DISCUSSION from Excerlnovice:
Thank you for sharing the information and proposed solution. What I am trying
to do is use a drop down list to select macros to run from. For example, I have
12 macros, 1 for each month, and instead of creating buttons and assigning a
macro to each individual button I want to have a drop down list i...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927405/4946246/52

-----------------------------------------------------------------------
NEW DISCUSSION on:
IT career requirements for Java?

DISCUSSION from Carlosdl:
I agree with Mshen; there are fields in which you will probably not need it,
but based in my experience, it is always good to have some programming skills,
and I think Java is a good option, since it can be used in a variety of
environments.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927364/4946246/53

-----------------------------------------------------------------------
NEW ANSWER on:
How can I compare fields on two databases

ANSWER from Carlosdl:
You will need to specify what database and programming language you are using,
in order to get some useful responses.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927459/4946246/54

-----------------------------------------------------------------------
NEW DISCUSSION on:
Update one database from another database with ASP.NET

DISCUSSION from Mrdenny:
Assuming that you are using SQL Server you can use an UPDATE statement like
this using the remote objects three part name.

[CODE]UPDATE OtherDatabase.dbo.YourOtherTable
SET Column1 = LocalTable.Column2
FROM LocalTable
WHERE LocalTable.Column1 = YourOtherTable.Column4[/CODE]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927460/4946246/55

-----------------------------------------------------------------------
NEW DISCUSSION on:
Server 2003 memory performance configuration

DISCUSSION from Labnuke99:
Will adding memory above 4GB to a 32-bit machine really help? We were not
planning on moving the servers to 64-bit architecture.

Since it is an n-tier architecture, I am thinking that there could be problems
at several points along the path creating the slow performance being reported
by users. I...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927355/4946246/56

-----------------------------------------------------------------------
LINUX UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Linux related Questions and Answers
http://go.techtarget.com/r/5927380/4946246/57
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
FTP over SSH on Windows

DISCUSSION from Petkoa:
Hi,

it's quite tricky to set ssl/tls ftp - for the same reasons ftp is tricky for
natting and firewalling: control channel, data channels on various ports,
encryption of just control channel, but not data channels etc., etc... - but I
believe you are aware of this. I'd agree with Edhacker, that...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927381/4946246/58

-----------------------------------------------------------------------
MICROSOFT WINDOWS UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Microsoft Windows related Questions and Answers
http://go.techtarget.com/r/5927382/4946246/59
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Using Access query data in Excel

DISCUSSION from Findsarfaraz:
Excellent SbElectric ,

seems you too like MS Excel like me...

Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help [/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927383/4946246/60

-----------------------------------------------------------------------
NEW ANSWER on:
office 2003 excel filter

ANSWER from Findsarfaraz:
Check if you have any empty rows in between?

Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"]MS Excel help[/A]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927384/4946246/61

-----------------------------------------------------------------------
UPDATED ANSWER on:
transferring data from iSeries to Excel 2007

ANSWER from Findsarfaraz:
Well, seeing that Excel has a row limitation of 65536... The only way to
download more rows than that would be to insert them into Access! Or ask
Microsoft to expand the Excel row limitation.

The MS office 2007 has unlimited rows. However, can you tell how are you
connecting iSeries?
Sarfaraz ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927330/4946246/62

-----------------------------------------------------------------------
NEW DISCUSSION on:
How do I run Excel Reports?

DISCUSSION from Findsarfaraz:
Can you clarify if the data is lying in MS Access? if yes, there is an option
to export the data from MS Access to MS Excel using macro.

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help[/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927385/4946246/63

-----------------------------------------------------------------------
NEW DISCUSSION on:
Linked Workbooks return #VALUE error until linked workbooks are opened

DISCUSSION from Findsarfaraz:
Please let us know if the linked work book is store on the same system or the
network drive. Does it happen with one excel workbook or all MS Excel work
book.

Try the steps below
move the sheet from linked workbook to the same workbook from where it is
referencing. Refresh links. Move the sheet ...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927386/4946246/64

-----------------------------------------------------------------------
UPDATED ANSWER on:
Excel 2007 - How do I ignore zero's and #DIV/0! for a graph?

ANSWER from Findsarfaraz:
I am not pretty clear about your query. However, you want to have blank in
cell instead of Div/0 error.

You can use the formula mentioned below
suppose A1 has numerator values and B1 has denominator value which does not
exist or is zero. So you have Div/0 error in C1 which has formula A1/B1

...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927387/4946246/65

-----------------------------------------------------------------------
UPDATED ANSWER on:
Cell color coding

ANSWER from Findsarfaraz:
Sounds like they did conditional formatting on it. Did you try to copy the
formatting by using the format painter?

yes, the formula is placed under condition formatting. You can find that under
Format Menu-> click on conditional formatting.

[A href="http://findsarfaraz.blogspot.com"]MS Exc...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927388/4946246/66

-----------------------------------------------------------------------
UPDATED ANSWER on:
Active Dir. Web Based Password Reset Tool?

ANSWER from Sharepointfan:
Take a look at [A
href="http://www.sharepointboost.com/passwordchange.html"]Sharepoint Password
change[/A]. this may help you.
You should know if you are using Sharepoint there is no such feature to let
them change passwords.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927357/4946246/67

-----------------------------------------------------------------------
NEW ANSWER on:
SharePoint List View unique permissions

ANSWER from Sharepointfan:
I do not think there are much option in Sharepoint OTB functionality.
Couple of things I can think of:
No. use filter, specifically change the value of filter into (me) . then you an
set some of it. However I have not got what I wanted through this solution.
Hope you can harness it.
Other thin...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927368/4946246/68

-----------------------------------------------------------------------
NEW ANSWER on:
Tracking Laptop Users

ANSWER from Mrdenny:
The software that the company I work for does this nicely. The software is
called [A href="http://www.interguardsoftware.com/"]Interguard[/A].

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927389/4946246/69

-----------------------------------------------------------------------
NEW ANSWER on:
Windows xp control panel wrong icons

ANSWER from Nicknailers:
First, hi, I found your problem interesting and did search a bit about it. I am
sure you did too but I found a solution that makes sense to me so It could be
worth a try here it is :

Click Start, Run and enter REGEDIT

Go to: HKEY_CURRENT_USERControl Paneldon't load

Look in the right pane...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927390/4946246/70

-----------------------------------------------------------------------
NEW DISCUSSION on:
Loading Windows Server 2003 - Raid 5 (3 X 500Gb Drives)

DISCUSSION from HoosierCAB:
Go to http://support.dell.com/, click on Drivers and Downloads. Enter the
service tag of the server. Assuming the server has a DVD drive, download the 4
parts of "Dell DVD ISO - Dell Systems Management Tools and Documentation".

Once you have that burned to DVD, you should be able to boot the se...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927391/4946246/71

-----------------------------------------------------------------------
NEW QUESTION on:
Resizing Microsoft Access properties form

QUESTION from JNewmarch:
I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3.
I find that I cannot resize the properties window when doing form design. The
problem also applies to popup forms that I create. If I take the .mdb file to
another machine, it works just fien. I have tried uninstallin...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927392/4946246/72

-----------------------------------------------------------------------
NEW QUESTION on:
Reverse Proxy Suggestions

QUESTION from Mshen:
I'm look for a Reverse Proxy software vendor which will work on a Windows IIS
server. Does anybody have an suggestions?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927393/4946246/73

-----------------------------------------------------------------------
UPDATED ANSWER on:
How do I get started in the IT Job market

ANSWER from Mshen:
If you went to college or a trade school check and see if they have job
placement services. You could also try looking for a job with the [A
href="http://www.geeksquad.com/"]Geek Squad[/A] they are in many areas around
the country and while the pay might be a bit low, you can really rack up some
ex...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927361/4946246/74

-----------------------------------------------------------------------
UPDATED ANSWER on:
Memory Stick Virus

ANSWER from Mshen:
Did he run a virus scan? You did not mention whether he did or not. If so, did
SAV detect a virus? There should be info on Symantec's web site about it with
instructions for removal.

=======================

Files 2 and 3 look like viruses. Make sure the antivirus is updated and run a
scan in ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927394/4946246/75

-----------------------------------------------------------------------
NEW ANSWER on:
Using an on screen keyboard for login

ANSWER from Mshen:
In Regedit, go to HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsNTCu
rrentVersionWinlogon

Change the SYSTEM value to osk.exe


VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927395/4946246/76

-----------------------------------------------------------------------
NEW DISCUSSION on:
Need guidance in starting my career in SAP

DISCUSSION from FredMackie:
Even while you are looking, keep busy with online resource such as [A
href="http://www.microsoft.com/events/series/mbserp.aspx"]Enterprise Resource
Planning[/A] to keep you up to date.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927396/4946246/77

-----------------------------------------------------------------------
NEW DISCUSSION on:
Conditional Formatting Excel 2003

DISCUSSION from SbElectric:
Good Job, Sarfaraz!
Yes, to consider 1 month or 3 moths away one should use your formula.

I just browsed thru your web-site. Nice site for someone who is interesting in
broadening Excel knowledge. I recommend to others.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927397/4946246/78

-----------------------------------------------------------------------
NEW DISCUSSION on:
FTP over SSH on Windows

DISCUSSION from Petkoa:
Hi,

it's quite tricky to set ssl/tls ftp - for the same reasons ftp is tricky for
natting and firewalling: control channel, data channels on various ports,
encryption of just control channel, but not data channels etc., etc... - but I
believe you are aware of this. I'd agree with Edhacker, that...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927381/4946246/79

-----------------------------------------------------------------------
NEW ANSWER on:
When I boot my laptop I have a Black Screen Password to be entered?

ANSWER from AndOrTech:
You will need to pull the cmos battery. and then press and hold the power
button with all batterys and power removed. That should clear the CMOS and the
passwords. The battery is generally accessable in two locations. I usually
find it under the keyboard or via the memory cover on the back.

On...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927398/4946246/80

-----------------------------------------------------------------------
NEW QUESTION on:
Desktop shut down policy

QUESTION from Looknc:
Does anyone have an actual policy (company or County) which addresses desktop
shutdowns? Any type of policy scenario would be greatly appreciated.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927399/4946246/81

-----------------------------------------------------------------------
NEW ANSWER on:
Copy Propietary CNC controller to Virtual machine

ANSWER from Esiebert7625:
Not sure which virtualization product you plan on using but if you use VMware
Workstation or Server you could probably import the old server by creating an
image of it using one of the import formats that they support. Workstation has
built-in Import capabilities and you can also use the free Conver...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927400/4946246/82

-----------------------------------------------------------------------
UPDATED ANSWER on:
Ghost

ANSWER from Flame:
If you have a copy of Norton Ghost, you need to boot the PC with the Windows XP
installation you want to image from a boot CD. Most CD burning software
contains an option to create a bootable CD.
This CD should either contain a copy of the Ghost software, or boots so that it
connects to a network ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927401/4946246/83

-----------------------------------------------------------------------
NEW QUESTION on:
Installing IIS on Windows Server 2008 with PowerShell script

QUESTION from ITKE:
I want to install IIS in Windows Server 2008. Does anyone have the script in
Powershell

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927402/4946246/84

-----------------------------------------------------------------------
UPDATED ANSWER on:
What is used to control the Windows and third-party services in Windows
2000/XP/2003 system

ANSWER from Koohiisan:
To configure, start and stop windows services, the default tool is the Services
console, which is usually under "Administrative Tools" -> Services.

------------------------------

Or...
Start | Run | services.msc

Or...
from command line: net [start | stop] [service name]
As in:

net...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927403/4946246/85

-----------------------------------------------------------------------
UPDATED ANSWER on:
Wireless access gone after hard drive replacement

ANSWER from Technochic:
You will need a WPA or WEP key to connect unless the access point has open
security. The key is a several character long string that is entered on the
client to connect to the access point. If you don't have the original key and
there are no other devices, then create a new key and reset the router ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927404/4946246/86

-----------------------------------------------------------------------
NEW DISCUSSION on:
DistributionList Send As Event ID

DISCUSSION from Technochic:
Exchange 2000/2007 administration are both quite different. Ex2000 allowed you
to do administrative tasks through Active Directory because the tasks were
integrated with AD. Exchange 2007 changed that back to the Exchange Management
Console instead of AD and many tasks are no longer available throug...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927375/4946246/87

-----------------------------------------------------------------------
NEW DISCUSSION on:
Remote RSOP gives RPC server unavailable

DISCUSSION from NetSupport:
Yes, Yes, and Yes

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927376/4946246/88

-----------------------------------------------------------------------
NEW DISCUSSION on:
Backup Exec 11d with Exchange 2007

DISCUSSION from Technochic:
Well that just stinks. I wish I had experience with BE, we use NetBackup, so I
can't be of any assistance with this one unfortunately. We do have a support
agreement with the product though so we do not pay for each support call.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927377/4946246/89

-----------------------------------------------------------------------
NEW DISCUSSION on:
Macros in a drop down list

DISCUSSION from Excerlnovice:
Thank you for sharing the information and proposed solution. What I am trying
to do is use a drop down list to select macros to run from. For example, I have
12 macros, 1 for each month, and instead of creating buttons and assigning a
macro to each individual button I want to have a drop down list i...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927405/4946246/90

-----------------------------------------------------------------------
NEW DISCUSSION on:
IT career requirements for Java?

DISCUSSION from Carlosdl:
I agree with Mshen; there are fields in which you will probably not need it,
but based in my experience, it is always good to have some programming skills,
and I think Java is a good option, since it can be used in a variety of
environments.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927364/4946246/91

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to create DHCP relay agent in Windows Server 2003

ANSWER from Carlosdl:
The DHCP relay agent typically resides in a switch or router configuration. The
DHCP server should have the appropriate scopes to serve the remote subnets. If
the DHCP server is connected to both subnets, then DHCP relay should not be
needed.

----------------------

If you still need to create ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927406/4946246/92

-----------------------------------------------------------------------
NEW DISCUSSION on:
Server 2003 memory performance configuration

DISCUSSION from Labnuke99:
Will adding memory above 4GB to a 32-bit machine really help? We were not
planning on moving the servers to 64-bit architecture.

Since it is an n-tier architecture, I am thinking that there could be problems
at several points along the path creating the slow performance being reported
by users. I...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927355/4946246/93

-----------------------------------------------------------------------
NEW DISCUSSION on:
Sending more then 1 Access Report to Outlook

DISCUSSION from JulieSandra:
Thanks for replying. I am exporting the Reports as .pdf files in two emails.
I just thought it would be better to have one email with 2 attachments. It
dosnt look like I am going to be able to do this without some major coding.

Thanks again

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927378/4946246/94

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to create a desktop shortcut to a 2nd email account on Windows Mail

DISCUSSION from Vonga:
My initial question was: I had opened a google mail account for my husband and
wanted to set him up on Windows Mail with his own separate mail box that could
be accessed by his own shortcut on the desktop. I was trying to do this from
my own Windows Mail account, but I've since found out that I n...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927407/4946246/95

-----------------------------------------------------------------------
MOBILE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Mobile related Questions and Answers
http://go.techtarget.com/r/5927447/4946246/96
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
Dual B servers?

ANSWER from Mrdenny:
I don't think that the blackberry supports dual BES servers. I'm pretty sure
its going to be one or the other.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927449/4946246/97

-----------------------------------------------------------------------
NEW ANSWER on:
How to get internet service on 2 desktop pc's without running cables

ANSWER from Mshen:
You are on the right track. You should go with 802.11n draft wireless cards
and a matching router if you have the money for it. Otherwise 802.11g will
work; the difference is how fast the wireless connections can go. 802.11n can
go up to 270Mbps and 802.11g can go up to 54Mbps which is a huge dif...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927451/4946246/98

-----------------------------------------------------------------------
NEW DISCUSSION on:
iNotes

DISCUSSION from Asudoh:
Correction to myself - Firefox on Mac browser support began with 7.0.2
release.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927363/4946246/99

-----------------------------------------------------------------------
NEW ANSWER on:
When I boot my laptop I have a Black Screen Password to be entered?

ANSWER from AndOrTech:
You will need to pull the cmos battery. and then press and hold the power
button with all batterys and power removed. That should clear the CMOS and the
passwords. The battery is generally accessable in two locations. I usually
find it under the keyboard or via the memory cover on the back.

On...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927398/4946246/100

-----------------------------------------------------------------------
UPDATED ANSWER on:
Wireless access gone after hard drive replacement

ANSWER from Technochic:
You will need a WPA or WEP key to connect unless the access point has open
security. The key is a several character long string that is entered on the
client to connect to the access point. If you don't have the original key and
there are no other devices, then create a new key and reset the router ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927404/4946246/101

-----------------------------------------------------------------------
NETWORKING UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5927326/4946246/102

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5927326/4946246/103

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5927326/4946246/104

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5927326/4946246/105

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5927326/4946246/106
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
ftp a zipped file to a client in a batch job.

ANSWER from Gilly400:

Hi,

To be able to FTP from the QDLS you need to use the HFS (Hierarchical File
System) naming format. In your FTP session you need to use the following
command to switch to HFS naming :-

NAMEFMT 1

Then you can put from the QDLS :-

put /QDLS/EMAIL/EMAIL.ZIP d:ftpfolder/email.zip

...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927328/4946246/107

-----------------------------------------------------------------------
UPDATED ANSWER on:
Active Dir. Web Based Password Reset Tool?

ANSWER from Sharepointfan:
Take a look at [A
href="http://www.sharepointboost.com/passwordchange.html"]Sharepoint Password
change[/A]. this may help you.
You should know if you are using Sharepoint there is no such feature to let
them change passwords.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927357/4946246/108

-----------------------------------------------------------------------
NEW DISCUSSION on:
What questions should I expect for a Network Engineer interview?

DISCUSSION from Flow:
Thanks for all your input i would appreciate if you can give me answer to the
qyestions you posted pls

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927360/4946246/109

-----------------------------------------------------------------------
UPDATED ANSWER on:
How do I get started in the IT Job market

ANSWER from Mshen:
If you went to college or a trade school check and see if they have job
placement services. You could also try looking for a job with the [A
href="http://www.geeksquad.com/"]Geek Squad[/A] they are in many areas around
the country and while the pay might be a bit low, you can really rack up some
ex...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927361/4946246/110

-----------------------------------------------------------------------
UPDATED ANSWER on:
Convert RJ45 connection to wireless.

ANSWER from Mshen:
Dlink makes a device, DWL-G730AP. This is a multifunction device that can be
configured as a router, access point, or wireless adapter. When I travel, I
take one of these with me and configure it as necessary. Check [A
href="http://www.dlink.com/products/?sec=1&pid=346"]here[/A]

================...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927408/4946246/111

-----------------------------------------------------------------------
NEW DISCUSSION on:
Designing a network

DISCUSSION from Labnuke99:
I have sites with a T1 servicing >200 users for site to site communications.
They have a separate DSL link just for internet traffic.

It all depends on what is running across the link and expected performance for
the users.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927374/4946246/112

-----------------------------------------------------------------------
NEW DISCUSSION on:
FTP over SSH on Windows

DISCUSSION from Petkoa:
Hi,

it's quite tricky to set ssl/tls ftp - for the same reasons ftp is tricky for
natting and firewalling: control channel, data channels on various ports,
encryption of just control channel, but not data channels etc., etc... - but I
believe you are aware of this. I'd agree with Edhacker, that...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927381/4946246/113

-----------------------------------------------------------------------
UPDATED ANSWER on:
Wireless access gone after hard drive replacement

ANSWER from Technochic:
You will need a WPA or WEP key to connect unless the access point has open
security. The key is a several character long string that is entered on the
client to connect to the access point. If you don't have the original key and
there are no other devices, then create a new key and reset the router ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927404/4946246/114

-----------------------------------------------------------------------
NEW DISCUSSION on:
IT career requirements for Java?

DISCUSSION from Carlosdl:
I agree with Mshen; there are fields in which you will probably not need it,
but based in my experience, it is always good to have some programming skills,
and I think Java is a good option, since it can be used in a variety of
environments.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927364/4946246/115

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to create DHCP relay agent in Windows Server 2003

ANSWER from Carlosdl:
The DHCP relay agent typically resides in a switch or router configuration. The
DHCP server should have the appropriate scopes to serve the remote subnets. If
the DHCP server is connected to both subnets, then DHCP relay should not be
needed.

----------------------

If you still need to create ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927406/4946246/116

-----------------------------------------------------------------------
ORACLE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Networking related Questions and Answers
http://go.techtarget.com/r/5927346/4946246/117
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Formatting PL/SQL code in SQL DEVELOPER

DISCUSSION from Inprise:
thanks yes even i am using 1.5.3,anyhow will check my formatting preference to
have good formatting of my code

thanks once again.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927347/4946246/118

-----------------------------------------------------------------------
NEW QUESTION on:
SQL query and design -help needed

QUESTION from Rohit3312:


Need help in designing the SCHEMA below and then the questions below

There is a COMPANY(STAR INTERNATIONAL*) WHICH has many divisions/departments in
it.
These divisions has employees.

(1)one employee can be in many departments(1 TO MANY) and and each department
has one manager.(1 to 1)
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927348/4946246/119

-----------------------------------------------------------------------
NEW QUESTION on:
SQL query and Databse design -help needed

QUESTION from Rohit3312:
Sorry for all the confusion with the questions.So let me clear myself,i am
doing this not as assignment or homework,but something
which interests me and trying to leran.Earlier as I stated that its a part of
my school(** well frnakly speaking, it was my plan if i could
put this as an item of the s...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927349/4946246/120

-----------------------------------------------------------------------
NEW QUESTION on:
java.lang.NoClassDefFoundError

QUESTION from Scottlinn:
Hi,
I need some serious help here..I use OAS 10.1.2.0.2.. I deployed my ear file to
the OC4J container. And everytime I access the webpage
I get this error.

500 Internal Server Error
java.lang.ExceptionInInitializerError at
com.experio.common.util.AppUtil.getInitialContext(AppUtil.java:71) at ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927350/4946246/121

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to run Oracle 10g forms on browser

DISCUSSION from Missmye:
Have you download java applet to your browser or already have java applet in
your browser? If not yet, you can't run your form on browser...To download java
applet to your browser,,you must install Oracle JInitiator.. Its version
depends on your windows. If you are using Windows XP,,you must instal...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927351/4946246/122

-----------------------------------------------------------------------
NEW ANSWER on:
ProC under Oracle 10g

ANSWER from Kccrosser:
It would help if you would post your code. Knowing which tables are being
accessed, and the syntax of the query could help diagnose the problem.

I assume you copied and ran the query and it works outside the Pro-C routine.

Things that usually cause behavior problems between versions (with "no...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927352/4946246/123

-----------------------------------------------------------------------
SAP UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5927326/4946246/124

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5927326/4946246/125

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5927326/4946246/126

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5927326/4946246/127

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5927326/4946246/128
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Need guidance in starting my career in SAP

DISCUSSION from FredMackie:
Even while you are looking, keep busy with online resource such as [A
href="http://www.microsoft.com/events/series/mbserp.aspx"]Enterprise Resource
Planning[/A] to keep you up to date.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927396/4946246/129

-----------------------------------------------------------------------
NEW DISCUSSION on:
Starting with ERP training based on product development experience

DISCUSSION from FredMackie:
If you are self-disciplined, you can continue your education with free online
resources such as the webcasts on [A
href="http://www.microsoft.com/events/series/mbserp.aspx"]Enterprise Resource
Planning[/A].

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927462/4946246/130

-----------------------------------------------------------------------
NEW QUESTION on:
SAP R3 PO release strategy

QUESTION from Caveytaz22:
What is the maximum amount of PO release levels that can be created in R3?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927473/4946246/131

-----------------------------------------------------------------------
NEW ANSWER on:
SAP-MM How to book Discount in MIRO

ANSWER from DJW101:
[B] One can via MIRO book the discount although the PO does not have it.
On the MIRO screen enter the amount (minus the Discount + tax if applicable) in
the Amount field
Enter the applicable PO number for the [I]Goods/service items [/I] and select
the particular PO item(s)
In addition you select ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927474/4946246/132

-----------------------------------------------------------------------
SECURITY UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5927326/4946246/133

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5927326/4946246/134

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5927326/4946246/135

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5927326/4946246/136

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5927326/4946246/137
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
ISERIES SFTP

ANSWER from Gilly400:
Hi,

Here's a great article by Scott Klement that should get you up and running :-

[A href="http://systeminetwork.com/article/ssh-scp-and-sftp-tools-openssh"]The
SSH, SCP, and SFTP Tools from OpenSSH[/A]

Note: for automating with scripts :-

[B]SFTP does not use OVRDBF for scripting. Inste...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927409/4946246/138

-----------------------------------------------------------------------
UPDATED ANSWER on:
Active Dir. Web Based Password Reset Tool?

ANSWER from Sharepointfan:
Take a look at [A
href="http://www.sharepointboost.com/passwordchange.html"]Sharepoint Password
change[/A]. this may help you.
You should know if you are using Sharepoint there is no such feature to let
them change passwords.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927357/4946246/139

-----------------------------------------------------------------------
NEW ANSWER on:
Outside vendor located on premises

ANSWER from Rklanke:

Shared premises is not a relevant factor for PCI compliance. You don't face
fines for customer information you don't handle.

PCI compliance should be a minimal standard. Does your shared customer
recognize your organizations as distinct, or do you act as one support
organization? Act to meet yo...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927410/4946246/140

-----------------------------------------------------------------------
UPDATED ANSWER on:
Memory Stick Virus

ANSWER from Mshen:
Did he run a virus scan? You did not mention whether he did or not. If so, did
SAV detect a virus? There should be info on Symantec's web site about it with
instructions for removal.

=======================

Files 2 and 3 look like viruses. Make sure the antivirus is updated and run a
scan in ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927394/4946246/141

-----------------------------------------------------------------------
NEW DISCUSSION on:
Designing a network

DISCUSSION from Labnuke99:
I have sites with a T1 servicing >200 users for site to site communications.
They have a separate DSL link just for internet traffic.

It all depends on what is running across the link and expected performance for
the users.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927374/4946246/142

-----------------------------------------------------------------------
NEW ANSWER on:
When I boot my laptop I have a Black Screen Password to be entered?

ANSWER from AndOrTech:
You will need to pull the cmos battery. and then press and hold the power
button with all batterys and power removed. That should clear the CMOS and the
passwords. The battery is generally accessable in two locations. I usually
find it under the keyboard or via the memory cover on the back.

On...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927398/4946246/143

-----------------------------------------------------------------------
SQL SERVER UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5927326/4946246/144

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5927326/4946246/145

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5927326/4946246/146

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5927326/4946246/147

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5927326/4946246/148
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
SSIS and Excel

QUESTION from Cathryn:
I have a road block that I need to find a work around for. I work on a system
where the Databases reside on a soley database server (SQL 2005).

I need to run a stored procedure on a nightly basis and export the results into
a template excel file and put out on shares. Sounds simple right? Here's...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927353/4946246/149

-----------------------------------------------------------------------
NEW ANSWER on:
Website and database connection

ANSWER from Mrdenny:
You'll need to use the information you have to create the connection string.
[A href="http://www.connectionstring.com/"]Connectionstrings.com[/A] has all
sorts of good info on getting up the connection string.

You'll then need to open the [A
href="http://www.devhardware.com/forums/programming-8...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927354/4946246/150

-----------------------------------------------------------------------
NEW ANSWER on:
Explain Stored Procedures in AS/400

ANSWER from Philpl1jb:
Stored procedure is:

1. Called by SQL
2. Is either a program written in PL-SQL
or
3. Identifies a program (in languages like RPG/Cobol/CL etc) on the AS/400 to
run
4. Can receive a set of IN parameters
5. Can return a set of OUT parameters
6. Can receive and return a set o...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927342/4946246/151

-----------------------------------------------------------------------
NEW DISCUSSION on:
Server 2003 memory performance configuration

DISCUSSION from Labnuke99:
Will adding memory above 4GB to a 32-bit machine really help? We were not
planning on moving the servers to 64-bit architecture.

Since it is an n-tier architecture, I am thinking that there could be problems
at several points along the path creating the slow performance being reported
by users. I...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927355/4946246/152

-----------------------------------------------------------------------
STORAGE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5927326/4946246/153

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5927326/4946246/154

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5927326/4946246/155

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5927326/4946246/156

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5927326/4946246/157
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Active Dir. Web Based Password Reset Tool?

ANSWER from Sharepointfan:
Take a look at [A
href="http://www.sharepointboost.com/passwordchange.html"]Sharepoint Password
change[/A]. this may help you.
You should know if you are using Sharepoint there is no such feature to let
them change passwords.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927357/4946246/158

-----------------------------------------------------------------------
NEW DISCUSSION on:
Bandwidth size

DISCUSSION from Mrdenny:
What's the peak data change rate for 30 minutes?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927411/4946246/159

-----------------------------------------------------------------------
NEW DISCUSSION on:
Loading Windows Server 2003 - Raid 5 (3 X 500Gb Drives)

DISCUSSION from HoosierCAB:
Go to http://support.dell.com/, click on Drivers and Downloads. Enter the
service tag of the server. Assuming the server has a DVD drive, download the 4
parts of "Dell DVD ISO - Dell Systems Management Tools and Documentation".

Once you have that burned to DVD, you should be able to boot the se...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927391/4946246/160

-----------------------------------------------------------------------
NEW ANSWER on:
Need SAN upgrade suggestions

ANSWER from Mshen:
EMC's Clariion series has a good range of Fiber SANs to look into. The
Navisphere interface makes for easy management. I've also heard that
Compellent is an easy to use SAN which is also easy to upgrade because it is
module based.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927412/4946246/161

-----------------------------------------------------------------------
NEW QUESTION on:
LTO Ultrium Tape Labels

QUESTION from Flame:
We use Ultruim 2 Tape cartridges in our ExaByte Magnum 1X7 LTO tape drive. Is
there a source for the proper sized labels and a program that will create the
bar code labels for these tapes? Currently we create these labels in MS-Word,
and then cut down standard sized Avery labels but it is a clunky...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927413/4946246/162

-----------------------------------------------------------------------
NEW DISCUSSION on:
Backup Exec 11d with Exchange 2007

DISCUSSION from Technochic:
Well that just stinks. I wish I had experience with BE, we use NetBackup, so I
can't be of any assistance with this one unfortunately. We do have a support
agreement with the product though so we do not pay for each support call.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5927377/4946246/163

-----------------------------------------------------------------------
VIRTUALIZATION UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Virtualization related Questions and Answers
http://go.techtarget.com/r/5927414/4946246/164
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Citrix XEN-Server software

QUESTION from Fouad:
What are the advantages and disadvantages of using Citrix XEN-Server Software?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927415/4946246/165

-----------------------------------------------------------------------
NEW ANSWER on:
Need SAN upgrade suggestions

ANSWER from Mshen:
EMC's Clariion series has a good range of Fiber SANs to look into. The
Navisphere interface makes for easy management. I've also heard that
Compellent is an easy to use SAN which is also easy to upgrade because it is
module based.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927412/4946246/166

-----------------------------------------------------------------------
NEW ANSWER on:
Copy Propietary CNC controller to Virtual machine

ANSWER from Esiebert7625:
Not sure which virtualization product you plan on using but if you use VMware
Workstation or Server you could probably import the old server by creating an
image of it using one of the import formats that they support. Workstation has
built-in Import capabilities and you can also use the free Conver...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5927400/4946246/167

-----------------------------------------------------------------------
VOIP UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all VoIP related Questions and Answers
http://go.techtarget.com/r/5927416/4946246/168
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
txt messaging

QUESTION from Rachbob:
can i set a different song for each person when they txt me on my blackberry
curve?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5927417/4946246/169

-----------------------------------------------------------------------
-----------------------------------------------------------------------

UNSUBSCRIBE
You are receiving this e-mail because you subscribed to tag e-mail alerts
on ITKnowledgeExchange.com.

To unsubscribe from tag e-mail alerts click the link below to
"Edit My Account". Go to the Newsletter Preferences section and un-check
tags you no longer wish to receive e-mail alerts on and click "Save".
http://ITKnowledgeExchange.techtarget.com/settings/account/

To unsubscribe from all tag e-mail alerts, click the link below:
http://ITKnowledgeExchange.techtarget.com/unsubscribe?email=sekhargreen@gmail.com&key=41289&tag=1

Contact us:
TechTarget
Member Services
117 Kendrick Street, Suite 800
Needham, MA 02494

-----------------------------------------------------------------------

ABOUT THIS E-NEWSLETTER
This e-newsletter is published by ITKnowledgeExchange.com, a
targeted Web site from TechTarget, The IT Media ROI Experts and
events company.

Copyright 2009 TechTarget. All rights reserved.

Hot in Week

Popular

Archive

item