Free IT Book: Drupal’s Building Blocks
Today’s free IT book is an essential addition to any developer’s library: Drupal’s Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels, all by answering one of five questions and posting the link to your answer in the discussion area below. A particular IP range cannot access internet through ISA [...]
Answer Question
| February 7, 2011 3:35 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Today’s free IT book is an essential addition to any developer’s library: Drupal’s Building Blocks. Learn how to quickly build web sites with CCK, Views, and Panels, all by answering one of five questions and posting the link to your answer in the discussion area below. A particular IP range cannot access internet through ISA [...]
Answer Question
| February 7, 2011 3:35 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Drupal, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Sybase user connections exhausted
Hi, I got my conenctions exhausted on sybase server. I am unable to connect now is there any work around its very urgent. thnkx.
Answer Question
| February 7, 2011 1:46 PM
Sybase, Sybase connectivity, Sybase Databases
Hi, I got my conenctions exhausted on sybase server. I am unable to connect now is there any work around its very urgent. thnkx.
Answer Question
| February 7, 2011 1:46 PM
Sybase, Sybase connectivity, Sybase Databases
Careers after MCSE certification
Hi all, i m mcse certified and having good knowledge but not getting any job because every company require too much like third party products whereas no any institute teaches those. so, please help you out coz i m really in dilemma what should i do or to change my line to programming. thankx in [...]
Answer Question
| February 8, 2011 5:10 PM
Information Security Career, IT careers, MCSE, MCSE CCNA
Hi all, i m mcse certified and having good knowledge but not getting any job because every company require too much like third party products whereas no any institute teaches those. so, please help you out coz i m really in dilemma what should i do or to change my line to programming. thankx in [...]
Answer Question
| February 8, 2011 5:10 PM
Information Security Career, IT careers, MCSE, MCSE CCNA
Create a database with Java
i need to create a database with tables using java language, only java. it must be very simple database. maybe you have some sources, books etc. I really need help with this.
Answer Question
| February 4, 2011 6:24 PM
Database, Java, Java applications, Java Database
i need to create a database with tables using java language, only java. it must be very simple database. maybe you have some sources, books etc. I really need help with this.
Answer Question
| February 4, 2011 6:24 PM
Database, Java, Java applications, Java Database
SQL Server 2005 permissions required by public
Our security madates that ALL object permissions be removed from”public”. After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?
Answer Question
| February 15, 2011 6:46 PM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server permissions
Our security madates that ALL object permissions be removed from”public”. After doing that, no one can see their tables or do anything. What are the absolutly NEEDED permissions required by public (Execute, Select, etc.)?
Answer Question
| February 15, 2011 6:46 PM
SQL Security, SQL Server 2005, SQL Server 2005 security, SQL Server permissions
Open IT Forum: Tell us your must-read IT blog or Twitter feed & earn 50 knowledge points!
We’re always looking for great resources to share with the community, so here’s your chance to share what’s in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you’ll never forget. Don’t have a favorite tech blog? [...]
Answer Question
| August 23, 2011 4:25 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
We’re always looking for great resources to share with the community, so here’s your chance to share what’s in your own bag of tricks! Share your favorite IT blogs or Twitter personalities, what they write about, or a link to a post that taught you something you’ll never forget. Don’t have a favorite tech blog? [...]
Answer Question
| August 23, 2011 4:25 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Earn 50 knowledge points by tweeting out our iPad contest!
We’ll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.
Answer Question
| February 3, 2011 3:51 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
We’ll give you 50 knowledge points for sending out a tweet about our iPad contest, happening now through February 16th! Spread the word, earn points, and qualify yourself for an iPad or Amazon.com gift card! Contest details at the Community Blog.
Answer Question
| February 3, 2011 3:51 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Access 2010 macros
I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!=”NO” THEN EmailDatabaseObject called “Reject Report”. . . My problem is that after the macro completes it locks the table that was made earlier and I cannot run the [...]
Answer Question
| February 4, 2011 7:14 PM
Access 2010, Access macros, Access query, IIF function, IIF statement
I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!=”NO” THEN EmailDatabaseObject called “Reject Report”. . . My problem is that after the macro completes it locks the table that was made earlier and I cannot run the [...]
Answer Question
| February 4, 2011 7:14 PM
Access 2010, Access macros, Access query, IIF function, IIF statement
How to concat SQL Server 2005 data with line feed
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The [...]
Answer Question
| February 2, 2011 10:46 PM
Access 2003, Concatenate, Line Feed, SQL 2005, SQL Server 2005, T-SQL
COmplex update takes a 90 minutes to run in Oracle
In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table has 40 records. It has been written by someone else, I don’t have access to Oracle so can’t check my thinking, but I believe, if we select the data to be updated into pl/sql tables, and [...]
Answer Question
| February 1, 2011 4:19 PM
BULK COLLECT statement, Oracle, Oracle administration, Oracle Processes, Oracle Query
In the following procedure, the update is taking 90 minutes. The client table has 22 million records, the CPDS table has 40 records. It has been written by someone else, I don’t have access to Oracle so can’t check my thinking, but I believe, if we select the data to be updated into pl/sql tables, and [...]
Answer Question
| February 1, 2011 4:19 PM
BULK COLLECT statement, Oracle, Oracle administration, Oracle Processes, Oracle Query
Usual type of work available in AS/400
whats the usual type of work in as 400 platform.whether more opportunities in technical or maintanance
Answer Question
| February 7, 2011 3:52 AM
AS/400, AS/400 careers, IT career development, IT careers
whats the usual type of work in as 400 platform.whether more opportunities in technical or maintanance
Answer Question
| February 7, 2011 3:52 AM
AS/400, AS/400 careers, IT career development, IT careers
Free IT Book: Computer Incident Response and Product Security
This week’s free IT book is a practical guide to building and running incident response and product security teams. To win Cisco’s Computer Incident Response and Product Security answer one of these five questions and post the link to your answer in the discussion area below. Good luck! Mitigating cloud server risks during DDoS attacks [...]
Answer Question
| February 1, 2011 5:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book is a practical guide to building and running incident response and product security teams. To win Cisco’s Computer Incident Response and Product Security answer one of these five questions and post the link to your answer in the discussion area below. Good luck! Mitigating cloud server risks during DDoS attacks [...]
Answer Question
| February 1, 2011 5:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
How do you change user password for a separate Access database than you are working in?
I’ve built a database (Production) with user level security on it. I also have built a smaller database (Login) so I don’t have to use Access’ login. I’m trying to figure out if there is a way to change the user password in the Production database FROM the Login database. I’ve been working with the following [...]
Answer Question
| January 28, 2011 4:00 PM
Access 2003, Access 2003 Security, Access Database, VBA
I’ve built a database (Production) with user level security on it. I also have built a smaller database (Login) so I don’t have to use Access’ login. I’m trying to figure out if there is a way to change the user password in the Production database FROM the Login database. I’ve been working with the following [...]
Answer Question
| January 28, 2011 4:00 PM
Access 2003, Access 2003 Security, Access Database, VBA
Hyperlinks in forms sent from Access 2007 to Sharepoint 2007
Hi, I send files from Access 2007 to Sharepoint 2007 daily. The first column of data in the Access file is a hyperlink, and appears as one(htt:…..). When I send the file to our Sharepoint sight I would like it to appear as an image of our logo in that field, instead of the url. The link [...]
Answer Question
| January 28, 2011 3:52 PM
Access 2007, Access 2007 functions, SharePoint, SharePoint 2007, SharePoint 2007 interoperability
Hi, I send files from Access 2007 to Sharepoint 2007 daily. The first column of data in the Access file is a hyperlink, and appears as one(htt:…..). When I send the file to our Sharepoint sight I would like it to appear as an image of our logo in that field, instead of the url. The link [...]
Answer Question
| January 28, 2011 3:52 PM
Access 2007, Access 2007 functions, SharePoint, SharePoint 2007, SharePoint 2007 interoperability
Customizable IT software for examination process and question database
Thank you in advance for your helpful replies. I am interested in hiring an IT company to create a custom software that facilitates the examination process we offer at our school. However, I am unsure of what exactly is needed so I was hoping for assistance: The goal is to have an online secure web [...]
Answer Question
| February 1, 2011 3:10 PM
CMS, Content Management Systems, Custom software development, Database
Thank you in advance for your helpful replies. I am interested in hiring an IT company to create a custom software that facilitates the examination process we offer at our school. However, I am unsure of what exactly is needed so I was hoping for assistance: The goal is to have an online secure web [...]
Answer Question
| February 1, 2011 3:10 PM
CMS, Content Management Systems, Custom software development, Database
How to get started in SAP
I have done Masters IN Computer Sciences and after that i worked for IT Departments in an ISP and a Bank. After that i worked for five Years in International Banking Department ( Foreign Trade) in a Bank. Now Please guide me how can i proceed with a career in SAP. as currently i have [...]
Answer Question
| January 31, 2011 1:43 PM
IT careers, SAP, SAP careers
I have done Masters IN Computer Sciences and after that i worked for IT Departments in an ISP and a Bank. After that i worked for five Years in International Banking Department ( Foreign Trade) in a Bank. Now Please guide me how can i proceed with a career in SAP. as currently i have [...]
Answer Question
| January 31, 2011 1:43 PM
IT careers, SAP, SAP careers
Courses to Take for QMF beginner
Is there a list of courses to take in QMF for a beginner from course one to the end? If so, could you please list them. We have SkillSoft courses through our Learning Center but they do not them in order from what you need to take first and so on. If you could help [...]
Answer Question
| February 1, 2011 1:09 PM
IT career planning, QMF, Query Management Facility, Query Manager
Is there a list of courses to take in QMF for a beginner from course one to the end? If so, could you please list them. We have SkillSoft courses through our Learning Center but they do not them in order from what you need to take first and so on. If you could help [...]
Answer Question
| February 1, 2011 1:09 PM
IT career planning, QMF, Query Management Facility, Query Manager
Experience applying SP4 to SQL 2005?
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to [...]
Answer Question
| February 7, 2011 5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances
Hi, I have a Microsoft SQL 2005 SP3 database server with 2 instances (both patched to SP3.) The one instance (1a) includes 52 small production databases. The other instance (1b) includes 2 large production databases. Now I would like to upgrade the (1b) instance to the new Service Pack 4. The way I would to [...]
Answer Question
| February 7, 2011 5:49 AM
Database Instances, SQL 2005, SQL Server 2005, SQL Server database, SQL Server multiple instances
Open IT Forum: How did you get into IT?
Have you always been curious with how things work behind the scenes, or did you realize later in your career that IT was where you belonged? We’d love to hear what inspired you to pursue whatever pocket of IT you’re in. We’ll give you 50 knowledge points just for sharing your story, which will be [...]
Answer Question
| March 6, 2012 8:45 PM
Giveaways, iPads, IT career development, IT career planning, IT careers, Knowledge Points, Open IT Forum
Have you always been curious with how things work behind the scenes, or did you realize later in your career that IT was where you belonged? We’d love to hear what inspired you to pursue whatever pocket of IT you’re in. We’ll give you 50 knowledge points just for sharing your story, which will be [...]
Answer Question
| March 6, 2012 8:45 PM
Giveaways, iPads, IT career development, IT career planning, IT careers, Knowledge Points, Open IT Forum
Problems with DB2 program
I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve [...]
Answer Question
| January 26, 2011 3:49 AM
AS/400 Parameters, COBOL, DB2, DB2 administration
I have a COBOL program that calls a db2 stored proc program. I get corrupted o/p records when reading the input file from CARTRIDGE. The same records, when copied to DASD, come out fine. Same code, JCL, etc. WTH! Is there a parameter that I need to pass to the system with PGM=IKJEFT01 to solve [...]
Answer Question
| January 26, 2011 3:49 AM
AS/400 Parameters, COBOL, DB2, DB2 administration
