Physical Database

I'm using Crystal Reports 8.0 and Asp. When i try to see my reports it show me an error "Physical Databse Not Found". Whether u run the repprt on server or on clent.

View Replies


ADVERTISEMENT

Physical Path To Database

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....

View Replies View Related

Web Site Physical Path

How can I get the physical path of a web site from an EXE application? The Web Site is on the same server as the application.

View Replies View Related

Physical Pages Categories

I want to put my existing review books webpage in Asp/Database because I have more than 5000 of them and its now too complicated to keep tracks of it all in HTML only. My database is ready, I know how to connect to it, how to list records and how to select in them, I know how to pass a variable from a page to another, I know how to add, modify and delete records... yeah its about that so far.

Here is how I want my website to look like. I want to have physical pages categories, like all the science fiction books should be listed in sf pages separated alphabetically Ex reviews of Lord of the ring will be in sciencefictionT.asp and so on for each categories. I want too that a page with all the reviews listed linking to the right place. In my database I have already categories for each books.So is it possible to do or I complicate my life too much?

I know that it would be much more easier just to make a review.asp and have the review one at the time there, but I like the way my website is already is, that make it different from others.

View Replies View Related

How To Give Physical Path

Please let me know how to avoid giving physical path & line number in the
error messages of web applications. Instead i would like to replace it with
general error message to the user.

View Replies View Related

ASP IIS 5.0 Mapping An FTP Share To The Physical Directory

I've setup several FTP shares on IIS 5, where some of the shares are
located on another computer, while other directories are on the local
computer.

Is there a function similar to server.mappath that I can use to return
the physical path of a FTP virtual directory using ASP?

For example, I have a virtual directory called TestA located at
C:TestA on the local computer running IIS 5. I have another virtual
directory called TestB located at DevserverTestB where Devserver is
another machine on the network.

In my ASP code, I need to be able to access the physical directories
directly and I would like to avoid having additional code to deal with
hard coded directory paths.

Is there something similar to the command server.mappath("TestB") which
would return "DevserverTestB"? This way, the physical path is
transparent and I can treat local and network shares in the same way.

View Replies View Related

Virtual Path And Physical Root

Is it possible to include my remote web server path eg: m:/html/root/site1
| m:/html/root/site2 etc

....in virtual includes....

Thus eliminating the need to create duplicate INC files in each sub-domain on my remote web server host domain IP. eg: http://72.3.5.6.0 (www.site1.com; www.site2.com)

I would like to be able to use a UNIVERSAL INC file in the root of my web IP for the benefit of all my sub domains.

View Replies View Related

Skip Out The Name Of The Page From The Physical PATH String ..

If the physical path of a page is : " e:facecgi_bindetails\_Nviews.asp "

and i want to remove "\_Nviews.asp" portion from this path ...means whenever the page refreshes,no matter what the name of the page is ....the last portion of the name of the page with slash must skip out from this path string .....how can i do this while using VBscript Functions.....like using Split(),RIGHT(),LEN(),LEFT()...etc..

View Replies View Related

Physical Path Of Any Page Hosted On Other Server

May i get the physical path of any page hosted on other server?

View Replies View Related

Convert A Physical File Path To A URL For Hypertext Links

I have a Physical path that I need to convert on the FLY I thought using Replace would be a good idea, and it almost works

function MapURL(path)

dim url2
'Convert a physical file path to a URL for hypertext links.
url2 = (path)
MapURL = Replace(url2, "", "/")
MapURL = Replace (url2,"E:","http://myscs/docLibraryDocs")
MapURL = Replace (url2, "IntranetLibrary", "")

end function %>


- Is it possible to have multiple replace on the same variable ?
- am I doing it the right way ? or is it possible to concatenate those replace in one go ?

Is there a limit on how many Replace one can use for one variable ?

The problem I have is that it takes the first two Replace in consideration but not the third one. If I remove or comment the second one then the First and the third one works fine. For some reason, it doesn't like to have the three in the same time.

by the way, the link I try to change is as follow: Code:

View Replies View Related

Physical Path & Virtual Path

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.

View Replies View Related

Database Limit - Microsoft JET Database Engine Error '80040e14'

I have just started using ASP, I am normaly using PHP but I thought ASP might be a good road to go down. I am having a few problems, I am trying to limit the number of records I take out the database but I keep getting errors.

<%
'connection string
datapath=Server.Mappath("guest.mdb")
strconn="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & datapath & ";"
Set CONN = Server.CreateObject("ADODB.Connection")
CONN.Open strconn

'select all records row by row
DBquery="SELECT * FROM Guests LIMIT 10"
set query=Conn.execute(DBquery)
do while not query.eof

'get a variable from the table
guest_id = query("ID")
guest_name = query("Name")
guest_msg = query("Mesg")
guest_date = query("DateTime")

'print the variable to the screen
response.write guest_id & "<br />"
response.write guest_name & "<br />"
response.write guest_msg & "<br />"
response.write guest_date & "<br />"
response.write "<br />"
'move to the next record
set conn = nothing
query.movenext
loop
%>

I am getting this error;

Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

/guestbook/guest.asp, line 11

can anyone help me?

View Replies View Related

Microsoft JET Database Engine :: Cannot Update. Database Or Object Is Read-only

I had made a form name 'dform.html' which asks idno, name and phone from the user and after the user clicks on button "save data" sdata.asp is executed. sdata.asp is written to save the values entered for idno,name and phone in dform.html into table "myfriends" in the mydata.mdb (access database). but when i am clicking on save data button i am getting error saying

"Error Type:

Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/SDATA.ASP, line 9"

can please anyone tell me why i am getting this error.

View Replies View Related

Database Connection String To MySQL-database On A Different Server

I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!


Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.

View Replies View Related

How Do I Export Data Fom Local Database To Server Database?

I'm current working on a project which need to upload local data to
live server database.

Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.

View Replies View Related

Microsoft JET Database Engine , Database Or Object Is Read-only

Error Type:

Microsoft JET Database Engine (0x80040E21)
Cannot update. Database or object is read-only.
/q_maker/aero_admin/delete.asp, line 12

what is wrong! i checked the db and its not readonly.

View Replies View Related

Using Value From Database Updating The Database And Resuing The Value

i wrote a shopping cart using cookies found out thatIE 7 won't let me add more cookies after a certian number. decided to use DB along with cookies and now i have very weired problem never encountered before Code:

View Replies View Related

Many-to-Many :: Seperate Database Or One Database?

Products ---> Products|Customer <--Customer

With regardst the above many-to-many relationship:

Is there any advantage in creating seperate access databases for:

- Customer
- Products

....Rather than keeping them as three tables in one database.

The reason I ask is that I have found that if I am using a ftp approach to
overwriting or updating the remote database there are sometimes problems
with synchronizing data .....This seems to be a better solution?

Am I off base?

View Replies View Related

Web Database

does any one know a simple free database driven website tutorial that i could learn? i need it for when someone searches a name ionformation on that name comes up along with photographs realating to them.

I have built several websites before but none are database driven so is there any dummy proof versions?

View Replies View Related

Do While Out Of A Database

How do I do a Do While loop to display rows of information out of a database. Here's my code, and it seems like its in an infinite loop. Code:

View Replies View Related

ASP With Database

I have a Access DB with two tables (Users and tblpersons). Users are stored in table Users and their records in tblpersons. They are able to login, Enter, Search, Update their data.

I want users to be able to Enter and update only their data not other users data.

Example:User_Id 1 when logged in, is able to enter data for any user(1,2,3......) and able to modify their data.

View Replies View Related

Database.mdb

I can make a simple database file and name it database.mdb, all I need to do is name a single field email and save it. But I dont know how to make it so that my page will become active and the emails submitted will be saved either to the mdb file or a text file, im not sure what goes on there.

