Shown below is ASP Code sample that tries to access a method,CreateUser in the server called,
"http://smallbutsmart.basis.com.au" using the protocol,XMLHTTP. Can you explain to me why this
Code does not work and showing the correct Code Sample?
I cant use Microsoft.XMLHTTP object's Send method for posting a form. Can anyone help?
The form field is
<input type="hidden" name='content1' value='Add User'>
But when i post
objXMLHTTP.Send "content1=Add User"
an error occurs.
Neither of these works:
objXMLHTTP.Send "content1='Add User'"
objXMLHTTP.Send "content1=""Add User"""
How could I use POST method to transfer parameters with XMLHTTP?
With GET all works correct, but with POST I get a problem.
client.asp with GET - all works .....
I have a peculiar problem using the method
Server.CreateObject("MSXML2.ServerXMLHTTP") in order to get a connection
from one server to another.
On my personal host (IIS) the above method works perfect, and I can 'include' an HTTP stream from a remote URL into my own page. However, the method doesn't work on another webserver (IIS, too) although the MSXML2.ServerXMLHTPP method is installed (I checked it).
The error message I get there is:
msxml3.dll error '80072ee2' The operation timed out
This error does only appear if I try to get data from a remote URL, if I try to get data from http://localhost/foo, the method works - I believe the webserver is behind a proxy. Would this cause any problems? And if so, how can it be solved?
- Do you guys know of any other solution how to 'emulate' the php
include command in ASP without using the MSXML2.ServerXMLHTTP method?
Shown below is ASP Code sample that tries to access a method,CreateUser in the server called, "http://smallbutsmart.basis.com.au" using the protocol,XMLHTTP. Can you explain to me why this Code does not work and showing the correct Code Sample?
<%
dim objXMLHTTP
set objXMLHTTP = Server.CreateObject("Microsoft.XMLHTTP")
objXMLHTTP.Open "Post", "http://smallbutsmart.basis.com.au", false
'objXMLHTTP.SetRequestHeader "Content-type", "text/html"
'objXMLHTTP.CreateUser "abc","123","Scriven","1","001","qms"
objXMLHTTP.Send
%>
I'm trying to run the below script on my website and keep getting the ever unhelpful
....
msxml3.dll error '80004005'
Unspecified error
....
on line 11
when i ran this on our intranet server at work it worked fine but on my personal site it wigs out can anyone spot anything wrong in the code?
<%
strLink = request("linkval")
strLinkDescr = request("desc")
If Not Left(strLink,7) = "http://" Then
strLink = "http://"&strLink
End IF
set xmlreq = Server.CreateObject("MSXML2.serverXMLHTTP")
'on error resume next
xmlreq.open "GET",strLink,false
xmlreq.Send ""
PageStatus = xmlreq.status
If err.number<>0 or PageStatus <> 200 then
Select Case PageStatus
case 404 PageResponse = "Page Does not exist (404 error)"
case 401 PageResponse = "Access was denied (401 error)"
case 500 PageResponse = "Internal Server Error encountered on remote site"
case else PageResponse = "Remote Server is: down, not accepting connections or does not exist"
end Select
Else
PageResponse = "Remote server was located and URL is valid."
XMLResponseText = xmlreq.responseText
End If
set xmlreq = nothing
response.Write(PageResponse&"<br />"&XMLResponseText)
%>
I'm trying to use the Stream ADO object, and I need to access a file that is on a remote server.
I tried using the FileSystemObject object, but I need to save a CSV file that contains some funky characters.
The documentation I have access to does not tell me that I can or cannot enter in a remote location...(e.g. "http://10.10.10.10/foo/foobar.csv")
I receive this error:
ADODB.Stream error '800a0bba'
File could not be opened
Code:
Got a quick query in relation to the Server.Transfer method available in IIS
5+/ASP. I've got an issue where I want to take a portion of an online app and
extract this out into a web site on its own, so I will end up having two web
sites. This planned to aid problems we've been having with performance, as if
the portion (which is an app in its own right) has problems we then have to
restart the whole site and so bring everything down just because of the
portion of the app which we're having issues with. Taking the portion of the
site will allow us to run it in isolated mode in ISS and so just restrat that
if needed, while not affecting the rest of IIS.
Anyways, I'm in the process of writing a jump page to facilitate the process
of moving from the first site to the new second site, but as we need to reuse
session info created in site 1 I need a way of passing this over to the
second site.
I've been aware of the Server.Transfer but never really used it so I'm not
too sure how I can actually use this. I was planning to write an ASP page
that takes the required info out of session is site 1, calling
Server.Transfere to send it over to the second site. I don't want to do a
Response.Redirect, not wanting the client to do this and not allowing it to
know what info I'm using in the session.
And so, I thought the Server.Transfer would facilitate this, but after
reading some of the documentation on MSDN I'm not sure I can, ie: redirect to
another ASP page in this way and tack on a QueryString holding all the
session info I need, as MSDN says that I'll get an 'ASP 0173 error, "Invalid
Path Character"' error if I have a question-mark '?' in the path, or any
other of a list of invalid chars. But then I need this '?' char to build my
QString ie: XXX.asp?sas=123&jdy=0689...
So what I'm after is some clarification that I can use Server.Transfere in
this way or not, ie to redirect to an ASP page and tack on a QueryString, of
if it just allows for an ASP page without s QString. So then if I want to do
this I might need to use the Response.Redirect method, or some other way!!
MSDN also says: "When you use the Transfer method, the state information for
all the built-in objects are included in the transfer. This means that any
variables or objects that have been assigned a value in session or
application scope are maintained"
....So will I have the session info from site 1 available in site 2 after the
redirect or does this only apply for a Server.Transfer within the same web
(which I think is what it means!).
I don't have an environment up that I can test this on yet so I'm kinda
feeling may wat in the dark here, hence my lengthly post.
I need to map a path to my database file automatically, if I move the application to a different direcotry level I still have to write part of the path to get the application to work.
Is there anyway I can translate the directory path and place inside the mappath function so I dont have to manually edit it?
cst = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &
server.mappath("shopsmartnetworkcartcart.mdb")
Wondered if anyone could help me out with some simple connection string problems I'm having.
Ive got this on the page so far and it works:
----------------------------------------------
Dim strConnString
set strConnString = server.createobject("adodb.connection")
strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=c:Inetpubwwwrootdlnforumforumadminwwforum.mdb"
strConnString.open
-----------------------------------------------
But I want to change it to a Server.MapPath method, so I tried the following:
------------------------------------------------
Dim strConnString
set strConnString = server.createobject("adodb.connection")
strConnString.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & Server.MapPath("forum/admin/wwforum.mdb")
strConnString.open
---------------------------------------------------
But now I get the following error:
-------------------------------------------
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)
Operation was canceled.
Can anyone help me out?
Our asp programs seem to have different behaviors when users use IE and firefox. One of most annoying things is the data disappearing problem in IE but not in firefox.(Note: Sometimes a search program can run much faster in Firefox than in IE, don't know why)
For example, I have an internal user interface which they can do different product data
entry, the program will use Server.Transfer to different asp program for data entry.
Page1---UserInterface.asp
Select Case Request("Product")
Case "Sel"
Server.transfer("/Virtualdir1/test1.asp ")
Server.Transfer("/Virtualdir2/Test2.asp")
Case "Bear"
Server.Transfer("/Virtualdir3/test3.asp")
Case "IMED"
Server.Transfer("test4.asp")
Case "AC"
Server.Transfer("/Virtualdir4/test5.asp")
Case Else
End Select
When user finished data entry on test1.asp(second page, the web address will still show UserInterface.asp page as you know), click continue, on the third page if they found something typed wrong, if they click back button in the broswer, all data on the second page is gone. This only occurrs in IE, Firefox is fine.
It's very annoying, how can I fix it, if not, is there any other way?
I have made a asp page that will read a db table and select certain fields concerning the current day's activities to be written to a text file. After the information about the current day's activities has been compiled, it is stored in a variable and written to a text file.
What I would like to do is create a text file for each day instead of over-writing the same one. Is there another Server.CreateObject method that will allow the 'creation' of a text file rather than just over-writing a text file that already exists? I would use "month(date)", "day(date)","year(date)" to append to a text file name to keep it unique.
Below is what I currently use to create a text file. But any new information will only overwrite what is already contained in the text file. Code:
I have an Access DB connected to an IIS via ODBC, and use ASP pages to get info to/from the DB. My guys in IT now want to migrate the Access DB to SQL Server. Can anybody tell me what this implies in terms of :
a) syntax of my ASP pages
b) syntax of my SQL statements
c) other problems I may not have thought of.
I am told it is really easy, however, I just cannot get is to work. BTW, I have activated the "SQL Syntax" option in Access, in case that helps any.
This might be more of a database question than ASP. But when you create a database and then create relationships with the database, once you open an asp page say to create a new record; once the record is saved, shouldn't it also update the relationship with the table involved?
Unless I am doing something wrong, it is not updating the second table; for example:
rs.AddNew
rs("username") = Request.Form("txtUserName")
rs("password") = Request.Form("txtPassword")
rs("firstname") = Request.Form("txtFirstName")
rs("lastname") = Request.Form("txtLastName")
rs("email") = Request.Form("txtEmail")
rs.Update
Response.Write("Record has been added!")
Say the information is entered, because of the UserID field is "autonumber", that would be my primary key: so "1" would be related with the second table where I have:
upload.id (PK)
userID
Upload1
date1
Upload2
date2
Upload3
date3
If on the other table I have number of uploads to generate, whenever it adds a document, it would have the relationship of the username, and the upload:
But when I do that, even adding the code, it does not update the code. So what am I doing wrong? Do I have to do another Add.New at the same time for the second table?
I ask this here because as ASP Developers I figure you have more experience with windows Webhosts. I know Phpmyadmin is usually provided on Apache platforms to manipulate MySQL databases. What interface is usually provided by webhost to access and manipulate your Microsoft SQL databases?
View Replies View RelatedCan any help me on how to use ASP to access a mail server? I need to send an email from the web but i don't want to use "mailto" as the contents sent using "mailto" is messy.
View Replies View RelatedI am at a loss trying to set the connection string to connect to an access db on a web server from a secure server! i have tried using the ipaddress of the webserver in the file name and the http: url but to no avail.
View Replies View RelatedI have always used PHP and MySQL to do anything database related on the web, however I find myself in a new situation. I've been handed the daunting task of creating a (relatively) simple, partially database driven website for my company's intranet.
The one problem I have is that all of our servers are Windows 2000 based because all of the in-house software we have works off of SQL Server... and I've never touched a windows based server, SQL Server, or ASP in my life.
Searching through the forums, I've been able to find a few ASP tutorial sites, but everything I've found seems to be either all technical info and no basics or a basic tutorial written for people who are already familiar with Visual Basic, C, or another type of windows programming 'thing'.
I have a database in MS Access and have one table in it (tblcontest) which has 30 fields in it, I want to export all the fields into Sql Server 2000, any idea how to? PS: I dnt wanna create all the fields manually one by one in SQL Server.
View Replies View RelatedWish I'd found the thread yesterday before spending half the day fighting
the same battle and finding a workaround. But at least it explains why my
final approach worked.I set the remote folder as a virtual folder on the webserver, assigned web rights to a domain user and used fso.copyfile(server.mappath) to copy a
file created locally.I'm not thrilled that access to the remote location can't be controlled at the user level this way but at least access to the calling script can.
Strange though, the problem showed up during a migration. Server A had been
hosting this asp page and connecting to server B sucessfully. I was moving
the application to server C when I ran into the problem. All three machines
are W2K, same service pack, same domain, same users, same access
rights/method configuration. Go figure.
I was given the following by my host:
Database name: asdfafasf
IP/Host: 11.111.11.111
Server: asfafaf
Username: afafdadaf
Password: adfadf
Every program I use (excluding Enterprise Manager - I don't have it) to connect is unsuccessful. Access Projects for example, when I try to establish a connection, it doesn't ask for IP/Host.
I have admin privileges on a remote server and would like to use a web interface (asp) to manipulate various files. It seems that when I access the remote web pages I only have IWAP and IWAM privileges. Is there a way to automatically send my admin username and password via the asp pages so I will have admin privilages?
View Replies View RelatedI've been using URL asp shopping cart (free version) for a while with an access database and it worked perfectly.
My store is very popular now (more than 200 simultaneous users) and I need to migrate to a professional database. Comersus is compatible with SQL Server and mySQL. Which one do you recommend? My idea was to use mySQL since in that case I can purchase Power Pack Medium ($239) instead of Premium (.$370)
Im changing from Access to SQL Server and had a few questions:
What is the Equivalent in SQL:
Access: Memo Field
Also, for my Autonumber field, which is Identity in SQL Server, why can I only go up to (int) 4 in Length for SQL Server?
I am about to migrate my asp web pages from a previous well functioning connection with Access 2003 to SQL Server 2005 Express Edition instead.
I have created a database in SQL Server called "test_db". As far as I know I have not set any particular user id or password for the database.
In this microscopic database I have onnly a single table called "name" and in this table I have two columns called "fname" and "lname". I have two records stored in the name table. What I want to achieve is simply to display these two records in my asp-page.
How can I achieve this and what am I missing here?
I have an ASP page which has commands to access a SQL Server 2000 database. Ex:
rsDatabase.ConnectionString = "Provider=SQLOLEDB;Data Source=xx.xxx.xx.xxx,yyyy;Initial Catalog=ABCDEF;uid=john;pwd=smith"
This line returns the following error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
1. There is not much load on both the web and sql server and this is the only connection which I'm trying to open with the database.
2. I have tried connecting to the database using the System DSN, but it won't connect
3. On some days and at some times, the page works perfectly with no complaints.
I have a web form to publish data to a ms sql database. Everything works great on my local machine which I use for development. When I uploaded the form and connection file to our web server, I receive the following:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
/psc/Connections/psc_lms_db.asp, line 5
Here is the connection string I am using: Code:
i am using persists mail component for sending emails. all my pages were working fine 2 days ago, but suddenly it started giving me error as below:
Server object error 'ASP 0178 : 80070005'
Server.CreateObject Access Error
/contest/thankpage.asp, line 183
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
View Replies View Relatedisit possible to access variables (code) from ASP server script to ASP client page?? take for example the code supplied below:
'server script
<%@ Language=VBScript %>
<%
dim svalue
svalue="access me"
%>
'client code
<HTML>
<BODY>
<SCRIPT LANGUAGE="VBScript">
dim x
x = svalue 'svalue isfrom server script
response.write x
</SCRIPT>
</BODY>
</HTML>
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
The SQL statement is as follows: Code:
When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
View Replies View RelatedI've published my asp file to the website. I've uploaded all the asp files including access database and it works fine. But the record is not updated until i upload the latest database.
Actually the updated database stored in the my local server. Is it possible to access the database on my local server? It means, user can access all the updated directly.