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?)
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.
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:
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.
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:
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.
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.
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?
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.
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.
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?
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.
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.
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.
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...
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.
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 .....
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.
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?
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.
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:
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.
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.
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.
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.
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.
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.
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.
