demo
|
Posted: 01/20/2004, 6:45 PM |
|
1. how can i tell that server is running ASP 3.0 and VBScript 5.5?
my friend is having problem runing asp pages on his win 2000.
he also gets Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified error and some vbscript error, session not working. i had to manually edit dsn string for him to be able to connect to database. whereas on mine i use generated string. could somebody have problem like this running ASP 3.0 and VBScript 5.5? wht about sql? 7 0r 2000 does it matters? some of querry won't work either.
thanks
2. i hve my own ques, if i use appilcation wizard to create an entry form i don't see submit(edit) and delete button.
how can i make those button working b.c the only one that shows is add(submit) button only.
demo
|
|
|
peterr
Posts: 5971
|
Posted: 01/20/2004, 7:04 PM |
|
Re: 1
If you're using CCS, the program will display an error message if you're not using ASP 3.0 and VBScript 5.1 or higher.
You can also print those values in VBScript:
response.write ScriptEngineMajorVersion & "." & ScriptEngineMinorVersion
If you were able to manually edit and fix the database connection string then you can put it back into CCS Connection -> Server, so that next time it will be generated correctly.
It's also possible that the ODBC/DSN name was different on the development computer from the one on the server, in which case you may need to change it every time when switching between the development machine and the server. Also make sure that the DSN is created as "System" DSN, not "User" on all machines.
Re: 2
The submit/edit button appears automatically only if there is something to edit. If it doesn't appear then it means that the program doesn't know which record to edit, and therefore you can only add a new record. You may also want to check if your record key is shown in the URL, for example "user_id" as in: page.asp?user_id=1
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
demo
|
Posted: 01/20/2004, 7:49 PM |
|
thanks.. i'm pretty sure that ODBC/DSN name on developing machine is diff from server. will have him check on that b/c dreamweaver having same problem. that probably the problem.. will let you know if that fixes it..
i changed the string to
ConnectionString = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=db1;UID=login;PWD=;"
from CCS generated string
ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Data Source=dsnname"
User = "login"
Password = ""
what do you mean DSN is created as "System" DSN, not "User" ?
lol at reply no.2
thanks a lot
Demo
|
|
|
demo
|
Posted: 01/21/2004, 8:18 AM |
|
putting the string b/4 generating works
but he is getting problem with session
he is getting this error when ever login/restriction is enable
.................................................................
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'Session'
/testing/Common.asp, line 1413
|
|
|
Demo
|
Posted: 01/23/2004, 7:50 AM |
|
anyone knows reason for this error when login is enabled?
Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'Session'
/login/Common.asp, line 1413
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
Page:
GET /login/list.asp
Time:
|
|
|
DonB
|
Posted: 01/23/2004, 8:50 AM |
|
What does line 1413 contain (and the few lines before that?)?
--
DonB
http://www.gotodon.com/ccbth
"Demo" <Demo@forum.codecharge> wrote in message
news:6401142e16b0be@news.codecharge.com...
> anyone knows reason for this error when login is enabled?
>
> Open the localhost home page, and then look for links to the information
you want.
> HTTP 500.100 - Internal Server Error - ASP error
> Internet Information Services
>
> --------------------------------------------------------------------------
------
>
> Technical Information (for support personnel)
>
> Error Type:
> Microsoft VBScript runtime (0x800A01F4)
> Variable is undefined: 'Session'
> /login/Common.asp, line 1413
>
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322)
>
> Page:
> GET /login/list.asp
>
> Time:
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
Demo
|
Posted: 01/23/2004, 12:44 PM |
|
'CCGetUserLogin @0-4306ED6C
Function CCGetUserLogin()
CCGetUserLogin = Session("UserLogin")
End Function
'End CCGetUserLogin
'CCSecurityRedirect @0-2ACFBE19
Sub CCSecurityRedirect(GroupsAccess, URL)
Dim ErrorType
Dim RetLink
Dim RetLinkParams
Dim Link
ErrorType = CCSecurityAccessCheck(GroupsAccess)
If NOT (ErrorType = "success") Then
If IsEmpty(URL) Then _
Link = ServerURL & "Login.asp" _
Else _
Link = URL
RetLink = Request.ServerVariables("SCRIPT_NAME")
RetLinkParams = CCRemoveParam(Request.ServerVariables("QUERY_STRING"), "ccsForm")
If NOT (RetLinkParams = "") Then _
RetLink = RetLink & "?" & RetLinkParams
Response.Redirect(Link & "?ret_link=" & _
Server.URLEncode(RetLink) & "&type=" & ErrorType)
End If
End Sub
'End CCSecurityRedirect
'CCGetUserID @0-449B3B19
Function CCGetUserID()
CCGetUserID = Session("UserID")....................LINE 1413
End Function
'End CCGetUserID
'CCSecurityAccessCheck @0-DA9F730C
Function CCSecurityAccessCheck(GroupsAccess)
Dim ErrorType
Dim GroupID
ErrorType = "success"
If IsEmpty(CCGetUserID()) Then
ErrorType = "notLogged"
End If
CCSecurityAccessCheck = ErrorType
End Function
'End CCSecurityAccessCheck
|
|
|
Demo
|
Posted: 01/23/2004, 12:48 PM |
|
Here for infor i got from ms site, but not helpful
http://support.microsoft.com/default.aspx?scid=kb;en-us;257625
|
|
|
DonB
|
Posted: 01/23/2004, 3:17 PM |
|
Is the web folder configured as an "application" (in the IIS control panel
does it just show up as a plain yellow folder or is there a blue globe? If
no globe, then that may be it - you need to configure the site to function
as a web site (which is done in the IIS control panel).
--
DonB
http://www.gotodon.com/ccbth
"Demo" <Demo@forum.codecharge> wrote in message
news:640118885db35e@news.codecharge.com...
> Here for infor i got from ms site, but not helpful
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;257625
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
peterr
Posts: 5971
|
Posted: 01/23/2004, 4:51 PM |
|
See: http://www.tokeshi.com/modules.php?op=modload&name=News...rticle&sid=1231
This article looks specific to Citrix, however it talks about something being broken and part of the solution is to reinstall IIS...
Anyway, possibly first try adding "ENABLESESSIONSTATE=True" directly below "Option Explicit" in Common.asp
Also see: http://www.google.com/search?q=vbscript+%22Variable+is+...27Session%27%22 http://groups.google.com/groups?q=vbscript+%22Variable+...27Session%27%22
Especially this more recent thread, again about Citrix problem: http://groups.google.com/groups?threadm=071f01c3b7ac%24...1280a%40phx.gbl
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
DonB
|
Posted: 01/23/2004, 5:06 PM |
|
The key point is:
"This occurs when the //Citrix/MetaFrameXP/WIAdmin directory beneath the Web
root is not recognized by Internet Information Services (IIS) as an ASP
application"
This is the situation I described in a previous post. Your CCS application
is not configured as an application in IIS (you have published to a physical
folder in the IIS root folder (so the pages are accessible to you through
your browser, but you have not configured the folder as an ASP application.
This occurs when you create a new project and hit the "Publish" button in
CCS. For some reason CCS doesn't complete the IIS configuration.
When the folder (either a "site" or a "virtual directory" is not not
configured for application use, IIS will not be able to create a session -
thus the error message sbout the undefined session variable.
Recovery might be more difficult when this happens in Citrix's stuff, but
you do not need to reinstall IIS to get the CCS application to work.
--
DonB
http://www.gotodon.com/ccbth
"peterr" <peterr@forum.codecharge> wrote in message
news:64011c18678bb9@news.codecharge.com...
> See:
> http://www.tokeshi.com/modules.php?op=modload&name=News...rticle&sid=1231
> This article looks specific to Citrix, however it talks about something
being broken and part of the solution is to reinstall IIS...
>
> Anyway, possibly first try adding "ENABLESESSIONSTATE=True" directly below
"Option Explicit" in Common.asp
>
> Also see:
> http://www.google.com/search?q=vbscript+%22Variable+is+...27Session%27%22
> http://groups.google.com/groups?q=vbscript+%22Variable+...27Session%27%22
> Especially this more recent thread, again about Citrix problem:
> http://groups.google.com/groups?threadm=071f01c3b7ac%24...1280a%40phx.gbl
> _________________
> Peter R.
> YesSoftware Support Representative
> http://support.codecharge.com
> Warning: I use Google and CCS Docs/Examples in most of my answers
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
Demo
|
Posted: 01/25/2004, 5:42 AM |
|
This is classic asp file not asp.net if that maters
but how do i make the folder asp application in IIS?
steps?
|
|
|
DonB
|
Posted: 01/25/2004, 6:10 AM |
|
You have a tool called "Computer Management".
At the bottom of the Tree, expand Services and Applications,
drilldown into that to Internet Information Services,
then locate your website.
Double-click it and you will see it's Properties.
There is a tab for either Home Directory or Virtual Directory, which has a
button for "Create".
Just click the button.
--
DonB
http://www.gotodon.com/ccbth
"Demo" <Demo@forum.codecharge> wrote in message
news:64013c7ca68875@news.codecharge.com...
> This is classic asp file not asp.net if that maters
> but how do i make the folder asp application in IIS?
> steps?
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
Demo
|
Posted: 01/27/2004, 11:04 AM |
|
actually that didn't work, He even moved it to another folder that was already configured as application. Im sure there some other settings in IIS because in my system with IIS, i don't have to configure anything in IIS to get session to work.
peterr
when trying ENABLESESSIONSTATE=True as you stated returns same Error Type:
Microsoft VBScript runtime (0x800A01F4)
Variable is undefined: 'ENABLESESSIONSTATE'
|
|
|
peterr
Posts: 5971
|
Posted: 01/27/2004, 11:36 AM |
|
Sory, try:
@ ENABLESESSIONSSTATE = True
or:
<%@ ENABLESESSIONSSTATE = True|False %>
Otherwise reinstall IIS. Not the best solution, but if nothing else works...
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|