Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Too Many Connections


Hi

I am a dba for sql server recently we are facing problems with the no of
connections.

we have a database called ( x ) every day almost million users is using that
databse after some time the cpu showing 100 percent utilization an error
throwing like odbc error connection so in that case no one is able to connect
to the server.when we pause it then restart the server for some time it looks
good then again it will go to 100 % utilization.but there is no blocking
occuring

if anyone knows this problem please help
your help would be appreciated.

Thanks


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...eneral/200510/1


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Need Help - Converting OLEDB Connections To SQL Connections In Asp.net
Hi there,
        Here we have got a
asp.net application that was developed when database was
sitting on SQL server 6.5. Now client has moved all of their databases
to SQL server 2000. When the database was on 6.5 the previous
development team has used oledb connections all over. As the databases
have been moved to SQL server 2000 now i am in process of changing the
database connection part. As part of the process i have a login
authorization code.
Private Function Authenticate(ByVal username As String, ByVal password As String, ByRef results As NorisSetupLib.AuthorizationResult) As Boolean
Dim conn As IDbConnection = GetConnection()
Try
Dim cmd As IDbCommand = conn.CreateCommand()
Dim sql As String = "EDSConfirmUpdate" '"EDSConfirmUpdate""PswdConfirmation"
'Dim cmd As SqlCommand = New SqlCommand("sql", conn)

cmd.CommandText = sql
cmd.CommandType = CommandType.StoredProcedure
NorisHelpers.DBHelpers.AddParam(cmd, "@logon", username)
NorisHelpers.DBHelpers.AddParam(cmd, "@password", password)
conn.Open()
'Get string for return values
Dim ReturnValue As String = cmd.ExecuteScalar.ToString
'Split string into array
Dim Values() As String = ReturnValue.Split(";~".ToCharArray)
'If the return code is CONTINUE, all is well. Otherwise, collect the
'reason why the result failed and let the user know
If Values(0) = "CONTINUE" Then
Return True
Else
results.Result = Values(0)
'Make sure there is a message being returned
If Values.Length > 1 Then
results.Message = Values(2)
End If
Return False
End If
Catch ex As Exception
Throw ex
Finally
If (Not conn Is Nothing AndAlso conn.State = ConnectionState.Open) Then
conn.Close()
End If
End Try
End Function
''' -----------------------------------------------------------------------------
''' <summary>
''' Getting the Connection from the config file
''' </summary>
''' <returns>A connection object</returns>
''' <remarks>
''' This is the same for all of the data classes.
''' Reads a specific
connection string from the web.config file for the service, creates a
connection object and returns it as an IDbConnection.
''' </remarks>
''' -----------------------------------------------------------------------------
Private Function GetConnection() As IDbConnection
'Dim conn As IDbConnection = New System.Data.OleDb.OleDbConnection
Dim conn As IDbConnection = New System.Data.SqlClient.SqlConnection
conn.ConnectionString = NorisHelpers.DBHelpers.GetConnectionString(NorisHelpers.DBHelpers.COMMON)
Return conn
End Function
in the above GetConnection() method i
have commented out the .net dataprovider for oledb and changed it to
.net dataprovider for SQLconnection. this function works fine. But in
the authenticate method above at the line
Dim ReturnValue As String = cmd.ExecuteScalar.ToString

for some reason its throwing the below error.
Run-time exception thrown : System.Data.SqlClient.SqlException - @password is not a parameter for procedure EDSConfirmUpdate.
If i comment out the
Dim conn As IDbConnection = New System.Data.SqlClient.SqlConnection
and uncomment the .net oledb provider,
Dim conn As IDbConnection = New System.Data.OleDb.OleDbConnection
then it works fine.
I also have changed the webconfig file as  below.
<!--<add
key="Common" value='User ID=**secret**;pwd=**secret**;Data
Source="ESMALLDB2K";Initial Catalog=cj_common;Auto
Translate=True;Persist Security Info=False;Provider="SQLOLEDB.1";'
/>-->
<add key="Common" value='User ID=**secret**;pwd=**secret**;Data Source="ESMALLDB2K";Initial Catalog=cj_common;' />
 
