Local Testing Using SQL Server

I have a SQL server db set up locally. I have a local DSN set up. I have DW connected to the SQL server db and can create Bindings and use Server Behaviors without any problem.
When I try to test the site locally in the browser, I get the following error:

"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database
"xxxxxxx" requested by the login. The login failed."

What am I doing wrong?

View Replies


ADVERTISEMENT

About Testing On Local Computer

I have been teaching myself ASP for several months now and seem to have a pretty good handle on it. All along, I have been uploading changed files directly to the website and refreshing to test.

However, today I will be at a location with no internet access and would still like to be able to work and test my programming. How do I go about testing ASP pages on my local computer without an internet connection?

For now I am not worried about testing any databases or anything, just layout and design.

If it is useful, I am running Windows XP Home edition and I use Dreamweaver to write the ASP.

View Replies View Related

Testing Email From IIS On Local Machine

I have written an asp page that is supposed to send email (using CDONTS). I think my code is correct, but I'm trying to test it from my local machine and although the ASP code runs I am not sure the email portion of the code works.

I have not yet received any messages from the code. Perhaps there is a delay of some sort - or perhaps it is because I am on a network behind a firewall. Whatever the case, could someone offer some suggestions in testing the emailing portion of my code? Code:

View Replies View Related

Sending Email By Using Corporate Exchange Server Instead Of Local Server

I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.

P.S. I’m using Dreamweaver MX2004.

The code that sends email is shown below ....

View Replies View Related

Testing Web Server

I had a mild hack of the default windows web page in inetpub because I was running IIS whilst my DSL connection was on. Ever since,I have disconnected the DSL before running IIS.

Could anyone give me advice on running IIS safely as a local testing server
(for asp pages) whilst online? I have to admit that I run an admin account (win2000) so I know this is one thing I should change

View Replies View Related

Testing Server Error

I'm using Dreamweaver for a number of ASP sites and long ago set up testing servers for each, which worked fine. Now they don't - I just get a 404 message. I've double-checked the testing server address and HTTP address and nothing's changed, so I'm wondering if the address of localhost can have been altered? I've forgotten how to check it, though. Can anyone point me in the right direction?I should say that the only thing that has changed since I last did some testing is that I've downloaded IE7 - is that a clue?

View Replies View Related

Using IIS For LocalHost Testing Server

I trying to run a sample asp web application, using IIS as a localhost testing server. I have created a virual directory called global with path C:/global/asp/. I also have a another website sitting in the default root folder in intpub/wwwroot. then i use localhost my old website home page starts up not my virtual directory site global if I type localhost/global/asp/filename.asp, I get cant find.

What am I doing wrong, what do I have to do to get virtual directory site to run and not the old site in wwwroot folder. I start and stop IIS from the right click from the default web site.

View Replies View Related

Server To Local

An application runs on server, and is used for Hour-registration. Now I want to run the application local, I use SQL Server 2005, and managed to fix connection changes.

But now, I get this error everytime I run the application:

Microsoft VBScript runtime error
Error Code :0x800A01CA

Error source :
Error Description :Variable uses an Automation type not supported in VBScript

Any solution please?

View Replies View Related

Local ASP Server

I need to setup my home computer to view ASP files like I veiw PHP files through Apache2Triad or some other similar installer package.

I'm using Windows XP Home,is this possible?

View Replies View Related

Local Web Server

I have a computer running Windows XP home edition and i would like to have a local web server for testing my classic asp pages.

View Replies View Related

Local Server To Remote Server

I am not an expert but I am trying to create an application where I need to connect my website to the user's(basically my client) database in access and then I will read the values from the database in the local drive and upload all the values in the database at my webspace. I will have everything like the database name and the password....so how can I do this

View Replies View Related

Testing Of Concurrent Users/ Load Testing

How do test my web application for concurrent users (how much concurent user connect at a time and how traffice will be affected and what will the response time?) and how it is done, how long it will takes, does it interfere with current site, etc.?

Reagarding the number of users the site will accomodate is it based on where it's hosted

Application written in ASP/Sql Server. Code:

View Replies View Related

Setting Up Local Server?

What is the best way to set up a server with MSSQL on your local machine. I have IIS set up, and am wondering if there is some way to get MSSQL for testing purposes for a reduced cost? From what I understand, a typical MSSQL license is around $8,000, am I right

View Replies View Related

Local Server Error

I am using Windows XP Pro, and since I updated to Internet Explorer 7 I am having problems getting web sites to work on my PC in Internet Explorer using the local IIS web server. These web sites are using ASP and Access databases.

The two errors I get are:
Operation must use an updateable query or Cannot modify the design of table 'TABLE_NAME'. It is in a read-only database.

Does anyone know how I can get this working so I can test my web sites locally before uploading them to the live sites?

View Replies View Related

Page 2 - Server To Local

Manipulate your asp code in whatever editor floats your boat, but try your code in IIS without your ide and see what happens.

View Replies View Related

Local And Server Script

Code:

strpath1 = rsResults("app_path")
strresult = Replace(strpath1,"","")
%>

<SCRIPT LANGUAGE="Vbscript">
msgbox(strpath1)
</SCRIPT>

What i want to do is pass strpath1 to my locally ran script which is the bit at the bottom but i cant find a way to do it i have tried request.querystring("strpath1")

View Replies View Related

File From Local Machine To Server

im trying to create a intranet site which copies files to the server. im guessing i should use filesystemobject to achieve this but im not sure on how to accompish this.

View Replies View Related

Current Media In Local WMS Server

anyone could assist me in finding an ASP script to find the current playing media in a local Windows Media Services server. Since the particular stream is a broadcast, it will have constantly changing media.

