Is there a way to create an asp program which counts the number of impressions, clicks, leads and sales of a certain ad and post it somewhere else? I have actually reviewed some ad servers one of which is Adxpress by Valuead. It's a good one but it'll really cost some money.
View RepliesI've got a web-based "database admin console" that uses ADOX, etc. to query a database and return the tables, columns, etc to a form that I can then use to build SQL statements to run against that database. It's very "generic" - i.e., everything is dymanically created but pretty handy to have
If you send it a "SELECT" statement, it can print out a table on the screen showing your recordset. No big deal. What I'd also like to include is some way for users to get that output in a comma- or tab-delimited text file that they can use however they like. There are two ways I know of to accomplish thi
1) Create a big string as I step through the recordset - (strOutput = strOutput & "'" & objRS(I) & "," .....) and then slap strOutput into a <textarea>. This is probably not desirable because the user would have to copy all the content in that <textarea> and manually paste it into Notepad or whatever
2) Use the FSO. However, my limited experience with the FSO leads me to believe that I'd have to SAVE the resultant file before I can send it to users. I don't want to do that.
Does anyone have any suggestions about how else I can accomplish this? Or, if FSO is the way to go (which I suspect it is), bear in mind that my only exposure to FSO is in the context of .vbs files....are there any special tricks you need to use for ASP
I keep getting this message onmy webiste. I have had to change from a DSN connection to a dsn less connection but i still can't get the site to work.
Link to the error message
Page
Here i sthe code that relates to the error message
Code:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=ftp://SimonJohnstone/htdocs/Tpvsite.mdb"
objConn.open
I need to take some info from a SQL Database into an ASP (VBscript) web page, create a temporary vcs file (Outlook vCalender file) and use the SQL data to create the entrys for the appointment, then email it to someone as an attachment. Getting the SQL values is no problem. How do I go about creating, populating & sending the vcs file? its similiar to a txt file. Its plain ASP not ASp.net and I can't install any components onto the server. It has to be kept local.
View Replies View RelatedI have a script that generates varius entities of data, like this
Name__________Value
nameA_________2
nameB_________18
nameC_________4
nameD_________23
I want to 'response.write' these onto the webpage, but I want them to be ordered by the value (largest first). Can I create a temporary table, put the values into it, then call them back using the an SQL command? If so, how do I create 'temporary tables'?
How I can erase all the files from the cache of an ASP page, at the end of a session?
Is it possible?
i am developing a search engine. its like this. i have an asp from which gets the search string. i display a page with a wait symbol for 2 seconds (meta-equiv-refresh=2) and then transfer the control to the same page which would display the search results.
I think even this forum does this type of display. Now my question is how do i start searching for the entered string and stop displaying the wait page only when the search is finished.
i.e i dnt want a wait page to be displayed simply for two seconds and then show the search page. I want to ""show the wait page after the search is started and then stop displaying it and display the search results only after the result is got""
I use the ASP to genereate the excel file. We use the Excel.Application to create a excel. But we find many excel shortcut or directory shortcut under the C: or D:
How can we resolve it?
I have a form on my site that users must fill out before downloading a pdf document, however, i would like the form to send them an email with a temorary URL.
which they can click to download from, and which expires after 'x' days. is this an asp thing? or do i have to move to .net to do this?
Is it possible to delete internet temporary files using ASP code? And maybe specify the extension of the files to delete?
View Replies View Relatedi have written a stored procedure. depending upon different parameters, query is prepared as string and executed through exec() function. it returns a certain number of rows. stored procedure also contains a temporary table. the question is this how can i insert the rows returned by the query in to temporary table?
View Replies View RelatedI am using ASP + IIS + MS access, when running the following codes:
set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")
The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508 Thread 0x634 DBC 0x2181024 Jet'.
I have shared the MS knowledge base and try to grant the modify Permissions to IUSR_SERVER on the folder that holding the database, and set the script authority in IIS, the error is still exist. If I create a system DNS for that Access file and modify the second code as ...
conn.Open "AKmobile"
Another error is show:
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
But there is no problem when conencting with MS SQL Server.
Why d I get this error?
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x18c8 Thread 0x1478 DBC 0x2f56fa4 Jet'.
/wheelofgod/search/cat/showbook.asp, line 102
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xa60 Thread 0xb30 DBC 0x1391ec4 Jet'.
/name.asp, line 17
my code:
All time that I go to make login to enter in admin is appearing this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x120c Thread 0x1494 DBC 0x1690024 Jet'.
/noticias/config.inc, line 6
In line 6 of config I have this: .....
Here's what my code looks like...
View Replies View RelatedI have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
Is there anyway to generate a PDF using ASP Scripting(VB Script).
View Replies View RelatedDoes anybody knows a way (free of cost, code or dll) to generate pdf?
View Replies View RelatedI use a website in asp for which I have to type a username and
password everytime I want to login.
On the form are two fields for typing the username and password and
one button LOGIN.
I want to create an standard url for the website which includes my
username and password so I don't have to type it in everytime.
I looked at the page source but I can't find the right string.
I thought maybe http://.........aspx?username=me&password=it
but that doesn't work.
Is there a (simple) way to create a PDF file from ASP?
View Replies View RelatedI have 2 developper machine running visual studio 2003 and Windows 2000. On the first machine (Machine A) I may create a new asp project without problem. On the second (Machine B) I cannot create a new project.Visual Studo create the project but not the initial files and freezes.
But I may create a new project from Machine A using the web server of machine B.I have checked the access rights of both servers, the access rights on directory wwwroot and inetpub.Everything seems the same.
Has anyone seen or know if anyone has done this? I think that ASP would be a great tool to do this with but I am curious if anyone has tried it and found it to be too hard or too burdensome to follow through with?
View Replies View RelatedI'm running IIS5 on a Win2K server, and I want to have an ASP page that
creates new users. I have some simple code to test this, but am getting
a "500" error when I run it. The ASP looks like:
<%
strDomain ="Foo.com"
strUser ="Foo1"
' Create new user with password
Set oDomain = GetObject("WinNT://" & strDomain)
Set oUser = oDomain.Create ("User", strUser)
oUser.SetPassword = "password"
oUser.SetInfo
%>
Just for this testing, I've added IUSR_machinename to the Administrators
group, but am still getting the 500 error.
how to create dao.tabledef object in asp:
I need to convert the following code into asp:
Dim tdf As DAO.TableDef
Dim db As DAO.Database
Dim fld As DAO.Field
Set db = OpenDatabase("C:Mydb.mdb")
Set tdf = db.TableDefs("Table1")
Set fld = tdf.CreateField("Field2", dbText, 10)
tdf.Fields.Append fld
Is there a way to create a host header in IIS with an ASP?
View Replies View RelatedI want to create a web page for my friends.(I have a subdomain and my server supports ASP scripts) It will contain a small basic guestbook.It must write the entries to a text file on the server.And i must be able to view the guestbook.
View Replies View RelatedI'd like to create ASP file on ther server side. Can I use
fso.createtextfile("c:folder est.asp")
Do I need to create a folder too?
I am trying to create a menu with multiple tiers. I want to use the one menu as an include file throughout the site. Depending on what page you are on, I want the 2nd and third tiers to show up.
The rest just show the tier 1 links. I'm pretty sure this can be done in CSS, but the problem is that with a very big menu, I'd rather not have to load up the entire menu when it all won't be showing.
There for I figured I could create it in ASP. I could set some sort of parameter in the page so the menu include file would know what page I'm on, and then would only show and load the 2nd and 3rd tiers of that section. Is this possible? Code:
is it possible to create a xml file and save so that i can upload with asp?
View Replies View Relatedi want to create flowchart/flowdiagram like msword.And the user type inside the rectangular what they want to do..
View Replies View RelatedHow can I simply save some data into a flat file (.txt) ? I've some data available and if the user clicks on a button it will save that data into the flat file... The user also need to define the directory (as in VB the common dialog box)...
Is this possible ???
I have created an asp page that pulls data from SQL server and displays
on webpage in the form of Table and Chart.
I use OWC to generate Chart. It work find on my computer with Ms office
2000 installed, but when I upload my the page to my webserver, it
doesn't work with the following error message:
006~ASP 0177~Server.CreateObject Failed~Invalid ProgID. For additional
information specific to this message please visit the Microsoft Online
Support site located at: http://www.microsoft.com/contentredirect.asp.
Does anyone know how to solve this problem?
P.S. On the production server, Office Web Component had already been
installed. WSCript.CreateObject("OWC.Chart") works fine in my colleage's
vbscript file.