Hi, I'm trying to make a connection to sql server database(hosted on localhost) but keep getting the error mentioned in the title. Application("ConnectionString") = "Provider=SQLOLEDB;Data Source=localhost\SQLExpress;Database=mydb;Trusted_Connection=yes;UID=dbadmin; PWD=dbadmin" Application("ConnectionTimeout") = 15 Application("C...
Hi, I have a selectbox on a form - which I've turned in to a list box by putting <select id="Select1" name="D1" size="5" style="width: 220px"> I'm filling this select/listbox with values... When I post the form how can I get all the values in the select box..is this possible or am I only able to get one that has been selected. Tr...
I have a classic asp application. I want to post a contest form from that page to an Asp.Net form. The reason is that I want to use a lot of logic i have built into an Asp.Net page for validation before entering into the database and I don't know asp very well. Not to mention asp.Net being more secure. What's the best way to accomplish ...
I am in need of some help with trying to figure out how to go about checking the users session and seeing if they are still logged in or not. The problem being is because i have a static page that pretty much loads everything into "tabs" using jquery. So when the user navigates the page, it really never leaves that same page they starte...
I want my multidimensional array to be dynamic, when I am trying to do that using reDim i am getting the error "This array is fixed or temporarily locked:refArr ", Following is my code: max=10 dim refArr(10,2) dim i i=0 while not rs1.eof max=max+1 redim refArr(max,2) niftyChange=0 refArr(i,0)="niftyDate"...
I'm using jQuery UI Sortable to make a list "categorizable". I'm stuck on the code to put items in the proper category when the page is loaded with existing data (either from the database or just from a prior form submit). The html is a list with radio buttons: <ul id="Main" class="sort"> <li> <input type="radio" name="i1" id="i1...
In a VB6 program: Dim conn As Object Set conn = CreateObject("ADODB.Connection") conn.Open "DRIVER={SQL Server}; Server=(local)\aaa; Database=bbb; UID=ccc; PWD=ddd" In an ASP program: Sub ProcessSqlServer(conn) Set conn = Server.CreateObject("ADODB.Connection") conn.Open "DRIVER={SQL Server}; Server=(local)\aaa; Database=bbb...
I'm trying to send an email using classic asp and cdonts on a Windows Server 2003 machine. But I'm guessing the SMTP service needs to be running. Unfortunately it's asking for teh SP1 disk...which apparently has gone missing. I'm guessing not but is there any other way of doing this? Thanks, ...
This is a method in ASP Classic that saves a file to disk. It takes a very long time but I'm not sure why. Normally, I wouldn't mind so much, but the files it handles are pretty large so need this needs to faster than 100kB a second save. Seriously slow. (old legacy system, band aid fix till it gets replaced...) Public Sub SaveToDisk(sP...
I can already see that I'm not going to enjoy the experience, but I have to do some sql cleanup on this 1000 file asp classic web-app without any prior knowledge of asp, and before I get to hacking away at it I'd like to be aware of any major gotchas to watch out for while coding in asp classic/sql parameter preparing/making asp whitespa...
I have a classic ASP page which is loading an ASP.net page through an iframe inside the ASP page. This is working great except for the fact that it takes a while to load the ASP.net page. The user is left here with unfavorable experience because all they say is an empty blank page until the page is finish loading. What I would like ...
<html> <body> <%@ Language=VBScript ENABLESESSIONSTATE = False%> <form Name="sushant" method="post" action="sushant.asp"> <select id="selFiles" name="selFiles" class="Select" style="width: 250px" tabindex="130"> <% Dim fso, folder, files Set fso=Server.CreateObject("Scripting.FileSystemObject") Set folder=fso.GetFolder("C:\") ...
I have the following code from a legacy app which currently reads from an excel 2003 spreadsheet on a server, but I need this to run from my machine which uses excel 2007. When I debug on my machine ADO does not seem to be reading the spreadsheet. I have checked all file paths etc. and location of spreadsheet that is all fine. I've he...
Hello, I have this web page that works fine in one webhost but not in the other one. Here it works fine: http://www.kollelbaaleibatim.com/pweb.asp Here it doesn't work: http://pmustangs.com/pweb.asp Any idea? Thanks ...
I have a text field who's value is populated from a SQL recordset (below). <input name="txtAmount" id="txtAmount" type="text" size="10" maxlength="10" value="<%=RS("Amount")%>"> In the SQL table, the Amount field (which is a money data type) is inserted correctly, as 5.00 However, in the web page, it displays only as 5 (i.e. the deci...
Hello, I want to port an existing, legacy, ecommerce website from ASP to ASP.NET. What approaches do I have ? is there a way to run an ASP file with an ASP.NET engine ? are there tools to automatically convert ASP to ASP.NET and do they work on complex websites ? other approaches ? Thanks for your help Jerome Wagner ...
I am working on a classic asp form that has a number of dropdowns. Three of these are cascading, i.e. they rely in the previous dropdown. For almost everything this code works fine, one of them however is not playing nice. To start off I have a script tag with the following in it: $(document).ready(function () { $("#Academ...
I'm using Visual Studio 2008 SP1 and trying to debug a website created in ASP Classic. I have read numerous tutorials, however nothing seems to be working (PEBKAC?). I have enabled server-side debugging in IIS and am attaching the debugger to dllhost.exe. When I open my page in Google Chrome, set breakpoints and set VS to debug, nothing ...
In asp classic, the cint() function or procedure or whatever it is won't allow me to cast arbitrary strings, like "bob" or "null" or anything like that. Is there anything that will allow me to simply cast integers, numeric strings, and arbitrary strings to actual integers, with some sane default like 0 for strings? ...
The following function was suggested to me: ' Defines a forced casting function, which "casts" anything that it can't detect as a number to zero. Function MakeInteger(val) If IsNumeric(val) Then MakeInteger = CInt(val) Else MakeInteger = 0 End If End Function Unfortunately there appear to be s...