If an ASP page works locally on your system but doesn't work remotely on the web hosts server and your only alteration to the page before uploading is your connection string to make it point in the right direction on their server then surely the fault has to be the path to the servers database doesn't it?
Or is there another possibility why the page would show up an error page.
I am using CDONTS to send mail to the user from my ASP application.
However, the code doenst works all the time. I am able to get mails but
nothing happnes most of the time. The code works maybe once in 20 tries.
What could be the reason?
i posted earlier, and the response seemed to be there is
another dll i need to use the cdonts object, i used it
fine for awhile on my old setup, i upgraded to 2k3 and it
errors up as if cdonts isnt an object. So is there a dll
i need to have to use the cdonts object in iis 6 or do i
need to rewrite my code to use cdo? (if so, please provide
asp 3 example on how to send an email with recepient,
sender, body and subject)
I have got a problem wit da FILESYSTEM in ASP coding. Before I use window 98 installing PWS. Everything works fine....
And now, I use Window XP professional ( Laplop ), everything is updated ( Service Pack, .NET component, ASP.net stuff...
All my ASP code with FileSystem which used to be properly ran cant be executed on my XP server.
There is no message error on da page, but the browser icon keeps spinning and da content is blank, it means u dont see anything happens. I wanna ensure dat all da code is right, cos it work properly with PSW and other servers. I even tested with a simple code, but It still doesnt work..... Code:
I'm using SQL Server and I decided to convert one of the fields from nvarchar to ntext. The transition in the manager was all right, but my ASP pages wouldn't display the ntext and there is no error message. I use Code:
<%=rs("Text")%>
to display the ntext...and there is nothing.
I have a database table with several records. Now I am filtering some data based on the "where" statement. If I run the query in analyzer then I get 20 rows. If I run the same query in asp and assign GetRows() to an array, then the array returns only 4. I am not sure if I am using the GetRows wrong. Here is a snipp of my code:
View Replies View RelatedI have a site with the directory structure like this:
wwwroot (where the default.asp and other pages sit)inc (where the includes are)login (where login pages are)otherDirs (where other pages are)datafiles (where database is)
I usually hard code the db connection path but want to use the MapPath now in case in the future my site moves servers (have been though that and having to manually change all db connection strings - Not Fun ) Code:
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:
I'm have a VB function that connect to SQL SERVER , get's information
and returns the relavant string.
using this function within VB application (say cmdbutton) works great,
but when trying to activate the function from asp page, i'm getting
nothing. Code:
I've been setting up an IVR server that needs to be able to directly update databases(remote data input from field reps). The database which I'm trying to get to is in fpdb of the ISS server. It is spewing this information at me: Code:
View Replies View RelatedI want to download or save a file from remote location to my local computer everyday. for example. i have an excel file . so i need to write a script to download this file automatically everyday. How do i do this.
View Replies View RelatedI need help bad. I have an ASP page that is used by a program in our office to upload clients information to an access database. I'm trying to convert this whole process ti MYSQL but the program does not recognize PHP files to upload data and their is no way to change that. I have contacted the vendor and they said they only support access and not mysql.
If you click on the link it will download a zip file of the page i need help with. What i am trying to do is leave the asp format as is so that the data can upload to a mysql database instead of a access DB. I know there is a way to connect ASP to mysql, but he methods i have tried have been unsuccessful.
1 - Yes, Norton Internet Security 2003
2 - NTFS
3 -
Radio button selected = "A directory located on this computer"
Checked = "read", "log visits", "Index this resource"
Execute permissions drop down = "Scripts only"
Application protection drop down = "Medium (Pooled)"
I have tried
<p style="page-break-before: always;"></p>
and
<style type="text/css">
.break{page-break-before: always;}
</style>
But it seems no work. I really take a page break for a particular row. How can I do it?
I have created 2 asp pages called testa.asp and testb.asp
testa.asp has a link to go to next page testb.asp
testb.asp has a form that ask you for a reference number and post it
to the same page testb.asp
If the reference number is not blank, it will just write out what the
reference number is.
Now my problem....
If you go to testa.asp and click on the link to go to testb.asp you
will see the form. At this point, if you click the back button, it
till take you back to testa.asp ALL FINE SO FAR.
If you go to testb.asp again and see the form, enter a number say 33
and click on search. This will now show you the number you have just
entered. NOW - click on the BACK BUTTON, it will just show you exactly
the same page ! WHY does it not go back to the FORM in order to refill
in a different number. Code:
ASP does not work locally on my main web site when I browse the machine locally at the console itself, but to the outside world all is fine, and ASP executes normally.
I have 4 other virtual webs on this server and I can browse ASP pages fine, locally. We need this working for a search engine product that is failing when trying to execute URLs against this virtual web site, locally. Code:
When I type in the url...URL I get an error saying I'm unauthorized to view the page?
View Replies View RelatedIs there a program like xampp for ASP? where it will allow me to preview locally without having to upload?
View Replies View RelatedI'm using formmail.asp which is an emailing utility. Basically, the user
fills out a request page, clicks "Submit" and the page posts to formmail.asp
which emails the user information.
I'm running IIS5 on a Win2k server box and recently ran the Windows Updates
(the last time I do that). Anyway, that emailing form doesn't work now on
any of the sites I host. Any ideas?
I am receiving the following error whenever I attempt to run any ASP from localhost:
"The page cannot be displayed. There is a problem with the page you are
trying to reach and it cannot be displayed."
At the bottom of the page is states the following:
"HTTP 500 - Internal server error Internet Explorer"
Any ideas?
Having a permission problem I'm guessing but I have a ASPX page with a link to a Crystal Reports created PDF. On the local machine it access the pdf file without any problem. All other machines come up with the 'The page cannot be displayed' error.
I'm using form authentication and for testing purposes only the IIS6 application pool is using the identity 'Local System'. I've checked permission on all files and all are set correctly. Any other ideas anyone?
I have a query in ASP that does a select * from table
It doesnt retun all columns!
When i use objRS("columnname") I get blank. This only effects some colums and I fix it by using
select *,missingcolumn1,missingcolumn2 from table
I wrote the code for Members of Register. and i use cookie in this code, My database is SQL server. SQL server dosent support the cookies in my codes i dont know why this cause but my codes are working without any cause .
View Replies View RelatedMy ASP page contains the following VBScript code:
<%
zipCode = Request.Form("zip")
%> <br>zip: <%= zipCode %>, rf: <%= Request.Form("zip") %>
When I enter "abc" into the "zip" field on the form, I get the
following output:
zip: , rf: abc
Why doesn't the first statement assign the "abc" string to the
variable "zipCode"? What am I not seeing?
My friedn is using PWS on NT4 machine, its a local machine, whenever he directs to an .asp page, visual interdev starts.
How can we over ocme this.I had solved this problem long time ago. Now i dont remember. Also to install IIS4.0 do we need to install MTS? if yes, where can we get
it?
I'm using an ASP page to display all our office printers, I want the users to have to possibility to install the network printer with just one click on the page. Is this possible. ?? PS all information is retrieved from SQLServer.
View Replies View RelatedWhen we send a mail using the code below,we do not get simplified chinese characters if they are present in the body but we get junk in the mail and we need to change the mails encoding to simplified chinese to see the Chinese characters.
'CDONTS object
set objMail = Server.CreateObject("CDONTS.NewMail")
objMail.MailFormat = 0
objMail.SetLocaleIDs(65001)
objMail.From = sFromEmail
objMail.To = sToEmail
objMail.Subject = sSubject
objMail.Body = sMessage
objMail.Send
set objMail = Nothing
I have one field char type data length 1.. It has data either 1 or 2 in all the field tht I have checked through enterprise manager.
I'm running query:
"select * from table" and fetching all the records and displaying...
It display all the data except data from this field..Doesnt display anything..
I had put Response.write rs("fieldname")
What could be the problem?
(incidentally, the more i look at it, the more i feel i should point out that to be totally sure your SQL statement is correct you should write it like:
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)
so that you know your info is going to the right column on the table
I use the ASP page to test whether the connection of SQL Server is fine. I use windows authentication. I get fail when I attempt to use hostname of the destination server. Contrary, I get success when I attempt to use IP address of the destination server. Does anyone know how to fix this issue?
View Replies View RelatedI created connection to the Microsoft Access DB using DSN from my ASP page.
<%
Set vpconn = Server.CreateObject("ADODB.Connection")
vpconn.ConnectionString =
"File Name=c:inetpubwwwrootDBDNAME.dsn"
vpconn.Open
' Close connection immediately after opening for testing
vpconn.Close
Set vpconn=Nothing
%>
The Microsoft Access, for every database opened for shared use, creates an .ldb file to prevent users from writing data to pages that other users have locked. Whenever the last user closes a shared database, the .ldb file should be deleted.
It is working; the .ldb file is deleted immediately after closing connection
but not if you open/close this connection from your ASP page.
What I found, the .ldb file is deleted with about 70 seconds delays after closing connection from an ASP page.
We're moving an asp site onto our fedora redhat server and I am fairly sure that I have installed all the proper modules to get apache to read the site properly, but when I bring the site up in Firefox it displays the actual asp code as text. I would assume this means that something is wrong somewhere along the way, and yet when I display the page in ie the site shows up fine? How could this happen?
Looking at it in firefox displays code and ie displays the site (with some errors, but it still displays)I'm a php/mysql personally so I have no experience with this, but as far as I can tell we have apache-asp support installed properly and the site should be showing up.
I have built a site completely with ASP.I am searching for free web host which works with ASP.give me a list web links of fre asp hosters.and i have used drive letters to access my database, how can i remove those drive letters (ex. "c:m.mdb").
View Replies View Related