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.







Idle Connection


How can one remove idle connections that are just sitting/sleeping.
Most of the time the developers are hitting the database through some
front end app like VB, the front end app may perform a insert, update,
select, or delete after they log out you can still see their spid
in sleep mode.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
What's The Idle Timeout Of SQL Login Connection?
Hi.. I have application which is connected to my SQL 2000 database. Normally our users use Terminal service to the SQL 2000 and application (same box) remotely and connect to the database. But some time the connection break and I have idle login stuck there.

For example, if I use sp_who, I can see many logins still login to DB even they are out. And sometimes I see duplicate logins too even there is only one person using that login to logon to DB. Is there a way to find out what is the idle timeout of the user login session??

Is that under SQL server properties -->remote server connections-->Query time-out--> >> sec ?

Is there a way to limit only 1 session can be allow for each login ??

View Replies !   View Related
DB Connection Is Closed After It Is Idle For Some Time
 

I am using MS JDBC driver 2005 1.2 and in-house written connection pooling  that was working fine for a number of years. This combination worked OK with SQLserver 2000.  But recently we switched to SQLServer 2005 (x64) on WIN Server 2003 Standard x64 eddition.  Everything seems work OK during business hours, however, after business hours when there are lesser users and connection stays idle for sometime, I am getting the following error:
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source)
 at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(Unknown Source)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.freeConnection(OnlineTransactionManager.java:420)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.releaseConnection(OnlineTransactionManager.java:707)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.releaseConnection(OnlineTransactionManager.java:688)
 at com.nms.serverframework.dbaccess.OnlineTransactionManager.finalize(OnlineTransactionManager.java:399)
 at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
 at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83)
 at java.lang.ref.Finalizer.access$100(Finalizer.java:14)
 
Any help would be appreciated
 
thanks in advance

View Replies !   View Related
@@cpu_busy And @@idle
Should these two stats added together give me the time (ms) since SQL Server has been restarted? Maybe I don't understand but @@cpu_busy is the amount of time sql server has accessed the cpu and @@idle is the amount of time sql server has no cpu activity. When I add these two figures together, I don't get the total amount of time (ms) SQL Server has been running. What am I not doing? Any help is appreciated.
Thanks

View Replies !   View Related
Idle Time
Dear ,

If a user not doing in the database for more than 30 minutes i want
to disconnect his connection.

Kindly help me

Thanks

G Selvam

View Replies !   View Related
Performance Gap After Some Time Of Idle.
 Hello everybody,I have a ASP.NET (3.5) Web site which uses an data connection to my Sql Server 2005 Express. When I browse in my data-driven pages of my website, I am satisfied with the performance. But when I try my website after a long break, e.g. in the morning, the data-driven pages take a long time to come up, about 10 seconds. After this gap, when surfing on the other pages, there is no problem. It is only the first page. So it seems that my SQL Server goes "to sleep" after a certain time of idle.First I read a post about this problem which came up with the user instances of Sql Server. So I got rid of my user instance and set up my database "normally". But still I have that performance gap.I am using Linq To SQL and a couple of ListViews. I am totally confused how to manage this problem.Any suggestions?Thanks in advance,Hannes 

View Replies !   View Related
Session Idle Timeout Over
Hi all,
We got this message on our production server event viewer for source MSDTC.

"String message: Session idle timeout over,tearing down the session"..
Even though it is marked as informational, just wanted to know what it is?..

thanks guys,
Marx

View Replies !   View Related
Idle Connections Termination
folks
We have a situation where people just login run complex queries and then just don't shut off their query analyzer of apps.

Some of these chew up a lot of CPU cycles and unless we kill the query the CPU cycles are not released.

I see some of them are idle for over 1-2 hours or more, their last_batch would be at least 2 hours old.

The question is, "Is there a setting in the sql server whereby we can automatically disconnect idle threads?"

Regards
Paresh Motiwala
Boston, USA

View Replies !   View Related
Slow Startup From Idle
Is it possible to stop the server from going to sleep when it is idle to improve responsiveness to new connections?

View Replies !   View Related
Removing Idle Client Connections
Is there any parameters/procedures one can use to remove idle client connections (sql65sp5a)from the server or odbc side?
The only parameter that looks like a remote possibility is
remote conn timeout, but this appears to work server to server?
TIA
Yvonne

View Replies !   View Related
Replication - Distribution Agent Becomes Idle
I have been seeing this issue for several weeks now. The distribution agent will become idle even though there is activity occurring within the replicated database. If I manually start the distribution agent, it will begin retrieving the transactions. I thought that this might be due to inactivity but I have modified the inactivity threshold and I am not receiving an actual inactive agent warning. There are no warnings -- it simply sits there and does not resume sending transactions.

Any thoughts? This is a transactional replication with a distribution agent that is run at the subscriber.

Thanks,

MV

View Replies !   View Related
Locating Idle Sessions Using Dm_exec_... DMV's
Hi

I have been looking at the new DMV's prefixed with dm_exec_....and found a limitation with them.

Books online says sysprocesses is replaced with sys.dm_exec_connections, sys.dm_exec_requests and sys.dm_exec_sessions. The problem I came accross is identifying any sessions connected to a specific database which were idle. This is the sort of thing you need to know if you tried to restore a database and it says the database is in use.

I wonder if this is a bug or by design?

 

 

View Replies !   View Related
Can't Connect To DB When SqlServer Exp Has Been Idle For A Couple Hours.
Does SQLServer go to sleep when it's been idle?  How can I connect without an error?
 
I have SQLExpress on a server.  Server Name is SqlExpress.  I have 2 DBs on that server... Tuna & Guppy.  I'm connecting to the DBs from a remote PC which runs my App... an exe created with Visual Studio 2008, Visual Basic.
 
If I run my App at say 9:30PM, after the server has been idle for several hours, I get a "Can't open connection to Guppy" error, which is my error message when the connection attempt fails.  If I quit & relaunch the app, it connects fine, and will continue connecting fine unless you leave the server idle for serveral hours again.
 
If I'm developing a 2nd app all evening... which connects to a 2nd DB...Tuna, that activity seems to keep the SqlServer awake and then launching the 1st app at 9:30PM connects to Guppy just fine.
 
I tried adding a "Connection Timeout=30" to my connection string but that did not help.
 
My connection code is as follows (note the server's name is SQLExpress):
 
Dim strConnG As String = "Data Source=SQLEXPRESSSQLEXPRESS;Initial Catalog=Guppy;Integrated Security=True;Connection Timeout=30"
Using ConnG As New SqlConnection(strConnG)
       'open Guppy connection
       Try
           ConnG.Open()
       Catch ex As Exception
            MsgBox("Can't open connection to guppy")
            Return False
       End Try
       'Code that does stuff
End using

 
Can anyone tell me how to fix this so I can connect without error, even if the server has been idle?
 
Thank you,
 
Joe A

View Replies !   View Related
Database Is Slow To Access After Being Idle For Some Time
I've noticed that after the database have been idle for some time, it takes up to 10 seconds to get it started when something needs to access it. In the event viewer it says that the database <name> have been started.

Obviously, there is some idle timeout setting.

I saw an option in the database properties that is called "Auto Close" which is set to true. I assume this is what i'm looking for. Can someone confirm that? (it could take some time to test myself...)

But what i'm actually wondering is:

1. Is it possible to adjust how long it would wait before timing out?
2. What advantages does closing the database bring? Does it free up (a noticeable amount of) ressources? Or is it only that it's unlocking the files, so that it's possible to copy the database source files?

View Replies !   View Related
SQL Express 2005 Going Idle And Not Allowing Connections.
Just upgraded to SQL Express 2005 from MSDE for Firehouse. Upgrade went great and the db is accessable and running fine. Except when not used for a while. Then I need to restart the db to allow connections of any kind. If I don't I get an error that the db is not accessable and I can't connect. Everything runs fine after until it goes to "sleep" on me again. We upgraded to make use of the 4GB limit as we were at 1.9GB and MSDE was getting a little unhappy.

 

Any suggestions? Is this a "feature" and if so, is there a script I can run to kick it into working mode again?

 

Thanks

Chris

View Replies !   View Related
Kill A Session After An Idle Duration In SQL Server 2005
Hi all;

I want to implement "Auto disconnection" (or kill) of user session that exceed a specified idle duration in SQL Server 2005.

I know how do that in oracle by creating a profile and set the IDLE_TIME paramter and asign that profile to all users. But in SQL Server i don't know how to do it.

Can anyone help me.



Kindly

View Replies !   View Related
Problem With Performance After Leaving SQL Server Express Idle For Some Time
Hi, everyone!
I have this strange problem... After every time my application leaves sql-server idle (doesn't send anything, doesn't retrieve anything) next command to sql-server processes really long.
I've also noticed this bug/feature/misconfiguration even if I open a DB in Management Studio...
Please, could someone tell me, is there any timer that "puts a DB to sleep" if no one is using it for some time? Can I change the way server behaves in this situation?

View Replies !   View Related
Close Unattended Multi-user Applications Automatically After Idle Time
Auto Close Idle helps you utilize your multi-user concurrent users licensesmore efficiently. It closes unattended clients remotely after a certainperiod of time or manually. Furthermore, clients can close the most idleuser automatically without the need for the administrator's intervention.For more information visit our web site...http://www.autocloseidle.com

View Replies !   View Related
Stopping/starting Sql Server With Commandlinecommands In Batch To Free Up Idle Connections?
Hello:

We have a new sales force automation application for sales rep to log their contacts, etc. It runs on mssql 6.5, sp 4.

They log in and leave their connections on without logging off or leave their coonections idle .

We set the user connections fiarly high but we are concerned that the max amount of user connections weill be consumed and the sql serve becomes locked.

My questions are:

1) Is there any parameter in the sql server configuration that will log off idle users have a certain time and dsiconnect them?

2) A backup of the database will be made each night. If there is no parameter, would it be a good idea to stop and start the sql server every night to release the idle connections?

3) If so, how to stop sql server from the commadn and start it with a command line command and do this in a batch file as a scheduled task?

4) Is there any other way to release these idle connections each night?

Any information you can supply will be appreciated. THanks.

David Spaisman

View Replies !   View Related
Idle Timeout, Orphan Timeout Help
Here's the DB Connection code for a site (Web.config file)
I was wondering how I could specify an idle timeout or orphan timeout.
I tried idle timeout=x and kept getting errors

<add key="DBConn"
value="server=localhost;Trusted_Connection=true;database=SaltwaterFishing;Min Pool
Size=5;Max Pool Size=150;"></add>

Thank you

View Replies !   View Related
Cannot Set Connection Property Of Backup Database Task If Connection String Is Customized In Connection Object
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.

Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.

Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.

Is this an intrinsic issue?

View Replies !   View Related
Failed OLEDB Connection: Cannot Aquire Connection From Connection Manager
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table.  However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors?  Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
 
Thanks,
 
John T

View Replies !   View Related
Connection Strings, Trusted-connection VS Username-password, SQL Server 2005 Express
All --
Please help.
I have some questions about connection strings.
 
BACKGROUND...

Note that I am using the "SQL Native Client OLE DB Provider", SQL Sever 2005 Express, ASP.NET, C#.NET, and VS.NET 2005.
Note that I do not want to use the "Attach a database file" type of connection string.
Note that I am using the site http://www.ConnectionStrings.com as a reference.
Note that this "Standard security" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Uid=MyDatabaseUser;Pwd=MyDatabasePassword;" />...does not work and causes the following run-time error...A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
Note that this "Trusted connection" connection string...<add name="LocalSqlServer" connectionString="Server=MYTESTOFFICESERVERS;Database=MyDatabase;Trusted_Connection=yes;" />...works but is less-than ideal because it uses a Trusted Connection rather than a Username/Password combination.
 
QUESTIONS...
(A) What exactly does the error in Item 4 mean?
(B) Do 4 and 5 imply that one must use a Trusted_Connection for all SQL Server 2005 Express connection strings when the database does not reside in the web application's App_Data folder or use a "Attach a database file" type of connection string?
(C) Are there any alternatives?
(D) What do you suggest?
 
Please advise.
Thank you.
-- Mark Kamoski

View Replies !   View Related
Want To Reference Connection Managers From Within A Data Flow Task/Custom Connection Manager
Hi,
is there a way to get the references of connection managers from within a custom data flow task during runtime?
In
control flow tasks the connection service object can be used to get the
references to connection managers. For data flows I haven't found a way
yet.

Another question:
Where can I get a sample for a custom connection manager which is explained here

http://msdn2.microsoft.com/en-us/library/ms345276.aspx

My installation for sample codes does not contain connection manager samples.

View Replies !   View Related
SSIS Project Failing To Run Even Though I Verified Remote Sybase Connection Via Connection Manager
 

When running the project in debug mode or non-debug mode, I get the following error from MS Visual Studio:
 
TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Package [Connection manager "SYBASE_CONNECTION"]: The connection manager failed to defect from the transaction.
 (Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
 
Any ideas???

View Replies !   View Related
SQL Connection In Vista With Trusted Connection Fails Under Local System Account Until Reboot
Hi All,

We are using the Windows Task Scheduler as a substitute for the SQL Server Agent, which isn't available in the Express edition. The scheduled task just calls a batch file, which in turn, runs a stored procedure using osql with the -E option for a Trusted Connection.

SQL Server Express has been installed using the defaults, which means the service is running in the "NT AUTHORITYNETWORK SERVICE" account. The scheduled task we create is set to run using the "NT AUTHORITYSYSTEM" account.

Now we find that on Windows Vista (tested using Ultimate Edition) that the scheduled task fails to run the stored procedure until the machine is rebooted the first time after installing SQL Server Express. When I say "fail", I mean that the stored procedure isn't executed. The scheduled task however completes and reports no errors. On Windows XP, we do not run into this problem so I suspect it has something to do with the UAC in Vista?

We further found that after installing SQL Server Express and creating the scheduled task in the "NT AUTHORITYNETWORK SERVICE" account, the scheduled task (and stored procedure) runs fine WITHOUT requiring a reboot.

Can anyone explain why a reboot is needed to get SQL Server Express to run the scheduled task correctly under Windows Vista and the SYSTEM account?

Any help or thoughts greatly appreciated.

View Replies !   View Related
The Connection Name 'LocalSqlServer' Was Not Found In The Applications Configuration Or The Connection String Is Empty.
Hi,
I'm having a BIG problem, this is my 3rd day looking for answer !I'm trying to create a custom membership provider with MS SQL database 2005 but not the default ASPNETDB. I've changed the web.config to be as following:<connectionStrings><add name="sqlConn" connectionString="Data Source=.;Integrated Security=True;Initial Catalog=ASPNETDB;"providerName="System.Data.SqlClient" /></connectionStrings> <system.web><trace enabled="true" /><roleManager enabled="true" /><authentication mode="Forms" />
<membership defaultProvider="MySqlProvider"><providers><remove name="AspNetSqlProvider"/><add name="MySqlProvider" connectionStringName="SqlConn" type="System.Web.Security.SqlMembershipProvider" applicationName="/" /></providers></membership>
But when I try to login to the site using the login control the following error occurs:
Server Error in '/etest' Application.


Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty.Source Error:



Line 149: <roleManager>
Line 150: <providers>
Line 151: <add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 152: <add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
Line 153: </providers>Source File: C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Configmachine.config    Line: 151


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.213
 It is clear that this is a prblem with my Machine.Config file - since I've "worked!" on this file for a while. But when I've checked the Machine.config file I've found the LocalSqlServer connection it is talking about! .
I'm lost and I dunno what to do, can anyone help?
Here is the mahine.config in case if you need it:<connectionStrings>
<add name="LocalSqlServer" connectionString="data source=.;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" /></connectionStrings>
<system.data><DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /><add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /><add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add name="SQL Server CE Data Provider" invariant="Microsoft.SqlServerCe.Client" description=".NET Framework Data Provider for Microsoft SQL Server 2005 Mobile Edition" type="Microsoft.SqlServerCe.Client.SqlCeClientFactory, Microsoft.SqlServerCe.Client, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" /></DbProviderFactories>
</system.data><system.web>
<processModel autoConfig="true" /><httpHandlers />
<membership><providers>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression="" /></providers>
</membership><profile>
<providers><add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers></profile>
<roleManager><providers>
<add name="AspNetSqlRoleProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" /><add name="AspNetWindowsTokenRoleProvider" applicationName="/" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers></roleManager>
</system.web>

View Replies !   View Related
Remote Connection Refused When Creating ODBC Connection To SQL Server 2005
When I create a new odbc connection to a SQL server 2005 Db I get a failure telling me dat de SQL server does not allow remote connections.

How can I allow the server to allow this.

 

Any help appreciated

 

regards

View Replies !   View Related
Jdbc Refuses Connection With 'user Not Associated With A Trusted SQL Server Connection' Message
When using jdbc with IntegratedSecurity, I run into this problem when the machine is not part of a domain & gets its IP address via dhcp.  Is this expected behavior or a bug in the jdbc driver.

 

The SQLServer and client application are installed on the same machine and a local admin is logged in, running the client app.

 

If I change one of the two parameters mentioned above, the connection can be established leading me to believe this may be intentional for security issues.  Am I correct?

View Replies !   View Related
ExecuteReader Requires An Open And Available Connection. The Connection's Current State Is Closed.
I am accessing SQL2005 with C# code using  OleDbConnection.

 

A try and catch block catches the following error once a while between the Open() and Close() of the connection:

ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.

 

I do not even have any idea where to start to debug this.  The ExecuteNonQuery() runs a delete SQL query. It works 99.9% of the time. I do not see anything wrong when this error happens. 

 

Any hint would be greatly appreciated.

 

 

View Replies !   View Related
The TCP/IP Connection To The Host Has Failed. Java.net.ConnectException: Connection Timed Out: Connect
Hi,
                i am getting this exception i.e."

The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect" whenever i try to connect to the remote DB which is present at a different system.

View Replies !   View Related
Rounding Error: Between Flat File Connection Manager Source &&amp; OLE DB Connection Destination (SQL Server 2005)
I have a Rounding error: Between flat file connection manager Source & OLE DB Connection Destination (SQL Server 2005) in my Dataflow.

File looks like this lets call column names Col A,B,C,D

70410000        RD1      1223631.92     196042.42
70329000        ICD       11025.84          3353.88
71167300        COL      104270.59       24676.96

flat file connection manager settings: first row Column names then Advanced tab Col A  float , Col B  float , Col C  string ,Col D  float ,

OLE DB Connection Destination (SQL Server 2005)

CREATE TABLE [dbo].[PT_CUST_ABR](

[PARTY_NO] [float] NULL,

[PARTY_NAME] [varchar](75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[TELECOMABR] [float] NULL,

[GENIABR] [float] NULL,

 

Problem: ColA (Source) Rounding error to PARTY_NO (Destination)
I have a field of text of in a flat file that the flat file connection manager Source picks up correctly €œ70000893€?
 However when it gets the OLE DB Connection Destination the data has changed to 70000896. That€™s before its even Written to the database.
 The only clue that something is wrong in the middle is the great Data viewer shows the number as 7.000009E+07
Other clues looking at the data it appears there is a rounding error on only the number that dont end in 00
ColA (Source)  PARTY_NO (Destination)
71167300       71167296
70329000       70329000
70410000       70410000 
Any ideas people?
Thanks in advance
Dave

 

 

View Replies !   View Related
Connection Attempt Failed With Error: '10061(No Connection Could Be Made Because The Target Machine Actively Refused It.)'.
I am working in a distributed environment, I verified msgs have been successfully send from server1 db1 to server2 db2, but I still get the following error msg from the sender server through SQL profile:
 

Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.
 
Does anyone experienced the samething?
Thanks!

View Replies !   View Related
SSPI Handshake Failed With Error Code 0x8009030c While Establishing A Connection With Integrated Security; The Connection Has Be
Hello, I have a sql 2005 server, and I am a developer, with the database on my own machine.  It alwayws works for me but after some minutes the other developer cant work in the application

He got this error

Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.140]

and When I see the log event after that error, it comes with another error.

SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.1.140]

He has IIS5 and me too.

I created a user on the domain called ASPSYS with password, then in the IIS on anonymous authentication I put that user with that password, and it works, on both machines.

 

and in the connection string I have.

<add key="sqlconn" value="Data Source=ESTACION15;Initial Catalog=GescomDefinitiva;Integrated Security=SSPI; Trusted_Connection=true"/>

I go to the profiler, and I see that when he browses a page, the database is accesed with user ASPSYS, but when I browse a page, the database is accesed with user SElevalencia.

Thats strange.

The only way that the other developer can work again on the project is to restart the whole machine. He has windows xp profession, I have windows 2000.

If you want me to send logs please tellme

 

 

View Replies !   View Related
Dropped Network Connection Breaks Connection To Local SQL Server
Let me set the stage of my testbed configuration: On Windows XP SP2, my default connection to the Internet is via wireless express card modem using EV-DO via Verizon Wireless. Let's call this connection A. I also have a traditional wireless network connection (802.11g) that is always enabled. Let's call this connection B. Connection A is always connected during normal business hours. Connection B is not and is often searching for a wireless network to connect to when nothing is in range.



Yesterday, connection B was continuously trying to connect to a wireless network not under my control, meaning that the connection was never established and notification messages continually popped up to complain of this fact. Over time, I've learned to ignore these messages and go on doing my daily work without much thought of the possible implications.




Then, things started to get odd. I was running our application, WebWatchBot, to perform some simple tests of various websites and servers, when I started to get messages from the application that database connectivity was lost, which is a message that pops up to inform the user that the connection is forcibly dropped by SQL Server. After a few moments, the connection to the database was re-established and the message went away. Since I was actually working with SQL Server, I thought it was an anomoly, so I continued on. Then, it happened again. And again. Then, I noticed that the "database connectivity lost" message started to coincide with the wireless connection's (connection B) inability to connect with a wireless network.




Why would this be happening? The database and application are on the same exact computer. The connection to the database is via ODBC drivers over tcp/ip, but why would connection B affect this?





Some added information that may prove useful:



Client side:

What is the connection string in you app or DSN? (please specify)
DRIVER=SQL Server;SERVER=HIGHNOTEWEBWATCHBOT;Database=WebWatchBot;UID=sa;PWD=*****

If client fails to connect, what is the client error messages? (please specify)
[Microsoft][ODBC SQL Server Driver]Communication link failure

Is the client remote or local to the SQL server machine? [Remote | Local]
Can you ping your server? [YES | NO ]
In cmd.exe console, type €œping -a <server_name>€?.

Can you telnet to your SQL Server? [YES | NO, please specify the error message ]
In cmd.exe console, type €œtelnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+€™[€˜ to bring up telnet prompt and type €œquit€? <enter>.

What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify): WebWatchBot - Website and Server Monitoring Software
Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup)
What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes].
Do you have aliases configured that match the server name portion of your connection string? NO
Do you select force encryption on server and/or client? NO
[2] Server side:
 

