Viewing A Database
On a shared hosting account, I've got access to an SQL 2000 database on a remote server.
Stats are data size: 12MB, Log Size: 25MB. I set it up five years ago, and, uh, forgot
how I set it up...
Anyway, I need to be able to view and browse the structure of my SQL 2000 database - and
it would be nice to do it with an interface like a Microsoft Access style GUI? I need to
be able to see what tables, columns, etc. my db contains.
Is there a web-based, or client-based, interface I can use that will allow me to view
and browse my SQL 2000 database? (Would it be easier if I had my web host provider
convert it to SQL 2005?)
View Replies
ADVERTISEMENT
how to view my database without making it a webpage for everyone to see. I would like to create a form and intake client name and phone number but I don't want the information available to the publicc to view. Is this possible. I use frontpage2002, windows millenium, and asp and frontpage extensions.
View Replies
View Related
I havent got any hosting and I was wanting to test out my pages, I noticed you can set up microsoft personal server using microsoft front page on your pc but i havent managed to get it to work.
Im currently running a test page with the following code but it just doesnt want to work. Code:
View Replies
View Related
Right i am making an ASP guestbook. I have got the code and everything sorted for INSERTING into the database. But i dont no how to view the guestbook, in a guestbook kind of way I have searched everywhere, but theres no look.
View Replies
View Related
how can I view the threads posted before by me.
View Replies
View Related
I want my Default.asp page to view different content in a <TD> according the request.
I've been understand that the best method to do it is by using the method GET, Example:
..MyHost../default.asp?page=news
And I have no idea how to write the code:
View Replies
View Related
I have placed PDF files in a protected folder.I have a secure ASP page that I want to open a PDF file How can I have the ASP page handle the login authentication to the protected folder.
View Replies
View Related
I have three PCs connected in a workgroup, all have Windows XP.On one PC, called MF1, I have IIS installed.In IIS I have a virtual directory called dbsite, pointing to a folder c:dbsite.In a web browser I can view the site via http://localhost/dbsite, or http://MF1/dbsite.
how would I allow the other two pcs on the network to access this site.
View Replies
View Related
i have work on this 4 days already but still cannot find a way to solve.is the way i code cannot be support by firefox?it work well in IE,but firefox cannot work.i have upload the file, can someone pls help me on that?
the asp.txt is my asp page, while the menubar.txt is the js file that i include in the asp page.it should work like ie.jpg but when i use firefox to browse,it show like firefox.jpg. is my code got problem?
View Replies
View Related
I inherited a site - www.highparkclub.com/curling.asp . If you look at any of the schedules - and you don't have excel installed it gives you the option to view or save the file.
For Mac users - this causes even more problems, as the link does not work at all. Is there a simple way to correct this, or do I need to associate the file type with the link.
View Replies
View Related
I have a variable that passes through, called teamid which is requested by a page that has values called album type. I want to know if I can hide a snipt of code, and once a value is pass through, hide the first page, then display results of the second on the same page.
View Replies
View Related
i have work on this 4 days already but still cannot find a way to solve. is the way i code cannot be support by firefox??it work well in IE, but firefox cannot work. i have upload the file,. the asp.txt is my asp page, while the menubar.txt is the js file that i include in the asp page. it should work like ie.jpg but when i use firefox to browse, it show like firefox.jpg. is my code got problem?
View Replies
View Related
Im having a problem in viewing date, does ASP have a function to format a date like this one (ex.12-Dec-05) aside from VBgeneralDate, VBlongDate and VBshortDate. In MS Access its called (Medium Date) but when I use VBmediumDate there is no effect at all. btw im using MS Frontpage and MS Access as my database.
View Replies
View Related
how can i open an xls ( excel ) file and print its contents formatted with asp? is this possible without any ActiveX or Dll's?
View Replies
View Related
I have localhost on my pc and its working. I use it to test all my asp pages, before uploading to the server. I have a web connection with a dsn connection. When tested on my pc it works fine. but as soon as i upload it to the server, it looks as if it doesn't get the data from the access database. I created exactly the same dsn on the server as on my pc, so why is it not working?
dsn name: pscs-db.mdb
is there something wrong that i'm not seeing or is the problem more complicated.
View Replies
View Related
We have the following problem: There is a RTF file that must be viewed on browser and we
have been developed a solution in Java to do it.
but the Java's VM is so bigger for download. So, we need a way to view this file in client side without bigger downloads. Any help will be welcome, because we work more than a month in this problem.
View Replies
View Related
is there an easy way of viewing the files in a directory without using "server.MapPath"!!!
i need to view Doc files in a folder and then open them in IExplorer to print the matter in them...
View Replies
View Related
is it possible to restrict users in different countries from viewing certain sections of the web site?
View Replies
View Related
Is there a method in ASP, which allows you to note how many users are currently viewing pages on your site.
I understand that there is a way of knowing if the user has actually logged onto the system, as I am sure you can detect how many members are actually signed in using I think global.asa file If I am right. I am sure you could also do it via an sql query if memberid=true, I am sure you could output how many members are true, returning a numbered value.
But is there a method of detecting how many viewers are actually connected to your site, without them actually being logged in? i.e non-members.
Also, how many hits to the site would be good, however this is an inaccurate reference, as a simple refresh would add 1 to the value, is there a method to prevent this, off the top of my head I would think a detect via the ip address? however some ip addresses change depending on there ISP.
View Replies
View Related
This problem occured just the other day. Whenever I try to access an .asp file on my server with an exact url, I get an error: The system cannot find the file specified.
BUT, if I type in an url to a folder containing a default file (in my case, index.asp) the file is shown correctly .....
View Replies
View Related
Is there any way of viewing a list of stored procedures from a database.for example i state i which database i am looking at and it returns a list of stored procedures.
View Replies
View Related
Can I make somebody else view my webpage, that i made in asp-mysql on anohter machine? I tried to give my ip address to another person to view my page. But it doesnt work. i tried as : http:ip-addresslogindb.asp?
To run ASP on my machine i had to change my port for localhost to 8888 from the original. Before changing it to 8888 it was giving 'in use...' error. I got asp functioning when i changes my port to 8888. Now when i want to make others view my page can I do it?
If yes, then i was wondering why would we need space to host a website (small scall). I can always make my machine as the host machine and no need to buy space and all? do i need to make any changes to my IIS setting for any 2nd person to view my login page?
View Replies
View Related
How can i list a folder content in ASP? for example i want it to list all pictures in a certain folder and show them.
View Replies
View Related
I am wanting to display a sheet from an excel file. I dont need to change/update it, just a simple display. Somthing like the 'Print Preview' you get in excel (that would be perfect).
i cant display the top row of the excel file. also if i try and access a cell that is empty i get an error. I need to display all cells from A1 - G60 if they have data in them or not.
View Replies
View Related
I have a form that end-users upload files on, into a folder on my server. I want people in my company to be able to go into our intranet, and view the upload files, and be able to download them.
It Works Well When ...
It works perfect when someone has a file with no spaces in the name. So files like document.pdf or document_1.pdf display fine, and are easily downloadable. When this happens, the URL when you put your mouse over the link is http://www.mycompany.com/extranet/uss/document_1.pdf -- so it's easily downloadable.
The Problem:
When an end user uploads a file with spaces in it, such as document 1.pdf. When this happens, and you put your mouse over the link, it will display as "http://www.mycompany.com/extranet/uss/document" .... and then it doesn't have a file extension or anything; it ends where the space ends, so you can't download it. Code:
View Replies
View Related
I want to take in a user id passed from a specific asp page "login.asp" and query and SQL Server Database & display result of this query on to another for "UserWorkspace.asp".
I need to know how can I establish this, i.e., how do I pass the parameter to the UserWorkspace.asp form.
View Replies
View Related
I'm using WinXP Professional SP2, I've installed IIS, but am having a problem viewing the temp version of the ASP file IE makes when you go to view an ASP page.
So, I hit F12 to bring up IE and my ASP page, IE generates a URL something like, http://localhost/MyWeb/ACEI/TMP91g0dk4dw.asp ... but that always comes back as a "File Not Found" error, however if then I replace the TMP91g0dk4dw.asp part with the actual file name e.g demo1.asp..the page runs fine.
View Replies
View Related
I am working with crystal reports 8 ,and call these reports through asp using smartactivexviewer in browser, i want to print these report before these can be viewed in browser.
View Replies
View Related
im trying to view one of my fields in MySQL DB with a "time" type:
rsShowTime ("stime")
output is:
7/5/2004 hh:mm:ss AM
in my DB the record only shows hh:mm:ss, how come it outputs "7/5/2004 hh:mm:ss AM"?
i only want to have hh:mm:ss as my result.
View Replies
View Related
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
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
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
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