Please help. Thanks in advance.
 

View Replies !   View Related
Help - Server Stops Responding To Connections, Stops Accepting Connections
I've been having the same problem for 2 weeks now. If anyone has anyideas, I'd love to hear them. We are using both SQL and WindowsAuthentication. I was running a Profiler Trace at the time, and amgoing through it now but have not seen anything yet.Thanks in advance.About once a week, at no fixed time (but so far, between 8am and11am), my SQL Server 2000 on Windows 2000 (8.00.679) will stopresponding. New connections will at first take forever to connect,then an error message about the PreLoginHandshake(). We have to killthe service (read below) to stop it, but it comes back withoutproblems.The very first time this happened, I got buf latch errors in the SQLError Log, but not this time. (However, the first time we waited forabout 5 minutes after it stopped responding , and then the buf latcherror message showed up. This time we restarted the services before 5minutes had passed.)The SQL log shows nothing abnormal. The SQL Agent log shows nothingabnormal. The Event Log shows nothing abnormal. Stopping the servicethrough the SQL Service Manager doesn't work - we have to go into theServices control panel, stop the Agent then stop the service, and whenthe service says that it cannot be killed, we then run the "kill"command on it (from the resource kit, I believe) and it stopsimmediately. Once this occurs, we can use the SQL Service manager tostart everything up successfully, with no problems in the logs.Note: we have not rebooted the server yet, juststopped/killed/restarted the services. We plan on rebooting thisweekend.Timeline:10:20 - an openquery job runs successfully - as far as I know,everything is okay at this point.10:22 - for some reason, a transaction log backup job does not run(ran successfully at 10:02, runs every 20 minutes.). That timedoesn't show up at all in the Job History for that job, nor is there alog file, nor was a report txt file generated.10:29 - openquery job 1 fails to run. Connections are sluggish, butopen connections can run queries.10:30 - openquery job 2 fails to run. (not the same query as 1 or 3)Connections are sluggish, but open connections can run queries.10:30-10:40 Enterprise Manager cannot connect - stuck duringconnection. This is the case on multiple machines, as well as on theserver. My Enterprise Manager doesn't respond, and I cannot start anew instance. "Select getdate()" can take several seconds to run, andI get a "Lost connection" error.10:40 - openquery job 3 fails to run. Profiler shows my openquery jobwas the last thing run - no further profile messages for the next 2-3minutes.10:43 - We start shutting down the server.

View Replies !   View Related
Keep A Few Connections Open All The Time Or Open/close Connections On The Fly?
Just a quick question about connection management. My application willnever need more than 1 or 2 connections about at any given time. Also, I donot expect many users to be connected at any given time. For efficiency, Iwould like to keep connections alive throughout the lifetime of the objectsrequiring them, rather than opening a new connection, executing code andthen closing it again. What is the most efficient way of doing this?Should I perform the open/close or just one open when I create the objectand a close when I dispose of it?

View Replies !   View Related
Some Ms SQL Connections
Hi I have some simple questions of for MS SQL. Say I have a database with a table Called Company. In this table I have Employee's with these columns(EmployeeID<PK>, FirstName, LastName) Now I am inserting some data like this.EmployeeID  FirstName, LastName------------------------------------------------------- 1                  Bob            Smith2                  Joe               Mitter Now Say I have this situation(this will look weird for this example but for another examples and the stuff I am working on it make sense). Say I have a new Employee Called Jessica White. Jessica must be the second record. So I need to insert it between the 1st and 2nd record. Like I said I am very noob at doing this stuff so I am not sure how I would do it. I first was going to my table and then went to modify. This brought up a blank grid with all my column names. I then started to add all my data in. I found out later to make my life easier I need to enter in certain spots null rows in it to help with formating(otherwise I would have had to figure out a way to do make null rows with c# code). I then went back to this grid and I tried to add a record before the data just like you if you used excel. I quickly found out you can not do that. This resulted me having to recreate the table and reput the all the data back in(this told me I was doing something very very wrong). I was then thinking of writing it with a query and I been playing around with it and still running into problems like say I had a table called test with a coloum called id<PK> and testss(yes bad names just playing around though).So if I did something like this:INSERT INTO testVALUES(2)INSERT INTO testVALUES(1)SELECT * FROM testNow I am trying to figure out how to insert something between rows 1 and 2. Would I have to drop the table or delete all the data and then run a saved copy of my script with the added change or what?My second question is what is a good site that has examples of all the commands(I don't want to read a book on it I have had a oracle sql course and well it was just boring and I did not learn too much.). I think the best way for me to learn is just continue doing my site and picking it up on the file and when I got a problem read about it and ask on the forums.   Thanks 

View Replies !   View Related
SQL Connections Using NAT
I've been using NAT for MS SQL server 2000 to connect to another MS SQLserver on the internet, but its been too slow and connection drops allthe time.As recommended, I've installed WGIC on the Windows Server 2003, but nowI get connection error in SQL. Is there some configuration I need to doon WGIC to make it work?Wingate Version 6.03 (build 1005)Tried a few things, but didn't get much wiser from it:http://support.microsoft.com/kb/216415/EN-US/http://support.microsoft.com/kb/287932Any one with any experience to shed some light on this matter would begreatly appreciated!ThanksDarren

View Replies !   View Related
SQL Connections With VB.NET
As most of you are aware, when you close a VB.NET connectrion to a SQLserver, the connection doesn't actually drop right then and there.From my tests, using VB.NET 2003 and SQL2K, the connection doesn'ttimeout and drop off for 6 1/2 minutes. How can one force thisconnection to immediately drop off with code?

View Replies !   View Related
Connections
Hi I would like to know about connections of sa, where SQL store thenumber of connections

View Replies !   View Related
Connections
im writing a service that will be on a app serverthis is one of many service's to process Recordsets from Sql Server...1 service may have 20 Processes to Completeexamplemain class PreProcess()method CleanNames();method updateNames();methodr ValidateContracts();Various things must be completedSuedo Example belowMy question isin the main class make my connection and keep it for all sub membersor connect in each memberA. This Way opens connection...closes connectmethod cleanNames()1 get connection2 get recordset3. Close Connection4 process Recordset5. Open Connection4 Commit Changes6. Close Connection()finished cleanames()ormethod cleanNames()1 get connection2 get recordset3 process Recordset4 Commit Changes5. Close Connection()finished cleanames()orthis final way is in the parent Class or Calling Functionsends in the connections holds it open till the service iscompleted of all jobs its Suppose to dothen releases the connectionmethod cleanNames(oconn) connection as parameter1 get recordset2 process Recordset3 Commit Changesfinished cleanames()ThanksDaveP

View Replies !   View Related
Too Many SQL Connections
We have a case where a user is using Excel sheet to connect the database on SQL2K and generally his connection runs in the upper 150 in numbers. He generally gets more than 150 connections open.

I know that it's not a good thing, but is there a way to limit it or even kill it after it reaches max?

What are the disadvantages of opening too many connections?

View Replies !   View Related
Out Of Connections... Or Am I?
I'm getting the classic message "The timeout period elapsed prior to obtaining a connection from the pool" etc when connecting to my SQL Server 2005 Express from a .Net application.
Then I try connecting, simultaneously, from a simple ASP.net thing I wrote just for testing and this works fine. So, then the connection pool can't be full, can it? Or, does each application have its own pool??

View Replies !   View Related
Max Connections?
Ok, yeah, I'm being lazy...

Any comments?

View Replies !   View Related
Connections
I figure anyone who has done VB and SQL Server might have run into this.
>
> I am set up as a DBO on SQL Server with access to db1 and db2. My default
> is set to db2. From my local machine, I can log through VB(DSN-less) in
> to
> either one without a problem. BUT, if I go to another machine and try to
> log in through VB(DSN-less) to db1, it rejects my login. Here is my
> connect
> string :
>
> UID=xxxxxxx;PWD=pedro;DATABASE=db2;DRIVER={SQL
> Server};SERVER=Athens;DSN=``;
>
> The only thing that changes when I log into db1 is the database parameter-
> "DATABASE=db1".
>
> Am I doing something wrong here? Is there something that needs to be
> setup
> differently in SQL Server? Do I need to put something else into the
> connect
> string?
>
> This happens for the other developers as well, not just me.
>
> Any help would be GREATLY appreciated.

