Can't access website outside local when doing .webtests

Question

Alright I'm trying to set up .webtest for doing load/stress tests at our company and it can do all the company's local DEV/QA test servers just fine... but they try accessing outside resources / websites and they don't work/fail.... I can't seem to figure out why they don't work so i just delete those lines, but that won't simulate real load tests if they fail to load everything and are unable to simulate real world access of our websites.

Like i said it access our local stuff just fine but not anything else...

I use visual studio 2010 ultimate and the project type is under TEST and you make .webtest and then make .loadtest to run your scripts using your .webtest to simulate 250+ users at a time

If anyone can help me out that would be great.... Was thinking it might be something to do with how the company handles there gateway to the outside or something... sorry not much of a network guy and have no idea how i would ask the question to find out... 

Answer 1

can any body solve this SQL code running total, it is not working  MS ACCESS Database?

 

ID-OrderID-OrderDate-Amount-Running_Total

1-1-11/11/2016-120-120
2-2-11/11/2016-40-160
3-3-11/11/2016-30-190

4-4-11/11/2016-80-270

 

<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.*"%>
<%@ page import="java.util.Calendar" %>
<%
//java Code 25/11/2016

try
{
String date = (new java.util.Date()).toString();
String OrderDate=request.getParameter("OrderDate");


int OrderID = Integer.parseInt(request.getParameter("OrderID"));
int Amount = Integer.parseInt(request.getParameter("Amount"));
int Running_Total=Integer.parseInt(request.getParameter("Running_Total"));

String sql_debit="select OrderID,OrderDate,Amount,(select sum(Amount) from CustomerOrders where OrderID <= OrderID)'Running_Total' from CustomerOrders";
String s="jdbc:odbc:Database2";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection(s);
Statement pstmt=conn.createStatement();
Calendar calendar = Calendar.getInstance();
java.sql.Date startDate = new java.sql.Date(calendar.getTime().getTime());

ResultSet result = pstmt.executeQuery(sql_debit);
//int count = 0;
while (result.next())
{
//result.getInt("Running_Total");
Running_Total = result.getInt(1);
//result.getInt(1);
String output = "User #%d: %s ";
System.out.println(String.format(output, Running_Total));
}
conn.close();
}
catch(Exception ex)
{
System.err.println(ex.getMessage());
}
%>

</body>
</html> 

Answer 2

Use regex those are best for validation for phonenumbers,pincode and so on

http://stackoverflow.com/questions/28716539/how-to-validate-pin-code-mobile-number-and-email-in-javascript

For saving and rerieving images

http://stackoverflow.com/questions/21452418/source-code-to-store-image-into-mysql-database-and-retrieve-it-and-display-in-js