Mssql Database Manager, Web-based
i need web based mssql database manager.
features
create table
edit table
del table
add-del-edit records
and free
ADVERTISEMENT
ASP Script To Connect To MSSQL 7 Database
What I need to do is connect to my database server from my webserver [which are both in my LAN] and bring back some data and allow the end user to search through the data.
Is ASP the best way to go about this?
Verify MSSQL User/Password/Database Combination
I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password.
But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password.
I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:
Mssql Database Driven Spry Type Horizontal Menu
how to create asp spry type horizontal menu that is populated from a mssql database. Only able to find help for asp.net, need help for strait asp.
View Replies View RelatedReceipt Based On Database Input
i'm trying to show a message where a user can print after checkout. i have 2 pages, the checkout page and the validate order page, where the checkout page displays a form and the user will fill this page and submit the order, then the order will be stored in the database in a table called Orders where the Order ID is generated automatically, and the date is also stored using the date function.
now what i need is after the order is being stored in the database the validate order will be called to display the message that the order has being received, well i need to add the two fields (Order ID, date) from the Orders table based on this specific order.
How can i do that ?
Have To Create Hyperlinks Dynamically Based On The Values From Database.
I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.
View Replies View RelatedAdding A New Entry To A List Menu Based On A Database
Let's say I have a dynamic list/menu, which gets its values from a
database table, for example a list of contact people where the value is
an ID number and the label is the name. However, if the value the user
wants is not in the list I would like to place a hyperlink which
will...
(1) open a small window, with an ASP form to allow the user to add a
new entry
(2) save the entry to the database
(3) add that value to the list/menu in the parent window and make it
the selected option
(4) close the small window and return to the original window.
I can handle the code for 1,2 and 4, but 3 is what I'm not sure about.
I don't like the idea of forcing the user to leave the current screen,
go to some other form, add the entry they need to the lookup table,
then come back; this seems like a logical approach, but just wondering
how to make it work.
This seems like a common enough situation; anyone have any code samples
or suggestions about how to do this?
License Manager
What are some of the more popular and less expensive methods for tracking software license usage (such as Win 2003 Server and SQL Server 2000 licenses) for usage of a web application.
View Replies View RelatedUsing Enterprise Manager
im using enterprise manager and on my courses table, i have an id that increments the number with each record.so e.g it has soemthing like this.
1 kings england bourenmouth italian £2300
2 mine england christchurch spanish £1000
so it increments the id by one each time, im using this so i can delete rows using the id so i dont delte similar rows, however, say i delete a row all rows and there were 4 of them, well the next time i add a row it starts at 4 and not one, how can i change this?
Content Manager
I would like to know how to build a content manager, where do I begin.
View Replies View RelatedTEMPLATE MANAGER
i work a lot with smarty that is a template manager for php.. there is someone similar for asp ?
View Replies View RelatedEnterprise Manager
I have a stored procedure in enterprise manager that generates sql inserts of selected tables. What I need is ASP should call the stored procedure and outputs the result in a textfile as .sql file.
View Replies View RelatedGrayed Out In IIS Manager
I just noticed that the "Home Directory" option in the "Home Directory" tab is grayed out. Why would this be grayed out?
Would this be a configuration thing or a permissions thing? I have an administrator account on this server computer which I do development work on and is not accessible outside the firewall of my company. However, the I.T. dept maintains it (but I am the only user of this machine).
So is there some setting I need to set in IIS manager to endable the "Home Directory" or do I need to contact I.T.? I can create virtual directories to my heart's content. I just can't set the "Home Directory". what I need to do to enable the "Home Directory" option.
Where To Download Enterprise Manager From ?
Does anybody has an idea where to download Enterprise Manager from?
View Replies View RelatedSite Manager Prog
I've done this template site that I'm using for about 6 or 7 different
people and I'm finding it a real pain to carefully update each site with all
of the relevant pages, pics, css, etc every time I do an update to my
template. I can't do a bulk upload to each site and overwrite everything
because certain files in certain folders are specific to each site.
What I need is an app that allows me to specify which files can be
overwritten on a site and then each time I put the new files in a folder
ready to upload I can instruct this app to update all of the relevant places
on all of the relevant sites.
Please note that there are a lot of folders, sub-folders and files so I need
some kind of mapping tool to make this practical rather than raw scripting
line-by-line
Enterprise Manager Port?
I'm trying to use Enterprise Manager to manage my remote SQL database, but I can't seem
to get a connection. I think my cable ISP Comcast may be blocking the port EM uses.
What port does Enterprise Manager use to communicate with SQL?
Text Blurb Manager
is it possible to creat a news/content manager that has a login/admin area that will have a textarea that will allow me to update text blurbs on other pages? I've looked all over and everything I've found is TOO robust...with uploading, "added by", "date added", comments, blah blah. I'm looking for something much more simple.
View Replies View RelatedProper FTP Manager Required
I've created a web site system that a number of users use on their sites,
but I manage each individual site/system on my ISP's server.
Creating updates to this system was fine when I only had a few users, but
now its starting to become hard work uploading the required files to each
site (I use CuteFTP) so I wondered if you knew of an FTP app that would
allow me to automate the process.
I basically want to put a file or files in a local folder and then instruct
the app to auto-upload these files to the same places, but on each site. If
required, I can create the folder structure locally so that the app goes
through a set of folders locally and uploads them to the same places on the
sites.
Do you know of an app that can automate the process of uploading the same
files to certain directories across multiple FTP sites?
Erase Password Manager
When a user signs in to a web site, he/she may be prompted by the browser on whether he wants to save his id and password. In future sessions, the user won't have to enter his id and password since they're automatically populated in the login form.
If the user wants to login as a different user I want to erase whatever saved 'browser' entries there are for the user. I then want to allow the user to enter new values for his id and password. how do I remove the saved entries in the browser?
IIS - Internet Services Manager
For some reason I've installed IIS but have no Internet Services Manager available for doing things like changing the namd of the "default" page etc. I've gone through the Add/Remove Programs -> Add/Remove Windows Components and I'm getting nowhere I cannot find this snap-in and it doesnt occur with the IIS install.
I've used this before at work but have been completely unable to install Internet Services Manager on my local machine.
Mssql
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one.
I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it.
I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page).
The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.
ASP And MSSQL
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?
View Replies View RelatedCall MSSQL Job Using ASP
Does anyone try before using ASP to execute JOB in MSSQL?
View Replies View RelatedASP (Javascript) And MSSQL XML
I was wondering if anyone could give me some pointers as to using ASP (Javascript, not VB) to get XML out of SQL.
I have my storedProc with the FOR XML AUTO on the end, and that is returning a recordset with XML fine in query analyzer.
I am lost as to how to output this as XML from an ASP page so I can transform it with XSL.
My transform would be something like: Code:
Stable ASP/MSSQL CMS Out There
Looking for suggestions on any stable asp/MS SQL server content management systems in the market place. Any suggestions, or even places where I can look? I have quickly seen Rainbow and would like any comments from users of this CMS.
View Replies View RelatedASP/MSSQL Version
I am currently learning ASP but have a small PHP background,
With PHP I used PHPMYADMIN to work with MYSQL
Is there a web based Alternative for
ASP and MSSQL that provides similair functionality?
ASP/VERY COMPLEX MSSQL
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code:
strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC"
now I have 2 things going on here...
1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records)
2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)
Update Mssql Using Csv Or Xml
Can't seem to find anything relating so forgive me if i've missed it.
I'm after a way to open either a csv or xml file, then cycle through each line to see if it's in mssql, if it is update it... otherwise add it and then if it's in mssql and not the csv, remove it.Is it possable?
Still learning and haven't dug into opening files, let alone this so any help would be grateful... oh and the fields are exactly the same in both
Asp MSSql Hit Counter
Anyone know of a free advanced mssql hit counter?
View Replies View RelatedConnecting To MSSQL Db From Web
In our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it.
the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view.
so to connect to it, what all do i need to do?
Access Vs. MSSQL In ASP
I'm just deciding whether to use Access or MS-SQL for a web-application
I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make
...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?
Stored In MSSQL
I am new to programming and I managed to store images in MSSQL.
The problem I have is that when I retrieve the image from the database
and display it in my browser it opens a new window. I would like to use
the image control, but it requires a url. Is there anyway of viewing that image
in the image control or keeping it in the same page where my information is
but displaying it where and when I want it
Can Run MSSQL DB In Linux
I want an answer by tomorrow with examples and reference URLS if we can do this.There is a program written in ASP and the databse is MSSQL (Microsoft) hosted in Windows platform.
But they want this databse and ASP Program host on a UNLIX/LINUX server and use the same ASP program. Can thy do it/ and how?