Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ASP > ASP database not working on Internet

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-16-04, 22:12
chiina73 chiina73 is offline
Registered User
  
Join Date: Jan 2004
Posts: 5
ASP database not working on Internet
I made a simple asp site including a MS Access database. Everthing shows fine on my local PC but after uploading to the internet all that happens when you go to the page containing the asp database is I get prompted to download open the file.

Thank you for any help
Reply With Quote
  #2 (permalink)  
Old 01-16-04, 22:23
gyuan gyuan is offline
Registered User
  
Join Date: Dec 2003
Posts: 454
Can you post the code which is the connection to database?
Reply With Quote
  #3 (permalink)  
Old 01-17-04, 10:07
chiina73 chiina73 is offline
Registered User
  
Join Date: Jan 2004
Posts: 5
code
I will show you my site. When you click each pic, you can go to my asp pages, and you can see the code.
http://home.cogeco.ca/~chiina/profession.htm
Thank you for your help.
Reply With Quote
  #4 (permalink)  
Old 01-17-04, 15:23
paulanthony paulanthony is offline
Registered User
  
Join Date: Oct 2003
Location: Belfast
Posts: 16
Re: code
Thats more than likely a problem with your server. You should check with your hosting that they actually supports asp scripts.

Regards,

Paul.
__________________
---------------------------------------
Make something idiot proof- and someone will make a better idiot
----------------------------------------
Reply With Quote
  #5 (permalink)  
Old 01-18-04, 13:51
chiina73 chiina73 is offline
Registered User
  
Join Date: Jan 2004
Posts: 5
Re: code
Actually, when I uploaded my asp pages without link to the database, it shows fine, so I was guessing they do have a support for asp hosting.
When I uploaded the pages with database, it only shows code.
Do you know why this happens?
Thank you again for your help.
Reply With Quote
  #6 (permalink)  
Old 01-18-04, 22:34
rnealejr rnealejr is offline
Registered User
  
Join Date: Feb 2002
Posts: 2,232
Can you include a link on your website for the asp page that does work without the database reference ?
Reply With Quote
  #7 (permalink)  
Old 01-19-04, 00:06
chiina73 chiina73 is offline
Registered User
  
Join Date: Jan 2004
Posts: 5
Link
This is a link to my asp page which is shown correctly.

http://home.cogeco.ca/~chiina/testtest.asp

Thank you.
Reply With Quote
  #8 (permalink)  
Old 01-19-04, 10:23
gyuan gyuan is offline
Registered User
  
Join Date: Dec 2003
Posts: 454
Can you post the code for the files testtest.asp and soaps.asp?
Reply With Quote
  #9 (permalink)  
Old 01-19-04, 22:04
chiina73 chiina73 is offline
Registered User
  
Join Date: Jan 2004
Posts: 5
code
What do you mean by that when you say CODE? I am very new to make database website and I am not sure what I am doing here but these are all I can see from testtest.asp and soaps.asp pages sources.

testtest.asp
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
This is a test for asp./
</body>
</html>

soaps.asp
<%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// DesigntimeType="ADO"
// HTTP="True"
// Catalog=""
// Schema=""
var MM_Soaps_STRING = "dsn=soaps;"
%>

and other asp site starts something like this.

<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/Soaps.asp" -->
<%
var rsUniqueS__MMColParam = "Unique Sculptures";
if (String(Request("MM_EmptyValue")) != "undefined" &&
String(Request("MM_EmptyValue")) != "") {
rsUniqueS__MMColParam = String(Request("MM_EmptyValue"));
}


I am making website with Dreamweaver MX so I am not familiar with the code. I am wondering if these site doesn't show on the net because of DSN is not set up correct?
Reply With Quote
  #10 (permalink)  
Old 01-20-04, 04:37
paulanthony paulanthony is offline
Registered User
  
Join Date: Oct 2003
Location: Belfast
Posts: 16
Try this script

I'm pretty sure your server doesn't support asp. A page saved as ASP with no "code" in it will still display because the html renders however your "database" pages dont because they are using code.

<%=Response.Write("I support ASP")%>
__________________
---------------------------------------
Make something idiot proof- and someone will make a better idiot
----------------------------------------
Reply With Quote
  #11 (permalink)  
Old 01-20-04, 04:40
paulanthony paulanthony is offline
Registered User
  
Join Date: Oct 2003
Location: Belfast
Posts: 16
In addition your host is running

Zeus/4.2 on HP-UX

Someone more techy will tell us if ASP pages are possible on this platform. Majority of ASP hosting runs Windows.
__________________
---------------------------------------
Make something idiot proof- and someone will make a better idiot
----------------------------------------
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.