View Replies View Related

Database Not

i have 2 tables and i only want the records where which arent in the one database eg.
table 1

idnum
1
2
3
4
table two
idnum
1
2
3
4
5
6

out of these two tables i only want from table two idnum 5 and 6 cause they arnt in the 1st table.

View Replies View Related

Job Database

They are on Windows 2000 IIS 5.0 and currently have an older version
of their job database using Access hosted on a Brinkster server.
The new server that they are on, when I contacted the host, they advised me
against creating any new applications using Access, as the server is not meant
for multi-users.
So, I am thinking that they need to get their host to upgrade to a SQL database
and have the job database developed using that.
My question to this forum is: What do you think is the best combination for
improvement here, SQL or MySQL or what, considering that their site is using asp
and hosted on Win2000 IIS 5.0?
Also, any recommendations on scripts that might be already available that could
be customised to their site?

View Replies View Related

Same Database

What we have is our own (in house) Windows 2000 Server which runs MS SQL for our data storage and we have writen our own VB6.0 Application which runs of the SQL DB to manange our stock, ordering, price's etc etc. Also we have our own Website with a Web Hosting Company which is also a Windows 2000 Server but can only Run access databases.
What we what to do is somehow have the Access database and the SQL database sync together to have some of the same data in both database's. But I don't know where to start.

View Replies View Related

Database

I have the following code to execute a SQL query.Code:

SQL = "INSERT INTO teams (`teama`, `teamb`, `pot`, `winner`, `finished`, `start`) VALUES ('" & teama & "', '" & teamb & "', 0, '', False, '" & gdate & "')"
teamrs.Open SQL, conn
all works fine.
I just want to know what result it gives.because once i add it, the form submits, and its a blank page. I want it so it does this Code:

if sql = worked
redirect
else
error
end if
so how can i make sure the query was executed successfully.

View Replies View Related

SQL Database

This is probably a stupid question (I'm good at those)...
I would like to enable a user to be able to browse to a picture on their local machine and upload that picture to a remote directory where it can then be displayed along with it's other pertinent data.
I thought it might be a good idea to use Front Page's "file upload" feature which includes a "browse" button and prompts me for a storing location - but I can't get it to work and am not even sure if that's its intended purpose.
So my question is two-part, what should my insert or update page look like regarding an upload process, and then how would I link to or display that picture?

View Replies View Related

ASP - Database

I have some questions in a database, i showed in the web page, for each questions i gave 3 (Yes, No, Not Applicable) options via select - option. when i get the variable with select name, it is showing with comma.

Example :
If they select for like that

Ist question - Yes

IInd question - No

IIIrd question - Yes

IVth question - Not applicable

The variable is coming like (Yes, No, Yes, Not applicable)

but i want to get with separate variables.

View Replies View Related

Best Database

What is the best database to connect to, and why?

View Replies View Related

Asp To Database

I have a form that is inserting data to an access database i have it working, but when ever a user enters a name with a special character eg Tom O'Conor i get an error due to the ' character, is there anyway of over coming this problem.

View Replies View Related

Database Dsn-less

i have this code that is supposed to help me out in some databse retrieval issue. however i am not aware of the dsn-less code and stuff:
<%
var rs = Server.CreateObject("ADODB.Recordset");
rs.Open("select * from states","DSN=IST_SQL;UID=....;pwd=....");

var n=0;
while (!rs.EOF)
{
...
}
rs.Close();
%>

i think the following is also to be included in the above code, but i am not sure of the whole connection thing.

View Replies View Related

Database

Well Im finally getting how to do asp but I cannot seem to find where I import ms sql .sql files? I know in phpmyadmin there is a place to upload them but not anywhere in ms sql admin. Anyone know how to do this?

View Replies View Related

SQL Database

I just wanna know if I got a asp page in a location A and wanna connect to the SQL database in a server with IP address 144.214.87.11 through the Internet,then how can I configure in the SQL Server 2000?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved