I have an ASP page using Jet 4.0 oldeb provider for mdb. (ADO 2.8). I use
the _same_ code in ASP from my well working VB application.
The problem is:
when I do the same "SELECT * FROM table WHERE field1 LIKE '%asdf%' " query,
it works in Access (SQL query) or in my VB .exe code, but generates OLE
automation error in ASP. The same code!!!
If I use "=" instead of LIKE, it works. (field1 is string type). But I need
LIKE
I have a very small ASP function that basically allows me to add items to a list and it all gets stored in an Access DB. The output is a loop that displays all of the items.
I wanted to know if anyone knows how or if with ASP I can update an RSS file so that when it saves the new list item it also updates the RSS feed with the new items as well. Sort of like updating a Text file just not sure how or even if it can be done.
I am getting ready to build another ASP page with a form on it. This form is part of a very complex application I am in the middle of building. It is an event management and scheduling application. The whole idea of this page is to register an individual for the event and to schedule their activities they want to participate in.
Here is were it gets complicated... We have over 30 events and they are all happening at different times. Some are overnight and others are half day and other are full day. We even have some that are two days long.
Some of the events can hold 80 people but their are 40 instructors for that time period. I solved this problem by creating section numbers kind of like in a college. Here is my actual question:
How can I build drop down boxes that change according to what is selected in a previous one. I am using the DB to populate the drop down boxes. Here is an example of what should happen: Code:
I have a recordset containing some data.
Using that recordset I want to populate them in a work book in differrent
sheets, using client side VBScript.
Previously, I used server side automation for this. But it gives error
"ActiveX Component can't create object" then and there. Some times the
automation works fine.
I need to generate one document on the server and then send it to de client. I having problems of security when i try to open word by code. How can i do that?
View Replies View Relatedi have a software application and i have to import around 250 users data into the app.
I want to automate this step,it the most common info
like FN,LN,e-mail etc.
The app runs on IIS and uses ASP. I am looking for a GUI input Automation tool which will have scripting capability to take input from a text file and fill the user input fields "automagically".can testing tools like winrunner do this for me?
I have a script that populates my access database upon form submision.I was asked to find a way to automatically Populates 10 records, that do not change, to the database
once a month.I thought of using WHS to to call IExplorer to execute and launch the URL. and set the windows scheduler to execute it once a month.
But my 10 records that I need to add have different names. How do I set the loop to call the record set
for each field name.Another approche is to set those uncahgeable data in a flat file and use my asp script to call the file and append the records in the table.
What is the best approch
I developed an application using VB6 as FE and Access as BE ( Lan based solution). This application involves picking up preformatted excel workbook with multiple worksheets as template . This excel workbook is more like a form ( containing checkboxes and option radio buttons etc). This also contains clients logo, Header, footer. In this application, on a button click event, the Excel file is picked up from a fixed location, opened, and some data like name of the user, address etc which are available in Access are filled into predefined cells of the excel.
In case any of the fields is already filled, the application reads that fileld and performs validation. After this the workbook is saved at the original location. Most of the fields are not stored in database and data is not in a tabular form.
Now I need to make this application web enabled instead of being on LAN.
Can the above excel automation be acheived in conventional ASP or ASP.net.
I can force the excel path to be fixed path on server ( IIS). I would be too happy if the said excel workbook can be picked up from client machine, modified and stored back at same location.
i have a problem in email using ASP.i have created 3 fields named EMP MAIL,TRAINING START DATE,TRAINING END DATE.now the user enters these 3 details and on clicking the SENDMAIL button the mail should be reached to that particular employee 1 week before the date entered in the TRAINING END DATE field.after testing the application this all is working fine(i used CDONTS in ASP).
The problem is that every day user has to run my application atleast once only then all the mails that are to be sent on that particular day will be sent.
i think this is no good as user will enter the details once for any day and he or she may not run my application every day..in order to send mails automatically what should i do..pls any body can give me any suggestion?
I'm about to create an ASP script which will essentially parse SQL
tuples (rows) into a Word file, creating labels, although would need
to use the pre-defined label templates within word.
Can anyone direct me in the right direction?
I want to do some time based house cleaning chores on a server based on server time/date. I know how to do it based on a call from the client using asp, but is it
possible to have a program residing on the server that comes alive based on server time (not a client call) and does it's tasks such as delete an inactive page, or more importantly, send out a cdonts e-mail to a client list? I should also mention that this is a shared Windows 2003 Server (Interland Blue Halo).
I've develop a simply exe app that merge two or more document in one using MsWord automation.
I call this exe from an asp page (giving authorization to IAWM IUSR...). This run ok on a web server with Xp and IIS 5.1 but don't work on W2K3 and IIS 6.0.
We have a excel document, which is been updated regularly. After everyday
updating, we export as HTML file and upload it.
As a ASP programmer, I want to write a script, which can parse this excel
file and make it as a web ready file.
Is there any simple way to do this?
Our data entry operator, is very new to computers and all he know is a
little in Excel.
I am facing some problems with generating the word documents usin ASP pages. This is the automated process and it is breaking often Since Microsoft is not providing any support for this issue, I though using WordPerfect 12 for the automated document generation would hel me a lot. Is there any possibility of facing the same problem with wor
perfect too?
I have problem in word automation. I have a code in VB that opens word document and performs some Find & Replace operations in it and then shows to the user the document. The script runs perfectly on local machine which has Word2000 and OS-win 2000 professional. But When I test the same script on Server which has Os-2000 server Edition and word2000 then it does not opens the word doc eventhough script has line "WApp.visible = true".
I am using Word.Application and Word.Document object in my script. When I create a word document with same script but close it in end of script and then open it with shell script command it works perfectly. But my requirement is not to save the doc but only show it to user and leave it for users choice to save it or not.
Could someone point me in the right direction? I've
migrated three FrontPage 2002 websites to a new web
server. Each web site has a Access 2000 database on the
data server.
I have the global.asa on each site pointing
to a .udl file which is pointing to the appropriate access
DB on the data server. We're not allowed to use DSN's.
Front Page 2002 will not allow me to create a network
connection to an Access (only SQL). Only one of the three
web sites work. On the other two I keep getting the
following message when I open an ASP page: Code:
I have a page in my website which display the weekly timeslots. The code that generates these slots is giving me the following error:
Microsoft VBScript runtime error '800a01b0'
File name or class name not found during Automation operation: 'regExp'
It used to work fine, I have no clue what has gone wrong.
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code:
# Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/CoxAxis/adminEditPage.asp, line 6
My code:
<%
dim self, pid, i, c
self = Request.ServerVariables("URL")
pid = Request.Querystring("pid")
set Session("pageContent") = Server.CreateObject("Scripting.Dictionary")
Set custObj = Server.CreateObject("NFIFunctions.ValidateField") Line 6
set psi = Session("pageContent")
set errDict = Server.CreateObject("Scripting.Dictionary")
i = 1
i'm getting
Provider error '80004005' Unspecified error
admin/dbconnection.inc, line 4
what this is, it only started happening after i did a recent upload of my database!, i 've tryed uploading it again but the error still appears.
Let me start by saying I'm fairly new to Asp coding. That said...
My ISP only uses AspSmartMail. I've created an online form that uses fill out, which is then e-mailed to the collector of the information and CC-ed to the person who submitted the information.
The error I'm receiving is this:
aspSmartMail.SendMail : Error 28 error '8004001a'
504 Invalid Username or Password
In my script, I've Dimensioned several items, as you'll see below, passing the authenticating username/password to the smtp server, but it's not working. I tried not passing the information by entering in the actual info without it being passed by the diminsioned items. This didn't work either. I of course verified that the username/password I'm usine is correct.
Can someone plase tell me why I can't authenicate? I would really appreciate any help that might be out there.
Relavant Asp code below:
-----------------------------------------
Dim smtpserver,youremail,yourpassword,yourusername,rem oteemail
'Edit these 3 values accordingly
smtpserver = "mail.smtp_server.org"
youremail = "yourname@smtp_server.org"
yourpassword = "password"
yourusername = "yourusername"
remoteemail = "email_address_to_send_to"
Dim ObjSendMail
Set ObjSendMail = Server.CreateObject("AspSmartMail.SmartMail")
'Config remote SMTP server info.
ObjSendMail.Server = smtpserver
ObjSendMail.ServerTimeOut = 35
ObjSendMail.SenderAddress = youremail
ObjSendMail.Password = yourpassword
ObjSendMail.Username = yourusername
'End remote SMTP server config.
'Config E-mail.
ObjSendMail.Recipients.Add remoteemail
ObjSendMail.CCs.Add Request.Form("Confirm_Email")
ObjSendMail.Subject = "Email Subject"
ObjSendMail.SenderAddress = "Confirmation-NoReply@smtp_server.org"
ObjSendMail.SenderName = "SenderName"
ObjSendMail.ContentType = "text/html"
ObjSendMail.Body = strBody
'Note - strBody is Dimensioned elsewhere in my script to build the HTML message body.
'End Config E-mail.
'ObjSendMail.Send
ObjSendMail.SendMail
if err.number <> 0 then
response.write("Error n° " & err.number - vbobjecterror & " = " & err.description & "<br>")
else
Response.Write "aspSmartMail has sent your message with this file as attachment : <br>"
'Response.Write ObjSendMail.Attachments.Item(1).FilePathName
end if
Set ObjSendMail = Nothing
---------------------------------------
End code
i m getting this following error:
Compiler Error Message: BC30002: Type 'ODBCConnection' is not defined.
Following is my code: ...
I keep getting an error when I try to run this update statment: [CODE]
INSERT INTO MYPosts ( IEname, country, server_name, LANIPAddy, license_ver, wrkstn1, wrkstn2, wrkstn3, wrkstn4, wrkstn5, notes, status, rdse, esc, eso, parent, , timezone, ) VALUES ( '" & lcIEname & "', '" & lcCountry & "', '" & lcServerName & "', '" & lcLicenseVer & "', '" & lcwrkstn1 & "', '" & lcwrkstn2 & "', '" & lcwrkstn3 & "', '" & lcwrkstn4 & "', '" & lcwrkstn5 & "', '" & lcNotes & "', " & lcStatus & ", " & lnRDSE & ", " & lcESC & ", " & lcESO & ", " & lcParent & ", " & lcTimeZone & ")"
I get the following error:
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression
I am trying to display data from three tables in an MS Access database. Here is my code:
View Replies View RelatedCDONTS is not working on my webserver. IIS 5.0 Windows 2000
I am using this code
<%
Dim objNewMail
Set objNewMail = CreateObject("CDOnts.NewMail")
objNewMail.From ="webmaster@test.com"
objNewMail.To = "***@***.com"
objNewMail.Subject = "Test"
objNewMail.MailFormat=0
objNewMail.BodyFormat=0
objNewMail.Body = "<html><b>test test</b></html>"
objNewMail.Send
Set objNewMail=nothing
%>
But it gives me error
__________
Microsoft VBScript runtime error '800a0046'
Permission denied
/test.asp, line 11
_________
I have also referred this Microsoft KB but no help....
I'm trying to send an email with a list of people in the body of the email but when i ty to send the mail i get the error
Microsoft VBScript compilation error '800a03ea'
Syntax error
/admin/tr1.asp, line 124 do while not rsp.eofwmail is the body of the email.I'm completely stumped here. Code:
I have a database driven (ms access) website which runs fine on my computer (win 2000 iis6). However, on uploading, some pages am receiving the following error
"An Unknown script error occured while processing your request."
......
I am testing a new website I built on the actual server. My section for uploading documents seems to be giving me problems. Can someone help me please? This is the error I am getting:
Microsoft JET Database Engine error '80004005'
'c:logindatairb.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
/login/insert.asp, line 28
I had this before: .....
This New Company I'm with Sets their Default WebSite to a local Directory on "D" Yea I've been down the whole route reinstalling XP Pro,,, IIS 5.1 The .NET framework everything. Now I'm just frustrated.
What the Heck !! Theres a web project (C# ASP.net) in the solution containing many many some odd 19 or so projects. MSVSS is additionally in the picture to make things a little more complex. (I.E. the non web projects go elsewhere on the D drive) All I'm asking for here are the BASIC Settings to get my DEV environment and my IE to "SEE" this D:Web folder as Localhost. It worked for a sec. A very brief second. Then it was Gone. Specific ERROR:
Could not load type 'appname.web.Global'. Parser Error Server Error in '/' Application.
My text file, dsn file, and asp page are all in the same directory on the web server.My problem is that I want the text file to be on drive U: (which is each users drive)When I do this I get the following error (even if I copy the dsn file to the U: drive):-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Text Driver] '(unknown)' is not a valid path.Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
I'm getting the following error on one of the servers I maintain:code:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[MySQL][MyODBC 5.00.11][MySQL] 2006 MySQL server has gone away
Always occurs when the MySQL server it connects to restarts, which is hosted on another box. Nothing but an IIS restart fixes it.Is there anything I can do to get ASP to automatically pick-up the connection, or force a reconnect? I'm not an ASP coder, so a little hand-holding would be nice (don't worry, I won't kiss you).
I am getting this error after uploading an asp search page and attempting to search an MS ACCESS database.
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 0x7d0 Thread 0x340 DBC 0x2870cd9c Jet'.
I've researched the error code online,and it seems to be server-side,but a lot of the server talk is pretty much Greek to me.
I have designed my database so that u cannot insert duplicate keys. So when this happens, I get the following error:Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'pk_QuoteItem'. Cannot insert duplicate key in object 'QuoteItem'.
How do I catch this error and print a more user friendly error message?