Help Needed: Uploading website with ASP and MS Access
Hi everyone.
I have only just started to use VB script with MS Access. I can create the site and database on my computer, but i can not upload them to my server, which is hosted by someone else, they say that there server is setup to work with Visul basic.
I have been given this code " @ server. mappath(" /") @ " "
It has bin a long time since i have looked at this code, and now i have forgot what it means. The script is used for the connection string.
What would be the best way of uploading a site with VB (ASP) and what connection string should i use.
Thank you for your help
EvilHaider posted this at 03:49 — 21st November 2003.
They have: 17 posts
Joined: Nov 2003
OKK....
ASP uses VBScript. If you've created an ASP script that interacts with an access database, and you want to upload it to a webhost that supports ASP scripts and Access databases, there should be no problem.
There are 2 ways to connect to Access DB in ASP. There's DSN connection and DSN Less connection. Which did you use on your own computer? Some hosts will create a system DSN for you for an access db for no charge. Others will ask you to use DSN Less connection. Ask them if they can make you a DSN.
The Server.Mappath portion you're talking about is basically for the server to find out which one of your folders the Access DB you want to connect to is stored in.
Without knowing where the DB is, your script will not work properly.
Hope this helps.
Tutorial Maniacs - The most comprehensive collection of QUALITY hand picked tutorial links on the internet.
http://www.tutorialmaniacs.com
druagord posted this at 20:46 — 21st November 2003.
He has: 335 posts
Joined: May 2003
server.mappath("/") should give you the path of your website on the disk something like c:\path\to\your\site
this can be useful to connect to a access database
IF , ELSE , WHILE isn't that what life is all about
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.