View Replies !   View Related
SQL Connections
I want to limit the clients which could connect to SQL Server, so that the frontend could only be run on valid workstations. I have a lookup table of the ip-addresses and MACs of the valid workstations, now, how do i make sql server grant/refuse the connection (if it is possible)?

View Replies !   View Related
Db Connections
Can anyone tell me how to return a value(int) which shows the current number of connections to a SQL 7 database??

View Replies !   View Related
DTS Connections
I am looking for some ideas on the following DTS challenge: I need to import the data from an Access 97 database into a set of tables(about 25). The location of the database can be anywhere on the users drive(s) and I will need to get the location of the database from a registry setting and use it to define the connection.

Thanks

View Replies !   View Related
Connections
HI all,
I have a problem here. I am having two computers both are loaded windows NT 4.0 AND SERVICE PACK 4 AND ALSO I INSTALLED SQL SERVER 7.0.
Now i want to connect those two servers , so pls anyone suggest me how i have to do.I connected both servers thru HUB.
Pls suggest me..
thank u..

--ram

View Replies !   View Related
SQL Connections
We use linked servers to run distributed transactions across servers and am having problems with hung connections. Server A runs a distributed
transaction out to servers C, D, & F. If server A experiences any time out issues with servers C, D, or F when it is writing records the connections are
dropped on servers C, D, or F but on server A it does not. I have to reboot the server to drop the connection so the process can run again.
The process is a stored procedure that is run in a job and handled through by job scheduler but trying to stop the job does not work nor killing the process using the
kill command. Any one have any suggestions on what I could try to resolve this problem? Thanks in advance
Barb

View Replies !   View Related
Connections
We have an application that is running slow with max connections set at 150 connections. We changed it to 0 for unlimited and now the application flies.

Can anyone explain this? Does SQL Server do something different when it is set to a specific number versus unlimited?

Thanks!

View Replies !   View Related
SQL 7 Connections
Very strange event. Installed new machine into NT 4 network, which has a PDC and a BDC. We have copies of all SQL databases on both the PDC and the BDC. I installed SQL 7 on new workstation. Throught Control Panel/ODBC connections I can reach the SQL files on bith the PDC and BDC. Howver when I try to use Enterprise Manager, I can connect to the tables on the PDC, but not the BDC. SQL lists both machines in the server group, but only allows me to access tables on PDC! Here is the Event information that I recived on the BDC:

The computer IVR1 tried to connect to the server NTBACKUPSERVER using the trust relationship established by the MASSCOM domain. However, the computer lost the correct security identifier (SID) when the domain was reconfigured.

How do I fix this?

View Replies !   View Related
2 Connections
hi,

have been looking for ages for somewhere that might be able to answer my question so thought i'd try here.

anyhows, my place of work have goldmine 6.7 running on a server. the problem is that some of the client machines seem to be taking 2 connections to the server when logged into goldmine and some only 1.

when looking at the open sessions it shows a second for some users accessing pipesqlquery. all users show this but only some show it as a second connection.

please any ideas

View Replies !   View Related
Connections To SQL
Hi

I have heard that SQL Server can support upto 10,000 users,

What if my application , connects to the sql & does not do antything then , why does the SQL server slow down with just 700 users.

I mean just the connection is established & NOTHING further is done.


Thanks

View Replies !   View Related
DSN Vs. DSN-Less Connections.
Is there any type of performance gain to using DSN connections? Or any real advantage to using them over DSN-Less connections?

--
If I get used to envying others...
Those things about my self I pride will slowly fade away.
-Stellvia

View Replies !   View Related
Help With Connections
Hi everybody,

I need a little help...

I created several packages, that after their creation should not be changed again; that's why I created a Package Configuration File in which I set all the Connections I need, so that this is the only file I have to modify.

I set there also the path of the connections for my log file and for my error files (which are both text files), but if I change their paths in the configuration file this change doesn't affect the package, and the path of the log remains the same.

