I am creating a small program for my workplace in asp. It runs fine o
my laptop using XP Pro through IIS. I set IIS up on the server runnin
Windows 2000 Server Standard, have IIS set up identically, and i
doesn't recognize the session variables. Even trying to run i
directly on the server, not through the network, it doesn't work.
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.
I am planning to design a database (destined for the web) that will have
between 20000 and 45000 records in it and will receive a lot of reads but
very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using
OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially
since it's said that an Access DB can have about 9 users or so accessing it
at the same time. But is that a general rule or is it about many people
writing to the DB? In other words, if an Access DB has hardly any writes
and 99.9% reads can it be used as efficiently as it would be used on SQL
Server 2000?
I recently had to reinstall windows 2000 professional due to a harddrive
crash, I downloaded all the newest updates, now I find that session
variables are not being kept from page to page as it had with older
software.
If any else had this problem with IIs 5.0, frontpage 2002 server
extentions I would appreciate a tip. What I have found out so far is that
the session variables used with asp 3.0 are going away in favor of dot.net
asp...
This is a repost from another group, the server appears to be
configured correctly, and the application still works fine on the server it
is published on, the problem appears to be only on my development machine
after installing the sp4 update for windows 2000 Professional.
i get this error
Code:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'IUSR_MOHD'.
/sql1/data.asp, line 16
when i try to add data to my sql server 2000 database throw asp?!? so whatz the problem , i try to connect it to access on the same lginuser and it works well
We are not using Active directory and as such do not have access to Kerberos authentication methods. What I need to do is connect to an SQL (2000) database using ASP 3.0 - I have setup an account on SQL Server with read access to two tables (and no password). Just to complicate the issue even further, the IIS server and the SQL server reside on different machines on the network. Code:
View Replies View RelatedI'm just after installing windows 2000 server. It seems to be running fine. I can log onto sites stored within etc. However I'm having major problems trying to sending email forms. I am using an asp form to send the details however I never receive them. After completing the form and submitting the user is brought to a confirmation window which displays all the form details. There are no errors howver the email is never recieved.
With the errors I cannot say if the email was sent or not. So i do not know if it is the server settings or the asp file.
Do I need to preform additional installation of configuration to get the smtp server up and running as I am only using the default settings.
I just started learning ASP.NET and i need to learn to use the database for SQL Server 2000 quickly. First, (forgive me for my ignorance) what is a database? Do you guys know any good sites that teach you how to access the database for SQL Server 2000? and have tutorials, and sample code?
View Replies View RelatedIs it possible to convert from excel to SQL sever .. I have data in my excel which i want to convert to SQL server.If any body have the information.
View Replies View RelatedHow would I be able to simply read an MS Exchange Server 2000 mail and transfer it to a SQL Server 2000 database programmatically. I need reference for this an has been unsuccessful in looking for any for the past week already.
View Replies View RelatedI've noticed a few times yesterday I recived this error on my web
server:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
Server does not exist or access denied.
I know for sure the server is running and at the time was under a load of about 2,900 page views for the hour. By far not my largest audience. What could cause this? Is ODBC having some issues? FYI, the database server isn't on the web server, they are physically two different machines connected via LAN.
i just want to ask how many online connections can mssql server 2000 accomodate at the same time?
can it handle 250 to 400 simultaneous connections? the specs of my pc is pentium4, 2gb ram, 80gb hd..is this enough?
Will CDO work under Windows Server 2000? I'm guessing it will. The problem is that I wrote a nice little ASP app under Windows Server 2003 which works REALLY well. Sends out the email with NO problem. 'Course, it uses an external SMTP server, but I'm assuming this shouldn't matter, right?.
Because when I port it over to Windows Server 2000, it blows right past it. Is there a particular setup procedure that needs to be done for Windows Server 2000 to enable CDO to work properly?
I've not used Index Server since I set it up about 4 years ago on a Windows NT 4 machine.
I now have to move the site to a Windows 2000 machine. I've hunted high and low and have yet to find anything on the subject. Anyone point me in the right direction?
Am having a bit of trouble with the @@identity field - I probably just have that friday feeling and am missing off something obvious, but the below code brings back am empty identity value ("sid" appears empty). I've definitely set up an identity field in the tblSurvey:
set rsAdd = Server.CreateObject("ADODB.Recordset")
rsAdd.open "tblSurvey", conn, 3 , 3
rsAdd.AddNew
rsAdd("title") = title
rsAdd("intro") = intro
rsAdd("enddate") = enddate
rsAdd.Update
Set rsIdentity = Conn.Execute("SELECT @@IDENTITY AS sid")
sid = rsIdentity("sid")
....any ideas would be greatly appreciated.
My client had someone modify their home page of their commerce site. Howerver when then did they removed the include for store/template/menu.asp and created a hard coded menu on the default.asp (home page). Now the client wants this static menu to replace all of the dynamic menu's throughout the site. I found the area in menu.asp that pulls the data from the commerce server and if i delete this section the old menu item go away. I need to know how to insert the static HTML menu items in its place.
View Replies View RelatedOur site is down, because of our hosting company applied sql server 2000 sp4
on windows 2000 server.
right after it applied the service pack, our sql server database is down and
no conn etc. When one technical support restart the server,
the obejcts like tables in database cannot be recognized from our asp pages
anymore, data cannot be inserted into any database table and data cannot be
pulled out correctly from database table through asp program, but I can run
query and look at data through sql analyzer.
what is the problem, is it because of connection string? before this service
pack 4, everything runs fine and we never had this kind of disaster.
I have connection string like this: Code:
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
View Replies View RelatedI have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
The SQL statement is as follows: Code:
I am working on a App. at my work place, now wanting to set it up at home
but for some reason I keep getting this error :
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable
range, or are in conflict with one another.
I did some research on the NET but I am still unable to figure out why I
cannot connect to my db. Code:
I've been trying to create a test site - The site uses ASP with VBscript and talks to SQL Server 2000. I was able to complete and test it on my locally on my computer using Microsoft’s IIS 5.1. The website communicated fine with the database on the webserver/network server
However, when I tried to save the site from my local computer to the wwwroot folder in the server’s IIS hoping to make the internal site available to everyone here the resulting error comes up when we try to open a page with a recordset connected to the database: -
Our Error: -
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'AUMBSDDSSIUSR_AUMBCOMP'.
/mysite/htm/test2.asp, line 8
The page calls on an include file
Code: ....
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={SQL Server}; Server=;Database=pubs;Uid=myUsername;Pwd=myPasswor d;"
Instead of database, how can I set the DSN in this connection string?
DSN is DSNName. I am trying to connect to a SQL Server 2000 database.
server doesnt pass the session parameters to next pages.
pls anyone can help on this issue.code:
set rs = server.createobject("adodb.recordset")
sqlquery="select * from account where uid='abc'
and password='123'"
rs.open sqlquery, conn, 3, 3,0
if not rs.eof then
session("acct")= rs("account")
end if
The session() object is not working on my computer, my OS is XP professional, i'm not using a virtual directory. session () object is working ok on my second computer, OS server 2000 what is wrong?
View Replies View RelatedTried to pass some variable from site1 to site2 through the session but it doesn't work. It works in the site1 though. Accepted all cookies and checked the session timeout.
site1
<%
session("test") = "ok"
dim i
For Each i in Session.Contents
Response.Write(i & "<br />")
Next
%>
site2
<%
Response.write(session("test"))
%>
How to select query according to User Input for a WebPage in C#.Net with SQL Server 2000.I am trying to build a web page in C#.NET with SQL Server 2000 using Visual Web Developer 2005. I want to select and execute the query according to user input.
I have a form which has 2 textboxes which gets start date and end date from the user. Based on start/end date my 1st query runs. Now if user does not enter any start/end date I want to run another query which takes default dates from database(which is in varchar:ex. now()/now()-180) according to logged on user's permisstions.
How to select query ?
I am passing form data to a distant server that is out of my control. The
destination server (posting to) rejects all postings beyond ONE from the same
session ID. I am trying to get around this...my postings are valid but I
can't get the programmers on the other end to accomodate me.
I am doing the following:
Data is posted, from elsewhere, to me in an ASP page.
I process the data then redirect to a 2nd page (on my server) w/ a QryStr
The 2nd page populates a dummy form w/the QryStr data and OnLoad submits.
I have a Session.Abandon command JUST BEFORE the redirect to MY 2nd page
(the one that populates the dummy form and submits itself)
My subsequent postings beyond the first are still being rejected due to
"Same Session ID"
Any thoughts?
I have web forms that frequently expire because users have them up for more than the default 20-minutes without interacting with them. So, I changed the timeout in IIS to 7200 seconds (2 hours, of course) and added a Session.Timeout = 120 to the pages in question. (Am I right that Session.Timeout is in minutes?)
Still, however, the pages seem to be timing-out well in advance of the 2-hour threshold. Have I left something out?
I've skirted around the issue by putting the forms into a framepage and setting a blank frame to refresh every 10 minutes, but I'm not fond of that solution. Plus, I'm just curious why the Session.Timeout setting or IIS timeout setting does not seem to work as advertising (allowing for the fact that I may just be a moron and missed a step).
Localy along with VS2005 when hitting ctrl+f5 the asp application server get's launched, and the whole site works fine, now on my windows 2003 server i installed IIS, it also has apache running and that works fine but the IIS part, i cant get it to work.... i have my inetpub filder on c which has a www folder but when i copy my project to there it tells me it's unable to process the page (aspx), can somebody help me out here please.....
I did the configuration and rule statements in the server manager which now displays ASP.net working and active, but it does NOT work at all....
I am using smart upload object to upload files in n/w it works fine with one of my server setup but when i tried to replicate in another server this is not working
I checked with the dll registration every thing is fine....
I am trying to run a test sending mail using CDONTS on my W2K3 machine.
It works fine running from my WXP Pro, but I don't recieve the mail if
run the W2K3 machine.
Both machines have IIS configured essentially the same. Code:
I want to install asp and access on a server, is there way to password protect asp pages from being accessed directly?. I don't mean via web.But being accessed from the server directly?
Is there way to ensure that the asp pages works on the computer/server it has been installed on and not for any other comp?
So if some new admin tried to copy those asp pages to another computer,they would not work.
I have the problem being kicked out by session although successfully login whenever I use the server name in my path. It seems no problem when I use localhost in my path. Would appreciate if someone can tell me how to solve this problem asap. Need to use the server name to refer to the asp page
View Replies View Related