Hi all, I have set out some data, however I am not sure if it is possible to list it in a specific way

For each product (prod_ID) there is events that happen, no matter what date the event is (like lines 20-24 & 32 & 33)
product is the Formula 1 event

For each departure (dep_ID) there would be different things happening (like lines 25 & 31)
departure is the specific package (where as there could be different-longer packages with different itinerary)

Data:

TABLE: prod_itin
itin_ID	brand_ID	cons_ID	date_added		itin_live	prod_ID	dep_ID	itin_day	itin_IATA_start	itin_start	itin_finish	itin_IATA_finish	itin_item
20		GPT		1	9/08/2017 1:00:00 PM	Yes		3		1		AEGPA		1:00:00 PM	2:30:00 PM				Free Practice 1
21		GPT		1	9/08/2017 1:00:00 PM	Yes		3		1		AEGPA		5:00:00 PM	6:30:00 PM				Free Practice 2
22		GPT		1	9/08/2017 1:00:00 PM	Yes		3		2		AEGPA		2:00:00 PM	3:00:00 PM				Free Practice 3
23		GPT		1	9/08/2017 1:00:00 PM	Yes		3		2		AEGPA		5:00:00 PM	6:00:00 PM				Qualifying
24		GPT		1	9/08/2017 1:00:00 PM	Yes		3		3		AEGPA		5:00:00 PM						Race
25		GPT		1	9/08/2017 1:00:00 PM	Yes			6	1		AUH		2:00:00 PM						Check-in
31		GPT		1	9/08/2017 1:00:00 PM	Yes			6	5						10:00:00 AM	AUH			Check-out
32		GPT		1	9/08/2017 1:00:00 PM	Yes			6	1		AEGPA		8:00:00 PM						Concert: Calvin Harris
33		GPT		1	9/08/2017 1:00:00 PM	Yes		3		4		AEGPA		8:00:00 PM						Concert: P!NK

TABLE: prod_deps
dep_ID	brand_ID	cons_ID	date_added		dep_live	prod_ID	dep_date	dep_type	dep_conf	dep_sold	dep_prod	

Select all Open in new window

…

Hi experts, please help me  understand what's the reason why some computers cannot  get the message from the server while trying to  accessed it? The codes below is trying to test the server response how the server deal with the response. My laptop is able to get message while some of my destops, pc cannot. I'm using chrome to all computers but some of my computers cannot get the message from the server. The alert box message will appear blank but some computers able to obtain the message.

Js

 function iSaveToServer(x)
{
	if (window.XMLHttpRequest)
	  {// code for IE7+, Firefox, Chrome, Opera, Safari
	  xmlhttp = new XMLHttpRequest();
	  }
	else
	  {// code for IE6, IE5
	  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
	  }
	xmlhttp.onreadystatechange=function()
	  {
	  if (this.readyState==4 && this.status==200)
	    {
	        	var str = this.responseText; 
	        	alert (str);
	    }
	  }                                             
		xmlhttp.open("GET","SendMsg.asp?a="+ x, true);
		xmlhttp.send();
}

Select all Open in new window

Asp

<%
dim msg
msg = request.querystring("a")

response.write("test-1")
response.end()

%> 

Select all Open in new window

I am having issue trying to get my Web Application published and running correctly on our IIS server.

When I test from within Visual Studio 2015 with the same ODBC driver setups, everything works fine.  It is only once I try to publish the Web Application and access it off the IIS webserver in a browser that I am getting an issues.

I am using Visual Studio 2015 v14.0.25431.01 Update 3

The IIS server is a 64-bit Windows 2016 server

The ODBC driver is a Progress OpenEdge 11.6 driver - 32 Bit

The ODBC connection is setup using the 32-b it ODBC Manager found in c:\windows\sysWOW64\odbcad32

I came across many forums that say to make sure that the ODBC driver is setup correctly, and using the correct ODBC manager, which it is.

