Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 24th, 2005, 11:27 PM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default upload asp to the web

hello
i have another question.would you asnwering me?i want to upload my asp pagesand it is the first time that i'm uploading asp to net.as you know i've written my pages with Dreamweaver and Dreamweaver itself make a connection page separatly in a folder that called connections.i want to know wich changes i should make to view my pages in intenet correctly.i didn't see any server name in my connection page.would you please help me again to solve this problem?
and i'm very thankfull of mr imar.He helped me very much and i think if he didn't help me i couldn't write my programs.

  #2 (permalink)  
Old July 25th, 2005, 08:43 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

i upload my pages and i recieve this error:
Active Server Pages error 'ASP 0126'

Include file not found

/login.asp, line 2

The include file 'Connections/QCcon.asp' was not found.
would you please help me.i don't know how should i write my connection


  #3 (permalink)  
Old July 25th, 2005, 02:10 PM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

I think the error message says it all: on the server the Connections/QCcon.asp file is missing. Either upload it manually, or locate file in Dreamweaver, right-click it and choose Put. This sends the file to the remote server.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: The Bends by Radiohead (Track 2 from the album: The Bends) What's This?
  #4 (permalink)  
Old July 26th, 2005, 12:06 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

i uploaded manualy once again and problem is fixed now.shouldn't i make any changes in connection page that macromedaiDreamweaver itself made it???

  #5 (permalink)  
Old July 27th, 2005, 02:50 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Sure you can change these files to whatever you see fit. In fact, there is a high probability that you need to change these files, as it's likely you're using a different connection string (e.g. other database file name, other server and so on) on your production server.

Don't forget to Put the file when you have made the necessary changes.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Kelly watch the stars by Air (Track 4 from the album: Moon Safari) What's This?
  #6 (permalink)  
Old July 28th, 2005, 01:39 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

i checked that file but i didn't find any database name or server name.the code is as below:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_QCcon_STRING
MM_QCcon_STRING = "dsn=QCcon;"
%>
thank you

  #7 (permalink)  
Old July 28th, 2005, 02:09 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

This connection string uses a local DSN. To make that work on the remote server, you'll need to recreate the DSN with the same name on the remote server. With a shared host / provider, this is usually something the system administrator does for you and then gives you the name.

Alternatively, look at www.connectionstrings.com for alternative connection strings....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
  #8 (permalink)  
Old July 28th, 2005, 02:30 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

thank you.i will change my connection page

  #9 (permalink)  
Old July 28th, 2005, 04:28 AM
Friend of Wrox
 
Join Date: May 2005
Location: tehran, tehran, Iran.
Posts: 201
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to hastikeyvan
Default

i insert codes below to my connection page but it gives me error for those codes(ofcourse i substitute my data base name,username,password and server instead of the codes below.please help me to fix the proble.one thing else sould i put my DSN value ???
"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asda sd;"
"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connect ion=yes;"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
and what is oConn?is it my connection name???should i remove all codes that i had before and just put these codes?

  #10 (permalink)  
Old July 28th, 2005, 04:36 AM
Imar's Avatar
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

First things first; you need to determine a few things before you can do this.

Are you using a DSN? Have you, or our system admin set up a DSN? If so, you should use that name. If not, you need to find out the proper names for your SQL Server installation, and how to connect to it (user name, password, integrated security and so on).

oConn is most likely a connection object defined somewhere in your code. But it looks like you copied this from a windows application (because of the adPromptAlways value).

How do you expect to connect to the app? Where is your server located? Do things work on your local machine?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.




Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP Upload vin_0x1 Classic ASP Databases 1 June 24th, 2006 05:35 PM
Upload a Text file from a Web Client to SQL Server petercyriljones Classic ASP Professional 0 May 20th, 2005 10:26 AM
Is it required to upload vti_cnf files...into web? ashokparchuri General .NET 1 May 20th, 2005 09:02 AM
how to upload a mysql db on web server umair_rathore MySQL 2 May 14th, 2005 05:46 AM
how to upload asp pages to web 222 Classic ASP Basics 1 June 10th, 2003 02:31 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.