That's an image of one of those packages....



The fact is that I cannot change the ConnectionString of the connection called "log_pkg", but it always remains the same...

How can I resolve this problem??

Thanks everyone

View Replies !   View Related
SQL Connections
Hello,



This might not be the right forum, but I'll go ahead and ask anyways -

How does SQL server's per seat/user licensing work ? What I'm hoping to find out is that - if some one has procured a 2 user/seat license - will the number of connections that the two users are allowed to open be limited to 2 ?

Or can the two users open any number (reasonable number)of connections ?I'm asking this in the context of the possibility of having multiple connections service our desktop application. Or am I tied to having a maximum of one connection per client/user by virtue of the licensing restrictions ?

Thanks,

Avinash

View Replies !   View Related
Too Many Connections Since My Win App
I have a c# winapp and use SqlHelper to CRUD operation wint an sql server 2005 database, every time mi data access layer opens an connections, I do Close() and Dispose() after the transaction, and I execute SP_WHO and the database server shows me that my winapp has generated a lot of connections, I dont understand why since i clean every connection, Also, I m not using pooling since my connection string. Has someone has faced this before??



Best Regards



Joseph

View Replies !   View Related
OLE DB Connections
I have .net 2.0 framework and SQL V 8.0 on my web server.

I am trying to create a DSN and I am not given the OLEDB provider for SQL as an option for my list of providers. Is there a download that will add this ? What do I do to get it????

View Replies !   View Related
ADO Connections
Forgive me if this is the wrong forum, but it does have to do with data access. Just a quick question: When using an ADO Component /Object to connect to a database, C# or whatever, that connection that is established - How likely is it that data being retrieved from the database is intercepted, is that channel encrypted/secured, and if not for either questions, how do i secure that channel?

View Replies !   View Related
Best Practice For SQL Connections And Asp.Net
Hi.
We have developed as quite simple ASP.Net webpage that fetches a number of information from a SQL 2005 database. We are having some problems though, becuase of a firewall that is beetween the webserver and the SQL server, and I think this is because of bad code from my part. I'm not that experiensed yet, so I'm sure that there is much to learn.
Usualy when I do a query against a SQL database, I do something like this:
Function GO_FormatRecordBy(ByVal intRecordBy As Integer)        Dim dbQueryString As String        Dim dbCommand As OleDbCommand        Dim dbQueryResult As OleDbDataReader        dbQueryString = "SELECT Name FROM tblRegistrators WHERE tblRegistratorsID = '" & intRecordBy & "'"        dbCommand = New OleDbCommand(dbQueryString, dbConn)        dbConn.Open()        dbQueryResult = dbCommand.ExecuteReader(CommandBehavior.CloseConnection)        dbQueryResult.Read()       dbConn.Close()        dbCommand = Nothing        Return dbQueryResult("Name")    End Function 
Now, lets say that I have a DataList that I populate with Integer values, and I want to "resolve" the from another table, then i do a function like the one above. I guess that this means that I open and close quite alot of connections against the database server when I have a large tabel. Is there any better way of doing this? Chould one open a database connection globaly in lets say the ASA fil? Whould that be a better aproch?
When I added the CommandBehavior.CloseConnection to the ExecuteReader statment, I noticed that it was a bit faster, and I think there was fewer connections in the database, so maby there is more to the "closing connections" then I usualy do.
Any tips on this?
 Best reagrds,Johan Christensson

View Replies !   View Related
OPENDATASOURCE Connections
 Hi all, In a select sql statement, I have to query 2 databases from 2 different servers. The only way I found to do this, is to call OPENDATASOURCE like this :<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:bdConnectionString1 %>"        SelectCommand="SELECT * FROM [Table1] t1 left join OPENDATASOURCE('SQLOLEDB','Data Source=servername;Initial Catalog=xxx;Persist Security Info=True;User ID=xxx;Password=xxx').dbname.dbo.table2 t2 on t1.id = t2.id">    </asp:SqlDataSource>My question is the following :Is there a way to connect to the second server without using the full server declaration into the sql statement ? For information, the server connection is already declare into my web.config like that :<add name="bdConnectionString2" connectionString="Data Source=servername;Initial Catalog=xxx;Persist Security Info=True;User ID=xxx;Password=xxx"   providerName="System.Data.SqlClient" />so is there a way to use 'bdConnectionString2' directly ?If not, is there a way to connect to the second server without entering informations like User ID and Password ? My problem being that I'm not sure it's safe to send this informations directly from the asp.net page. Thank you 

