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.

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

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?

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

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?

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

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.

thank you.i will change my connection page

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?

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.