What is the MS SQL version? [ SQL Server 2005 | SQL Sever 2005 ]
What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)].
Microsoft SQL Server Management Studio                        9.00.3042.00
Microsoft Analysis Services Client Tools                        2005.090.3042.00
Microsoft Data Access Components (MDAC)                        2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML                        2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer                        7.0.5730.11
Microsoft .NET Framework                        2.0.50727.832
Operating System                        5.1.2600

What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm.
Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG?
If SQL Server is a named instance, is the SQL browser enabled? [YES | NO]
What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account]
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable]
Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance.[YES | NO | not applicable ]
[2a]  Tool Used to Connect

What tool or Application are you using to connect to SQL Server (eg: Visual Studio, SQL Server Management  Studio, SQLCmd.exe, OSQL, etc) and especially the version of SQL Server (Express, Workgroup, Standard, Enterprise, Developer)
 
[3] Platform:

What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ].
Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify)].
 

View Replies !   View Related
Login Failed;0xC0202009; Cannot Acquire Connection From Connection Manager
hi all,
i got the error, when i run my package after deploy into the server machine;
i can able to run that package in my local machine, if i deploy it to the server or some remote machine, its not running, and rises error messages, that says cant accquire connection from the connection manager;

the problem might be with the login name and password; i could not see any password in any of my config file, or connection manager while running the package.
how to resolve this problem?? please help me!
 

View Replies !   View Related
The Connection Name 'name' Was Not Found In The Applications Configuration Or The Connection String Is Empty
 

I have seen another thread with this same problem, but the problem seemed to be a typo.  I am getting an error when I try to access the web site ..
 

The connection name 'USASH-AS0013' was not found in the applications configuration or the connection string is empty.
 
However, in my web.config file I do have a connection named USASH-AS0013.  Here is my web.config file (with my user/pwd hidden).  Any help would be greatly appreciated.
 


<?xml version="1.0"?>
<!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website->Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    WindowsMicrosoft.NetFrameworkv2.xConfig
-->
<configuration>
 <appSettings/>
 <connectionStrings>
  <add name="USASH-AS0013" connectionString="Provider=SQLOLEDB;Data Source=USASH-AS0013;User ID=****;Password=*****;Initial Catalog=&quot;Smart Factory&quot;"
   providerName="System.Data.OleDb" />
 </connectionStrings>
 <system.web>
  <!--
            Set compilation debug="true" to insert debugging
            symbols into the compiled page. Because this
            affects performance, set this value to true only
            during development.

            Visual Basic options:
            Set strict="true" to disallow all data type conversions
            where data loss can occur.
            Set explicit="true" to force declaration of all variables.
        -->
    <compilation debug="true" strict="false" explicit="true"/>
    <pages theme="MySkin" >
   <namespaces>
    <clear/>
    <add namespace="System"/>
    <add namespace="System.Collections"/>
    <add namespace="System.Collections.Specialized"/>
    <add namespace="System.Configuration"/>
    <add namespace="System.Text"/>
    <add namespace="System.Text.RegularExpressions"/>
    <add namespace="System.Web"/>
    <add namespace="System.Web.Caching"/>
    <add namespace="System.Web.SessionState"/>
    <add namespace="System.Web.Security"/>
    <add namespace="System.Web.Profile"/>
    <add namespace="System.Web.UI"/>
    <add namespace="System.Web.UI.WebControls"/>
    <add namespace="System.Web.UI.WebControls.WebParts"/>
    <add namespace="System.Web.UI.HtmlControls"/>
   </namespaces>
  </pages>
  <!--
            The <authentication> section enables configuration
            of the security authentication mode used by
            ASP.NET to identify an incoming user.
        -->
  <authentication mode="Windows"/>
  <!--
            The <customErrors> section enables configuration
            of what to do if/when an unhandled error occurs
            during the execution of a request. Specifically,
            it enables developers to configure html error pages
            to be displayed in place of a error stack trace.

        <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
            <error statusCode="403" redirect="NoAccess.htm" />
            <error statusCode="404" redirect="FileNotFound.htm" />
        </customErrors>
        -->
 </system.web>
</configuration>

View Replies !   View Related
The Connection Name 'name' Was Not Found In The Applications Configuration Or The Connection String Is Empty
I have been trying to host my website on Go Daddy for about 3 weeks and I have cleared several problems but this one remains. I can get into the ASPNETDB database for doing logins , etc but I cant access my database called "PINEmgt".
To try to understand where the problem is located,I built a very simple application without login controls and put on  it one Detailform accessing a single line table "Signin". I continually get the error message I got with my real app :"The connection name 'PINEMgtConnectionString2' was not found in the applications configuration or the connection string is empty. " There is only one connection string in my app -'PINEMgtConnectionString2'. When I run the app locally on my machine it works. After I move everything to Go Daddy, I get the error message and the following dump"
 




Line 24: </Fields>
Line 25: </aspetailsView>
Line 26: <aspqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStringsINEMgtConnectionString2 %>"
Line 27: InsertCommand="INSERT INTO Signup(first_name, last_name, email, customer_id) VALUES (,,,)"
Line 28: SelectCommand="SELECT * FROM [Signup]"></aspqlDataSource>

This is indeed the code from my single page app.
 
The dump is:




[InvalidOperationException: The connection name 'PINEMgtConnectionString2' was not found in the applications configuration or the connection string is empty.]
System.Web.Compilation.ConnectionStringsExpressionBuilder.GetConnectionString(String connectionStringName) +3039085
ASP.default_aspx.__BuildControlSqlDataSource1() in d:hostinguck7scoutDefault.aspx:26
ASP.default_aspx.__BuildControlform1() in d:hostinguck7scoutDefault.aspx:10
ASP.default_aspx.__BuildControlTree(default_aspx __ctrl) in d:hostinguck7scoutDefault.aspx:1
ASP.default_aspx.FrameworkInitialize() in d:hostinguck7scoutDefault.aspx.vb:912306
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +40
System.Web.UI.Page.ProcessRequest() +86
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +18
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.default_aspx.ProcessRequest(HttpContext context) +29
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +303
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64


After Googleing, asking Go Daddy for info (which they dont give) , etc for three weeks, I need serious mental help
in the form of a solution of this problem. Your help with the problem or the name of a good mental health professional in eastern N.C. (maybe both) would be appreciated.

View Replies !   View Related
Using One Single-application Connection Vs. One Connection For Every Operation To SQL-Server Via ADO.NET
Dear members,I'am thinking about the "best" way to connect to my sql-server viaADO.Net (if there is a best way).My application uses the sql-server very intensively. At the momentevery database-operation opens a connection, executes and then closesthe connection.Another way would be to use only a single connection to the database,which is opened when the application starts.What do you think is the better way to get a high performing sqlserver: using one single application connection vs. using oneconnection for every operation?Cheers, Sebastian

View Replies !   View Related
SQL Server Refuses Connection, Says Maximum Connection Reached.
I have an application (Powerbuilder, ODBC, SQL server 6.5) running with about 10 users. When about 6 users are connected, any more users cannot get on. The system comes up with the error message, saying the maximum 15 connections are connected. I can configure more with sp_configue. I have the connection limit of 15 on the SQL server 6.5 Workstation. I don't understand how when 6 users are connected it can say all 15 connections are used. I checked the SQL server using Enterprise Manager. It was counting some system process as users also. How can I make this problem go away.

Can I schedule system Job at later times, or can I get more licences, or can I do some cleanup and get more connections.

Any help will be appreciated.

Thank you.

View Replies !   View Related
SSIS Package Does Not Remember Password (OLE DB Connection + ADO.Net Connection)
Both the OLE DB Connection and ADO.Net Connection in SSIS Package does not remember password.

Im connecting to a SQL Server 2000 box using its sa password as test.

The SSIS package runs fine when you first set up the connection in bids

The bottom line is that SSIS keeps forgetting the password I feed into
the two Connections that I'm using. I double-click a connection,
type the password in, check "Save my password" and hit "OK" but the
password disappears from there whenever I run the package or
double-click the connection again.

 

is there any known workaround for this issue as I would like to schedule my SSIS package using a SSIS Step in a SQL Server 2005 Agent job.

 

the only thing I found when googling this error was link below but the workaround described here is a little harsh

http://www.developersdex.com/sql/message.asp?p=1921&ID=%3C1146409399.447345.7470@j73g2000cwa.googlegroups.com%3E


 

thanks in advance

Dave

 

the box SSIS is running on is Windows 2003 Server Standard Edition latest service pack

SQL Server 2005 (no service packs )

 

 

 