View Replies !   View Related
SQL Pool Connections
HiI have written the following function public System.Data.SqlClient.SqlDataReader ExcuteReader(string strQuery, string strConnection)    {        System.Data.SqlClient.SqlCommand myCommand;        System.Data.SqlClient.SqlDataReader myReader;        myCommand = new System.Data.SqlClient.SqlCommand(strQuery, new System.Data.SqlClient.SqlConnection(strConnection));        myCommand.Connection.Open();        myReader = myCommand.ExecuteReader();        return myReader;    }to return a datareader for me but right now I am facing the problem that it seems this function isn't closing the connection by itself which is resulting in an error saying "Timeout expired.  The timeout period elapsed prior to
obtaining a connection from the pool.  This may have occurred because
all pooled connections were in use and max pool size was reached" and if I close it manually I will lose the data in the readerso are there any suggestions of what I should do?thank you

View Replies !   View Related
Reusing Connections
Every time my asp.net app needs to open a connection, it tries to establish a new connection with the mssql server. I´ve already set the max pool size property in the connection string. After that, my app raises an "time out"error saying it couldn´t obtain a connection from the pool. The problem is that I have a lot of iddle connections. With the Enterprise Manager I can see the status of the connections. They´re all the same "awaiting command". How can I reuse this connections? I know that the connection string must be the same for all connections and it is. I´ve set it in the web.config file. If I remove the max pool size property from the connection string I get a lot, I mean A LOT of connections with the sql server. Any ideas?

View Replies !   View Related
Trusted Connections
I was just wondering about the old error:"user not associated with a trusted connection"I know how to solve it, but I dont really understand what im doing. If my connection string is like:Trusted_Connection=true;Initial Catalog=jobitdev;Data Source=192.168.109.4;Packet Size=4096;then how validation is done on the sql server side of things? If i specify the "Trusted_connection" property what does the server do to validate the user? I'm assuming that the user it checks is the current windows user?

View Replies !   View Related
SQL Connections And Performance
How can I check/count how many connections are made during a requests, how many queries?, how long those queries took etc?

I want to know what's the approach to get this kind of information, so after that I can start working on improving performance.

View Replies !   View Related
Connections Limit?
Hi,

I have an application with a DAL that has an interface with SQL Server.
The application has 400 users that open the web forms.
My question is:
Is there a limit of the parallel connections that can be opened? Or the IIS is managing all the access to the DB? Should I worry about the performance Or it's normal behaviour for ASP.NET applications?

Thanks

View Replies !   View Related
Closing All Connections
How do I set up a job so that I close all open database connections? I think we have a leak in our code which causes our DB to go down (max connections used) roughly once every month, so we just restart the SQL server. Until we can find the exact problem I'd like to do this.

For simplicities sake let's say my database name is just "test."

Thank you.

View Replies !   View Related
Trusted Connections
Hey all, not sure if this is even possible but is there a way to connection an SQL server with ASP.NET using my username and password as the trusted connection? As I am a trusted connection but the ASP.NET working process isnt. Anything can be done about this apart from addeing the ASP.NET account as a trusted connection?

Thanks

Luke

View Replies !   View Related
25 Concurrent Connections
Hey,

MSDE 2000 allows 25 concurrent connections.

If these are all used up, and a 26th connection comes in. What happens? is the connection rejected? or does it sit in a queue, waiting to be given a connection?

Thanks,
-Ashleigh

View Replies !   View Related
MSDE Max Connections?
Hi, can anyone tell me whats the maximum number of connections you can have to MSDE? Eg, is it enough to host an intranet site for a relativly small business?

