CJWSoft Support Info: Having trouble with ASPProtect. Need help

Active Info

Memberlist

Help

ASPProtect Version 8.x Support
CJWSoft Support Info : ASPProtect Version 8.x Support

Info: Having trouble with ASPProtect. Need help

Author

Message

<< Prev Info | Next Info >>

garymgordon
New User

Joined: November/22/2008
Location: United States
Online Status: Offline
Info: 6

Added: November/23/2008 at 12:49am \| IP Logged

I just purchased v8 this evening. I'm trying to get it working.

Here's some background.

1.   I am running this on a Windows 2008 Server.
2.   I have Parent Paths enabled.
3.   I have SSI enabled and set up for .shtml, .shtm and .stm (but I can't seem to figure out how to get it to work with .asp and .html pages as well. (Again I'm on a Windows 2008 server.)
4.   I had an SQL database that was already set up and I ran your sql script (using the Query) to add the information. I followed the instructions in

SQL Database Creation (NEW INSTALL)

5. All my permissions on the folders are correct.
6.   I am using the correct username and password when trying to connect to the MS SQL database. The database is on a different server and I am using the correct IP address for that server.
7.   I downloaded an SSI sample script of:
 
which works fine and displays the day of the week.

Here are my problems.

1.   When I add the following:

to any .asp or .html page (even an empty page with nothing else on it), I get a 500 error.   You can see an example of this at:
http://www.comebackagainsoon.com/loginaccess/test.asp ; ... and on
http://www.comebackagainsoon.com/loginaccess/test.html .. I just get a blank page.

