sprinsen
Posts: 3
|
| Posted: 04/28/2008, 2:55 PM |
|
Hello,
I've been working on a test app with CodeChargeStudio and I'm stuck trying to get a live page working. Everything works well on the developement side but when I publish my page there is no data.
My gut tells me there is something wrong with the data connection but I can't seem to figure out the problem. Maybe I'm just too much of a noobie to get it so I was hoping someone could help me figure out what's wrong.
Background. I am a DJ. I use an Acces database to track my playlists and I currently publish them to a static html page on my website. I'm trying to make the page more dynamic by creating a new page that allows searches and filtered views. I have a basic page all set up and as I said it works well in CCS4.
However when I publish the page to my website (http://www.djdarkwave.com/playlistdb/playlist.html) the data does not show up and the search fields contain {s_Song} or {s_Artists} and my Date field does not show anything (but I assume that is only different because it's a list box instead of a text box). It seems like everything is published ok but the database is not found.
I have my database file copied to the remote directory on the web server. The webserver does support access databases and I've set up a DSN connection with my ISP. I've tried every option that seems correct to me but I can not get this to work.
I've tried building my connection as a Jet OLE DB which works great on the design side but how do I make the connection on the server side without a drive letter?
I've also tried it using ODBC but again I can't seem to figure out how I'm supposed to connect to a remote database located on my website.
I tried using the OLE DB for Internet Publishing and entered the URL to the database. The test connection works but I still get no data.
If anyone can provide some insight as to what I'm doing wrong I'd really appreciate it. I'm hoping to get this personal test page working well enough so I can tackle a work related page and get my boss to approve purchasing the software for more intense database related apps at work.
Thanks!
Steve
|
 |
 |
GeorgeS
Posts: 206
|
| Posted: 04/28/2008, 4:28 PM |
|
if you are using asp you should call playlist.asp page and not playlist.html which is just a template.
if there is no data on you asp page check your connection string on the server.
it should look like this:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../dbfolder/your.mdb") & ";Persist Security Info=False"
../dbfolder - your folder on the server above the root of your website where you mdb file should be located.
_________________
GeorgeS |
|
|
|
sprinsen
Posts: 3
|
| Posted: 04/29/2008, 6:31 AM |
|
YES!
Thanks so much, I knew it was something relatively simple.
I guess I was a little confused on asp pages, for some reason I was under the impression that you used the html page as a front end for the asp data. Obviously I need to do a little more homework on the backend structure.
The Server.MapPath () info is what I was so close on. I was playing with that for the longest time but I didn't have the correct syntax for the variable.
Thanks again for your expert help George!
Steve
|
|
|
|
|
