Daily Question and Answer Update for Jan 7, 2009

New questions and answers have been added to the community for the following
tags:
- CRM
- Database
- DataCenter
- Development
- Microsoft Windows
- Networking
- SAP
- Security
- Storage
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/5496543/4946246/1

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

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

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

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

NEW QUESTION on:
Database connectivity using ActiveX control

QUESTION from Reena:
Provide a sample code to how by using VB 6.0 connectivity can be done by
ActiveX(ADO) Control tool with the database SQL Server 2000

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496549/4946246/6

-----------------------------------------------------------------------
NEW QUESTION on:
Database connectivity using Data Control

QUESTION from Reena:
Provide a sample code to how by using VB 6.0 connectivity can be done by Daat
Control tool with the database SQL Server 2000

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496550/4946246/7

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

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

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

NEW QUESTION on:
can we migrate already encrupted data in MS SQL Server 2008 from MS SQL Server
2000.

QUESTION from Amit1may:
I have encrypted data in MS SQL Server 2000. I want to migrate in MS SQL Server
2008.
I have migrated successfully through the attach/dettach process but when I am
trying to decrypt the data. is it giving different result or value.
is the right process to migrate the encrypted data?
Please sugges...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496587/4946246/9

-----------------------------------------------------------------------
NEW DISCUSSION on:
Citrix Metaframe XP management console unavailable

DISCUSSION from Smithc32:
Metaframe XP is pretty old so I do not know for sure but my understanding is
that the datastore is running on a MSSQL server or Oracle Server and if that is
down then you can not make any changes to configuration of the Farm. If you
have your database in multiple locations using Dataguard for Oracle...

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

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

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

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

NEW DISCUSSION on:
rpg/400

DISCUSSION from Askt1:
i am writing INVAM to flat file. in flat file i am not getting any decimal
positions...

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

-----------------------------------------------------------------------
NEW QUESTION on:
How can I get my Dell Optiplex to see a usb keyboard DURING boot process? (So I
can get to the BIOS.)

QUESTION from Mjshellhm:
I cannot boot up my PC I just purchased. It gets to a screen that says no boot
device is available. (This is not a hardware problem, I just need to format the
drive.) I have a Windows XP disk and wish to install that onto this computer.
Sounds easy to this point right? Well I did not realize when pu...

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

-----------------------------------------------------------------------
NEW ANSWER on:
AS400 - RPGLE Module

ANSWER from AdamVanBuskirk:
While probably obvious, I though I would mention it just in case it is helpful.


You can use the detail parameter on either of the CRTPGM, CRTSRVPGM, UPDPGM, or
UPDSRVPGM commands to view the binding listing for the service progam/program.
The binding listing will display all the modules that are...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Embedded SQL over multiple physical file members

ANSWER from Markpg:
Hi Martin,
Unfortunately I dont think this is possible without creating
the alias for each member, a bit over the top as you say but the only way I
think you can do it. It is similar to what I was trying to do with my recent
post and I ended creating a source member with all the cr...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Database connectivity using ActiveX control

QUESTION from Reena:
Provide a sample code to how by using VB 6.0 connectivity can be done by
ActiveX(ADO) Control tool with the database SQL Server 2000

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496549/4946246/16

-----------------------------------------------------------------------
NEW ANSWER on:
MSGW in WRKACTJOB

ANSWER from Markpg:
I dont know a way using wrkactjob however you can monitor for messages inside
cl very easily or if using ile rpg you can use the monitor op code to catch any
error while adding or updating a file

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5496556/4946246/17

-----------------------------------------------------------------------
DEVELOPMENT 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/5496543/4946246/18

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

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

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

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

NEW QUESTION on:
What is the best & quick way to get a networking job?

QUESTION from Rishabh:
Is it the Microsoft way/ CISCO way / Red hat way/ Comp Tia way, for an
inexperienced person.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
turbo pascal question

ANSWER from PC32Mech:
This is my answer:

Program PassengerSeats;
Uses Crt;
Var Seat: array[1..4, 1..7] of boolean;
I, J: integer;
Number: integer;
Word: char;

Begin
ClrScr; TextColor(15);
Writeln(' Wellcome. The seats are numbered as follows:');
Writeln;
Writeln(' 1 A B C D');
Writel...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Change User Account Name in Active Directory

QUESTION from Littlejuanito7:
We have a user that recently got married and would like to have her account
name changed. How easy or hard would this be? We run Windows Server 2003 and
Exchange 2003. How would the changes affect her receiving emails? She is a
member of several distribution groups and has several Inboxes set up in...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496592/4946246/25

-----------------------------------------------------------------------
NEW DISCUSSION on:
Mailbox sizes will not update in system manager

