dsilcock
Posts: 4
|
| Posted: 03/08/2005, 12:52 PM |
|
I am trying to create a database linked webpage to no success. I have created a new application builder, selected the Access database and tested to connection sucessfully. However, I gone through the layout and all, but when I upload to the server (ftp) none of the record are displayed. Now I assume that the database in question must accompny the files, so I uploaded this to the same folder, still no success.
Can anyone tell me where I'm exactly going wrong. Btw I am using the evaluation version, if this is a restriction then I will be upgraging just so-long as I know whether it's me doing something wrong or not.
Thanks
Darren
|
 |
 |
peterr
Posts: 5971
|
| Posted: 03/08/2005, 1:14 PM |
|
What do you see?
(there are no restrictions on trial version)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
DonB
|
| Posted: 03/08/2005, 1:28 PM |
|
Be aware of which mdb you are uploading, if you have more than one (such as
one in your local dev folder being used in design mode, and a second one
used by your local webserver in "live mode").
You have two connection settings, one for local and the other for the
published version. Actually, more than two because you can select
publishing to a local/lan folder, or publishing to an FTP folder.
If there is no error displayed, then I suspect you've simply got an empty
database on the published site. Otherwise you'd get a message about being
unable to open the database connection.
--
DonB
http://www.gotodon.com/ccbth
|
|
|
|
dsilcock
Posts: 4
|
| Posted: 03/08/2005, 1:57 PM |
|
All i see is the general layout with the fields,
you can view at
http://www.sb-tek.co.uk/vanstock/stock_dsil_list.html
I'm obviously missing something vast.
Regards
Darren
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/08/2005, 3:32 PM |
|
Exactly what I thought. You need to open an ASP page instead of HTML.
The correct URL is http://www.sb-tek.co.uk/vanstock/stock_dsil_list.asp
Just configure your database properly as Don mentioned above, and in the documentation.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
dsilcock
Posts: 4
|
| Posted: 03/09/2005, 9:11 AM |
|
Cheers for that, however, sorry to be a pain but I now get
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/Stock2/Common.asp, line 127
ConnectionString = "ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" & Server.MapPath("Parts.mdb") & ";Persist Security Info=False""
----------------------------------------^
I folowed the advice given in one of the FAQ articles, the mdb file is in the same folder as the other files (Stock2), Is this correct?
Regards
Darren
|
|
|
|
peterr
Posts: 5971
|
| Posted: 03/09/2005, 9:20 AM |
|
You need to at least remove Quote :"ConnectionString = and the last quote.
And I'm not sure know which advice you followed, but if you are trying to change Common.asp - don't!
Also, most Web hosting companies don't allow to place the database in the same folder as the Web application and it is generally a bad idea. Ask your Web hosting company for the exact location where you should upload the database, and ask them for the full path. They should actually give you the whole connection string. Most Web hosting companies have documentation that provides connection string examples.
Enter that connection string as shown at: http://docs.codecharge.com/studio/html/UserGuide/Workin...Connection.html
Also, it's much faster and easier to test Web applications locally on the same computer where you installed CCS. If you have Windows XP Pro or 2000 Server, or any Windows that has IIS then I recommend testing locally first.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
dsilcock
Posts: 4
|
| Posted: 03/09/2005, 11:28 PM |
|
cheers, was a bit dim of me
|
|
|
|
|
