To retrieve records from SQL Server database
This is not clear enough, at least for me. I’m not sure whether you want to get records like ‘cleaning’ or not. If you want to get only records containing the word ‘lean’, then you should use something similar to this: <pre>SELECT name FROM table WHERE name like ‘lean %’ or name like ‘% lean’ [...]
View Answer
| February 5, 2009 2:38 PM
Query optimization, SQL, SQL Server development, SQL Server Query
This is not clear enough, at least for me. I’m not sure whether you want to get records like ‘cleaning’ or not. If you want to get only records containing the word ‘lean’, then you should use something similar to this: <pre>SELECT name FROM table WHERE name like ‘lean %’ or name like ‘% lean’ [...]
View Answer
| February 5, 2009 2:38 PM
Query optimization, SQL, SQL Server development, SQL Server Query
How to make installer of VB.NET including SQL Server 2000?
Is SQL Server already installed? What is in the connection string when you are trying to connect? this is my connect function to connect with database, I think there is problem with this coding. Please can you help. Public Sub connect() sconn = “Data Source=SUJAL;Initial Catalog=staff;User ID=sa;Password=longtail” scon = New SqlClient.SqlConnection(sconn) scond = New SqlClient.SqlCommand [...]
View Answer
| February 5, 2009 3:50 AM
Database connectivity, Setup and deployment, SQL Server 2000, VB Setup File, VB.NET, Visual Basic, Visual Basic .NET
Is SQL Server already installed? What is in the connection string when you are trying to connect? this is my connect function to connect with database, I think there is problem with this coding. Please can you help. Public Sub connect() sconn = “Data Source=SUJAL;Initial Catalog=staff;User ID=sa;Password=longtail” scon = New SqlClient.SqlConnection(sconn) scond = New SqlClient.SqlCommand [...]
View Answer
| February 5, 2009 3:50 AM
Database connectivity, Setup and deployment, SQL Server 2000, VB Setup File, VB.NET, Visual Basic, Visual Basic .NET
Single “Filler” Field Flat File vs Multiple Fields Defined Flat File
Hi, If you have fields defined, then it’s not really a “flat” file anymore. I can’t honestly think of what you gain or lose by doing this, unless you’re going to define the file completely with every possible field. If you need to access data in position 2-3 and you don’t have that position defined [...]
View Answer
| February 4, 2009 11:25 AM
Flat files, Multiple Field Flat Files, Single Field Flat Files
Hi, If you have fields defined, then it’s not really a “flat” file anymore. I can’t honestly think of what you gain or lose by doing this, unless you’re going to define the file completely with every possible field. If you need to access data in position 2-3 and you don’t have that position defined [...]
View Answer
| February 4, 2009 11:25 AM
Flat files, Multiple Field Flat Files, Single Field Flat Files
Sending a message from Access thru Lotus
replace de disign of you database to a 6.5 template. it should work **ADDED 02/03/09** If the error message is correct, my guess is you are using COM from MS Access to create a backend Notes/Domino document, then using the Send method to send it. However, you are likely setting the first parameter of the [...]
View Answer
| February 3, 2009 4:44 PM
Lotus Notes 6.5, Lotus Notes 8.x, Lotus Notes email error, Lotus Notes error messages, Microsoft Access
replace de disign of you database to a 6.5 template. it should work **ADDED 02/03/09** If the error message is correct, my guess is you are using COM from MS Access to create a backend Notes/Domino document, then using the Send method to send it. However, you are likely setting the first parameter of the [...]
View Answer
| February 3, 2009 4:44 PM
Lotus Notes 6.5, Lotus Notes 8.x, Lotus Notes email error, Lotus Notes error messages, Microsoft Access
Configuring a SQL Server to optimize for best performance
The only way to truly optimize performance is to monitor (using perfmon/profiler) and test. You need someone with the expertise to do this, or someone who can learn the rudimentary tools and give it a shot. But, I would recommend either hiring a consultant (I can give some recommendations) or maybe using Microsoft’s “health checkup” [...]
View Answer
| February 2, 2009 10:51 PM
ODBC, SQL Server 2005, SQL Server performance, SSMA, Sybase, Windows Server 2003, Windows Server 2003 R2
The only way to truly optimize performance is to monitor (using perfmon/profiler) and test. You need someone with the expertise to do this, or someone who can learn the rudimentary tools and give it a shot. But, I would recommend either hiring a consultant (I can give some recommendations) or maybe using Microsoft’s “health checkup” [...]
View Answer
| February 2, 2009 10:51 PM
ODBC, SQL Server 2005, SQL Server performance, SSMA, Sybase, Windows Server 2003, Windows Server 2003 R2
Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)
That error usually arises when you try to access a non-existent element on a collection. To debug this, you could place all the code inside the for loop in an if-then-else block to make sure you are referencing only existent elements. Something like this: <pre>for i in g_change_tab.first..g_change_tab.last loop if <b>g_change_tab.exists(i)</b> then select count(*) into [...]
View Answer
| February 2, 2009 8:24 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers
That error usually arises when you try to access a non-existent element on a collection. To debug this, you could place all the code inside the for loop in an if-then-else block to make sure you are referencing only existent elements. Something like this: <pre>for i in g_change_tab.first..g_change_tab.last loop if <b>g_change_tab.exists(i)</b> then select count(*) into [...]
View Answer
| February 2, 2009 8:24 PM
ORA-06533, Oracle 10g, Oracle 10g triggers, Oracle triggers, Subscript beyond count, Triggers
How to call trigger stored in database using Oracle Forms
You can’t call database triggers directly. You should use a stored procedure instead. You can call stored procedures the same way you do for Forms local procedures. Please provide more information if you need further help.
View Answer
| February 2, 2009 7:55 PM
Oracle development, Oracle Forms, Oracle triggers, Triggers
You can’t call database triggers directly. You should use a stored procedure instead. You can call stored procedures the same way you do for Forms local procedures. Please provide more information if you need further help.
View Answer
| February 2, 2009 7:55 PM
Oracle development, Oracle Forms, Oracle triggers, Triggers
Connecting to Oracle with Visual Basic 2005?
Your question is not clear enough, at least for me. You should be able to connect from any version of Visual Basic to an Oracle database.
View Answer
| February 2, 2009 7:26 PM
Database connectivity, Oracle connectivity, Visual Basic 2005, Visual Basic 2008, Visual Basic 6
Your question is not clear enough, at least for me. You should be able to connect from any version of Visual Basic to an Oracle database.
View Answer
| February 2, 2009 7:26 PM
Database connectivity, Oracle connectivity, Visual Basic 2005, Visual Basic 2008, Visual Basic 6
Crystal Reports OBDC (Oracle)
Are you using the same database user when connecting from Crystal than when connecting from Access ? It could be a problem of missing privileges or synonyms.
View Answer
| February 2, 2009 7:22 PM
Crystal Reports, Database connectivity, ODBC, Open Database Connectivity, Oracle connectivity
Are you using the same database user when connecting from Crystal than when connecting from Access ? It could be a problem of missing privileges or synonyms.
View Answer
| February 2, 2009 7:22 PM
Crystal Reports, Database connectivity, ODBC, Open Database Connectivity, Oracle connectivity
Career advice for moving from development to SAP
Really, you, Aditi, have a good skill for SAP. With your knolewdge of Java it is possible to be SAP Portal Developer or XMII Developer. But if development is not interested for you any more you always could try to be a SAP tester.
View Answer
| February 2, 2009 5:22 PM
Career development, IT careers, Java developer, SAP careers
Really, you, Aditi, have a good skill for SAP. With your knolewdge of Java it is possible to be SAP Portal Developer or XMII Developer. But if development is not interested for you any more you always could try to be a SAP tester.
View Answer
| February 2, 2009 5:22 PM
Career development, IT careers, Java developer, SAP careers
getting started in security
A good understanding of network fundamentals will help you. The Cisco certifications are vendor specific but will teach you a lot of foundational knowledge. The CompTia Network+ is not vendor specific and will help you also. A good mix of both vendor-specific and general education will be the best plan. CompTia’s Security+ is a good [...]
View Answer
| February 2, 2009 4:54 PM
CCNA, CCSP, Certifications, IT careers, Security careers
A good understanding of network fundamentals will help you. The Cisco certifications are vendor specific but will teach you a lot of foundational knowledge. The CompTia Network+ is not vendor specific and will help you also. A good mix of both vendor-specific and general education will be the best plan. CompTia’s Security+ is a good [...]
View Answer
| February 2, 2009 4:54 PM
CCNA, CCSP, Certifications, IT careers, Security careers
Access 2007 – How to include option group on report
I always put my variables in a seperate table (like printpara). I attach it in the report query so that I have these on every line in my query and so I can put it where I want on my report. Like in your exemple, i would put it in the page header. I you [...]
View Answer
| February 2, 2009 8:13 AM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 Reports
I always put my variables in a seperate table (like printpara). I attach it in the report query so that I have these on every line in my query and so I can put it where I want on my report. Like in your exemple, i would put it in the page header. I you [...]
View Answer
| February 2, 2009 8:13 AM
Access 2007, Database programming, Microsoft Access 2007, Microsoft Access 2007 Reports
What are the most overused tech buzzwords for 2008?
My list of overused IT buzzwords/acronyms: - Smart Phone - Mobile Broadband - Virtualisation - REST - AJAX Nandu:-) _________________________________________________________________ Might I ADD: Value – Add! …and Is there a better way to say Solutions? Please, no more Cloud Computing? GREEN anything … Bailouts and Financial Crisis… Bush Bashing ! Bob VL _______________________________________ Not really [...]
View Answer
| January 30, 2009 10:39 PM
AS/400, Buzzwords, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Technology, Virtualization, VoIP
My list of overused IT buzzwords/acronyms: - Smart Phone - Mobile Broadband - Virtualisation - REST - AJAX Nandu:-) _________________________________________________________________ Might I ADD: Value – Add! …and Is there a better way to say Solutions? Please, no more Cloud Computing? GREEN anything … Bailouts and Financial Crisis… Bush Bashing ! Bob VL _______________________________________ Not really [...]
View Answer
| January 30, 2009 10:39 PM
AS/400, Buzzwords, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Technology, Virtualization, VoIP
Monthly Average in Access 2007
Riaan, In Access 2007, try working with the table in Pivot table view. Open the table, go to the Views group, click the arrow and select Pivot table. Then, for example, you could add the Date field to the row field, then add the Data field you want to average to the detail area. You [...]
View Answer
| January 30, 2009 1:41 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average
Riaan, In Access 2007, try working with the table in Pivot table view. Open the table, go to the Views group, click the arrow and select Pivot table. Then, for example, you could add the Date field to the row field, then add the Data field you want to average to the detail area. You [...]
View Answer
| January 30, 2009 1:41 AM
Access 2007, Access 2007 functions, Database programming, Microsoft Access, Microsoft Access 2007, Monthly Average
AS/400 to SQL Server 2008
Rmason It’s been a few years and it wasn’t 2008. But, as I remember it …. Need client access installed on the server system — it contains ODBC driver If you go to create a new data source you should see Client Access ODBC driver I don’t remember any big issues creating a DTE or [...]
View Answer
| January 28, 2009 9:50 PM
AS/400, AS/400 to SQL Server 2008, ODBC, SQL Server 2008
Rmason It’s been a few years and it wasn’t 2008. But, as I remember it …. Need client access installed on the server system — it contains ODBC driver If you go to create a new data source you should see Client Access ODBC driver I don’t remember any big issues creating a DTE or [...]
View Answer
| January 28, 2009 9:50 PM
AS/400, AS/400 to SQL Server 2008, ODBC, SQL Server 2008
What is the market value/salary for a Exchange system administrator and MCSA on messaging
Here is a good site to look up <a href=”http://www.itjobswatch.co.uk/jobs/uk/exchange%20administrator.do”>global pay scales</a>. Good luck to you!
View Answer
| January 27, 2009 4:54 PM
Certifications, Exchange administrator, IT careers, IT salaries, MCSA, Microsoft Certified Systems Administrator, System administration, System administrator
Here is a good site to look up <a href=”http://www.itjobswatch.co.uk/jobs/uk/exchange%20administrator.do”>global pay scales</a>. Good luck to you!
View Answer
| January 27, 2009 4:54 PM
Certifications, Exchange administrator, IT careers, IT salaries, MCSA, Microsoft Certified Systems Administrator, System administration, System administrator
Need help with Oracle query
Select Top 1 * From (Select Top 3 * From EmployeeTable Order By Salary) Order By Salary Desc Another way to do this would be to use the rank functionality (which will bring back all employees that have the 3rd highest salary, where employees might have the same salary): select employee, salary from (select employee, [...]
View Answer
| January 26, 2009 3:55 PM
Oracle development, Oracle queries, Query optimization
Select Top 1 * From (Select Top 3 * From EmployeeTable Order By Salary) Order By Salary Desc Another way to do this would be to use the rank functionality (which will bring back all employees that have the 3rd highest salary, where employees might have the same salary): select employee, salary from (select employee, [...]
View Answer
| January 26, 2009 3:55 PM
Oracle development, Oracle queries, Query optimization
new career
Are there any local universities in the area? Because a lot of the larger universities will have a working professional program and often times they will even work with your current employer to help pay for it. Just a thought. Hope this helps! -Schmidtw I worked as an Admissions Representative for DeVry and Westwood College. [...]
View Answer
| January 25, 2009 8:51 PM
Careers in networking, CCNA exam, IT careers, Networking, Networking careers, Training institutes
Are there any local universities in the area? Because a lot of the larger universities will have a working professional program and often times they will even work with your current employer to help pay for it. Just a thought. Hope this helps! -Schmidtw I worked as an Admissions Representative for DeVry and Westwood College. [...]
View Answer
| January 25, 2009 8:51 PM
Careers in networking, CCNA exam, IT careers, Networking, Networking careers, Training institutes
Suggestions and guidance for IT courses/career
A lot of companies are looking for linux administrators. A CCNA will help because that will cover the networking requirement. Don’t discount IT management. Companies always require a fresh influx filling bottom management ranks, and people who can progress. Price Waterhouse Cooper and Carnegie-Mellon’s CyLab have recent surveys that show the senior executive class to [...]
View Answer
| January 23, 2009 4:20 PM
Career development, CCNA, Certifications, Cisco certifications, Cisco Certified Network Associate, IT careers, IT education, IT training, Linux administration, Linux certifications, Networking certifications
A lot of companies are looking for linux administrators. A CCNA will help because that will cover the networking requirement. Don’t discount IT management. Companies always require a fresh influx filling bottom management ranks, and people who can progress. Price Waterhouse Cooper and Carnegie-Mellon’s CyLab have recent surveys that show the senior executive class to [...]
View Answer
| January 23, 2009 4:20 PM
Career development, CCNA, Certifications, Cisco certifications, Cisco Certified Network Associate, IT careers, IT education, IT training, Linux administration, Linux certifications, Networking certifications
Oracle – Deleting a row from a complex view
What error message or code (ORA-XXXX) are you getting ? is it ORA-01752 ? Can you post your view’s query here (so we can see how complex the view is) ?
View Answer
| January 23, 2009 3:22 PM
DELETE statement, Oracle administration, Oracle Complex View, Oracle development
What error message or code (ORA-XXXX) are you getting ? is it ORA-01752 ? Can you post your view’s query here (so we can see how complex the view is) ?
View Answer
| January 23, 2009 3:22 PM
DELETE statement, Oracle administration, Oracle Complex View, Oracle development
