Error From Migrating
I promised a friend that I'd help him move his site over to a new server. It uses ASP and an MS SQL database and is on a Windows server. I moved his files over and for some reason I'm getting the following error and was wondering if someone could help figure out how to fix it.Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/default.asp, line 86
Here is the code where the error is generated from (the recordset is line 82):Code:
function rs_readonly( sql )
dim rs
set rs = createobject("ADODB.recordset")
' rs.cursorlocation = adUseClient
' response.write( sql & "<br>" )
' response.write( "<p>" & sql & "</p>" )
rs.open sql, connection, adOpenKeyset, adCmdText
set rs_readonly = rs
end function
Also, this is in the global.asa file. Can somebody tell me what this means/does?
View Replies
ADVERTISEMENT
Let me first apologize for anything that makes me sound stupid. I'm really not a ASP programmer, but i am the one fixing our glitch.
First, let me explain whats going on. We have a company intranet signout board. And under our IIS4 server, it works just fine, but under IIS 5 its works except for one glitch. The board lets the user choose their name from a databse, and enter a date and time of leaving a arriving.
On the old server, if the user just entered a time, it automatically added the current date followed by the time. Now, if the user just enters a time, that all that is displayed, and for some reason the board will only allow one name to be displayed like that.
So if person A signs out with just a time, he is listed, until person B signsout and overwrites person A
I think i have narrowed the problem down to this
If FormatDateTime(Request("txtReturn" & intIndividualPerson),2) <> "12/30/99" Then
rsUDPerson("OutReturning") = Request("txtReturn" & intIndividualPerson)
Else
rsUDPerson("OutReturning") = Date & " " & Request("txtReturn" & intIndividualPerson)
End If
The idea is, if there is a date, it wil be different then 12/30/99 so nothing is changed, but if no date if there it adds the current one. It almost acts like there is no Else statement.
View Replies
View Related
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is
Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS
as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+
application) fails.
It throws common error
Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running
application on Windows 2000 advance Server.
View Replies
View Related
We have a huge fat client database enabled application.
It is a MDI app with a very rich graphic interface and hundreds of different
screens and dialog windows.
There is a lot of client side processing, validation, file manipulation even
interaction with 3rd party apps (i.e Microsoft Office).
Is it possible to migrate this type of an app to run as a Web app using ASP
..Net?
Are there any 3rd party frameworks/libraries that could be used to
accomplish this?
View Replies
View Related
have a simple asp program that works fine from IIS. It's made up of 2 asp files and one MS Access database. One asp file execute just fine, it executes its code and dumps the html results onto the asp file I point to in the browser.
But on an ISP's site, after uploading the 3 files, the execution doesn't happen. The asp file I point to using a typical URL, shows only and as expected a couple of lines at the top of the page. The execution below that however, is not happening, and what I see normally locally just isn't there. What gives?
View Replies
View Related
My client has the need to upgrade to Windows 2000 Server from NT4 but are
concerned about whether there existing custom code (ASP,VB6,MTS, etc) will
work correctly once migrated.
Does anyone know where I might be able to find information relating to what
functionality has been deprecated in Windows 2000 Server since NT4 (I know
CDONTS is one of them).
View Replies
View Related
Whats the estimated time frame for an experienced asp/vb developer to get a
handle on asp.net in a comercial environment Im just looking on advice ?
View Replies
View Related
what all things to be taken care while migrating asp applications which is currently running under WIndows NT , IIS to Windows 2003 IIS.
View Replies
View Related
i will need to change my current Access backend to MS SQL 2000 Server. I have never done this before and I ve been told some queries change and some operations like JUNCTION etc, change too or at least act a little bit different.
I would like to ask to you people all sorts of suggestions, steps to follow, tutorials, etc,, you know, just all sorts of help to go through this without getting a headache.
View Replies
View Related
this is Aravind from hyderbad. i am working on application which we are migrated asp application from WIN NT to WIN 2003. Here iam facing some problems.
here iam loading .asp file as image on another .asp file to display data in chart. this is working good in WIN NT but it is not loading in WIN 2003.
iam giving html tag which we used to load the image
<img src="abcd.asp"> (this .asp is in the same directory)
but this is not loading.
Is it the problem with WIN 2003
View Replies
View Related
if i have 2 datasources with different table names and column headers that i want to merge i.e. "ptitle" and "name" whats the best way of doing this? are there any standard routines or should i use something intermediary like xml?
View Replies
View Related
Anyone over here ever Migrated WebWizForum from Access to MSSQL?
View Replies
View Related
I'm now receiving this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
login.asp, line 9
Worked fine with Access. Can somebody help me tidy up my code. login.asp below. Code:
View Replies
View Related
I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and
web browser for encoding to the database.
View Replies
View Related
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code:
View Replies
View Related
# 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
View Replies
View Related
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.
View Replies
View Related
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
View Replies
View Related
i m getting this following error:
Compiler Error Message: BC30002: Type 'ODBCConnection' is not defined.
Following is my code: ...
View Replies
View Related
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
View Replies
View Related
I am trying to display data from three tables in an MS Access database. Here is my code:
View Replies
View Related
CDONTS 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....
View Replies
View Related
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:
View Replies
View Related
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."
......
View Replies
View Related
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: .....
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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).
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
I had developed a messageboard in asp which allows users to post new messages,reply to existing messages.I am using textarea (Html tag) for a messagebox in my asp page .When the user enters any characters in messagebox except a single quote ('),the message gets inserted in oracle database without any problem.But if message contains single quotes (') , while inserting in a database it gives the following error
"Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00917: missing comma ".
Is there any solution to insert messages containing single quotes in a database?
View Replies
View Related
My asp run smoothly before. But, now, I found the ASP page is not smoothly recently.
Sometime if the ASP is requested to connect to Access, the page will prompt
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 0xdd8 Thread 0xae0
DBC 0x3a85074 Jet'.
What's going on?
View Replies
View Related
I tried to display an error detail on my webpage when I got an "HTTP 500 Internal Server Error" of my .asp page, but I was failed I did setup in IIS so it will display debug error on my asp page as well as setting up my browser internet option.
Can you help me how to set it up so I am able to see the error detail on my browser when I get "HTTP 500 Internal Server Error" ( Currently, I just got a blank page with "HTTP 500 Internal Server Error" in the web page title)I run IIS 5.0 and window professional xp browser.
View Replies
View Related