darkened forest
|
| Posted: 07/03/2004, 12:47 PM |
|
This online forum is just one more piece in an elaborate scheme to make me think I'm crazy, isn't it. You guys aren't actually using CCS successfully are you. Someone is just paying you tons of money to site around at talk as if you are, solely to satisfy some sick and demented plan to make me think I am the only person in the world that nothing every seems to work for!!!!!!!!!!!!!!!!!!!!
Some of you may remember me from my previous post "No records... anywhere..." Before I get bogged down with the particulars of my problems (seemingly larger than CCS itself) let me start with a brief introduction. I don't program. I don't really do databases or web design. I managed to learn enough access VBA to create a decent little database for my parents small business. Now they have two offices in different cities and I thought why not put the database on a secure web page. So that is what I am trying to do now. I setup Win 2000 server with IIS. That is working just dandy. I installed SQL server (initially to use Data Access Pages through access) However, in the process of upsizing the database I lost a lot of programmed featured, which I would have to go back and fix. But it appears that CCS with use an .MDB file as a database connection, so that would solve that. Now we come to my problems...
***THE PROBLEM***
At this point, I am working on my home computer running Windows XP. But I also tried the same thing on the 2000 Server computer with the same results. I have setup a connection to the tables.mdb file. The file is also specified as the server connection. It successfully sees the fields when I use a builder to create a grid, or form, or what have you. But when I view the web page, it simple says, no records. And I can't add any either. So I thought, I'm starting from the beginning. I walked through the very first "Quick Start" lesson in the help. The Hello World Application. I know I did it exactly as it says! But when I view the page, instead of saying Hello World! like it's suppose to, it says {MyLabel}
So I'm left to wonder, is there some 3rd party software I need installed. Some run-time files or something???
WHY? WHY???? WHY DOES IT WORK FOR EVERYONE ELSE BUT NOT ME?!?!?!?!?!
Thanks for the help,
Tyler
|
|
|
 |