View Replies !   View Related
Running Out Of Sql Connections
Hello:We have a a two tier application connecting to sql serverthrough remoting. The business objects are single call objects. We areopening and closing connections using ADO.NET command object. All"ExecuteNonQuery" are closed in finally blocks. We are running out ofsql connections because the profiler shows that connections are notbeing released till the business service is stopped and restarted.Does anyone have suggestions on how to fix this problem of theconnections not closing and why it may be happening?Thanks a lot,Han

View Replies !   View Related
Log All Connections To A SQL Server
I need to log all users connecting to any database on my SQL Server 2000cluster.Anyone know how I can accomplish this ?Ta,CJ.

View Replies !   View Related
ODBC Connections.
If I have a server that goes down and I then have my stand-by serverstart-up is there an easy way to remap 400 users who have ODBCconnection settings on their computer. If not, tomorrow morning Ihave to go to 400 computers and rename there ODBC connection to lookat the stand-by server.

View Replies !   View Related
Updating A Row With The Right Connections
Hi,

I have a database with two tables:

Notes
Appointments

The Appointments table stores date/time for an appointment as well as the 'member' (or customer) that is attending it.

The Notes table stores the notes entered after an appointment and is linked to the Appointment table by an 'appointment' field. There is also a 'new' field to show if the Notes have been read or not.

I need to be able to set the 'new' fields in Notes to 0 for all appointments that relate to, say, member 6.

I'm sure its a simple SQL process, but I don't know it.

I tried:

UPDATE Notes, Appointments SET Notes.new=0 WHERE Appointments.member=6 AND Notes.appointment=Appointments.ref

But it doesn't like this.

What is the correct format?

View Replies !   View Related
SQL Server Connections
Hello,

I would like to know if there is a command for SQL Server 2000 to know the existing connections to given database in real time

View Replies !   View Related
Refuse Connections
Hi guys,

I would like to know how could I configure my SQL Server (2000) to refuse every connection except localhost or server-name ?

I am sure this can be acomplished, but I've looked everywhere and can't find it.

I use asp.net only and I want to configure the server to accept connections from local computer and that's it. Any thoughts?

Thanks

View Replies !   View Related
Number Of Connections
Hi All,

where can I find the information about number of connections to the particular database?

thanks

View Replies !   View Related
Connections To SQL Server
Hi All,

I need to put a script together that would tell me how many connections to SQL Server there are at any given time. Which table would store this info?
Thanks.

View Replies !   View Related
DTS Connections Errors
HI!
It's me again....

I receive this message when I execute one of my packages...

"Multiple-step OLE DB operation generated errors. Check each OLE DB status..."

I want to find more specific error messages, so I want to access errors on the connection

In vb you have Recordset.ActiveConnection.Errors collection, but I can't find an errors collection

I have this

Function Main()

Dim pkg, con

Set pkg = DTSGlobalVariables.Parent
Set con = pkg.Connections(1)

and then??? con. ???


thanks

View Replies !   View Related
Odbc Connections
A colleague of mine has a problem;
"Has anyone ever experienced the problem of creating a System ODBC and it doesn't display in the ODBC administrator applet?"
was hoping someone here could help...

View Replies !   View Related
Sleeping Connections
Hi,

I have written an application in VB6 connecting to a SQL Server 2000 database using ADO. This app is running on the same computer as SQL Server.

What I am seeing now is that each day 2-3 new connections are being created by SQL and these connections have a "sleeping" status and "AWAITING COMMAND" command. Also, when double-clicking a
connection, it's last TSQL statement is empty... This way, connections are piling up.

Does anyone have an idea why this is happening and what I can do to avoid this ? Also, how can I determine what is causing this ?

Many thanks,

Jurgen Sanders

View Replies !   View Related
Multiple Ado Connections
Hi, I have a VB application running on SQL Enterprise Edition. Physically there are only 20 users loging in to the software at one time. However i can see more that 12 SPIDs for each user. The developers have been opening a new connection for each form in the application i guess. Is it normal or is there any specific requirement that foces them to do so? Shall i need to change the default WORKER-THREADS option on the server for peformance? Suggestions please!!!

Regards.

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved