Daily Question and Answer Update for Mar 5, 2009

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
Continue the conversation. Answer or discuss a question and earn Knowledge
Points.

-----------------------------------------------------------------------
CRM 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/6033410/4946246/1

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

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

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

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

NEW DISCUSSION on:
CRM department?

DISCUSSION from JohnKR:
The biggest CRM challenge I've seen in the auto industry is political
infighting about who owns the customer data. The local dealerships, or
corporate? If dealers are used to owning the customer data and have their own
processes for outreach, mailers, upsell, satisfaction surveys, etc., they
will...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033445/4946246/6

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

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

View all Database related Questions and Answers
http://go.techtarget.com/r/6033499/4946246/7
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Access 2003 using IIf statement on a form

ANSWER from BobBeechey:
Once you introduced the a,b,c, the grade is now alpha numeric. So C comes
after B. You may need to split the letters from the numbers. So one field has
3,4,5,.. and the other has the c, b, a. Then you can sort by field1 ascending
and field2 descending.

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

One way to make it...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033500/4946246/8

-----------------------------------------------------------------------
UPDATED ANSWER on:
New Access user!

ANSWER from SbElectric:
Check if the file is read only, if it was remove it

/////////////////////////////////////
This generally happens when someone opens Access to create a new database but
doesn't name it.
So the system is forced to name it different from any existing database file.

Phil

_________________...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033501/4946246/9

-----------------------------------------------------------------------
NEW QUESTION on:
Combining fields to create a unique ID in Microsoft Access

QUESTION from FSUResA:
I have been working on a database for my research job.For our research purposes
we are trying to create a unique identifier that tells us 4 things:

1) what study they are a part of, [this will be ?QQQ? for EVERYONE]

2) what group they are in, [this will be a four digit number, such a...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033477/4946246/10

-----------------------------------------------------------------------
UPDATED ANSWER on:
MS Access Tools References...

ANSWER from ItCareerCoach:
Hi Bob,

Here is a link to some code that you can start out with:

[A
href="http://www.eggheadcafe.com/software/aspnet/32916624/send-email-using-vba-c
ode.aspx"]http://www.eggheadcafe.com/software/aspnet/32916624/send-email-using-v
ba-code.aspx[/A]

Hope that works,

Kingsley
[A href="http://...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Formatting a subform for printing in access 2000

ANSWER from Randym:
Printing forms doesn't work very well. You don't have much control on what
prints. Why not make a report that displays the same information as the
form/subform?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033504/4946246/12

-----------------------------------------------------------------------
NEW QUESTION on:
How do I display a clickable link from database in table using PHP?

QUESTION from BigAL09:
I have a table and when I pull a clients info up I would like the web address
to be able to be clicked to view web site. How would I code this in? Here is
some of my code.

$num_rows = mysql_num_rows($query);
print "<b>Here is my Information on you. <br><br>E-Mail me with any
changes.</b><P>";
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033430/4946246/13

-----------------------------------------------------------------------
NEW ANSWER on:
Correct database format for Rich Text/HTML?

ANSWER from Mrdenny:
If you need to store HTML then you can use the NVARCHAR(MAX) datatype (TEXT if
you are using SQL 2000 or order). If you want to store Rich Text then this is
Binary data which would need to be stored in the VARBINARY(MAX) data type
(IMAGE if you are using SQL 2000 or order).

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033480/4946246/14

-----------------------------------------------------------------------
NEW QUESTION on:
How to implement One-to-One and One-to-Many class associations using VB.NET
2005?

QUESTION from Carlosdl:
You might want to show us what you have done so far (class definitions,
etc...), and provide more detail about the relations you want to implement, so
we can provide more specific help.

Are you going to use databases ? how and where are you going to save system
data ? are you talking about clas...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033505/4946246/15

-----------------------------------------------------------------------
NEW ANSWER on:
Database connectivity between Microsoft Access and C++

ANSWER from Carlosdl:
Here is an example, using ODBC, and functions from sql.h

[CODE] SQLHENV henv;
SQLHDBC hdbc;
SQLRETURN rc;
SQLCHAR server[12];
SQLCHAR uid[12];
SQLCHAR pwd[12];
.
.
.
strcpy((char*)server, "test_db");
strcpy((char*)uid, "Admin");
strcpy((char*)pwd, "");
SDWORD cbName...

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

-----------------------------------------------------------------------
NEW QUESTION on:
How to install the MySQL JDBC connector?

QUESTION from Carlosdl:
Have a look at the following pages. Hopefully you will find the solution to
your problem there.

[A
href="http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-j2ee.html#co
nnector-j-usagenotes-tomcat
"]Using Connector/J with Tomcat[/A]
[A href="http://dev.mysql.com/doc/refman/5.0/en/conne...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033510/4946246/17

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

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

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

NEW DISCUSSION on:
iSeries Access printing with Lexmark 2381 printer

DISCUSSION from LBurkett99:
Make sure you have set the Top of Form correctly. If you do not have a user
guide or Quick Reference, try this:
http://www.lexmark.com/publications/pdfs/2007/2400dm/en.html. It is for the
2400 series but I think it is the same as the 2381.

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

-----------------------------------------------------------------------
NEW QUESTION on:
XML parsing in COBOL on iseries

QUESTION from Sivan:
Can I get an example of how to parse XML document in ILE COBOL? I need both SAX
and DOM parser examples.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033450/4946246/20

-----------------------------------------------------------------------
NEW QUESTION on:
Solaris virtualization techniques

QUESTION from JennyMack:
[I]The following question was recently submitted via e-mail by a user:[/I]

Solaris users -- is there any preferred method of virtualization for Solaris
(zones, etc.)?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033452/4946246/21

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

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

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

NEW QUESTION on:
Integration of Jasper with Documentum Content Server

QUESTION from Shailesh14:
Hi,

We are looking to integrate Jasper reporting tool with EMC Documentum. I had
searched for the information on integration but didn't found any. Could anyone
help me on this. (Any PDF/document/URL link)

Thanks

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033518/4946246/23

-----------------------------------------------------------------------
NEW QUESTION on:
How to implement One-to-One and One-to-Many class associations using VB.NET
2005?

QUESTION from Carlosdl:
You might want to show us what you have done so far (class definitions,
etc...), and provide more detail about the relations you want to implement, so
we can provide more specific help.

Are you going to use databases ? how and where are you going to save system
data ? are you talking about clas...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033505/4946246/24

-----------------------------------------------------------------------
NEW ANSWER on:
Oracle database and Crystal

ANSWER from Sous:
in Crystal XI after opening a new blank report to create a connection to Oracle
Database,
- right click on Databse Fileds --&gt; Database Expert (or menu Database --&gt;
Database Expert)
- click on create new connection
- one of the option is Oracle where you can defne the server from which you
...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033437/4946246/25

-----------------------------------------------------------------------
NEW ANSWER on:
Database Connection Error

ANSWER from Carlosdl:
You are probably calling a stored procedure (PRC_RI_REPORT) that does not exist
in the package xxx in the Oracle database.

If you are sure that both the package and the procedure exist, you may need to
grant execute privileges to the package, and call the procedure this way if the
connected user ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033519/4946246/26

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

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

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

UPDATED ANSWER on:
Access 2003 using IIf statement on a form

ANSWER from BobBeechey:
Once you introduced the a,b,c, the grade is now alpha numeric. So C comes
after B. You may need to split the letters from the numbers. So one field has
3,4,5,.. and the other has the c, b, a. Then you can sort by field1 ascending
and field2 descending.

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

One way to make it...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033500/4946246/28

-----------------------------------------------------------------------
NEW QUESTION on:
Disable Form Controls in VB 2008 until...

QUESTION from Jacobass:
Beginning prog. student here...

I have a form with multiple controls, and i want everything to be disabled
except the datetimepicker. Once a date is selected, it should make the whole
form usable. I've searched the web, and can't find the right solutin. I found
this sight, and hoping someone can ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033521/4946246/29

-----------------------------------------------------------------------
NEW QUESTION on:
New Web Service Project

QUESTION from AL0428:
Hi,

Currently an iSeries job runs every 10 minutes where, at the back end, a file
is read (more than 400 fields), a pipe delimited file is created and FTP'd to
an outside location. Volume would normally be low but intermittently there
could be a spike.

I need to replace the FTP process with a ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033421/4946246/30

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to convert VBA decimal DataTypes

DISCUSSION from SbElectric:
I firmly believe in KISS principle ? so I will stick with your Excel cell
formatting options. Only potential problem may be if any data is negative
(denoted either by color or by negative sign in front or at end of data) or if
the data has 3 or more decimal places.
SbElectric

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

-----------------------------------------------------------------------
NEW QUESTION on:
OracleClient

QUESTION from Dax:
I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I
enter
Imports System.Data.OracleClient
The system did not support. Why??

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033436/4946246/32

-----------------------------------------------------------------------
NEW QUESTION on:
Excel 2002 Copy GetPivotDATA function

QUESTION from Steve7474:
I have a number of different items that I need to extract from a pivot table.
Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the
value from the first cell

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033476/4946246/33

-----------------------------------------------------------------------
NEW ANSWER on:
Setting up an Exchange mail server

ANSWER from Technochic:
[A href="http://support.microsoft.com/kb/266418"]Microsoft does not support
installing exchange server components and outlook on the same computer.[/A]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033464/4946246/34

-----------------------------------------------------------------------
NEW DISCUSSION on:
What language "Next" from RPG(LE)

DISCUSSION from WoodEngineer:
I'd recommend adding HTML and PHP to your skill set.
With Zend now available on the AS/400, these skills open up some nice options
for you and your users.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033428/4946246/35

-----------------------------------------------------------------------
UPDATED ANSWER on:
MS Access Tools References...

ANSWER from ItCareerCoach:
Hi Bob,

Here is a link to some code that you can start out with:

[A
href="http://www.eggheadcafe.com/software/aspnet/32916624/send-email-using-vba-c
ode.aspx"]http://www.eggheadcafe.com/software/aspnet/32916624/send-email-using-v
ba-code.aspx[/A]

Hope that works,

Kingsley
[A href="http://...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033478/4946246/36

-----------------------------------------------------------------------
NEW QUESTION on:
XML parsing in COBOL on iseries

QUESTION from Sivan:
Can I get an example of how to parse XML document in ILE COBOL? I need both SAX
and DOM parser examples.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033450/4946246/37

-----------------------------------------------------------------------
NEW ANSWER on:
Formatting a subform for printing in access 2000

ANSWER from Randym:
Printing forms doesn't work very well. You don't have much control on what
prints. Why not make a report that displays the same information as the
form/subform?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033504/4946246/38

-----------------------------------------------------------------------
NEW QUESTION on:
How do I display a clickable link from database in table using PHP?

QUESTION from BigAL09:
I have a table and when I pull a clients info up I would like the web address
to be able to be clicked to view web site. How would I code this in? Here is
some of my code.

$num_rows = mysql_num_rows($query);
print "<b>Here is my Information on you. <br><br>E-Mail me with any
changes.</b><P>";
...

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

-----------------------------------------------------------------------
NEW QUESTION on:
How to implement One-to-One and One-to-Many class associations using VB.NET
2005?

QUESTION from Carlosdl:
You might want to show us what you have done so far (class definitions,
etc...), and provide more detail about the relations you want to implement, so
we can provide more specific help.

Are you going to use databases ? how and where are you going to save system
data ? are you talking about clas...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Database connectivity between Microsoft Access and C++

ANSWER from Carlosdl:
Here is an example, using ODBC, and functions from sql.h

[CODE] SQLHENV henv;
SQLHDBC hdbc;
SQLRETURN rc;
SQLCHAR server[12];
SQLCHAR uid[12];
SQLCHAR pwd[12];
.
.
.
strcpy((char*)server, "test_db");
strcpy((char*)uid, "Admin");
strcpy((char*)pwd, "");
SDWORD cbName...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033507/4946246/41

-----------------------------------------------------------------------
NEW QUESTION on:
How to install the MySQL JDBC connector?

QUESTION from Carlosdl:
Have a look at the following pages. Hopefully you will find the solution to
your problem there.

[A
href="http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-j2ee.html#co
nnector-j-usagenotes-tomcat
"]Using Connector/J with Tomcat[/A]
[A href="http://dev.mysql.com/doc/refman/5.0/en/conne...

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

-----------------------------------------------------------------------
LINUX 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/6033410/4946246/43

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

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

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

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

NEW ANSWER on:
Building a backup server

ANSWER from Jmm-irl:
I would certanly look at FreeNAS as an OS for such a device. I have ran FreeNAS
on a compat flash card and used it to setup software Raid arrays that are
accessable as either CIFS shares or NFS or Rsync hosts.

There is no right answer. here is an interesting bit of kit from [A
href="http://www.vi...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033472/4946246/48

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

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

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

NEW DISCUSSION on:
print to HP OfficeJet 7780

DISCUSSION from Markp19:
I too have an HP L7780 printer that I need to be able to print to. These
settings didn't work for me. Am I missing something? MikeSchmidtPF did you
find a solution?
let me know please. thank you!
mark

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033415/4946246/50

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to pinpoint the Windows XP problem via BSOD stop codes

DISCUSSION from Avensis:
Flame and peter.hi,sorry for late reply but the uk seems crazy right now. It's
03:00 and I'm catchin up via iPod. Thank you both so much for your input. I
understand ntfs relates to x24 but it the other 4codes that I would love to get
insight of how to dicipher.it's gone way beyond what they mean...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
iSeries Access printing with Lexmark 2381 printer

DISCUSSION from LBurkett99:
Make sure you have set the Top of Form correctly. If you do not have a user
guide or Quick Reference, try this:
http://www.lexmark.com/publications/pdfs/2007/2400dm/en.html. It is for the
2400 series but I think it is the same as the 2381.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Ping request timed out

ANSWER from Jmm-irl:
Check the speed & duplex settings on both the server & the LAN switch. It
sounds like there is a mismatch somewhere and this could be causing the problem
you are seeing. Resetting the NIC would take care of this each time but you
should hard set all server NICs and switch ports attached to servers.
...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033475/4946246/53

-----------------------------------------------------------------------
NEW QUESTION on:
Excel 2002 Copy GetPivotDATA function

QUESTION from Steve7474:
I have a number of different items that I need to extract from a pivot table.
Can I copy the GETPIVOTDATA function? it seems to get stuck and return only the
value from the first cell

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033476/4946246/54

-----------------------------------------------------------------------
NEW QUESTION on:
Combining fields to create a unique ID in Microsoft Access

QUESTION from FSUResA:
I have been working on a database for my research job.For our research purposes
we are trying to create a unique identifier that tells us 4 things:

1) what study they are a part of, [this will be ?QQQ? for EVERYONE]

2) what group they are in, [this will be a four digit number, such a...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033477/4946246/55

-----------------------------------------------------------------------
NEW ANSWER on:
Generate PRN file on AS/400

ANSWER from WoodEngineer:
We've had good success by converting spool files to PDFs and saving on the IFS.
Its more versitile than a PRN file.

There are a number of low cost AS/400 utilities that can convert to PDF.
Probably even some free ones. If you have IBM's InfoPrint Services feature, it
can convert to PDF.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033429/4946246/56

-----------------------------------------------------------------------
UPDATED ANSWER on:
MS Access Tools References...

ANSWER from ItCareerCoach:
Hi Bob,

Here is a link to some code that you can start out with:

[A
href="http://www.eggheadcafe.com/software/aspnet/32916624/send-email-using-vba-c
ode.aspx"]http://www.eggheadcafe.com/software/aspnet/32916624/send-email-using-v
ba-code.aspx[/A]

Hope that works,

Kingsley
[A href="http://...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033478/4946246/57

-----------------------------------------------------------------------
NEW DISCUSSION on:
Remote Desktop Connection

DISCUSSION from Fahad:
You have several options that you can use to connect to your home computer
remotely.

You can either use internet service on your home computer and connect to it
remotely from your office
network using the softwares VNC(Virtual Network Computing) or logmein.

Or you can make VPN connection f...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Correct database format for Rich Text/HTML?

ANSWER from Mrdenny:
If you need to store HTML then you can use the NVARCHAR(MAX) datatype (TEXT if
you are using SQL 2000 or order). If you want to store Rich Text then this is
Binary data which would need to be stored in the VARBINARY(MAX) data type
(IMAGE if you are using SQL 2000 or order).

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033480/4946246/59

-----------------------------------------------------------------------
NEW QUESTION on:
Sharepoint Site Map Creation

QUESTION from BHybner:
Is there a simple out of the box way to create a SharePoint site map? I have
reviewed a few articles pointing to creating colums and such to generate this,
but I am just looking for something that will give a top level view of the Site
Collection and Sites.....

Also, is there a way to dump a site...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033481/4946246/60

-----------------------------------------------------------------------
NEW DISCUSSION on:
Not able to record more than 60 seconds with Windows Sound Recorder

DISCUSSION from Carlosdl:
I have done this many times in other similar machines (with less RAM), so the
problem seems to be the 4 GB.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033482/4946246/61

-----------------------------------------------------------------------
NEW DISCUSSION on:
DNS issue within the local network

DISCUSSION from Petkoa:
Well, Fahad, if you don't think about the "router" from the question just as a
highly-specialized device which is able of just, ehr, routing, there are at
least two scenarios which will explain the situation with DNS/gateway sitting
on the same IP without the "complications" of proxy-DNS or cac...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033433/4946246/62

-----------------------------------------------------------------------
UPDATED ANSWER on:
How can I find an Excel formula that helps me change text?

ANSWER from Carlosdl:
Try using the "Replace..." function on word. It is located in the Edit menu.
You might have to expand the edit menu to see it.

Good Luck!
-Flame

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

Yes, excel formulas can do that.

Have a look at the following pages:

[A href="http://www.codeforexc...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033484/4946246/63

-----------------------------------------------------------------------
MOBILE 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/6033410/4946246/64

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

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

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

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

NEW ANSWER on:
Email - Recipient requested to send notice

ANSWER from KarlG:
You can disable this via your Exchange server. I have Exchange 2003 and this is
how I did it:

Goto Your Exchange 2003 System Manager
Global Settings
Internet Message Formats
Right Click on Default Properties
Advanced

Uncheck Allow Delivery Reports

All Blackberry handhelds on the server ...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Can't Synch Outlook email folder through cable

QUESTION from Technochic:
Check your synch properties for each folder. I had to tell my device to synch
the folders I wanted. I could see them all, but they were empty as you say. I
was not using the desktop utility, I was synching with my exchange server and I
had to go into folder options and check the folders I wanted to ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033465/4946246/70

-----------------------------------------------------------------------
NEW QUESTION on:
Double email and facebook notifications on Blackberry Curve

QUESTION from Chancej:
Whenever I receive an email, SMS text or Facebook notification, it always comes
in twice. How can I change this?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033497/4946246/71

-----------------------------------------------------------------------
NEW QUESTION on:
Blackberry Services on "used" blackberry

QUESTION from Medhum:
I have just been made redundant and need a new phone. I want a blackberry
(probably curve as I have had before) but do not want to commit to a long
contract as I hope I will get a new job soon. The question is I have a monthly
sim contract with Vodafone and I want to know if I can access blackberry ...

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

-----------------------------------------------------------------------
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/6033410/4946246/73

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

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

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

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

NEW QUESTION on:
Intermittent access to web portal although Ping results are positive

QUESTION from Diyben:
I'm puzzled by our network connectivity between our main office and project
site. From the project site, ping results to both web servers in the main
office have no loss but just could not have access to main office web portals
(port 80 and 81).

The 'page disconnection' happens very frequently an...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033485/4946246/78

-----------------------------------------------------------------------
NEW DISCUSSION on:
print to HP OfficeJet 7780

DISCUSSION from Markp19:
I too have an HP L7780 printer that I need to be able to print to. These
settings didn't work for me. Am I missing something? MikeSchmidtPF did you
find a solution?
let me know please. thank you!
mark

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

-----------------------------------------------------------------------
NEW QUESTION on:
Setting Up Cisco 2950 Switch

QUESTION from Perkster:
Hello,

New to itknowledge exchange...

I have a hand me down Cisco 2950 12 port switch.

I currently have assigned to my Cable Modem4 Static Public IP's
Note: Not real but used for example.
70.66.131.1
70.66.131.2
70.66.131.3
70.66.131.4

I run 3 servers in my basement all of which I h...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033486/4946246/80

-----------------------------------------------------------------------
NEW DISCUSSION on:
Performance of Cisco 3750 Layer 3 switch

DISCUSSION from Bluezerk:
Thanks for the quick reply :) Currently there are 2 VLANS from a router to this
switch and the amount of traffic that is destined for a device local to the
switch is the 40MB stated in the question. This 40MB is obtained by capturing
traffic volume on the VLAN on the router. Could it be possible tha...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033487/4946246/81

-----------------------------------------------------------------------
NEW DISCUSSION on:
Blocking LogMeIn and remote access programs

DISCUSSION from CdnPlague:
I have enabled the IPS feature but it still seems to let it through.
I cannot find the article on the Linksys site. Could you provide me with the
link please.

Much appreciated.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033488/4946246/82

-----------------------------------------------------------------------
NEW QUESTION on:
New Web Service Project

QUESTION from AL0428:
Hi,

Currently an iSeries job runs every 10 minutes where, at the back end, a file
is read (more than 400 fields), a pipe delimited file is created and FTP'd to
an outside location. Volume would normally be low but intermittently there
could be a spike.

I need to replace the FTP process with a ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033421/4946246/83

-----------------------------------------------------------------------
NEW DISCUSSION on:
Static Routing and Dynamic Routing

DISCUSSION from Mshen:
I used run away router to generally characterize some sort of device that will
cause some sort of disruption to your network.

I used false routing tables to indicate that this "run away" device is spamming
or sending out incorrect routing updates to your routers thus causing problems
with your ...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033489/4946246/84

-----------------------------------------------------------------------
NEW ANSWER on:
Cisco 2811 configuration for managing traffic through two Internet connections

ANSWER from KarlG:
I am running a similar setup here is my config and notes:

Current configuration : 2187 bytes &lt;Delete this, :this is the file size,
will produce an error message if in a sript
!
version 12.4 &lt;Delete this: This is the ios verion
service timestamps debug datetime msec &lt;This puts a d...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Bandwidth estimation for EMC MirrorView

ANSWER from DaveGraham:
Rick,

dave graham from EMC here. I can help you get the information you need.

I'll need the array type (Clariion CX3, CX4?), connectivity protocol (FC,
iSCSI) as well as the current WAN link between sites.

as Mrdenny says below, the change rate over 30 minutes would be helpful. We can
also...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Multiple public IP's from 1 internet connection on different networks?

DISCUSSION from Mshen:
I'm not very familliar with the linksys router, but I'm not sure that you could
get that to work. It is a question for Linksys support. You could put your
5-port switch behind the Cisco router and get a connection off that.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Remote Desktop Connection

DISCUSSION from Fahad:
You have several options that you can use to connect to your home computer
remotely.

You can either use internet service on your home computer and connect to it
remotely from your office
network using the softwares VNC(Virtual Network Computing) or logmein.

Or you can make VPN connection f...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Is 192.168.35.165 the same as 192.168.035.165?

ANSWER from Spadasoe:
of course it is the same, to check it you may ping both addresses, or try to
connect to both you will be addressing the same PC
*********************
watch your ping, they will be the same
*********************

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033493/4946246/89

-----------------------------------------------------------------------
NEW DISCUSSION on:
DNS issue within the local network

DISCUSSION from Petkoa:
Well, Fahad, if you don't think about the "router" from the question just as a
highly-specialized device which is able of just, ehr, routing, there are at
least two scenarios which will explain the situation with DNS/gateway sitting
on the same IP without the "complications" of proxy-DNS or cac...

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

-----------------------------------------------------------------------
ORACLE 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/6033410/4946246/91

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

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

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

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

NEW QUESTION on:
OracleClient

QUESTION from Dax:
I am new to VB.Net, I am using VB.Net 2003 and Oracle 10g Express. In coding I
enter
Imports System.Data.OracleClient
The system did not support. Why??

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033436/4946246/96

-----------------------------------------------------------------------
NEW ANSWER on:
Oracle database and Crystal

ANSWER from Sous:
in Crystal XI after opening a new blank report to create a connection to Oracle
Database,
- right click on Databse Fileds --&gt; Database Expert (or menu Database --&gt;
Database Expert)
- click on create new connection
- one of the option is Oracle where you can defne the server from which you
...

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

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

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

View all SAP related Questions and Answers
http://go.techtarget.com/r/6033527/4946246/98
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
SAP User Access by Company Code

QUESTION from Cbt098:
I have pulled a list of users with access to certain T-codes, however, I would
like to include the company code(s) to which each user has access in the output
as well. Is there a way to do this or do I need to check access at the company
code level individually for each user?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033528/4946246/99

-----------------------------------------------------------------------
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/6033410/4946246/100

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

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

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

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

UPDATED ANSWER on:
ISA 2004 Checklist

ANSWER from Sous:
Check this link
http://technet.microsoft.com/en-us/library/cc302455.aspx

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033494/4946246/105

-----------------------------------------------------------------------
NEW DISCUSSION on:
Blocking LogMeIn and remote access programs

DISCUSSION from CdnPlague:
I have enabled the IPS feature but it still seems to let it through.
I cannot find the article on the Linksys site. Could you provide me with the
link please.

Much appreciated.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033488/4946246/106

-----------------------------------------------------------------------
NEW QUESTION on:
Copying our disaster recovery database on a SQL Server

QUESTION from SQL Server Ask the Experts:
We are using log shipping on our SQL Server as our disaster recovery solution.
When we want to test our disaster recovey with a test transaction, not
production, we need to use the secondary copy. However, we don't want to stop
it and lose consistency between disaster recovery and the production cop...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033440/4946246/107

-----------------------------------------------------------------------
NEW QUESTION on:
Checklists for Router, Firewall and Switch security

QUESTION from Labnuke99:
Check NIST for various publications.

[A href="http://www.nist.org/nist_plugins/content/content.php?content.28"]NIST
SP 800-70 Security Configuration Checklists Program for IT Products[/A]

(The below SP 800-70 description is from NIST.gov, edited)

The Security Configuration Checklists Progra...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033495/4946246/108

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

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

View all SQL Server related Questions and Answers
http://go.techtarget.com/r/6033438/4946246/109
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Copying our disaster recovery database on a SQL Server

QUESTION from SQL Server Ask the Experts:
We are using log shipping on our SQL Server as our disaster recovery solution.
When we want to test our disaster recovey with a test transaction, not
production, we need to use the secondary copy. However, we don't want to stop
it and lose consistency between disaster recovery and the production cop...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033440/4946246/110

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Server Stored Procedure

ANSWER from Mrdenny:
Anything that you can do as a normal T/SQL statement can be done via a stored
procedure. In some cases you may have to use dynamic SQL do to them however.
For example you can't create a stored procedure from within another stored
procedure unless you use dynamic SQL. The big requirement is that y...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Log shipping and replication

ANSWER from Mrdenny:
There is no quick way to fail over a log shipped database to test DR and fail
back. Once you make
the database writeable there is no way to begin the log shipping again without
resetting up the log shipping.

Something you could try, and I have no idea if it will work would be to stop
the SQL S...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033442/4946246/112

-----------------------------------------------------------------------
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/6033410/4946246/113

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

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

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

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

NEW ANSWER on:
Building a backup server

ANSWER from Jmm-irl:
I would certanly look at FreeNAS as an OS for such a device. I have ran FreeNAS
on a compat flash card and used it to setup software Raid arrays that are
accessable as either CIFS shares or NFS or Rsync hosts.

There is no right answer. here is an interesting bit of kit from [A
href="http://www.vi...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033472/4946246/118

-----------------------------------------------------------------------
NEW DISCUSSION on:
BRMS using newly expired tapes

DISCUSSION from PierreLG:
Hello,
We have exactly the same problem...
Did you find a solution ?
The result that we have is that the backup failed with an error CPF4290.

Thanks for the update.

Best regards,

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6033412/4946246/119

-----------------------------------------------------------------------
UPDATED ANSWER on:
Bandwidth estimation for EMC MirrorView

ANSWER from DaveGraham:
Rick,

dave graham from EMC here. I can help you get the information you need.

I'll need the array type (Clariion CX3, CX4?), connectivity protocol (FC,
iSCSI) as well as the current WAN link between sites.

as Mrdenny says below, the change rate over 30 minutes would be helpful. We can
also...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033491/4946246/120

-----------------------------------------------------------------------
NEW QUESTION on:
Copying our disaster recovery database on a SQL Server

QUESTION from SQL Server Ask the Experts:
We are using log shipping on our SQL Server as our disaster recovery solution.
When we want to test our disaster recovey with a test transaction, not
production, we need to use the secondary copy. However, we don't want to stop
it and lose consistency between disaster recovery and the production cop...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Log shipping and replication

ANSWER from Mrdenny:
There is no quick way to fail over a log shipped database to test DR and fail
back. Once you make
the database writeable there is no way to begin the log shipping again without
resetting up the log shipping.

Something you could try, and I have no idea if it will work would be to stop
the SQL S...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6033442/4946246/122

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

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

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

NEW QUESTION on:
Solaris virtualization techniques

QUESTION from JennyMack:
[I]The following question was recently submitted via e-mail by a user:[/I]

Solaris users -- is there any preferred method of virtualization for Solaris
(zones, etc.)?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6033452/4946246/124

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

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 Technology Media ROI Experts and
events company.

Copyright 2009 TechTarget. All rights reserved.