How Do You Solve POOL CONNECTIONS MAX OUT Problem On GoDaddy?
Mar 4, 2007
Hello,
I'm hosting with GoDaddy and I receive this error:
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.
For sure the problem is "MAX POOL SIZE WAS REACHED". How do I solve this problem? Or how do I prevent this from happening in the future?
Now, I cannot open any of my pages on GoDaddy.
Any advice would be appreciated. Thank you.
View 1 Replies
ADVERTISEMENT
Apr 13, 2007
Hello all,
I am hosting at Godaddy and using their SQL 2000.
Before, I used to use "Try, Catch and Finally" for my SQL connection. However, I received this error "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." so often that I changed it to "Using { .... }". Yes, the error doesn't come back as often as before.
Today, I encounter that problem again and my connection to the db is locked, because of that error. Is there away to prevent this from happening? Should I check to see if the connection is still opened before open another one? In case like that, if the connection is still opened, should I close it first before opening a new one OR can I use it too?
Any advice would be appreciated. Cheer ...
View 8 Replies
View Related
Feb 11, 2004
What does this error message imply?
View 3 Replies
View Related
Aug 22, 2006
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 4 Replies
View Related
Nov 24, 2005
Hi,Can anyone tell me if he ever got this issue and how he get the solution. In my asp.net 2.0 application i close always ma connexions to sqlserver in the finally clause (the open is in the try); I open 1 ou 2 connecxions per aspx page, i close them always (in the finally clause or at the bottum of the form). Sometimes, the application is down with the messageCan not open a new connexion, max pool size is reached !!!!I host my application on a remote server, i have no performance issues, only this great problem !!!i cant view the status of connexion on the sqlserver, so what can i do, or how shoud i develop my connection.thanks in advance to all of yuo who will help me.Imed.
View 1 Replies
View Related
Dec 19, 2003
Hi
I have seen the threads already in here about connections and SQL Server but I too am having a connection pool problem.
I am explicitly making a connection, creating a command object, executing a datareader then closing the command and then disposing the connection. The connection just prior to the dispose is definately closed.
However when I do an sp_who in SQL Server the connection is still listed. I have a connection timeout of 30 seconds, so I am considering reducing this to 5 seconds but dont wish to. So therefore when a process is called repeatedly instead of using an existing connection in the pool, it thinks that this connection is still active and therefore creates a new connection. Because all of this is in an ascx, I cant code for one connection to stay open for all 30 instances of the control.
This is a problem because I am creating controls at run time and using page.databind and at that point, I exceed the connection pool and therefore the site crashes out to the "SQL Server Timeout" error.
Anyone else seen this?
View 1 Replies
View Related
Feb 21, 2008
Hello.
I have a db dal containing the following code:
SqlCommand cmd = new SqlCommand();
cmd.Connection = dbc;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SOME STORED PROCEDURE";
.
.
.
declare some SqlParameters
.
.
.
dbc.Open();
cmd.ExecuteNonQuery();
dbc.Close();
This code, when concurrently running via several threads, yields the following exception:
"The connection was not closed. The connection's current state is open."
My questions are:
1. Why don't .Net allocate another connection from the pool (I try to only concurrently run 2 threads while there are 25 connections in the connection pool) ?
2. How can one explicitly allocate a connection?
3. How do you suggest to solve this problem without a mutex/monitor etc' on the 3 bold lines above and without BeginExequteNonQuery()?
Thank you !
View 2 Replies
View Related
Feb 21, 2007
hi i'm having this error on my application"cannot allocate more connection.connect pool is at maximum increase max pool size" the proble is when i do testing this error does not apply it only Appears when the application is been used by many people
How can I resolve this?
Thanks
View 1 Replies
View Related
Nov 18, 2005
I was wondering if anyone successfully managed to connect to the
asp.net 2.0 features (specifically authentication) with goDaddy. They
allow you to set up the schema for 2.0 in the SQL server, but I have
yet to manage to actually CONNECT to the SQL server using VS.NET 2005.
Anyone have any suggestions? Experiences?
View 1 Replies
View Related
Feb 12, 2006
CREATE TABLE [Sites]( [SiteID] [int] IDENTITY(1,1) NOT NULL, [SiteName] [nvarchar](500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_Sites] PRIMARY KEY CLUSTERED ( [SiteID] ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]GOWhat's wrong with that? Why won't godaddy take that?
View 5 Replies
View Related
Dec 29, 2006
I don't know if this is unique to GoDaddy: I found the program for working with a MySQL database very intuitive (to the point of compliments). Today I started work with ASP.NET and SQL, and when I went to work with SQL Server (on GoDaddy), it wasn't intuitive, and there was almost nothing on which to click. By chance might there be a tutorial that would help a person who needs to work with SQL Server on a provider like GoDaddy?
View 4 Replies
View Related
Jul 13, 2007
Hello,First, I tried to find the answet to this question, but no luck - so I decided to post it.
When I was creating my applications in asp.net - for the first time I decided to start using external DataSets. I think they are great and work very nice!But once I pushed the application to GoDaddy, I got an error of this nature:I was trying to access the exterbal dataSet like this:Dim productsAdapter As New NorthwindTableAdapters.ProductsTableAdapter()
Dim products as Northwind.ProductsDataTable...And got an error saying that it couldn't find this type (but it worked fine on my local machine in visual studio).So did I miss something that prevented this application working on GoDaddy? or there are some limitations on GoDaddy? ...or something else.Thank you for looking into this for me.Valera
View 7 Replies
View Related
Jul 22, 2007
Hi all, I'm a newbie of SQL. I built a website using SQL 2005, and the data control was using a dataset and wizard,now when I'm uploading the website + database,I learned godaddy doesn't support database uploading.I have to create an empty SQL database on godaddy's sql server, and reDir the connection in config file. my question is, where should I copy my dataset commands to godaddy's sql server?2nd, how do I invoke them in asp.net? thanks in advanceyonk
View 1 Replies
View Related
Aug 27, 2007
I know this has to be answered somewhere, I just need to know, am I going crazy. I have a shared webhost account at Godaddy. My web config was working at one point, but now I am getting this error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Now, If I were to look at this, its telling me that it cannot locate the server I am trying to connect to. Below is my connection string and the address I am getting this from is in my information at godaddy. Tell me, is there something that I am doing wrong here?
<connectionStrings>
<add name="Personal" connectionString="Server=whsql-v20.prod.mesa1.secureserver.net;Database=azwd30;User ID=XXXXX;Password=XXXXX;Trusted_Connection=False" providerName="System.Data.SqlClient" /><remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Server=whsql-v20.prod.mesa1.secureserver.net;Database=azwd30;User ID=XXXX;Password=XXXXX;Trusted_Connection=False" providerName="System.Data.SqlClient" />
</connectionStrings>
With the same user name and password, I can access the database through Godaddy's site and see my records, and the address 'whsql-v20.prod.mesa1.secureserver.net' is the same as whats on Godaddy's SQL configuration page, the database name is the same, I have double, triple and spent hours checking all that could affect this... I may just be burnt out using Godaddy. It seems I fix one thing, then there is another thing, I fix that, then there is another. I talk to support, and they say, they dont support anything that they have in their sales page for what they offer. I'd rather get support to say somthing like: "You may want to go to google and press the I'm feeling Lucky button. It would be probably be faster and cheaper than using our department, or you can upgrade to our virtual server and have a little more control, not total control but a little more ... what do you say mr Chris?"
Well, I feel almost a little better venting here. Since I have been with GoDaddy, and I live in the same city where they host their servers, I have been in shambles wondering how they can offer all that they do in their sales pitch and then drop a ball and say, we dont support 90% of what you read in the beginning. It almost wants to make you put a huge NoDaddy.com sticker in your back window and drive around town all day in gas with the same money you give to them. Ok, now I am done venting, any Idea's anyone.???
View 2 Replies
View Related
Apr 8, 2008
I've transfered a site recently from reinvent
hosting to godaddy, the site works, but the pages that retrieve ms sql
(2005) queries now load about 5-8 seconds longer than they did on
reinvent (which was basically instantly)... the guy who i talked to at
godaddy said that i need to change the links on the site from external
linking to internal linking... as far as i understand it all the links
are linking internally (not using somedomain.com/page.asp?var=param....
but using ?var=param, or page2.asp?var=param), unless there's a
different use of the term that i'm not familiar with... anyway i'm
confused what he meant by it... and the asp seems to be structured ok
(and as mentioned the sql did work perfectly fine on another hosting)..
it connects to the db, retrieves the data and puts it into the array,
then loops the array for printing to page... then closes the array/db..
i think that should work perfectly fine as it did on the other
hosting... but does anyone out there know a solution to fix this on
godaddy hosting, they say it's nothing with their sql server as they
checked it and it's fine... here's the site: pccti.com ... and the
slowness is when retrieving the healthcare/IT courses and then also
displaying course details... please help
View 1 Replies
View Related
May 19, 2006
Hi,
I have two sql db's. One for company record info, other for users (aspnetdb) I created the users one using the login control and web administration wizard. This all worked well until I had to publish to godaddy. I had to rebuild my company db, but eventually I was able to pull info and all that is working. The problem is, how the heck do I add users? I noticed that it put users table in my db to start. So I manually went into the db on godaddy's servers, and added an application. Then when I tried to add a user manually, it kept giving me errors. Is there an easier way to add website users through godaddy? Something like the web admin tool that comes with visual studio? Man it is driving me crazy!!!
View 10 Replies
View Related
Nov 7, 2006
I have a vb.net web page which I created (a shopping cart). I created this site using vb.net 1.1 and SQL 2000 on my laptop. On my laptop everything works properly, but when I tried moving it to GoDaddy (http://currahee3-506.org/px/default.aspx). In the code, each query to the SQL server is done using stored procedures.
When you first go the page, a drop down is presented. When you select "Shirt" from the category drop down. A second drop down menu is then displayed and will let you select what type of shirt you are interested in purchasing. Select Polo Shirt Without Pocket. Upon doing so, I receive an error message:
Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'tbl_LookupCategory'.Invalid object name 'tbl_pxProducts'.Invalid object name 'tbl_LookupColor'.Invalid object name 'tbl_LookupSizes'.Invalid object name 'tbl_pxQtySold'.Invalid object name 'tbl_pxImages'.Source Error:
Line 143: sqlCommand.Parameters.AddWithValue("@str_ItemName", Trim(DDL_Items.SelectedItem.Text))
Line 144:
Line 145: Dim dataReader As SqlDataReader = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
Line 146:
Line 147: dl_Description.DataSource = dataReader
Source File: d:hostingcurraheepxdefault.aspx Line: 145
Keep in mind the Stored Procedure works in my testing environment, but not on GoDaddy. I moved the selected statement into a view on the GoDaddy SQL server, and the view worked perfectly. The tables do exist on the GoDaddy SQL Server.
This is the Stored Procedure:
CREATE PROCEDURE [dbo].[sp_GetItemInfo]
@str_ItemName VarChar(50)
AS
SELECT TOP 100 PERCENTtbl_pxProducts.int_ItemID,tbl_pxProducts.str_ItemName,tbl_pxProducts.int_RetailPrice,tbl_pxImages.str_SmallImageURL,tbl_pxImages.str_MediumImageURL,tbl_pxImages.str_MediumImageBackURL,tbl_pxImages.str_LargeImageBackURL,tbl_pxImages.str_LargeImageUrl,tbl_pxImages.str_SmallImageBackURL,tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold AS int_QtyAvailable,tbl_LookupCategory.str_Category,tbl_pxProducts.Int_SizeID,tbl_LookupSizes.str_Size,tbl_pxProducts.Int_ColorID,tbl_LookupColor.str_Color
FROMtbl_LookupCategoryINNER JOINtbl_pxProductsONtbl_LookupCategory.int_CategoryID = tbl_pxProducts.int_CategoryIDINNER JOINtbl_LookupColorONtbl_pxProducts.Int_ColorID = tbl_LookupColor.int_ColorIDINNER JOINtbl_LookupSizesONtbl_pxProducts.Int_SizeID = tbl_LookupSizes.int_SizeIDLEFT OUTER JOINtbl_pxQtySoldONtbl_pxProducts.int_ItemID = tbl_pxQtySold.int_ItemIDLEFT OUTER JOINtbl_pxImagesONtbl_pxProducts.int_ItemID = tbl_pxImages.int_ItemID
WHERE(tbl_pxProducts.int_Quantity - tbl_pxQtySold.int_QtySold > 0)AND(tbl_pxProducts.str_ItemName = @str_ItemName)
ORDER BYtbl_LookupSizes.str_Size
Does anybody have any suggestions as to why this stored procedure is failing?
View 1 Replies
View Related
Apr 22, 2006
Everything works great on my development box. I am using GoDaddy for production (ASP.Net v2, SQL 2000).
I am not receiving any errors, so I am stumped; no data from the database is displaying on the GoDaddy pages.
I updated the connection string in web.config to this:
< add name="snsb" connectionString="
Server=whsql-vXX.prod.mesaX.secureserver.net;
Database=DB_42706;
User ID=username;
Password=pw;
Trusted_Connection=False" providerName="System.Data.SqlClient" / >
But I am unsure if this is the issue?? Any insights? This is the page I am working on: www.sugarandspicebakery.com/demo/bakery/default.aspx. So, the page displays fine, but it should be showing data from the database. This particular page uses a DataList with ItemTemplate. There is definitely data in the database, and I have even ran the same exact query from the code using the Query Analayzer on GoDaddt and it returned results
I know there isn't much info to go by, but I am hoping someone has some insight since I have been trying to figure this out for days now!
Thank youJennifer
View 2 Replies
View Related
May 5, 2006
Okay... GoDaddy's driving me nuts!!! Anyone... please help.
I am doing an insert into a database with:
INSERT blah blah blah; SELECT @@IDENTITY;
On EVERY OTHER SERVER I have tried this on (local SQLExpress 2005's and my companies various SQL2000 servers, this always returns for me the row number (of autoIndex number of the row just added to the database). My autoIndex was created with the following code:
ALTER TABLE sites ADD autoIndex INT NOT NULL IDENTITY (1,1) PRIMARY KEY
The code I have tried getting the identity with is:
cmd.CommandText = "INSERT blah blah; SELECT @@IDENTITY;";
string autoIndex = Convert.ToString(cmd.ExecuteScalar());
cmd.Dispose();
I also tried:
// bulding of SQL INSERT here
cmd.ExecuteNonQuery();
cmd.Dispose();
cmd = new SqlCommand(SQLDataSource_pics.SelectCommand, conn);
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT @@IDENTITY;";
string autoIndex = Convert.ToString(cmd.ExecuteScalar());
Session.Add("autoIndex", autoIndex);
Most of the time, I get a value of "0" (zero) for autoIndex. Every now an then (5%) of the time I get back a correct value.
I don't know where to go from here.
Thank you.
Hayedid
View 4 Replies
View Related
Jun 29, 2007
I have an application that utilizes aspnet for membership.
The application utilizes the same database (in SQLServer) for storage of other things. I have a view as follows:
USE [DB_Name]
GO
/****** Object: View [dbo].[Authorization] Script Date: 06/29/2007 15:27:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW Authorization
AS
SELECT dbo.Domain.Domain_ID, dbo.Domain.Domain_Name, dbo.Alias.Alias_Name,
dbo.Alias.Alias_Authority, dbo.Domain.Domain_ProcessType, dbo.Domain.Domain_Status,
dbo.aspnet_Users.UserName AS Owner_Name
FROM dbo.Alias INNER JOIN
dbo.Domain ON dbo.Alias.Alias_Parent_ID = dbo.Domain.Domain_ID INNER JOIN
dbo.aspnet_Users ON dbo.Domain.Domain_Owner_ID = dbo.aspnet_Users.UserId
This works fine locally. However, I am hosting this on GoDaddy and though it allows me to create the table, it seems to have a problem (I'm guessing because it is referencing differing schemas?) and I get an error of: Incorrect syntax near the keyword 'Authorization'.through the SQLServer Web interface whenever I attempt to view the data from this view.
I don't doubt that there is some kind of difference between the manner that SQLServer has set up the schemas and how they are set up on my local version.
Any help would be greatly appreciated. I am at a loss of how to get this info and truly want to utilize the view as it would improve performance over a query - at least I believe so. My thinking is that although there may be a performance drop when the item is being added, I gain on the back-end where I really need the performance over utilizing a query.
Thanks,
Steven Henley
View 3 Replies
View Related
Oct 12, 2007
Hello,I just got a personal site with godaddy that I would like to be able to connect to using SQL Server management studioI try to connection using Server Name: sdhfuh928323984ujf.phx3.secureserver.netauthentication: sql serverUsername: my usernamepassword: my passwordThen it tries to connect and gives me an error that I can't and remote connections may not be allowed. I followed the directions it gave and turned on remote connections, restarted the server, but I still get the error.any ideas?
View 3 Replies
View Related
May 1, 2008
Hello, we have the hosting account with GoDaddy Server. We have using Visualstudio.net and MSSSQL Server 2005.
For hosting the files for the remote server ( Godaddy ) we are using FTP Cute client to upload the files. For Uploading a database they given a seperate login and we are hosted my data as a Transact SQL File. Up to this its going fine.
After that I want to retrieve my data from GoDaddy Database server. They are not allow the remote connections directly. But they told to use the File DSN to retrieve the data from thier server ( GoDaddy Server ). I don't Know how to use thier File DSN to connect My ASP.Net 2.0 Application to thier GoDaddy Database Server.
If I asked to GoDaddy Support team they are sending this file.
Connecting to a Microsoft SQL Server Database Using ASP/ADO
View 10 Replies
View Related
Jul 13, 2006
1) What is the use of pooling actually?
I have an online application using SQL server, where I can check the connection pool from, SQL Server Enterprise Manager->Microsoft SQL Server->SQL Server Group->LOCAL->Management->Current Activity->Process Info.
2) In the connection pool, when I log into my system, a connection is made as I run query using stored procedure thus making the process available in the connection pool. Now when I am done and log out of the system, does the process suppose to stay there or not (the connection closed) and making it disappear from the pool?
I read from some forum that pooling is a good thing as it make accesing data faster.
View 2 Replies
View Related
Mar 14, 2007
I build an asp.net 2.0 (VS 2005) web application and put it on the server. The installed SQL server is SQL server 2003. I get this error message when i keep the application running for 10 or 15 mins. "Timeout expired. The timeout period elapsed prior obtaining a connection from the pool. This may have occure because all pooled connections were in use and max pool size was reached."
I made the server timeout unlimited but the error keeps coming up after some time of openning the application. The application session time out redirects the user to the login page and doesn't throw an error like the one i mentioned above.
Any idea. Thanks in advance.
View 4 Replies
View Related
Jun 28, 2007
hello to all
my problem is
when in database it reaches nearly 100 active connections (i check it from detach database) , my application does not allow me to open new browser page and show me error like:
time out expire. the max connection pool is reached.
please help.
View 2 Replies
View Related
Jul 20, 2005
Hello Experts,I make a connection with .Net Sqlclient Data Provider tomy server and I adjust the min pool size = 0, but when Icheck the sysprocesses I see that 2 connections have beenmade. Why is that? am I missing something here?Conn. string"server=MYSERVER;user id=sa;database=MYDB;min poolsize=0;max pool size=10;packet size=3072;ApplicationName=MYAPP"Thanks in advanceMichas KonstantinosSQL Sewrver Developer, DBA*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies
View Related
Sep 8, 2007
I have pages which are using a master page.
An example page on my site would be the homepage, it makes 3 connections to mssql.
1) Get the keywords of the page
2) Get a list of news articles
3) Get the content of the page.
When I visual web express to debug the site it's giving me a pool error message, neither can I get the site to load directly via IIS. It says theres been a pool timeout.
I've read on the internet about making sure connections are closed when you are finished and I've checked that all database connections are closed using
finally{conn.Close();}
does anyone have any idea why I would be having this problem?
How can I see what connections the site is opening, or maybe theres a limit on my server?
I'm using my own test server running windows 2003 and IIS
View 6 Replies
View Related
Mar 31, 2004
how can i change pool buffer of all connections?
I receive this error for each connection:
System.InvalidOperationException: 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.
View 1 Replies
View Related
Apr 30, 2004
I have a site which provides online studying for students in a graduate program. Apparently their final was today because lastnight everybody was on. I know, however, that this is a small class, so no more than about 80 people could be on the site at one time. I still got SQL errors (emailed to me from Application_Error). I read on MSDN that by default connection pooling should be in place, with a pool size of 100... that would mean I wouldn't have this problem if only 80 students were on the site.
Why is this happening?
Below is my connection string from web.config.
<add key="connStr" value="Server=xxxxxx;Database=xxxx;UID=xxx;PWD=xxx;"></add>Error:
System.InvalidOperationException: 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.
msdn link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp
View 11 Replies
View Related
Apr 7, 2005
Hi guys!
I have a dev server that has about 15-25 connections which is fine.
**
Looking at performance counters: _global_
under SqlClient: Current # connection pools
under SqlClient: Current # pooled connections
under SqlClient: Current # pooled and nonpooled connections
**
BUT when I look at staging and production I have only 4 or so...
WHAT'S GOING ON?!?! The querystring doesn't specify the max pool
size, pooling, nor timeout values. So I'm guessing it uses the
defaults. ( I also tried putting in max pool size, but it didn't
change anything! )
Does anyone know how I can increase the value? It is impacting the performance of the site considerably. Thank you!
View 1 Replies
View Related
Apr 17, 2008
Dear All,
how can i change the default pool size???
Vinod
Even you learn 1%, Learn it with 100% confidence.
View 1 Replies
View Related
Sep 24, 2007
I am having a puzzling problem with a DTS package in SQL 2000 that uses a combination of "Execute Process Tasks" and "ActiveX Script Tasks." The issue occurs with one of (the second) the ActiveX Script Task. The script invokes a COM object that was written in C#. This COM object connects to the database and writes a record set and then calls a stored procedure.
When I run this step individually, everything works fine. When I run it as part of the package, the record set is being written but the stored procedure is not invoked (SQL Profile confirms this).
I haven't really begun a serious attempt to troubleshoot the problem, though I have played around with the Transactions and OLE DB properties of the DTS Package.
Any suggestions as to why the behavior might be different, or some straightforward tips on troubleshooting would be appreciated. I have access to the COM component source.
View 1 Replies
View Related
Jan 3, 2008
When using connection string connect to sql server, there is a item max pool size.
The default is 100.
I set it to 500, but still get max pool size is reached and timeout error.
I checked my code and do open and close each connection each time using connection, so should have no memory leak.
What is the maximun value for max pool size? how to calc this size based on the memory used by SQL Server?
View 5 Replies
View Related
