MSSQL SERVER 2000 Connections
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?
ADVERTISEMENT
Multiple MS SQL 2000 Connections
I was wondering if it was possible to have multiple server connections in one asp application. Like if one connection to the main sql server failed, it would connect to the backup sql server.
View Replies View RelatedError In COM+ While Migrating From 2000 Server To 2000 Advace Server
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.
Access 2000 Or SQL Server 2000
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?
Connect To A MSsql Server
how do i connect to the server using asp?
View Replies View RelatedDozens Of SQL Connections Remain Open On Web Server
I have a set of scripts that accesses a SQL2000 database on another server. After several days of investigating an extreme slow-down on my web server I did a netstat-a command and found DOZENS of connections to the SQL server still open. Here's just a small sample of this. Code:
View Replies View RelatedCompactability Of Mssql With Linux Server
i want to know the possible activities in mssql configured with Linux server.
Because i can't able to execute some of the queries in this Configuration.
Like, the query is executed in all display the outputs in windows envirnment,
but it shows empty data's in linux Environment. ( also i am using the mssql connectivity in PHP) That is Why?
SQl Server 2000
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
ASP / SQL Server 2000
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 RelatedConfiguring Win 2000 Server + ASP
I'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.
SQL Server 2000 Database
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 RelatedExcel To SQL Server 2000
Is 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 RelatedExchange Server 2000
How 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 RelatedSQL 2000 Server Timeout
I'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.
Session Not Working On Server 2000
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.
Windows Server 2000 Question...
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?
Index Server Upgrade From NT4 To 2000
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?
Empty @@identity (sql Server 2000)
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.
Menu.asp In Commerce Server 2000
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 RelatedAsp Program Cannot Talk To Sql Server 2000 An
Our 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:
Access SQL SERVER 2000 DB From An Asp Page
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 RelatedAsp/access Sql Page Works In Xp But Not In Server 2000?
I 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:
Connection String From Include File ASP To SQL Server 2000
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:
Uploading Test Asp Page With Sql Server 2000 Onto Webserver
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: ....
How To Access An DSN In The Connection String To SQL Server 2000 Database?
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.
Select Query According To User Input For A WebPage In C#.Net With SQL Server 2000
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 ?
Connections DSN Less
I have a problem with DSNless connections. I used the code below but doesnt works.
An error message appears in browser...
<%
conn = Server.CreateObject("ADODB.connection");
conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:path odatabase.mdb";
conn.Open;
......
DNS-less Connections
I'm trying to make the following asp code work using a DNS-Less
connection on a windows 2000 server running IIS and ODBC 4.0 driver.
The Access database (odbc_exmp.mdb) was made using Access 2002. The
code works if I set up a DNS on the server under the ODBC drivers.
What I'm I doing wrong and what do I change the code to, to make it
work using DNS-Less connection? Code:
DSN Or DSNless Connections...
Right, which do you use? If your using DSNless, then STOP! It's SLOWING down your code and making it UGLY!!
Why? Lets look...
UGLY!
Which looks better
[vbs]
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("./data/vote.mdb")
[/vbs]
or
[vbs]
"DSN=databaseStuff"
[/vbs]
Its also easier to manage and will cause less typing errors. Think about it, it makes sense!
SPEED
Everytime you run a DSNless connection inside an ASP page the connection string needs to be verified,but a DSN connection is only verified when it is created! Meaning the DSN connection is indeed faster.
DSN Less Connections Problem
I am not sure what is wrong with this code. I have tested it at home, used in on previous webpages, and with previous employers. But I am getting this error at my current employers server: Code:
View Replies View RelatedMultiple Connections
I've been using ASP.NET for a couple years now and I'm trying to fall back into ASP for a new position I've acquired...and I'm having a bit of trouble remembering. I'm running to a problem where the basic logic is as follows:
Query
Do While Not rs.EOF
Query based on value in rs
Another query based on value in rs
Loop
There is no explicit connection object, they all use the same connection string however. When I limit myself to one query within the Do/Loop, I don't have any problems. However, when I add another query in there, it bombs with: Operation is not allowed when the object is open.
I'm assuming it's referring to the connection string being reused, but why would it allow one additional connection, but not two. I can't really close this connection before needing to requery. Is there anyway around this, or am I missing something entirely?
Implicit Connections
i am maintaining a system that was developed using dream weaver. a lot of the asp ado code looks like this:
set sp_yellow = Server.CreateObject("ADODB.Command")
sp_yellow.ActiveConnection = MM_MHR_CONN_STR_STRING
sp_yellow.CommandText = "Sp_HPMSQ007_GetSystemConstants"
sp_yellow.CommandType = 4
sp_yellow.CommandTimeout = 0
sp_yellow.Prepared = true
sp_yellow.Parameters.Append
sp_yellow.CreateParameter("@RETURN_VALUE", 3, 4)
sp_yellow.Parameters.Append sp_yellow.CreateParameter("@P_NAME_TXT",
129, 1, 17, "MLSTN_YELLOW_DAYS")
set rst_yellow = sp_yellow.Execute
someone on another forum expressed that dreamweaver "tends to drive the programmer to creat implicit connections and their effect on performance".could someone explain this to me? a provide some better code? (we no longer are required to use dream weaver to develop code for the app).
Open To Connections
in my main page i need to retreive record set from the database as well as search for products. but the recordsets i need to retrieve are located in a different table then the products i need to search. is this possible to do ?
View Replies View Related