View Replies View Related

Global.asa - Different Behavior On Local And Remote Server?

On a remote server running W2K and thus IIS 5 I have session variables declared in a global.asa file in the root of the application which are passed and visible on all pages with no problem. This was also the case on my localhost before (127.0.0.1), also on W2K / IIS 5. But now for some reason one variable doesn't pass through at all and the other is taken as a String on the localhost.

The problem area in question in my Global.asa file (which is identical on the remote and local servers)

<script language="vbscript" runat="server">

Sub Session_OnStart
CInt(Session("indx"))=0
CInt(Session("total"))=0
...
End Sub

When I view the values locally with:

pprice = Request.QueryString("fpPrice")
Session("total") = Session("total") + pprice
Response.Write "Index: " & Session("indx")
Response.Write "Total: " & Session("total")

I get (for example - pprice = 45, and after 3 attempts):

Index:
Total: 454545

Whereas on the remote server I get:

Index: 3
Total: 135

Has anyone else experienced this?

View Replies View Related

Copy File From Local Comp To Server ?

how can I copy a file from local disk to windows server using ASP (not asp.net)?

I have a control file on my web side, <input type="file" name="file1" />

I choose file on local computer and what function must I use to copy
this file to server ?

View Replies View Related

Copy File From Local Machine On Server

I have one .asp page with form and <input file> field on it.I want to copy selected file from local machine on server.But it doesn't work.

Should I use some component?

View Replies View Related

Automatic File Forwarding From Webserver To Local Server

Having finally mastered freeASPUpload, I really want the files being uploaded to the web server to automatically be forwarded to my local inhouse server. I'm sure there has to be a way.

View Replies View Related

Download File From Server To Local Hard Drive

my current setting is user will click a link in the web page and choose the place that they want to save the file to.

Now i am trying to auto download the file. that means user click the link, it straight away download to for eg. "D:Test". my problem is the web page is at server. user will access the web page thru http, but how am i going to auto download to the user's local drive?

View Replies View Related

Local Sql-server To Web-server

I am using MS-SQL Server2000 on my PC & my webhost is also using the same version.
Now the problem is that I have a lot of data in my local database which I want to port my database on my web-server. Since its lots of data, I can't enter it the conventional way of data-entry. Can someone tell me how to do it.

View Replies View Related

How Do I Export Data Fom Local Database To Server Database?

I'm current working on a project which need to upload local data to
live server database.

Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.

View Replies View Related

Server Time Local Time Convert

I'm trying to do a very simple code that converts the server time into a time zone of your choice.

<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>

but obvisouly i'm having trouble with the time zone convert.

View Replies View Related

App Testing.

test my app? it's still in development but it's very much usable. i'm looking for few good object oriented souls that can look at this. i'm still adding few functions so don't be surprised if it goes down for a VERY short time (minutes really).

View Replies View Related

Cookie Testing

I need to revisit cookie testing. On the home page and every product page I
write a cookie. I do this because some users enter by direct links to
product pages.

<%
Response.Cookies("cookietest") = ("49")
Response.Cookies("cookietest").Expires = Date + 2
%>

On the cart page I test for the cookie...

<%
If Request.Cookies("cookietest") <"49" Then
Response.Redirect("err.asp?e=1")
End If
%>

I have a user that insists he has cookies enabled, yet he keeps getting
redirected to my error page which suggests he does not have cookies enabled.
What could cause this? Is the above too simple for all circumstances?

Is there more extensive code that I could setup on a hidden page where I can
send users to get read out on how they actually have their browsers setup?
i.e. Run a test on their browser and the results are emailed to me.

View Replies View Related

Testing ASP Cookies Using IIS On Win XP Pro

I'm sure I have missed something but I can't see what...

I create two cookies on one ASP page as follows:

response.cookies("Errors") = "Must not be blank"
response.cookies("User")("Mem_Username") = response.write(M_Mem_Username)
response.cookies("User")("Contact_N") = response.write(M_Contact_N)

This page then calls the second ASP page which then reads the cookies:

E_Contact_N = request.cookies("Errors")
C_Contact_N = request.cookies("User")("Contact_N")
C_Mem_Username = request.cookies("User")("Mem_Username")

When I then use response.write (for example, response.write(C_Mem_Username)) to view the contents of the variables, there is nothing there.

As I say, I am still developing the site and so am using IIS on a Win XP Pro machine (local host)

What I am doing wrong?

View Replies View Related

Testing For A Cookie

I know very little about ASP and ASPX pagfes but i inherited a web site done by a guy who knew just a little more than me and I've worked around things with my knowledge of HTML and Javascript, as well as added on to the web site using Cold Fusion. But I am at a point that I need to be able to do more.

I have a ASPX page with a Log In button that I don't want see if a certain cookie exists. Is there a way to test for that cookie on the page and display or not display something based on that test?

View Replies View Related

Security Testing

my system is at testing phase. how do i test my system to check its security especially at the login page? i am running it at localhost. i have tried sql injection but nothing happened. i just saw the invalid login username or password error only.

View Replies View Related

Error Testing ASP And IIS

I have created a page that will allow all web based errors generated to be logged, like IIS errors 404, 403,401, 400.

I am now testing to see if the correct files are being displayed when the errors occur. I am able to replicate the 404 err as well as the 403 error, bu I cannot test the 401 or 400 errors. Does anyone know how to do this?

I tried using err.raise, but it doesnt seem to work, unless i m doing something wrong.

View Replies View Related

Testing Scalability

How can I test the scalability of my website, e.g how can I check if my website still performs correctly when there are 300 people visiting?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved