Select Statement & Where Clause ….
On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called ‘BUSINESS_UNIT’. On the same page i have created a Combo Box populated by [...]
Answer Question
| July 11, 2012 3:31 PM
ASP, SQL Server 2008, VBScript
On an ASP web page there is a Text Box with default Values for different records. The records are stored in a SQL2008 table called dbo.SOFTWARE and have been type in manually over time and contains many duplicates. The field is called ‘BUSINESS_UNIT’. On the same page i have created a Combo Box populated by [...]
Answer Question
| July 11, 2012 3:31 PM
ASP, SQL Server 2008, VBScript
ASP source connect to System i (AS400)
Hi.Now, I create ODBC of system i access software and config finishedBut, I can not get data form database on System i for showSouce code as below.(It connected to ODBC but can not get data for show)<%ConnectionString= “Driver={iSeries Access ODBC Driver}; System=10.230.1.32; UID=PCS; PWD=PCS;”set con = Server.CreateObject(“ADODB.Connection”)con.open(ConnectionString)Set rs = Server.CreateObject(“ADODB.Recordset”)on error resume nextset rs=server.CreateObject(“adodb.recordset”)sql=”select * [...]
Answer Question
| July 6, 2012 8:09 AM
AS 400, ASP
Hi.Now, I create ODBC of system i access software and config finishedBut, I can not get data form database on System i for showSouce code as below.(It connected to ODBC but can not get data for show)<%ConnectionString= “Driver={iSeries Access ODBC Driver}; System=10.230.1.32; UID=PCS; PWD=PCS;”set con = Server.CreateObject(“ADODB.Connection”)con.open(ConnectionString)Set rs = Server.CreateObject(“ADODB.Recordset”)on error resume nextset rs=server.CreateObject(“adodb.recordset”)sql=”select * [...]
Answer Question
| July 6, 2012 8:09 AM
AS 400, ASP
Doubt regarding ASP% in AS/400
How can i get detials of ASP% for suppose a couple hours back. and how find which job currently running is increasing the ASP ?….
Answer Question
| June 20, 2012 7:10 PM
AS/400, ASP
How can i get detials of ASP% for suppose a couple hours back. and how find which job currently running is increasing the ASP ?….
Answer Question
| June 20, 2012 7:10 PM
AS/400, ASP
Running multiple servers
well i want to execute servlets, asp code and php code the problem is cant able to execute all these three codes in one operating system, is it possible to execute these three. if i made three accounts for each and iam using the windows7 for servlets it is tomcat] for asp iis and php [...]
Answer Question
| May 14, 2012 10:05 AM
ASP, PHP, Windows 7
well i want to execute servlets, asp code and php code the problem is cant able to execute all these three codes in one operating system, is it possible to execute these three. if i made three accounts for each and iam using the windows7 for servlets it is tomcat] for asp iis and php [...]
Answer Question
| May 14, 2012 10:05 AM
ASP, PHP, Windows 7
ASP – Response.Write Object
Hi. I am using the ASP tutorial in www.w3schools.com. When i try out the following basic example it is not showing any results: <html> <body> <% response.write("My first ASP script!") %> </body> </html> [!--response.write("My first ASP script!") --]I have tried other simailar basic examples also with the same outcome. Is there some setting i [...]
Answer Question
| March 16, 2012 5:01 PM
ASP, ASP Maintenance
Hi. I am using the ASP tutorial in www.w3schools.com. When i try out the following basic example it is not showing any results: <html> <body> <% response.write("My first ASP script!") %> </body> </html> [!--response.write("My first ASP script!") --]I have tried other simailar basic examples also with the same outcome. Is there some setting i [...]
Answer Question
| March 16, 2012 5:01 PM
ASP, ASP Maintenance
Redundancy Misconfigured in iSeries-SAN
Oops..new DASD from SAN was misconfigured and loosing redundancy… There are the New Multi Path connections to the SAN for one of the IsERIES server.. note that the Redundancy connections are using the Same BUS. This unfortunately now gives us a single point of failure down to the Fiber channel card. What this means is [...]
Answer Question
| March 17, 2012 3:31 AM
ASP, Fiber Ports, iSeries, SAN
Oops..new DASD from SAN was misconfigured and loosing redundancy… There are the New Multi Path connections to the SAN for one of the IsERIES server.. note that the Redundancy connections are using the Same BUS. This unfortunately now gives us a single point of failure down to the Fiber channel card. What this means is [...]
Answer Question
| March 17, 2012 3:31 AM
ASP, Fiber Ports, iSeries, SAN
Why can’t I connect to SQL Server 2005 through ODBC ?
Hello people, the situation is this: we have 2 computers, one is for local store (let’s call it backend) and the other is a web server (let’s call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS for ASP [...]
Answer Question
| February 28, 2012 3:24 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
Hello people, the situation is this: we have 2 computers, one is for local store (let’s call it backend) and the other is a web server (let’s call it frontend). Both are PCs running Windows Server 2003 SP2 and both have the SQL Server 2005 Enterprise Edition installed. The webserver is using IIS for ASP [...]
Answer Question
| February 28, 2012 3:24 PM
ASP, ODBC Microsoft Access Driver Login Failed, SQL Server 2005 connectivity
iSeries : Current Un Protected Usage.
Hello I see now a days my Current Unprotected Usage is keep touching the threshold value and coming back after some time. I’m not sure which job/jobs are causing the job in doing hike? Is there any way that we can track this?
Answer Question
| February 28, 2012 2:08 PM
ASP, DASD, Memory, RAM
Hello I see now a days my Current Unprotected Usage is keep touching the threshold value and coming back after some time. I’m not sure which job/jobs are causing the job in doing hike? Is there any way that we can track this?
Answer Question
| February 28, 2012 2:08 PM
ASP, DASD, Memory, RAM
Get the ASPs with QYASPOL API from c++
I trying to get the ASP with the QYASPOL API from c++ but the next source code only returns data in the info variable , the receiver looks empty :S , could you point me in the right direction ? #include <QYASPOL.h> #include <stdio.h> #include <qusec.h> #include <QGYGTLE.h> ... typedef struct { YASP_Filter_t filterByNumber ; [...]
Answer Question
| March 19, 2012 12:49 AM
API, ASP, QYASPOL, V5R4
I trying to get the ASP with the QYASPOL API from c++ but the next source code only returns data in the info variable , the receiver looks empty :S , could you point me in the right direction ? #include <QYASPOL.h> #include <stdio.h> #include <qusec.h> #include <QGYGTLE.h> ... typedef struct { YASP_Filter_t filterByNumber ; [...]
Answer Question
| March 19, 2012 12:49 AM
API, ASP, QYASPOL, V5R4
ASP data to be sent to mail
daily basis i want to receive the iseries systems ASP percentage to be sent to my mail
Answer Question
| March 31, 2012 11:44 AM
AS/400 ASP, ASP, ASP Utilization
daily basis i want to receive the iseries systems ASP percentage to be sent to my mail
Answer Question
| March 31, 2012 11:44 AM
AS/400 ASP, ASP, ASP Utilization
AS/400 objects
Is there a way to find out from which ASP a object is retrieved on AS/400?
Answer Question
| March 31, 2012 6:16 PM
AS/400 ASP, AS/400 objects, ASP, ASP (application service providers), iSeries
Is there a way to find out from which ASP a object is retrieved on AS/400?
Answer Question
| March 31, 2012 6:16 PM
AS/400 ASP, AS/400 objects, ASP, ASP (application service providers), iSeries
Monitoring iSeries V5R4 V6R1
hi guys, i would like to monitor my system, i need some software to send a mobile message when the system ASP is to high or when there’s a disk damaged. Is there any native solution on iseries to do stuff like this, or anybody knows a cheap or free software to do it? Thanks [...]
Answer Question
| June 18, 2012 1:37 PM
ASP, iSeries, iSeries V6R1, V5R4, V6R1
hi guys, i would like to monitor my system, i need some software to send a mobile message when the system ASP is to high or when there’s a disk damaged. Is there any native solution on iseries to do stuff like this, or anybody knows a cheap or free software to do it? Thanks [...]
Answer Question
| June 18, 2012 1:37 PM
ASP, iSeries, iSeries V6R1, V5R4, V6R1
difference between QSTGLOWLMT and Threshold in dsk capabilty
there is a confusion regarding the ASP%. Just wanted to know that we have set the ASP% threshold in the SST as 90% and in the System Value is set to 95% as shown below Display System Value System value . . . . . : QSTGLOWLMT Description . . . . . : Auxiliary [...]
Answer Question
| March 18, 2011 10:42 AM
AS/400 administration, AS/400 ASP, ASP, ASP Maintenance
there is a confusion regarding the ASP%. Just wanted to know that we have set the ASP% threshold in the SST as 90% and in the System Value is set to 95% as shown below Display System Value System value . . . . . : QSTGLOWLMT Description . . . . . : Auxiliary [...]
Answer Question
| March 18, 2011 10:42 AM
AS/400 administration, AS/400 ASP, ASP, ASP Maintenance
How to check browser activity?
Hi, i’m working a project ,In that i’m storing login,logout time,wht if i don’t click logout button and close my browser,or somehow my system shutdown.i cannot store the logout time,so that my program will be in error state.. tell me how to get the logout time when my programmer didn’t click logout button and close [...]
Answer Question
| February 25, 2011 2:38 AM
ASP, C# .NET, SQL Server 2005
Hi, i’m working a project ,In that i’m storing login,logout time,wht if i don’t click logout button and close my browser,or somehow my system shutdown.i cannot store the logout time,so that my program will be in error state.. tell me how to get the logout time when my programmer didn’t click logout button and close [...]
Answer Question
| February 25, 2011 2:38 AM
ASP, C# .NET, SQL Server 2005
DSO file wrong pagecount
Hi, (1st post so be gentle ) I am using dsofile.dll to get pagecount from word documents, all i need at this point is pagecount and only word documents at this time. for some documents the pagecount returns as 0 (or invalid in general maybe?) and therefore i’m in need of a solution or a [...]
Answer Question
| September 22, 2010 11:30 PM
ASP, dsofile, VB script, Visual Basic, Visual Basic Script
Hi, (1st post so be gentle ) I am using dsofile.dll to get pagecount from word documents, all i need at this point is pagecount and only word documents at this time. for some documents the pagecount returns as 0 (or invalid in general maybe?) and therefore i’m in need of a solution or a [...]
Answer Question
| September 22, 2010 11:30 PM
ASP, dsofile, VB script, Visual Basic, Visual Basic Script
ADO not receiving errors raised in sub procedure
Hi, I’v known for a while that ado has it’s limits when it comes to dealing with errors… but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that [...]
Answer Question
| September 16, 2010 11:42 AM
ActiveX, ActiveX Data Objects, ADO, ASP, SQL Server 2008, Stored Procedures, VBScript
Hi, I’v known for a while that ado has it’s limits when it comes to dealing with errors… but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that [...]
Answer Question
| September 16, 2010 11:42 AM
ActiveX, ActiveX Data Objects, ADO, ASP, SQL Server 2008, Stored Procedures, VBScript
ASP.net to Sharepoint 2010
hi,I have asp.net web site I need to migrate it to Sharepoint Server,placing the ASP pages in _layout folder I could access the site on sharepoint server, but accessing it requires me to type URL manually in address bar , can’t I migrate it such that it is just another SP site.I alos have added [...]
Answer Question
| August 24, 2010 10:08 AM
ASP, ASP.NET, Sharepoint 2010, SharePoint Server
hi,I have asp.net web site I need to migrate it to Sharepoint Server,placing the ASP pages in _layout folder I could access the site on sharepoint server, but accessing it requires me to type URL manually in address bar , can’t I migrate it such that it is just another SP site.I alos have added [...]
Answer Question
| August 24, 2010 10:08 AM
ASP, ASP.NET, Sharepoint 2010, SharePoint Server
ASP Increased over night; how do I get it back to a normal level?
we have noticed that our 570 box took a ASP hit from 62 % to 81% over a day.I am getting inputs from development staff what was happened ontheir side. Apart from that ,I want to investigate it from administration side what are the new objects saved during that period.but, i’m not sure how to do it. [...]
Answer Question
| August 10, 2010 12:29 PM
AS/400, ASP, DASD
we have noticed that our 570 box took a ASP hit from 62 % to 81% over a day.I am getting inputs from development staff what was happened ontheir side. Apart from that ,I want to investigate it from administration side what are the new objects saved during that period.but, i’m not sure how to do it. [...]
Answer Question
| August 10, 2010 12:29 PM
AS/400, ASP, DASD
deploying an application in cloud platform
Can anyone help me in understanding the enterprise deployment and dedicated host deployment. a) what consists of a package ( we dont provide user the source code and db)and how to package an application. b) testing scenarios staging, developer , production
Answer Question
| October 17, 2010 9:41 AM
ASP, C# .NET, Cloud Computing, Web application deployment
Can anyone help me in understanding the enterprise deployment and dedicated host deployment. a) what consists of a package ( we dont provide user the source code and db)and how to package an application. b) testing scenarios staging, developer , production
Answer Question
| October 17, 2010 9:41 AM
ASP, C# .NET, Cloud Computing, Web application deployment
web-based GPS tracking application development with asp.net
i’m a final year degree student majoring in network computing. i’m developing a GPS related web application where data is being taken from a gps tracker (TK-102), which can send data to a ip address and port number defined. there for i need to save this data to a database and then represent it on [...]
Answer Question
| September 30, 2010 12:52 PM
Application and Web development, ASP, ASP.NET, Database, SQL, Visual Web Developer 2008, Web development
i’m a final year degree student majoring in network computing. i’m developing a GPS related web application where data is being taken from a gps tracker (TK-102), which can send data to a ip address and port number defined. there for i need to save this data to a database and then represent it on [...]
Answer Question
| September 30, 2010 12:52 PM
Application and Web development, ASP, ASP.NET, Database, SQL, Visual Web Developer 2008, Web development
