mysql connection using jsp
I provide the article just follow the steps: Step 1 – Creating a MySQL database Log into the Mysql, Enter a database username and password of your choice, the database name will be your username with “db” appended to it, so if you created a database called “amazon” your database name would be “amazondb”. Step [...]
View Answer
| October 12, 2010 7:09 AM
Java Web developers, JSP, Linux OS, MySQL
I provide the article just follow the steps: Step 1 – Creating a MySQL database Log into the Mysql, Enter a database username and password of your choice, the database name will be your username with “db” appended to it, so if you created a database called “amazon” your database name would be “amazondb”. Step [...]
View Answer
| October 12, 2010 7:09 AM
Java Web developers, JSP, Linux OS, MySQL
Earn 250 Knowledge Points now by tweeting out our contest
Here is my tweet @shillu13 Shilpa Venkateshwara I’m doing the @ITKE #NexusOne Challenge by asking and answering IT questions. You can too! http://bit.ly/7mBwGP
View Answer
| October 11, 2010 8:21 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP Gateway
Here is my tweet @shillu13 Shilpa Venkateshwara I’m doing the @ITKE #NexusOne Challenge by asking and answering IT questions. You can too! http://bit.ly/7mBwGP
View Answer
| October 11, 2010 8:21 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP Gateway
Access database file corrupt
There is a way to repair ur damage database. Carefully read this before doing anything : Before you run the Compact and Repair utility on a database, make sure of the following: * Make sure that you have enough free storage space on your hard disk for both the original and the compacted versions of [...]
View Answer
| October 11, 2010 11:41 AM
Access Database, Access Database Capacity, Access errors, Corrupt Database
There is a way to repair ur damage database. Carefully read this before doing anything : Before you run the Compact and Repair utility on a database, make sure of the following: * Make sure that you have enough free storage space on your hard disk for both the original and the compacted versions of [...]
View Answer
| October 11, 2010 11:41 AM
Access Database, Access Database Capacity, Access errors, Corrupt Database
How to convert a a string date to date time format
your q is not clear here properly. There r no of software that can support date format. what software do u use here? Excel / Java / C++ / VB ….. or others. plz give more details.
View Answer
| October 11, 2010 4:59 AM
Avantgo, M-Business Anywhere, SQL Anywhere, SQL Anywhere Studio
your q is not clear here properly. There r no of software that can support date format. what software do u use here? Excel / Java / C++ / VB ….. or others. plz give more details.
View Answer
| October 11, 2010 4:59 AM
Avantgo, M-Business Anywhere, SQL Anywhere, SQL Anywhere Studio
Disaster recovery for SQL 2005
That all depends on how much data you can afford to loose and what sort of systems you have in place. For a small business the most common solution would be to use database mirroring to replicate the database to a DR site. Larger companies will use storage based replication or something similar to replicate [...]
View Answer
| October 7, 2010 3:05 PM
Disaster Recovery, Replicating databases, SQL Backup, SQL Security, SQL Server 2003, SQL Server 2005, SQL Server 2005 security
That all depends on how much data you can afford to loose and what sort of systems you have in place. For a small business the most common solution would be to use database mirroring to replicate the database to a DR site. Larger companies will use storage based replication or something similar to replicate [...]
View Answer
| October 7, 2010 3:05 PM
Disaster Recovery, Replicating databases, SQL Backup, SQL Security, SQL Server 2003, SQL Server 2005, SQL Server 2005 security
IT Book Giveaway: Oracle Solaris Cluster Essentials
Hi Melanie, I answered this http://itknowledgeexchange.techtarget.com/itanswers/odd-network-printing-issue/#viewquestion
View Answer
| October 5, 2010 7:58 AM
Clustering, Contests, DHCP, Giveaways, IT answers, IT Books, Oracle, SQL Server 2008 R2, Veeam 4.0, Windows Server 2008
Hi Melanie, I answered this http://itknowledgeexchange.techtarget.com/itanswers/odd-network-printing-issue/#viewquestion
View Answer
| October 5, 2010 7:58 AM
Clustering, Contests, DHCP, Giveaways, IT answers, IT Books, Oracle, SQL Server 2008 R2, Veeam 4.0, Windows Server 2008
Infinite recursion in SQL Server 2000
infinite recursion and query optimization are pretty much mutually exclusive. If you can post the table design and the query (or a simplified version of it) it might help.
View Answer
| October 2, 2010 6:04 PM
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000
infinite recursion and query optimization are pretty much mutually exclusive. If you can post the table design and the query (or a simplified version of it) it might help.
View Answer
| October 2, 2010 6:04 PM
Query optimization, Recursion, SQL Query, SQL query optimization, SQL Server 2000
How do I create a trigger in VB 6?
According to Carlosdl, ur q’s is not clear here or u have to provide more details. Though, I provide an eg, hope it will help u. 1. Dim myDate As Date, ExpiryDate As Date 2. rsDates.Open “SELECT TheDate FROM MyTableDates”, cnDate, adOpenStatic, adLockOptimistic 4 MyDate = rsDates!TheDate 6 ExpiryDate = Now 7 If MyDate < [...]
View Answer
| October 1, 2010 11:31 AM
Triggers, VB, VB 6, Visual Basic, Visual Basic 6
According to Carlosdl, ur q’s is not clear here or u have to provide more details. Though, I provide an eg, hope it will help u. 1. Dim myDate As Date, ExpiryDate As Date 2. rsDates.Open “SELECT TheDate FROM MyTableDates”, cnDate, adOpenStatic, adLockOptimistic 4 MyDate = rsDates!TheDate 6 ExpiryDate = Now 7 If MyDate < [...]
View Answer
| October 1, 2010 11:31 AM
Triggers, VB, VB 6, Visual Basic, Visual Basic 6
When setting up a cluster for failover purposes do you only inclde hardware of one vendor?
When setting up clustering for failover all hardware should be from the same vendor and they should be exactly the same. You don’t want to run into driver issues and support problems with multiple vendors. So keep it the same vendor and same hardware exactly to be on the safe side.
View Answer
| October 1, 2010 3:05 AM
Clustering, Failover Clustering, Server Cluster, Vendor management, Vendor selection
When setting up clustering for failover all hardware should be from the same vendor and they should be exactly the same. You don’t want to run into driver issues and support problems with multiple vendors. So keep it the same vendor and same hardware exactly to be on the safe side.
View Answer
| October 1, 2010 3:05 AM
Clustering, Failover Clustering, Server Cluster, Vendor management, Vendor selection
search string in oracle DMP file
Are you referring to a DMP file created by the EXPORT utility ? If so, you can’t. Those files can only be read by the IMPORT utility.
View Answer
| September 30, 2010 10:53 PM
DMP Importing, Oracle, Oracle PL/SQL, PL/SQL, Search string
Are you referring to a DMP file created by the EXPORT utility ? If so, you can’t. Those files can only be read by the IMPORT utility.
View Answer
| September 30, 2010 10:53 PM
DMP Importing, Oracle, Oracle PL/SQL, PL/SQL, Search string
web-based GPS tracking application development with asp.net
I have the same question.. did you ever find a solution for this? all of the open source GPS web apps are for linux systems. thanks
View Answer
| September 30, 2010 6:56 PM
Application and Web development, ASP, ASP.NET, Database, SQL, Visual Web Developer 2008, Web development
I have the same question.. did you ever find a solution for this? all of the open source GPS web apps are for linux systems. thanks
View Answer
| September 30, 2010 6:56 PM
Application and Web development, ASP, ASP.NET, Database, SQL, Visual Web Developer 2008, Web development
Embedded SQL in RPGLE
True, they are. The problem was that I needed this: C/EXEC SQL SET OPTION commit=*none, closqlcsr=*endmod C/END-EXEC I did not know. Still not sure exactly what the commit=*none does but it works. Thanks Nick ================================================= <i>SET OPTION commit=*none</i> That tells SQL that you aren’t using commitment control for this program. If you don’t use commitment [...]
View Answer
| September 29, 2010 1:37 AM
Embedded SQL, MySQL, RPGLE, SQL, SQL statements
True, they are. The problem was that I needed this: C/EXEC SQL SET OPTION commit=*none, closqlcsr=*endmod C/END-EXEC I did not know. Still not sure exactly what the commit=*none does but it works. Thanks Nick ================================================= <i>SET OPTION commit=*none</i> That tells SQL that you aren’t using commitment control for this program. If you don’t use commitment [...]
View Answer
| September 29, 2010 1:37 AM
Embedded SQL, MySQL, RPGLE, SQL, SQL statements
Access 2003 – command button to show query in pivot format
Here is an example using a command button on an Access2003 form PART CODE BASEPRICE ABRA OLD $250.00 CA MID $2.50 CA NEW $2.00 DA MID $200.00 BRA NEW $250.00 TRANSFORM Sum(tbl3Cols.BasePrice) AS SumOfBasePrice SELECT tbl3Cols.Code, Sum(tbl3Cols.BasePrice) AS [Total Of BasePrice] FROM tbl3Cols GROUP BY tbl3Cols.Code PIVOT tbl3Cols.Part; RETURNS CODE Total Of BasePrice ABRA BRA [...]
View Answer
| September 28, 2010 7:35 PM
Access 2003, Access query, Data Tables, Pivot tables, VB Code, Visual Basic
Here is an example using a command button on an Access2003 form PART CODE BASEPRICE ABRA OLD $250.00 CA MID $2.50 CA NEW $2.00 DA MID $200.00 BRA NEW $250.00 TRANSFORM Sum(tbl3Cols.BasePrice) AS SumOfBasePrice SELECT tbl3Cols.Code, Sum(tbl3Cols.BasePrice) AS [Total Of BasePrice] FROM tbl3Cols GROUP BY tbl3Cols.Code PIVOT tbl3Cols.Part; RETURNS CODE Total Of BasePrice ABRA BRA [...]
View Answer
| September 28, 2010 7:35 PM
Access 2003, Access query, Data Tables, Pivot tables, VB Code, Visual Basic
Does SAP certification really help?
surely sap certification will help u to larger extent as it adds lot of value to the course compledted by you.COmpanies will look for the candidates having certifications.
View Answer
| September 28, 2010 7:55 AM
IT career development, IT career planning, IT careers, SAP careers, SAP certifications
surely sap certification will help u to larger extent as it adds lot of value to the course compledted by you.COmpanies will look for the candidates having certifications.
View Answer
| September 28, 2010 7:55 AM
IT career development, IT career planning, IT careers, SAP careers, SAP certifications
SQL Server I/O
No there’s no metric which will tell you how many times a query is run against the table. A lot more information is needed to figure out what the problem is. How many IOs are hitting the disk per second? How long are each of those operations taking? There are perfmon counters for both of [...]
View Answer
| September 24, 2010 9:09 PM
Average Disk Queue Length, SQL, SQL Server, SQL Server 2005
No there’s no metric which will tell you how many times a query is run against the table. A lot more information is needed to figure out what the problem is. How many IOs are hitting the disk per second? How long are each of those operations taking? There are perfmon counters for both of [...]
View Answer
| September 24, 2010 9:09 PM
Average Disk Queue Length, SQL, SQL Server, SQL Server 2005
Import AD data from CSV file to 2003 ad
See this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/i-want-to-write-a-utility-which-will-read-domain-users-details-from-the-active-directory-and-dump-it-in-a-database/”>similar question</a> which recommends the use of the dsquery command. Here’s another tip that might help you from <a href=”http://itknowledgeexchange.techtarget.com/itanswers/editing-active-directory-users-offline/”>another ITKE user’s question</a>.
View Answer
| September 24, 2010 5:32 PM
Active Directory, Active Directory 2003, Active Directory Users, AD, CSV, Windows, Windows Server 2003
See this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/i-want-to-write-a-utility-which-will-read-domain-users-details-from-the-active-directory-and-dump-it-in-a-database/”>similar question</a> which recommends the use of the dsquery command. Here’s another tip that might help you from <a href=”http://itknowledgeexchange.techtarget.com/itanswers/editing-active-directory-users-offline/”>another ITKE user’s question</a>.
View Answer
| September 24, 2010 5:32 PM
Active Directory, Active Directory 2003, Active Directory Users, AD, CSV, Windows, Windows Server 2003
Exporting Active Directory user info to CSV
This can be perceived as a hacking question. There is no way to export the actual passwords from AD. All you can get from AD are the password hashes and that will have to be done directly on a domain controller. You can use dsquery or the excellent PowerGUI utility to get a list of [...]
View Answer
| September 24, 2010 5:29 PM
Active Directory User Profiles, CSV, Security in 2010, Windows, Windows Server 2008 R2, Windows Server Security, Windows Server User Profiles
This can be perceived as a hacking question. There is no way to export the actual passwords from AD. All you can get from AD are the password hashes and that will have to be done directly on a domain controller. You can use dsquery or the excellent PowerGUI utility to get a list of [...]
View Answer
| September 24, 2010 5:29 PM
Active Directory User Profiles, CSV, Security in 2010, Windows, Windows Server 2008 R2, Windows Server Security, Windows Server User Profiles
Using SELECT with LIMIT clause on a physical file
Tom – thanks for the additional information. A Jakusz
View Answer
| September 24, 2010 2:07 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select
Tom – thanks for the additional information. A Jakusz
View Answer
| September 24, 2010 2:07 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select
MCA – Oracle or .Net career
Oracle and .NET are two very different paths to take. Oracle is a database product while .NET is an application programming language. While they are complimentary to each other you should be familiar with both in addition to SQL Server, MySQL, etc.
View Answer
| September 22, 2010 5:55 PM
.NET, IT career development, IT career planning, IT careers, MCA, Oracle Careers
Oracle and .NET are two very different paths to take. Oracle is a database product while .NET is an application programming language. While they are complimentary to each other you should be familiar with both in addition to SQL Server, MySQL, etc.
View Answer
| September 22, 2010 5:55 PM
.NET, IT career development, IT career planning, IT careers, MCA, Oracle Careers
Excel date format
Excel Help says you can use a function called DATEVALUE. In an empty cell, type =DATEVALUE( then click the cell that has the Text date and then close the parenthesis and press ENTER. That gives you the serial number of the date, and you can use format to cause it to to look like the [...]
View Answer
| September 22, 2010 5:39 PM
Database migration, Excel 2003, Excel 2003 functions, Excel Database
Excel Help says you can use a function called DATEVALUE. In an empty cell, type =DATEVALUE( then click the cell that has the Text date and then close the parenthesis and press ENTER. That gives you the serial number of the date, and you can use format to cause it to to look like the [...]
View Answer
| September 22, 2010 5:39 PM
Database migration, Excel 2003, Excel 2003 functions, Excel Database
