CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> ASP

 need help

Print topic Send  topic

Author Message
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
View profile  Send private message
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
View profile  Send private message
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
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.