View Replies !   View Related
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.

View Replies !   View Related
Using Oledb Connection From Connection Manager In Script Task
Is there anyone who tried to use a connection from connection manager to create a new connection in a script task? Including the password?

Now i passed the connection to the script task and called it in the vb script but then the password is not passed into the connect string.

Im searching for an example that works with passing the password in the connectstring?

 

Any help will be greatfull.


 

View Replies !   View Related
Cannot Acquire A Managed Connection From The Run-time Connection Manager
How would one go about using an ODBC connection with SSIS. I'm trying to ETL some Sybase ASE data, but I get the error when I try it:

"cannot acquire a managed connection from the run-time connection manager"

 

This wasn't any help:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=169777&SiteID=1

 

 

View Replies !   View Related
SSIS Remote Connection Failing ... Local Connection OK
I'm getting "Access denied" error when I try to connect to SSIS from my desktop (Database Engine is fine).  I'm a member of sysadmin within SQL, as well as an administrator on the server.  I don't have any problem when I log on to the server directly via Remote Desktop and open SSIS. 

I went into the surface area config tool, and I see that Database Engine and Analysis Services both expand and have a sub tabs to enable Services and Remote Connections, but Integration Services does not expand to a Remote Connections option, just Services.  We're running MSDN Enterprise edition.

Does it matter if all the SQL services are using "Local System" for the logon ?  I use an administrative logon on my SQL2000 boxes, and was fiddling with them on the 2005 box yesterday, but it seemed to cause more problems, so they are all Local System for now.

Am I missing something obvious ?

View Replies !   View Related
Edit Connection Manager Connection String At Runtime With C#
This is the first time I have used SSIS, so please bear with the ignorance.

 

I have a super simple package that inserts x000's of rows into a temporary table. The data source is a file that the user will upload. I need to be able to tell the package what file to upload. I'm thinking the simplest thing would be to edit the connectionString property of the SourceConnectionFlatFile at runtime. Is this possible? What form should the file path be in (UNC, other)? And, are there any other considerations I should be aware of?

 

Thanks!

View Replies !   View Related
Lost Connection To MySQL During Query In My ODBC Connection
I am trying to connect Visual Studio 2005 here in the Philippines to a MySQL server in CA, USA using the Connector/ODBC using the following parameters:

 

DSN = mysqlodbc

Server = host376.ipowerweb.com

userid = myuid

password = mypassword

 

when i used the port 3036  i got the  can't connect to MySQL on server blabla(10060)

 

when i used the port 8087 i got the "Lost connection to MySQL during query.

 

How do i connect successfully?

 

 

 

 

View Replies !   View Related
Connection.open And Connection.execute In SSIS
Hi
there are two commands in Activex - connection.open and connection.execute
which are used to open a connection and to run some commands in SQL2000

can anyone tell me how to do the same in SSIS.
would be much better if i can use the connection in the connection manager rather than creating a new connection in the script.

View Replies !   View Related
Making The Connection In A Connection Manager Retry
Is there a way by which we can make the Connection in the connection manager retry for a certain amount of time?
 
I have a DataFlow Task which uses a OLE Source which is connected to a database. there are time when the connection to the database is not available due to some transport level error. so i wanted the connection manger to make a couple of tries before giving up and saying that it was not able to connect and it timed out..
 
i have the Connect TimeOut and the General Timeout properties set to 0, but is there a way to retry?
 
Thanks for any help in advance

View Replies !   View Related
Problem With Deleting Connection From Connection Manager
Hallo,

 

I have deleted one of my file connection from Connection Manager (and

Executed ProcessTask which used it), however

trying to load the package I always get the error:

 

"Error loading MyPackage.dtsx: The connection "MyDeletedConnectionName" is not found.
This error is thrown by Connections collection when the specific connection element is not found."

 

I tried to Clean, Rebulid my project, but it doesn't help.

 

Does anybody know, how to solve it? Where this reference is saved? 

 

Thank you.

 

Anna

 

 

 

 

View Replies !   View Related
OlE DB Source - Cannot Acquire Connection From Connection Manager
My source files are in C:Process folder. File names are in the format proc*.csv

I am using foreach loop container to iterate over the files in folder "C:Process"

I have a user variable "filename"

 

The order of my tasks

ForEach - Data Flow task - File System Task

 

In Data Flow task, I have ole db source  which should take the dynamic filename from user variable "filename". whats happening is when i give fixed filename, without foreach loop container the package is working fine.

with dynamic filename, I am not able to run the package because of ole db source Error - cannot aquire connection from connection manager.

 

Thanks for u'r help.

 

View Replies !   View Related

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