I also came across some posts that reference compiling the Web Application and specifying in the Configuration manager to use x86 instead of Any CPU.  x86 is not an option when I go into the configuration manager.

I am at a loss as to how to resolve this error so that I can access the new Web Applications from the IIS server.


The error I get is...

Server Error in '/' Application.

ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception …

I have some text files, I handle them with asp

Some have á that I can replace with "á"  no problem (same for other accented characters)

But they also have:

á   I print to the screen and thay come up as á

I try to

datos=replace(datos,"á","á")

But the replacement doesn't happen.

Any ideas?

Hi experts, Due to poor connection or internet connectivity I encountered an error that says; "The source you are looking for has been removed, had its changed or is temporarily unavailable" this message is coming from the response of the network.  I am using ajaz as the code shown below and here I want to catch the error and put it in an alert box. Is this possible using the code below? Please help. Thank you!

Js

function iGetPerona(x,code,inv)
{				
	if (window.XMLHttpRequest)
	  {// code for IE7+, Firefox, Chrome, Opera, Safari
	  xmlhttp = new XMLHttpRequest();
	  }
	else
	  {// code for IE6, IE5
	  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
	  }
	xmlhttp.onreadystatechange=function()
	  {
	  if (this.readyState==4 && this.status==200)
	    {
	        var msg = this.response;
	        alert(msg);
	    }
	  }                                            
		xmlhttp.open("GET","SavePersona.asp?a="+x + "&db="+ mcCode + "&b=" + code + "&c=" + inv, true);
		xmlhttp.send();
}

Select all Open in new window

For a decade I had in place code that would add and update data in MSSQL tables. The code has stopped working, giving me errors such as this e:

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor does not include the table being modified or the table is not updatable through the cursor. 

Select all Open in new window

In order to solve the problem, i tried to simplify what am doing with a test program, the code of which appears here:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>

<head>
<!--#Include virtual ="includes/OpenData.asp"-->
<!--#INCLUDE Virtual="/includes/GlobalDefaults.asp"-->
<!--#Include virtual ="includes/adovbs.inc"-->
</head>
<body><%
strIP        = Request.ServerVariables("REMOTE_ADDR")
strEmail 	= "info@webuidler.us"
strTelephone = "516-123-4567"
strSQL =	"INSERT INTO [tblFeedback](Email,Telephone,IP,TimeStamp) "&_
				" VALUES ('" & strEmail& "','"& strTelephone & "','"& strIP & "','"& now & "');" &_
				"SELECT @@IDENTITY FROM [tblFeedback];"
Set RS = cnnData.Execute(strSQL).NextRecordset
iFeedbackID = cInt(RS.Fields(0))
RS.Close
set RS = nothing
response.write "New ID: " & iFeedbackID & "<br>"


set RS = Server.CreateObject("ADODB.RecordSet")
RS.Open "select * from tblFeedback where FeedbackID =" & iFeedbackID,cnnData,adOpenDynamic,AdLockOptimistic
RS("FullName") = "Lawrence Seltzer"
RS.Update
RS.Close
set RS = nothing
response.write "Record " & iFeedbackID & " updated with new information.<br>"
%>
</body>
</html>

Select all Open in new window

the opendata.asp file simply opens the database:

<%
dim cnnData
Set cnnData = Server.CreateObject("ADODB.Connection")
cnnData.Open "Driver={SQL Server};server=mssql3.webuilder.cc;UID=jkrasna_admin; PWD=xxxxxxxx; database=jkrasna_data;"
%>

Select all Open in new window

adovbs.inc contains the values for adOpenDynamic & AdLockOptimistic

The first part of the program works fine, and the record is correctly inserted.

The second part fails with error at the top of this question.
I use this logic in many different programs, across many different clients:
1. Create an object for a record set
2. Find the appropriate record
3. modify the field in the record
4. save the changes - this is the line that causes the error.

I was told that new security updates to MSSQL servers are what caused my working code to stop working.

If so, how can I quickly and easily work around this? I want to make as few changes as possible because there are so many other programs out there on my client websites that have this same problem.

Thank you.

Experts - I am getting pdfs from different people with different formats.

Ex: I may have 6 different templates or formats of PDFs.

Need to create something where I need to import PDF and design a template and choose what field to import in excel. Can someone guide me on freewares or something that I can create or any live examples please.

Hi experts, I wanted to know how server pc handle the multiple clients while accessing the data at the same time. I am beginner developing web programming, and have a little background of vb6 language. Here what I exactly wanted to know, I have a server side Asp named, GetProduct.asp When in terms of response to the client upon the request, does it matter the response of it base on the number of clients having a request? Since I've only one GetProduct.asp How could the server handle it? Let's say, for example 1,000 clients who have requested to inquire the product at exactly the same time, does the response of the server will cause a delay because of the multiple request? if it could cause the traffic because of the numbers of request, should I need to assign GetProduct.asp per client? I hope you (experts) can give some insight about this. Thank you!

Hello I have this code in HTML and VBScript

<HTML>
<HEAD>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
<META http-equiv="Pragma" CONTENT="no-cache">
<TITLE>Support</TITLE>


<title>Form to Support</title>
<style type="text/css">
<!--
.style1 {color: #ffffff}
.BotonExit {
	color: #ffffff;
	background-color: #ff0000;
}
.BotonSubmit {
	color: #ffffff;
	background-color: #336699;
}
.BotonReset {
	color: #ffffff;
	background-color: #336699;
}
-->
</style>
</head>
<body> 
<SCRIPT>
	
</script>

<%



'Single Variable Declarations
Dim myString, racecn, cn, stringrace

racecn = Request.QueryString("racecn")

if racecn = "" then racecn = "General Topic"

Session("cn") = racecn

Session("maestrocn") = racecn


%>



<div align="center">
<form method="POST" action="cdosys.asp" name="form1">




<%
Response.Write("Question: <b>" & Session("cn") & "<br /></b>")
%>



 	



</form>
</div>
</body>
</html> 

Select all Open in new window

now this code is .asp and I call like http://xxx.xxx.xxx/file.asp

For example if I want to pass special characters like:

http://xxx.xxx.xxx/file.asp?racecn=M%F3dulo%201%20exp

The results are:

M�dulo exp

The result must be: Módulo 1 exp

How can be fixed?

Note:

If I use like this:

http://xxx.xxx.xxx/file.asp?racecn=Módulo%201%20exp

works but I don´t want that because I´m passing the variables from other page.

Then what can be added or removed to the script above to accept:

http://xxx.xxx.xxx/file.asp?racecn=M%F3dulo%201%20exp

and results in:

Módulo 1 exp

instead of the corrupted M�dulo exp

Thank you

I have a <form method ="post" action="action.asp">
<input type="text" name="data" value=<%=string%>>

When the string is very long  (say 256K) it is not passed to action.asp.

When I set
data=request.form("data")

And response.write data

I get an error.

Not allowed

Wtih shorter strings it works fine. This is on my server windows 2012 iis 8.

I am sure there is a setting to allow larger strings. I just cant figure out where to set/reset it

Any ideas?

I have 10TB of client data, spread across hundred of millions of files, avg size 200KB, stored in millions of folders, served from an EC2 instance acting like a traditional NAS, using Windows File System on a Windows Server 2003 R2 EC2 server.

These data are uploaded and downloaded through our Classic ASP site, served from IIS websites, reading/writing data through UNC (network path) to the NAS.

Storage on AWS are expensive (storage+snapshot+ec2), so I would like to move to S3, but still maintain proper security, so files are not available to everyone on the Internet if they know URL.

Any recommendations to this approach? How to maintain support through Classic ASP? Anyone did this storage migration in the past in same Windows environment? How to maintain client security?