ASP/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?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
OS Version
Is there a way to determine users OS version and servicepack level (when WIN)??? (Browscap, broeserhawk,... ?)
ASP Version
I currently have an ASP website that utilizes an Access database, which I administrate through the web via aspaccess. I really would like to have a better database, but I can't afford to own SQL Server or pay extra hosting fees from someone that has it. I would like to keep ASP, but use mySQL. My dilemma is that, while I would like to add mySQL, I don't want to create a mixed environment by using phpmyadmin to administrate it. Does anyone know of an ASP-based administration package for mySQL?
ASP Version
I have PWS/Windows 98 but how can upgrade to ASP 2.0 or 3.0? Should I download a package from microsoft or Should I install a new version of the PWS?
Best Version
I see 2 versions. Visual Studio .net professional and Visual Studio .net Enterprise Developer. Can someone tell me which of these 2 is the best to buy.
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?
ASP.Net Version 2 - Worth It?
Is version 2 worth it, and is the only way to learn it the MS Visual Web Developer Free Download? It seems to have some really cool new features? I am sick and tired of Macromedia and the rotten code that they generate with Dreamweaver, it's so bloated and falls apart in so many platforms.
How Can I Know My IIS Version Number?
I am using w2000+sp4 server with IIS running, how can I know my IIS version number, is it iis5.0 or 5.1 or 6.0? I must know this, since I want to download patches from MS web site,
File Version
I'm looking for an easy to use file version control system for all of our web development files. We have been using Adobe’s Version Cue for our projects that utilize Adobe products and love it. The problem is that Version Cue only works with Adobe products. In essence we are looking for a Version Cue for “everything else”. We’ve tried tools like CVS and Subversion, but those are very difficult, seem to require a high degree of specialized knowledge and are not user friendly. On the other hand Version cue offers most of the same features, but has a very simple yet powerful and feature rich GUI. We need something that is usable by our programmers and designers alike
VBScript Version
I think the ASP that I wish to run needs a later version of VBScript than is installed. How do you find the VBScript version (server of course)? What needs to be done to update this on a win2000 box?
IIS Is Not Running ASP.net 1.1 Version
I have Xp prof, IIs 5.1, .NET2003 on my machine. I had the error "Visual studio.net has detected that the specified web server is not runnning ASP.Net version 1.1. Yow will be unable to run ASP.Net web applications or services." in .NET 2003. I fixed it by running the IIS mappings for ASP.NET, aspnet_regiis -r. But I figured that my IIS had some issue and I had to register the dll for IIS. After doing that my .net is throwing the same error, "Visual studio.net has detected that the specified web server is not runnning ASP.Net version 1.1. Yow will be unable to run ASP.Net web applications or services." I ran the aspnet_regiis -r again it is overwriting the 1.1 .net framework scripts but the error in .Net is not fixed. I know my webserver is running Ok because I can develop ASP pages using Visual Interdev and my default website is running fine.
IIS Version 5.0 Will Not Run ASP On LocalHost
I have a new ASP project that I need to desperately test on my Windows 2000 machine before posing to my Hosting Company. I am having problems getting the ASP pages to run from LocalHost. I will attempt to give as much information of what I have done to try to correct this without success. First my setup. Windows 2000 Professional with Service Pack 2 installed. IIS is installed. I have turned off the firewall just in case that was a problem as the laptop is operating as a stand alone and not on a network at this time. I also have VB6 with Service Pack 6 installed. I will explain later why that my be pertinent. The error that I am getting is: The Page Cannot Be Displayed. with a HTTP 500 error. This occurs every time I try to access a ASP page. HTML works fine from LocalHost. Code:
Correct Version
can someone explain to me the diffrence between the 2 below and why one works and the other one doesnt.could you also explain what each part of the correct version is doing because i dont really no. INCORRECT sql = "SELECT * FROM userlogon WHERE (username)=' "& (username) & "' AND (password)=' " & (password) & " ' " CORRECT sql = "SELECT * FROM [userlogon] WHERE [username]=' "& username & "' AND [password]=' " & password & " ' "
IIS Version Problem
has the error got anything to do with IIS version Operation must be Updatable query I am working on WIN XP Pro using IIS5.0 or 5.1 .. But when i run the same applocation on another WIN XP pro , it works fine Are there any patches that i have to install?
Developer Version
Do any 'classic' asp developers have any knowledge about the client side sql server EM tool found here: http://www.amazon.com/exec/obidos/t...46&vi=tech-data I am hoping this will allow me to leverage default sql server database on remote web host...but not sure if it will run on WinXp Professional....I was told it does... Also: any other fast track hints to get started would be great...I have some knowledge on Access sp's and I understand that dates are handled differently in sql server... Would it be a good idea to initialize the database path, username and password in the global asa
Version Of Phpmyadmin
Does anyone have a resource for a MySQL database tool like phpMyAdmin? It would need to be written in ASP. I have a local DB tool on my computer but I wanted to put something on my webspace to have acces to the DB from anywhere.
Version Numbers
I've got an ASP app. This app is deployed to two seperate Windows NT machines which I believed were the same. Unfortunately, the app works on one PC, but on the other I get some EOleExceptions from the COM object I use with the page. Does anyone know how I can check versions numbers of things like what ASP engine I am running (if there is such thing), version numbers etc. etc. I'm just looking for anyway of telling what the difference is between the two PC's. P.s. I know this isn't really a 100% ASP based question, but I thought I would get a fast answer on the ASP board.
Evalution Version
I am currently using an evaluation version the (latest) sa file up component. I have noticed and am concerned with the fact that the file up form collection, seems to support only one reading of values. Once i have created an instance of the file up component upload a file and destroy it i am unable to gain access to posted values again. This makes it difficult in a more object oriented approach to programming. I have a class responsible for uploading a file, and a class responsible for inserting data in a db. Only the first class that is called to extract info from the file up form collection is populated with data..after that all is gone.
WinHTTP Version 5.1
Would anyone know where I can find a copy of this.I just can't afford the MSDN subsrciption right now.
Browser VERSION If Then ELSE
I want to do one line of code if it the browser is specifically IE 6, if not then do something else? Can this be done?
Deleting Old Version
I have a problem of deleting old version of files. This is wat happens: Client side sends a few files to the server side via http and are saved into a folder. I need to delete these files when another batch of files are send next time. Any suggestions to solve this problem. Timestamp is out of question because it is not reliable to use time to differentiate between files within the same batch and other batch. Sometimes the sending might be delay by server. Therefore i need to come up with some sort of detection for new batch.
Finding Version
How can I programatically ascertain what version of ASP my ISP has installed ?
Version Of VBscript
1 of my hosts (Fast Hosts) recently upgraded to 5.6 and my other (HostingUK) has been using 5.6 with the .NET framework since I started using them.
Determine ASP Version
My web hosting account lets me use ASP and so I thought I'd try to learn and use some. There is only one thing that I would like to know, and that is how to find out what version of ASP is running. Preferably, what I am looking for is something similar to the PHP php_info() function. Is there anything like this for ASP?
Version Control
Which version control system would you recommend. Need to use it with ASP and .SQL files.
ASP (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.
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
Connecting 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?
Connect To MSSQL
I had used ASP about a year ago, I had connected to a *.MDB database but not MSSQL,can someone please throw me the just of it
MSSQL Connection
I am using a Windows 2000 Server and when i tried creating a simple asp application this error always appear everytime I access the database. Error Type: Microsoft OLE DB Provider for SQL Server (0x80040E4D) Login failed for user 'MYSERVERIUSR_MYSERVER'. /o/faculty_evaluation/add_dean_db.asp, line 22 what kind of error is this? is there something wrong with my connection string -> conn.Open "Provider=sqloledb;Data Source=MYSERVER;Initial Catalog=dog_evaluation;Integrated Security=SSPI;"
Connect To Mssql
any one have the connection string and included query on how to connect to the mssql server?
ASP Connection To MSSQL
If I create an ASP page, what do I need or how do I connect to a MSSQL database. And, is it possible to connect to a MySQL with ASP, or is it better to use MSSQL when developing a ASP page?
ASP/MSSQL To ASP/MySql
I am planning to convert an ASP/MS SQL based site into ASP/MySQL to save on monthly recurring fees. MSSQL costs additional $40 a month while MySQL is free. Are there any major technical issues?
Detect Java Version
I need an asp page that will detect the clients java version, and then email the results automatically.
'Printable Version' Webform (or .doc)
I have a really long webform that has hundreds of text fields, text boxes, labels, etc. I would like a button, that when clicked, will populate either a .doc, .pdf, .rtf, etc. file in a nice, printable format (perhaps from a template?) with a 'Save File' prompt displayed to the user. I don't know how to do this, but I can get the data from either the webform itself, or from the SQL database (which is where I'm populating the webform anyway). Simply clicking FilePrint from IE is not acceptable because we need a document that we can distribute electronically. How can I populate one of these file types from a webform or database?
Version Of Windows Server
Just starting with ASP but I have to order our server and serversoftware ASAP. Does it matter which version of Windows Server I go for? Our plan is to create serachable catalougue with dinamic pages using ASP VBscript and Microsoft Access. I am guessing it might depend weather we host the site ourselves or use a provider
Is There A VCS (version Control System) For ASP ?
As the subject states, does anyone know of a VCS for ASP/VBS files ? We are using the Liberum Help Desk system, which is "open sourced under the GPL license and free for use", and are about to make some changes to the system. As each new version of Liberum is released, we may need to re-apply our changes to the new source code. Any easy ways of doing this, or any good VCS available ? Any tips to help cut down on the work involved to re-apply our changes, for instance, the use of includes would be obvious. Our version of the (Access) db will be different from the Liberum releases, and I guess using stored queries would be in preference to 'hard coding' the SQLstrings ? I also hear stored queries are faster. With each new version, we would need to find out (i) Differences in the new release to the previous release, and (ii) Diifferences between the new release and our 'version' of the product. Any easy methods to do this, rather than a multitude of "file compares" ??
Maintain Version Number
We have developed an ASP application and I need to maintaind version number in the application. Earlier I was developing VC++ application and it is pretty straight forward to maintain version numbers.
Server Version Type
I am trying to set a mail reply back on a site and was wondering if there is some kind of script, that would let me know the Server type and version the site is at so I can determine if I should use CDOSYS or CDONTS.
Choose Oracle Version
I've just had a problem with an ASP page not connecting to one of our Oracle databases. It turns out that the web server has Oracle 8.1 and Oracle 9.2 installed and that my ASP page was trying to connect with Oracle 8.2. The TNSNAMES.ORA file for this version of Oracle is not maintained and did not have the correct entry I need. Is it possible to force my ASP pages to use Oracle 9.2 until the migration is complete and Oracle 8.1 is removed? My connection string looks like this: Session("PROVIDER") = "Provider=OraOLEDB.Oracle;Data Source=ht;User Id=" + Request.form("username") + ";Password=" + Request.form("password")
|
TRACKER