DonB
|
| Posted: 07/03/2004, 4:05 PM |
|
Ah, you are accessing the html page. That is only the template part (visual
aspect of the page). There is the .asp, .php or whatever, that is the
functional part.
I would really like to be getting paid for just sitting around talking about
using CCS successfully, but, - no - that's not the case!  I would like
to place an order for just one ton of money, please, Yes! I'm not greedy,
even a half ton would do 
Now, you might be crazy, but I am not qualified to make such diagnoses. I
suspect you are not.
So anyway, open the other page (you've not said what type, I assume it's
going to be "blah-blah.asp". If you always create the "main" page of your
app as "default.asp", then that's going to sort things out for you - just
open the site http://localhost/myapplicationname/ for example, and the
webserver should pickup default.asp automatically so you don't make the same
mistake again.
--
DonB
logging at http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net
<darkenedforest@forum.codecharge (darkened forest)> wrote in message
news:240e70d4891bc7@news.codecharge.com...
> This online forum is just one more piece in an elaborate scheme to make me
think
> I'm crazy, isn't it. You guys aren't actually using CCS successfully are
you.
> Someone is just paying you tons of money to site around at talk as if you
are,
> solely to satisfy some sick and demented plan to make me think I am the
only
> person in the world that nothing every seems to work
for!!!!!!!!!!!!!!!!!!!!
>
> Some of you may remember me from my previous post "No records...
anywhere..."
> Before I get bogged down with the particulars of my problems (seemingly
larger
> than CCS itself) let me start with a brief introduction. I don't program.
I
> don't really do databases or web design. I managed to learn enough access
VBA
> to create a decent little database for my parents small business. Now
they
> have two offices in different cities and I thought why not put the
database on
> a secure web page. So that is what I am trying to do now. I setup Win
2000
> server with IIS. That is working just dandy. I installed SQL server
> (initially to use Data Access Pages through access) However, in the
process of
> upsizing the database I lost a lot of programmed featured, which I would
have
> to go back and fix. But it appears that CCS with use an .MDB file as a
> database connection, so that would solve that. Now we come to my
problems...
>
> ***THE PROBLEM***
>
> At this point, I am working on my home computer running Windows XP.
But I
> also tried the same thing on the 2000 Server computer with the same
results. I
> have setup a connection to the tables.mdb file. The file is also
specified as
> the server connection. It successfully sees the fields when I use a
builder to
> create a grid, or form, or what have you. But when I view the web page,
it
> simple says, no records. And I can't add any either. So I thought, I'm
> starting from the beginning. I walked through the very first "Quick
Start"
> lesson in the help. The Hello World Application. I know I did it exactly
as
> it says! But when I view the page, instead of saying Hello World! like
it's
> suppose to, it says {MyLabel}
> So I'm left to wonder, is there some 3rd party software I need
installed.
> Some run-time files or something???
>
> WHY? WHY???? WHY DOES IT WORK FOR EVERYONE ELSE BUT NOT ME?!?!?!?!?!
>
> Thanks for the help,
> Tyler
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
darkened forest
|
| Posted: 07/03/2004, 4:42 PM |
|
Don,
Don't let the powers that be know you are ACTUALLY trying to help. Your family might miss you.
So, after I posted that message I noticed .asp files in the directory and I opened MyPage.asp and it just shows the code in the browser. The same thing happens when I click on Live Page in CCS. Why would this be? They must have gotten to my Internet browser as well.  Argh
Tyler
|
|
|
|
darkened forest
|
| Posted: 07/03/2004, 4:53 PM |
|
If you are reading this with in a few hours of the post, you can look at the site and tell me if it works on your end or what you notice etc. It's dialup so the IP is dynamic.
http://209.216.190.178//MyPage.asp
If you just type the IP it will list a directory of the files.
Thanks again,
Tyler
|
|
|
|
DonB
|
| Posted: 07/03/2004, 5:33 PM |
|
Hmmm, no go. No response. "Cannot find server"
--
DonB
logging at http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net
<darkenedforest@forum.codecharge (darkened forest)> wrote in message
news:240e746edf32ec@news.codecharge.com...
> If you are reading this with in a few hours of the post, you can look at
the
> site and tell me if it works on your end or what you notice etc. It's
dialup
> so the IP is dynamic.
> http://209.216.190.178//MyPage.asp
> If you just type the IP it will list a directory of the files.
> Thanks again,
> Tyler
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
DonB
|
| Posted: 07/03/2004, 5:42 PM |
|
That would indicate the server does not have the ASP interpreter running (or
not configured to execute ASP files, which would be really strange except
for XP Home Edition which does not provide a personal webserver like XP Pro
or Win2K does).
Thus, the problem lies in the webserver, it seems. How odd that two would
have the same issue, though.
A simple test would be a file like this:
<%
Response.Write "I am working!"
%>
saved as "hello.asp"
If it shows the code when you opening in your browser (just like the above),
then the webserver is not configured. If it prints "I am working!", then
the webserver is OK.
Hmmm, you ARE opening it like http://localhost/hello.asp and NOT
C:\inetpub\wwwroot\hello.asp - right? The second way will produce the
result you described, because it is not processed by the webserver scripting
engine.
--
DonB
logging at http://www.gotodon.com/ccbth, and blogging at
http://ccbth.gotodon.net
<darkenedforest@forum.codecharge (darkened forest)> wrote in message
news:240e7448388883@news.codecharge.com...
> Don,
> Don't let the powers that be know you are ACTUALLY trying to help.
Your
> family might miss you.
>
> So, after I posted that message I noticed .asp files in the directory and
I
> opened MyPage.asp and it just shows the code in the browser. The same
thing
> happens when I click on Live Page in CCS. Why would this be? They must
have
> gotten to my Internet browser as well. Argh
> Tyler
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
darkened forest
|
| Posted: 07/03/2004, 8:02 PM |
|
I GOT IT! Finally. Ok, so here's what the problems were. Initally, I was opening the html file, hence, no record. Also, I has the server path set as C:\inetpub\wwwroot. I figured out /localhost/ earlier today. Then I figured out the asp thing. I did install Apachie on my XP Home computer, but I had the code displaying issue. I finally decided to make a stop off at the office to test it on the IIS server since I was looking at the asp instead of the html and darned if it didn't work. Thanks for all the help and pointing in the right direction DonB. Much appreciated. Now I just have to learn how this program works and probably a little coding while I'm at it.
Now that everything is workings, here's a few more questions.
ASP or PHP?
Maybe I'll hold off on the rest until I have messed around with the program some more.
|
|
|
|
|