NOTE: ASPProtect is installed in the folder called   loginaccess (which is directly off the root of http://www.comebackagainsoon.com/

I need to know what's wrong and causing this. I also need to know how to be able to run an Include file from within an .asp or .php or .html page.

2.   When I try to connect to my MS SQL database it doesn't work.

I again keep getting a 500 error message.

My connection string looks like this:

ConnectionString = "Provider=sqloledb;Data Source=xxxxx;Initial Catalog=xxxx;User Id=xxxx;Password=xxxx;"

So I don't know why it's having a problem. I am able to use the same username, password, data source to connect to other MS SQL databases.

Since I expect to have thousands of users logging into the system, I need to use MS SQL and not MS Access for my database.

NOTE: I am able to connect at the moment to the MS Access database. I just can't seem to connect to the MS SQL database.

Please let me know what I need to do in order to fix these issues.

Thanks,
Gary

__________________
Gary M. Gordon
ggordon@garymgordon.com

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: November/23/2008 at 10:52am \| IP Logged

I need to know the real error. Error 500 is not helpful.

There is probably one of two reasons you're seeing an error 500 and not the real error.

Friendly error messages may be on in your browser
http://support.cjwsoft.com/code/moreinfo11-1.htm

IIS7 may not be configured to show them
http://blogs.iis.net/bills/archive/2007/05/21/tips-for-class ic-asp-developers-on-iis7.aspx

Once we know the real error we can continue.. I can tell you this.. Connecting to a sql server on a different machine requires that various things in sql server be set up to allow that. I'm pretty sure you have to open up that sql server to allow that sort of thing. That is something I consider the responsibility of the server admin as it really has nothing to do with the asp code in my applications. I will of course still try to help, but we need to know what the real error is. I have a server admin buddy who I can ask if it comes right down to it.

As for everything else you told me regarding SSI etx etc.. I don't think we need to worry about any of that. If you got the application working with MSACCESS then all those settings are fine. ASPProtect uses a lot of server side includes and if it was running they were working.

__________________

Best Regards, Christopher Williams www.CJWSoft.com

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: November/23/2008 at 10:57am \| IP Logged

Also, in the future please PM me any info that might be sensitive like your connection string. I x'd all those values out for you. We don't need someone trying to get into your sql server.

Now maybe you gave me altered info ? I don't know.
Just don't want anything bad happening there.

__________________

Best Regards, Christopher Williams www.CJWSoft.com

garymgordon
New User

Joined: November/22/2008
Location: United States
Online Status: Offline
Info: 6

Added: November/23/2008 at 12:25pm \| IP Logged

I got the error message to show properly.

It says:

Untitled Document

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'Replace'

/loginaccess/check_user_inc.asp, line 80

Gary

__________________
Gary M. Gordon
ggordon@garymgordon.com

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: November/23/2008 at 12:27pm \| IP Logged

oh, that should be an easy one.

Go to the admin area... you didn't fill out all the url values on the settings screen.

__________________

Best Regards, Christopher Williams www.CJWSoft.com

garymgordon
New User

Joined: November/22/2008
Location: United States
Online Status: Offline
Info: 6

Added: November/23/2008 at 12:35pm \| IP Logged

I got this to work.

I didn't copy and paste in all of the URL's to the various pages (under settings). Once I did this it worked.

But my other question is ..

How can I get this to work and password protect html, htm, php, and other pages using SSI?

Gary

NEXT ... the issue with SQL we just need to finish up and get working.

__________________
Gary M. Gordon
ggordon@garymgordon.com

garymgordon
New User

Joined: November/22/2008
Location: United States
Online Status: Offline
Info: 6

Added: November/23/2008 at 12:43pm \| IP Logged

By the way .. I sincerely appreciate your quick replies to help me and that you're available to assist me over a weekend. Thank you VERY much!!! I just hope I can get this to work with pages other than .asp and also get the MS SQL database to function properly. Thanks again.

__________________
Gary M. Gordon
ggordon@garymgordon.com

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: November/23/2008 at 12:48pm \| IP Logged

ok, I'm not sure where you got this idea about protecting non ".asp" pages with ASPProtect.. Cause that just isn't going to happen.

You see Active Server Pages means ".asp"

The page extension must be ".asp" or the server will just ignore any ASP code in the source.

You can rename a ".htm" or ".html" extension to ".asp" and then you can protect it with ASPProtect and it will work fine...

You can't do it with a ".php" extension though because PHP is an entirly different programming Language. PHP and ASP do similar things but they don't work with each other.

http://en.wikipedia.org/wiki/PHP

http://en.wikipedia.org/wiki/Active_Server_Pages

__________________

Best Regards, Christopher Williams www.CJWSoft.com

garymgordon
New User

Joined: November/22/2008
Location: United States
Online Status: Offline
Info: 6

Added: November/23/2008 at 1:57pm \| IP Logged

Damn. I sincerely appreciated your help. But I guess I'm going to have to purchase another application since I actually need to be able to password protect PHP pages. This was my mistake. I just thought with the SSI that I'd be able to do this in the PHP pages.

I guess I can't request or get a refund since it was my mistake, etc.

By the way, do you know of any similar apps that you could recommend for use with PHP pages?

Gary

__________________
Gary M. Gordon
ggordon@garymgordon.com

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: November/23/2008 at 2:26pm \| IP Logged

yes sorry. no refunds on digital source code..

search Codango for PHP applications..
http://www.codango.com/

__________________

Best Regards, Christopher Williams www.CJWSoft.com

garymgordon
New User

Joined: November/22/2008
Location: United States
Online Status: Offline
Info: 6

Added: November/23/2008 at 3:12pm \| IP Logged

Ok.

No probem. It was my mistake.

Question .. since I won't be using it for the website I thought I was going to use (since it is needing PHP protection), .. I know my license is for 1 domain. So, is it difficult for me to move it to a different domain (when ever I find the need to use this script)?? What will I need to do to move it to a different domain?

Thanks again for all your help.

Gary

__________________
Gary M. Gordon
ggordon@garymgordon.com

cwilliams
Admin Group

CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769

Added: November/23/2008 at 3:14pm \| IP Logged

that's fine

__________________

Best Regards, Christopher Williams www.CJWSoft.com

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

Printable version

Info Jump

You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area