asked on

Dreamweaver CS3 ASP vbscript returns 500 error on IIS 2k3 box

I have a site on Win2k3 with IIS and am using DW CS3 as my authoring tool. Got a SQL 2k5 DB. Built a client login page using DW. Always worked fine with SQL2k but now I get this error. When I build the page and do not connect the recordset or binding, it appears and performs the basic functions. when I define the recordset and the binding and test within DW i can return the rows of data I want. Then I save the file to the IIS Box and boom, Error 500. WTF!
Does CS4 fix this? Do I have to go learn Visual Studio now?
Thoughts are welcomed.

Wayne Barron

Need some code example to better assist.
Also. Is this DW Generated ASP/SQL Code?

Also.
Make sure that you can view the error's on the page.
In IE go to: Tools | Internet Options | Advanced |
[uncheck] Show Friendly HTTP Error Messages.

This way we can better determin the error.

Carrzkiss

garyoh

ASKER

Yes, this is DW induced code.

Resulting error when attempting to load page is:
Active Server Pages error 'ASP 0141'

Page Command Repeated
/ClientLogin/ClientsLogin1.asp, line 95
The @ command can only be used once within the Active Server Page.

So in looking at that, I see the code below attached.

' The top of the page shows:
<%@LANGUAGE="VBSCRIPT"%>
 
' Then on line 95 it shows:
<%@ Page Language="VB" ContentType="text/html" ResponseEncoding="utf-8" %>

Open in new window

ASKER CERTIFIED SOLUTION

Wayne Barron

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

garyoh

ASKER

Nope, I put your copy in that spot and got another error saying the server didn't understand "VB" and so I put it back as is and then pulled out line 95 to a notepad for safe keeping.
Now my page loads but at the top all the following code loads before the graphics: (See below)

This is, of course, all the code on the page which is now showing. Yikes!

" MM_redirectLoginFailed = "../LoginFail.asp" MM_loginSQL = "SELECT login_nm, login_passwd" If MM_fldUserAuthorization <> "" Then MM_loginSQL = MM_loginSQL & "," & MM_fldUserAuthorization MM_loginSQL = MM_loginSQL & " FROM

Open in new window

garyoh

ASKER

I figured out that i would just delete it and start over. But thanks for pointing the way to the error codes.

Wayne Barron

I am so, so, so sorry.
Put this at the top of the page.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>

Do not blow your page out right now.
It was my mistake at not properly re-writen your code.
I am sorry once again.

Carrzkiss