Guest
|
| Posted: 12/03/2004, 10:51 AM |
|
Sorry for asking a silly question.
If I want to work with a MS Access mdb file, do I just copy it onto the webserver and let the code do teh work. Or do I need some MS access server software?
|
|
|
 |
peterr
Posts: 5971
|
| Posted: 12/03/2004, 10:57 AM |
|
You just need to copy an MS Access (.mdb) file to the Web server, plus the ASP code that will be connecting to it. Nothing else involving MS Access is needed.
Just do not allow access to your .mdb file via the Web (URL) because someone could download it just by typing the URL address of your database in the browser. So place it in some folder outside of the Web server folders (like outside of "Inetpub").
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
 |
|
peterr
Posts: 5971
|
| Posted: 12/03/2004, 11:05 AM |
|
BTW, if you don't have your own Web server, ask your Web hosting company or check their documentation for the folder that should be used for storing the database. They usually create a special folder like "database" where you'd place the .mdb file.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
guest
|
| Posted: 12/03/2004, 2:38 PM |
|
Where do you actually place the mdb file? How do the scripts know where the mdb file is? For example in teh example project, the Internet connection has location pointing to the C drive. How does that translate to a location on the server?
|
|
|
|
guest
|
| Posted: 12/03/2004, 3:03 PM |
|
If you have a look at this:
http://www.fia-online.org/c22/
When I pick default.htm all I get is the { and } and no data activity.
This the example project that came with the software.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 12/03/2004, 4:15 PM |
|
You specify the location of the .mdb file in CCS, in the Server Connection:
http://docs.codecharge.com/studio/html/UserGuide/Workin...Connection.html
You should not run Default.html but Default.asp: http://www.fia-online.org/c22/Default.asp
Unfortunately as you see that computer cannot run ASP programs. You only see the code. If this is not a Windows computer then you cannot run ASP applications, or run or connect to MS Access databases.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
Guest
|
| Posted: 12/04/2004, 9:11 AM |
|
Thanks for the help but I feel really frustrated now.
I am now using a webserver that has ASP 3.5 (Chillisoft). Now I get an error:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/c2/Classes.asp, line 122
Public Default Property Get Parameters(Name)
Link at: http://www.fia-online.co.uk/c2/Default.asp
|
|
|
|
Oper
Posts: 1195
|
| Posted: 12/05/2004, 5:47 PM |
|
You need to ask to your Hoster that setup Default.ASP first , and not Default.html.
We have a host company and must of user use HTML first but CCS required .ASP first.
And Depend of teh control panel and the setup of your Hoster too.
Some hoster will reuired you to locate your Datafile in an epecific folder and use the BUILD in DNS.
Helm? Cpanel?, Plesk?.
Your hoster may help you with the String Connection.
Note: Some Hoster dont allow NO DNS connection too.
Its always good to have your Database one Step Behind Root folder too, so that way noone can touch your MDB unless scripted.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
