I have an classic ASP application which calls a VB6 activeX dll component. The DLL uses Office web component(v11.0) to create spread sheet. I'm getting an error when i try to create an instance of OWC11 Spread sheet. Dim oSS As OWC11.Spreadsheet Set oSS = New OWC11.Spreadsheet -- ActiveX component can't create object(error id 429) T...
Dim conn, spinsert Set conn = Server.CreateObject("ADODB.Connection") conn.Open " Provider=sqloledb;Data Source=eightprinter;Initial Catalog=Movetest;User Id=moving;Password=moving123" If conn.errors.count = 0 Then Response.Write "Connected <br>" spinsert = "dbo.Sp_Companydetails_Insert "&errCompname&" , "&errUser&" ,"&errPwd&"...
Hi everyone, I'm trying to connect to an oracle db from an odbc connection, the odbc connection is set and works properly when we test it. However when I try to connect to through ASP classic I keep getting that msg. I'm also able to connect to it through SQLPLUS and able to ping it with tnsping <% Dim connection : Set connection = Ser...
I have the following Stored Procedure, Im looking for the correct syntax so I can play the Comments Value in the Comments column with N in front end the value for Unicode I need save Russian Characters Values So at the moment the comments value is being passed as such @comments I want to do N@comments but not working ALTER PROCEDUR...
is there a library available for classic asp. I want to create a pdf file from rpt file in classic asp. i dont want to install crystal reports. is there a way? -Vivek ...
In a classic ASP Website, how can I use a DLL that is a .NET 2.0+ C# and some times VB Library? Is there any method we can use to consume such library? Added ...in order to use it in a Hosting Environment? Well, I can always create a WebService to serve as a "middle-men" but for such huge Libraries is impossible/takes long time... ...
Hi there, I've created a parametised query to get article/page content as follows; <% article = cint(request("article")) Set conn = Server.CreateObject("ADODB.connection") conn.Open Application("database") Set cmd = Server.CreateObject("ADODB.command") With cmd .ActiveConnection ...
Following this other question on how to make parametrized sql query on classic asp, I now ask how to debug it? I can write in a CommandText with it, and execute, but I can't see which SQL command I'm actually trying to run. So is there a way to check ADODB.Command's output to SQL? ...
I have a test form, (see below), that if I Submit manually, (clicking the Submit button), returns an XML list of orders from the action script. I would like to be able to pass the XML currently contained in the test HTML form programmaticaly via xmlHTTP. So far no luck. Any help would be appreciated. <form action="processorders.asp" m...
A while back, I needed a solution to sanely import libraries in VBScript. VBScript, for reference, has no build-in import capabilities. The traditional method of importing files is to use SSI, which dumps the contents of the includee verbatim into the includer. This is less-than-optimal for a number of reasons: there is no way to avoid ...
Using traditional ASP how can I return an image from a query. I want to use an image on a web page for tracking purposes, so for example I might have a page containing: <img src="../cgi-bin/getimage.asp?user1234&page=1232" WIDTH="1" HEIGHT="1"> Where GetImage.ASP would record the passed details and return a transparent GIF. ...
Hi there, I'm getting the following error on my site; Microsoft VBScript compilation error '800a03f2' Expected identifier /includes/pagecontent.asp, line 2 Public Class Article -------^ The above include is referenced in my page as follows; <% Dim article : Set article = GetArticle(22) %> <!--#include virtual="/includes/pagec...
Is it possible to run classic asp on Cassini Webserver? I have a mixed website (classic asp and dotnet)... ...
Am I always going to be able to use PATH_INFO to derive the root of my application as in the following function? function CommonFunctions_getRoot() pathinfo=Request.ServerVariables("PATH_INFO") Set myRegExp = New RegExp myRegExp.IgnoreCase = True myRegExp.Global = True myRegExp.Pattern = "^(/\w*/).*" CommonFu...
Hi I have just redeveloped some vbscript in to c#.net and i have it working well. However the function contained within the aspx.cs page that i have developed really needs to be used within a asp page. Is there anyway that i can use my aspx.cs functions within an classic asp page. Maybe using an include. If i can't it just makes the ...
I have a classic ASP website I am working to try and convert to .NET- one page at a time. I am using VS2010 for this. The development db is on a network share drive, and when I try to debug my application I recieve an error because the BIOS command limit has been reached, as a result of the db being located on a network share drive. Is t...
Is: <% Set Mail = Server.CreateObject("SomeCOMObject") Set Mail = Nothing %> the same as: <?php $Mail = new COM("SomeCOMObject"); $Mail->Close(); // <---- Not sure about this ?> ...
Hi all, I have a bit of code that I've used many times to export an HTML table into an Excel file, and it works fine. But now I have a new report that I need to be able to export that works fine when viewed as an HTML page, but viewed in Excel the entire spreadsheet is blank - no grid, no data, nothing. <%Response.ContentType = "applic...
Hello Everyone. In ASP.Net two of the possible ways to make the zip files are Sharp Zip Library Dot Net Zip Library How can i use any of these in Classic ASP to make the zip files ? And which one will be better ? ...
Hi, I'm trying to program a multiplayer tic-tac-toe game in VBScript/ASP. Here's the code on wich the error above occurs: For x = 1 To 3 If AllEqual(arr(x,1), arr(x,1), arr(x,1)) Then If arr(x,1) = GetText(currentplayer) Then bWinner = currentplayer Else If arr(x,1) = GetText(0) Then 'nothing to do Else If GetNumber(a...