I am getting this error. Got it for the first time, so am really not sure why
"[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '/dbmckenna'. Login fails.
/Sitter_Registration.asp, line 12 "
I have an ASP 2.0 secured website that works fine.My problem is that I need to run this "mini site" inside a frame.We have a domain hosted website and I'm redirecting the frame contents to our IIS server and my MD doesn't want the customers seeing a "messy" IP
address, so the solution was to run the mini-site inside a frame. However, despite the login screen being displayed, when a user logs in, theuser.identity.name is null and roles are not set.
I've got some ASP-code that uses FileSystemObject to move user home
directories on a DFS-root. When I run this code on the original
Win2000/IIS5-server, it works fine. But when I try it on a
Win2003/IIS6-server, I get the following error:
-2147023545
which I found can be translated as follows
=> 0x80070547 => 1351 =>
"Configuration information could not be read from the domain controller,
either because the machine is unavailable, or access has been denied."
I've tried to run IIS in IIS5-isolation mode, but get the same error.
i mtrying to run a message service using net send via our intranet -
basically the user selects the poeple on the network who they want to
send a message to from a drop-down list on a form and on submit a loop
is run - here's a snippet of the code (inside a for loop)
<% elseif Request.Form("recipients")(a) <> "" then %>
<% NamUsr = CStr(Request.Form("recipients")(a)) %>
<% server_shell.Run "%comspec% /c net send " & NamUsr & " FROM " &
username &":" & Msg %>
(Note : I create the server_shell object outside the loop and set it
to nothing when the loop has finished - also username is basically
Server Variable Logon User)
The problem happens when all users are selected - it sends it to a few
people and then bombs out and then i get a load of application errors
- cmd.exe or net.exe failed to initialize on the server.yet when tested for smaller numbers of users it runs fine
I have created 2 tables on my db. one is for customers and one for corporate. this is to distinguish the records so that we wont mix up our clients. i have created a login page for both customer and corporate. however, i think there is something wrong with the login process code which process the login for users to our page. there is an error message:Error Type:
Provider (0x80020005)
Type mismatch.
(see highlight in red) for attached code.i am not sure if its correct but here is the code as attached
<%
Response.Buffer = True
strUserName = Request.Form("User_Name")
strPassword = Request.Form("User_Password")
Dim rs
Dim sqlStr
Dim record_found
record_found = 0
Dim vPath, pPath, ConString
vPath = "xxxxx.mdb" 'use this one if database is in root of cart folder
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDB:"
Dim Conn, rsCatalog
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConString
sqlStr1 = "SELECT * from Customer WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
sqlStr2 = "SELECT * from Corporate WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
set rs = Server.CreateObject ("ADODB.Recordset")
adOpenStatic = 3
rs.CursorType = adOpenStatic
rs.Open sqlStr1, sqlStr2, conn
If (rs.RecordCount <= 0) Then
Response.Redirect("login.asp?from=no_record")
Else
record_found = 1
Response.Cookies("User_Name") = rs("User_Name")
Response.Cookies("User_Password") = rs("User_Password")
Response.Cookies("Login") = 1
Response.Cookies("View_Cart") = 0
End If
rs.Close
Set rs = Nothing
if record_found = 1 then
if Request.Form("hiddenVal") = "view_cart" then
Response.Redirect("view_cart.asp")
else
Response.Redirect("default.asp")
end if
end if
%>
I am trying to create an asp login wiht registration using asp and a ms access database.
However when i uploaded the asp pages onto the server it through up two problems. Code:
after publishing a web to iis, asp pages based on a
database fail to work. the browzer starts loading such page
and never does- at some point the status bar stops and the
page never loads without displaying any errors. the browzer
shows that it is busy all the time.
Greetings, I'm using simple code to send customers an email after they submit a helpdesk ticket. I wanted to copy myself on the emails, but when I enter myMail.BCC or myMail.CC, it fails to send. If I comment out these lines, the message sends successfully. I've made sure the bcc or cc addresses are valid. I changed the names in my code to protect the innocent.
View Replies View RelatedCreateFolder method does not produce a result from IIS. I tried many things including changing file permissions, web server permissions etc. to no avail.
View Replies View RelatedA custom ASP web application that i have developed has stopped working
after the install of WinXP SP2. The application breaks on:
Set oMaint = Server.CreateObject("efilingMaintenance.clsMaintenance")
with error message: Code:
I have an asp page (see source code below) running on IIS 6.0 on
Win2003 Server that tries to get file and folder information on a
Novell Server. I am able to successfully connect to the share on the
Novell box if I use the UNC path. But, unfortunately, I need to have
the mapped path for my application.
I created a simple vbs script and
saved it to the server desktop and run it to verify connectivity to the
Novell box. I am logged in to the server with the same user as set up
in my website as the anonymous user. The vbs file runs perfectly. But
as soon as I move the code into an asp file, I get the following error
"Microsoft VBScript runtime error '800a004c' Path not found". If I
go into my asp file and change the path to the novell box to a UNC
format, then it works. Below is the asp file: Code:
I have an upload script that seems to fail in Firefox and Mozilla based browsers when it hits the .SaveToFile Method. It works fine in IE. Is this a documented bug? Is there a work around?
View Replies View RelatedI am attempting to have an asp page call a batch file. I had it working, I was high on life and then I decided to log off the server. Once I did, the code would no longer work. When I logged back onto the server, I saw:
'The application failed to initialize properly (0xc0000142). Click on OK to terminate the application.' Code:
I'm experiecing a problem with file uploads from ASP pages.
On a Windows 2000 - IIS 5 server we're running an ASP Classic
application that features an upload form for files of great dimensions
(100+MB). Problem is, when we try to upload a file exceeding 3MB we
retive almost immediatly a message such as 'The page cannot be
displayed'.
We do not even reach the page that contains the code for file
managing; when we click on the submit button in the form with enctype
multipart form data the application ends and the error is visualized.
For files under 3MB there are no problems at all.
The FAQ of our upload third party component (ABCUpload by Websupergoo)
state that we could either have problems with our proxy or we could be
stopped by a wrong URLScan setting: we do not have any proxy nor
URLScan is installed on our server.
I may add that all the configuration of the script timeouts on IIS are
correctly set.
Is there anyone who can suggest us a solution?
I have a big asp file that has an error under certain conditions -- totally
repeatable. However, it only fails when I set response.buffer = True at the
top. WHen I set it False in order to debug it, it works every time! I even
set it to True, but did a .Flush just before the error, and the error won't
happen.
It only happens when response.buffer is True and no .response.flush is issued.
The error is a string variable turns-up empty and crashes a function
requiring a date. I could test for this before the line where it crashes,
but where did my data go? Why is the buffer affecting it?
If I copy & paste from a RTF document into a field, the javascript validation and field length are bypassed and cause the form to fail.
View Replies View RelatedNot sure if this is the right place but I need to get this website going and am having problems with the ODBC driver connecting to the SQL server When setting up the driver I am getting a sql error 18452 login failed reason: not associated with a trusted SQL connection I am at a loss as I installed this on another machine and it worked.
View Replies View RelatedCan anyone tell me why this code doesn't work? The original came from
an example in this group, but was modified slightly when the original
failed to return message details.
I am able to connect to the server and see the number of messages on
the server, but message details (sender, subject, body, etc.) are not
returned....
I am building a website to pull data from a remote https site using xmlhttp. The data from the https site is behind a login screen. I can successfully get through the login screen with:
set objXMLHTTP = Server.CreateObject("Msxml2.ServerXMLHTTP")
objXMLHTTP.Open "POST", "https://website.com/validate-login2.asp", false
objXMLHTTP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objXMLHTTP.Send "Username=uname&password=pwd&company=O"
That works great - but then, when I try to go to the next page (where the data is that I want to pull) - I use the same process and I get kicked back out to the login screen? Could there be some cookies, referer, strings being passed normally that I am not including in my second request - How do i find out for sure?
I have used the software IETrace and it looks like some cookies being passed, but how do I know for sure if (and what exactly) it is using?
The SQLServer and Web server are different computers. The error I got when logging on as ONLINE/ONLINE is "Cannot open database requested in login '<mydbname>'. Login fails.
/<mysitename>/validate.asp, line 12
Line 12 is: objConnection.Open Session("ConnectionParameter")
In global.asa, the setting is:
If Session("DataBaseBrand") = "SQLSERVER" Then
Session("ConnectionParameter") = "DSN=Alecto;UId=ONLINE;Pwd=ONLINE"
The names of UserID/Password fields on the form are dfsUserID/dfsPasswd
Below is validate.asp: Code:
I want to login to a page using MSXML2.ServerXMLHTTP.4.0 or an object like this, I must send the form variables needed to login when I try to login to the page. But the problem is, that the page looks like a exe file (not a asp file or php file or what ever). The name of the page I try to login is something like "/pw?/session/login", nothing more, without extension. I have tried the code with a normal asp file with session registration and login process and it worked, but not with this file.
View Replies View RelatedI 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.
I have created a login and members page, and checked that it works, so that when you enter the correct username and password it logs you in.
But how can I have it redirect the user to their own personal page? Because I don't want to have different users going to the same page, I want them each to have their own personal members page.
I've created a site where the user can register and then log in. However if a user registers, the data is entered into the database, but they cannot log in. But a username i entered directly into the database still works when logging in.
Does anyone have any ideas why this may happen?
I get an error like this:
Type mismatch: '[string: "UPDATE dbo.con_users"]'
With the following query code:
UPDATE dbo.con_users SET last_login = #" + nowDate + "# WHERE username = '" + Replace(userUSERNAME, "'", "''") + "' AND password = '" + Replace(userPASSWORD, "'", "''") + "'"
I've successfully tested the variables in it (nowDate, userUSERNAME, userPASSWORD). What is the mismatch?
I've already created a login page .. but how am i suppose to make sure that only those who login can access the member's areas and those who hasn't login will be redirected to login.asp ?? Is it possible to use cookies ???
View Replies View Relatedi am getting log in the application and woring with my some
windows.now keeping that other window open and now from that main window i am
logging out. so it throws me to the login page (as i am logged out). I
am also clearing and abandoning the session. also with the
FromsAuthentication.SignOut().
now with that login page i am relogging with other persons login ID.
Now i am taking the other window which i had kept it aside and now
refreshing it, it is showing me with the rights of the previous User.
I want it to redirest to the login page as it was open by other user
and now that user is not a vlid user as he has logged out.
Im new to ASP and im having trouble building a login script. I need an ASP login that reads the username and password from an XML page.
View Replies View Relatedi have a login page and a page that validates it, if you log in succesfully i want to to display the name of the user on the admin page e.g i want to have "welcome and then the name of the user" how can i do this?
View Replies View Relatedi couldnt find this around the site anywhere.
i'm very new to asp
i am trying to have users be able to register, so they
need to be able to change the users.mdb file
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("users.mdb")
they web browser says that i need to change that line of code so
it sends the password to the database so i can get access to it.
i want to make a login session for 40 misnutes.so, what should i do.
View Replies View Related