DISCUSSION from Cmolinere:
I am also having the same issue, did you have any luck resloving it? The
strange thing is in Outlook the folder sizes are not updating either. Once
email is deleted and you go back to folder size the total amount is not
updating when you view the folder list, the listing shows the new sizes.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Citrix Metaframe XP management console unavailable

DISCUSSION from Smithc32:
Metaframe XP is pretty old so I do not know for sure but my understanding is
that the datastore is running on a MSSQL server or Oracle Server and if that is
down then you can not make any changes to configuration of the Farm. If you
have your database in multiple locations using Dataguard for Oracle...

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

-----------------------------------------------------------------------
MICROSOFT WINDOWS 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/5496543/4946246/28

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

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

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

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

NEW DISCUSSION on:
podmena traffica test - What is this email trying to do?

DISCUSSION from Suzmonster:
Thanks folks! It's on my school email so I'll be sure to contact the admins.
I'm so used to having email headers hidden I forgot to check that out. Doh! So
much for transparency. =b I'll update if I find out anything more. Thanks
again!

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5496563/4946246/33

-----------------------------------------------------------------------
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/5496543/4946246/34

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

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

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

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

NEW QUESTION on:
Regarding deletion of user profile from AS400 system.

QUESTION from Gadang:
While changing the owner of the objects of the user profile from the system i
encountered an error 'Ownership of 0 document library objects changed to
profile XXXXXX; 1 not ...'. I need to know how can i solve this error.

Thanks,

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Inserting CRLF in mainframe FTP program

DISCUSSION from Indoubt88:
I don't believe the answer from Wiki will do what you are looking for. There
is a parameter in the system stettings for FTP on the mainframe that control
whether the data wraps to a new line or follows the value of the TRUNCATE FTP
setting:
WRAPRECORD FALSE ; (S) Specify what to do...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5496567/4946246/40

-----------------------------------------------------------------------
NEW DISCUSSION on:
Operating System not found

DISCUSSION from Smithc32:
I think this sounds like an issue with the boot.ini file. Since the machine was
re purposed perhaps there is an invalid first entry. That is where I would
start.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5496568/4946246/41

-----------------------------------------------------------------------
NEW ANSWER on:
Embedded SQL over multiple physical file members

ANSWER from Markpg:
Hi Martin,
Unfortunately I dont think this is possible without creating
the alias for each member, a bit over the top as you say but the only way I
think you can do it. It is similar to what I was trying to do with my recent
post and I ended creating a source member with all the cr...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5496555/4946246/42

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

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

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

NEW ANSWER on:
How to convert DBGrid database information to text files with VB 6

ANSWER from BPD:
in VB programme create all text variable like grid coloumn, all variable type
is text.
and then type following code

i.e. in grid their r 4 col.

srno as string * [20]
name as string * [50]
Addr as string * [90]
mobile as string * [10]

dim i

fopen ("c:result.txt")

for i=0 to dbgri...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Database connectivity using ActiveX control

QUESTION from Reena:
Provide a sample code to how by using VB 6.0 connectivity can be done by
ActiveX(ADO) Control tool with the database SQL Server 2000

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496549/4946246/45

-----------------------------------------------------------------------
NEW QUESTION on:
Database connectivity using Data Control

QUESTION from Reena:
Provide a sample code to how by using VB 6.0 connectivity can be done by Daat
Control tool with the database SQL Server 2000

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496550/4946246/46

-----------------------------------------------------------------------
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/5496543/4946246/47

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

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

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

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

NEW QUESTION on:
Access Database - Colorize one word or letter

QUESTION from BethG:
How do I colorize one character in a field in a table? I want the letter "O"
to be in red for one customer and blue for another customer in the same column
but different rows.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5496570/4946246/52

-----------------------------------------------------------------------
UPDATED ANSWER on:
MS Access 2003 write in SQL query to convert string to numeric

ANSWER from Findsarfaraz:
You can use expression builder to do same
CINT(TEXT value) will convert into numeric


http://findsarfaraz.blogspot.com

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

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

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

View all Storage related Questions and Answers
http://go.techtarget.com/r/5496572/4946246/54
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Remote access on Windows Server 2008

QUESTION from ITKE:
Is it possible to limit remote access to my windows server 2008 so that you
can
remote connect only to the console session?

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Remote desktop connection error

ANSWER from Spadasoe:
Check firewall settings on both the client and server and see that the server
permits inbound connections on port 3389 and that the client can make outbound
connections on port 3389. Are you able to ping the server?

Hi,

This Ali younis 1st of all check that remote desk top is enabled by press ...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Operating System not found

DISCUSSION from Smithc32:
I think this sounds like an issue with the boot.ini file. Since the machine was
re purposed perhaps there is an invalid first entry. That is where I would
start.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5496568/4946246/57

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

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.