I downloaded the below code to add my project, but I would like to know how can I change the path of my database to /db/forumMDB? , and why ForumMDB instead forum.mdb?
Code:
Dim rsForums
Set rsForums = Connect (ForumMDB).Execute ("SELECT * FROM Forums ORDER BY Forum ASC")
rsForums.MoveFirst
structure of my folders:
/forum -------here I want to put my forum code
/db------------here I want my db of my forum
/Misc
default.asp
if you need to place the path to your database, what path do you place when you are having you site hosted by a web hosting company. For example my database is in a folder called "db" and its called "company.mdb"
the path I'm using is: "Data Source=c:dbcompanx.mdb"
but I keep getting a "database can't be found error" what path am I to assume they used. I mean its probably not a "C" drive so what do I place? I tried it without placing the drive but it doesn't work it seems to want only the direct path.
I am getting the following error from the following code:
Server.MapPath(), ASP 0172 (0x80004005)
The Path parameter for the MapPath method must be a virtual path. A physical path was used.
/html/objconn.asp, line 11
The code is as follows....
What is the best/common practice when configuring the database path?When the asp application is distributed to customers. How can I facilitate trouble-free installation?. In my applications I use servermappath to determine the position of my files, but databases (Access) are usually stored in different folder structures depending
on the servers.
What is usually done to configure an application?? Ask the administrator/customer to edit global.asa manually? Is there a way to make this task easier for non experienced customers? Is the connect string with the path usually stored in global.asa or in an include file?
I am struggling to store an image path to a mysql database and in the process copy the image from one folder to the folder I would like it to be copied to.
My code for the inserting the image path and data into the mysql db is below: ....
Database path works on drive c:, but it doesn't work on a mapped network drive while i move the database to the mapped network drive it stops working.
Can anybody help how can I write Access Database Path to a mapped Network drive in my vb script?
I have a dynamic table asp/vb that is returning records as expected. There are 7 fields that are returning boolean values based on whether there is or is not a meeting on those given days.
My table is returning TRUE and FALSE and all I want to do is create an if or select statement that will detect the values in these fields and change them as follows:
If true, then field = "R" (Wingdings2 R is a checked box)
If false, then field = "T"(Wingdings2 returns a x'd out box)
I have a simple table "Line" with Columns Key, OrderNumb, Panels, Gates, Posts, Color, Memo, Comp. A user enters the information into the powder.asp page. It is then added to the database. The Comp Column is populated NO by a hidden input type. The data is then displayed on a page in a table and the last column has a submit button.
When the user Presses that button I would like it to update that record in the database to change Comp to YES. Some code snipits are below. The first is where the data is presented and where the submit button is. It then will go to the next snippet that hypotheticly will change just the Comp on that record to YES. I am not sure if I am not executing the SQL correctly or something but it will not change that order number row comp to 'yes'. Code:
I have virtual directory where I run test.asp page with only this code inside:
<%Response.Write now()%>
As a result, if I go into the IE and browse for the test.asp page, I get :
1/22/2004 14:18:04
If I copy this page on some other(existing) virtual directory, I get as a
result 22.1.2004 14:19:06
If I create a new virtual directory and I copy the page there, I get :
1/22/2004 14:18:04
Seems like that IIS takes english date format even if my regional setting is
:
d.M.yyyy and I would like that date on the page is always like this:
22.1.2004 14:19:06
Where I can change this setting?
I have problem with physical path & virtual path on the server.
<!--#include virtual="country/inc.bottom.asp"-->
In this script it is working.
In all the file i have <!--#include file="../ar-inc.top.asp"--> this script.
I have about 10,000 files in the website.
help on the correct "url" or path of pictureds to be appended in the database
View Replies View Relatedi'm working on uploading images to the webserver.Got a "test" version working, but as soon as i try to modify it.on my server i've got an Upload folder in the same folder as my aspUpload page.the path connection is as follows:Code:
sPath = Server.MapPath(".Uploads") & ""
but now i don't want it saved in the Uploads folder.The folder path i want is ../../../images/models/
how do i modify the above code to this path?
Main folder is "Web". In the "WEB" folder some asp file resides. another folder named "Admin" also reside in the "WEB" folder. My DB resides in the DB folder that is outside of the "WEB" folder and on the same root where "WEB" folder is.
I have a file named Connect.asp which contains the path for DB. I have included this file in both user files (which are simply in web folder) and in the administrator files. But when the admin tries to log-in the file didn't read the appropriate path as it finds the DB in the WEB folder. But it works fine when i communicate with the DB through user files.
I want to write logfiles to a textfile. But when the file doesn't exist, then the file should be created. But the code gives an error at this part of the code. I have no idea of what the mistake could be. Here's the code:
View Replies View RelatedIs it possible to get the physical path of a cookie? (C:Document and SettingsmyLoginCookies)
Because I need "myLogin" (the Windows Login), and I can't get with request.ServerVariables("logon_user") or ("author_user") or whatever...
I'm writing an ASP validation script that uses a cookie that is created by a user validation page and has a single value. This site will be used only under Internet Explorer 5 and more recent.
My problem is that the page called after the cookie creation can't read the cookie unless I set the Cookie.Path attribute to "". All the documentation that I found about it is very brief, don't explain how it really works and if there's any kind of "side effects". An even stranger fact is that some people of my team can read the cookie without setting the Cookie.Path attribute.
Can anyone tell me how the Cookie.Path really works or witch browser settings make it needed (or not)?
I have created my asp pages in "D:/test" . This i have created as a virtual directory.
i am having some files in "D:/download/cont/somename" From the asp page i want to access the files in the d:/download/cont/somename folder. Here somename changes according to username. i.e first i want to check whether this path is valid and then get all the files from it but its giving me the following error
Server.MapPath(), ASP 0174 (0x80004005)
An invalid '/' or '' was found in the Path parameter for the MapPath method.
/test/contractsfile.asp, line 11
code:
somename = Request.cookies("username")
source = ".. est" & "/download/cont/" & somename
if fs.folderexists(server.MapPath(source)) ---------------------------> line 11
I'm developing an asp uploader to upload word documents, but having problems getting it to upload, I think it may be a path problem.
Here's the code:
<%
Dim rs_upload
Dim rs_upload_numRows
Set rs_upload = Server.CreateObject("ADODB.Recordset")
rs_upload.ActiveConnection = MM_conn_watershed_STRING
rs_upload.Source = "SELECT * FROM tbl_upload"
rs_upload.CursorType = 0
rs_upload.CursorLocation = 2
rs_upload.LockType = 1
rs_upload.Open()
rs_upload_numRows = 0
%>....
I'm trying to concatenate a path of Application("WebSiteFullPath") which
equals http://www.mywebsite.com/ and an image file like CODE below. My
problem is the full path listing in RESULTS below adds an extra " quote and
obviously breaks the path to the image. How can I script the quotes to not
add the extra double quote between my website path variable and my image
path?CODE:
Response.Write "<img border=""0"" src=""" &
Application("WebSiteFullPath") & """images/edit.gif"" width=""15""
height=""15"">
RESULTS
<img border="0" src="http://www.mywebsite.com/"images/edit.gif" width="15"
height="15">
I'm developing a content management system that uses a file uploader. The uploader works fine and uploads the file when using a mac computer, but doesn't upload the file when using a PC. I am thinking this is a path issue??
Here's the path in the uploader script:
File.SaveToDisk "D:/virtuals/cwh/victorbernard/restigoucheriverwatershed_ca/web/download/"
if i use the physical path where the database is located then my code works fine
such as ("e:folderabc.mdb")
but when i use the server.mappath("abc.mdb") , i get error
My error is as follows:
Server.MapPath()error 'ASP 0171 : 80004005'
Missing Path
/raven/aspBoardFunctions.asp, line 19 The Path parameter must be specified for the MapPath method. Code:
While my wwwroot is under C:inetput, how can I make URL pointing to the
downloadable files on D:downloadmyfile?
Do I have to use download COM? If yes, which one is recommended for free?
I want to create a temperorary variable that is equal to a path that contains two
temporary variables fldr1 and fldr2. I can't seem to encode this...
Here is some of my code below:
Dim TempPath
Set TempPath = ("" & fldr1 & "" & fldr2 & " ")
Dim RequestFolder
Set RequestFolder = fso.GetFolder(Server.MapPath(TempPath))
im having a problem with folder path in include files. I have a solution, but there must be a way better one. The problem is when i have an include file... menu.inc in my root directory root/. This menu.inc references images in the root/images/ folder.
I also have an articles folder root/articles/. The menu.inc is included in files in the articles folder, however this messes up the image paths and files in the articles folder are looking for the images in root/articles/images/.
to combat this, in front of every image reference in my menu.inc file, i have a variable <%= pathVar %>. At the top of every file in the articles folder, i have the command <% pathVar = "../" %>. this will insert a ../ before the images folder in the reference therfore correcting the image reference. In the root folder I use <% pathVar = "" %> , so the <%= pathVar %> amounts to nothing leaving the paths correct.
This works, however means having to switch from HTML to ASP mode for every image in the include file, which is not efficient. Is there a better way around the path problem.
Why it is that to saVE a file an absolute path is required and to read a file or pic an relative path is required.can any one ellaborate it and also diff between relative and absolute path
View Replies View RelatedIs there something similar to PHP's php_info command to tell me all about the server? I need to find the actual path where the site resides.
View Replies View RelatedThe '..' characters are not allowed in the Path parameter for the MapPath method.
/Connections/connportal.asp, line 30
This is line 30
MM_connDUportal_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("..\_privateportal.mdb")
%>
Are there any way that I can display the current page's path in the browser's address bar?When I use frames the path dont display in the bar anymore.
View Replies View Relatedhow can I find out the path of the ASP I am currently executing? I mean the absolute path like: d:webaspmyasp.asp should bring me d:webasp.
View Replies View RelatedI'm trying to find out the entire path for the directory on the web server that I use for FTP'ing.
I had an ASP script which did it for me once before but I've lost it. Does anyone know how to retrieve the full path name?
I am trying to use the FSO to do some file work. I have a little bit of code:
View Replies View RelatedWhat are the pro's and con's of both methods?
Should I use:
<img src="../images/new_images/spacer_tenpix.gif" width="10" height="10">
or
<img src="http://www.keomed.com/images/new_images/spacer_tenpix.gif" width="10" height="10">