Server Time Out Expired

Jan 5, 2008

Hi Actually i have developed an Web application(intranet) and I put it on IIS which will be using it more than 5 persons at a time. In that application there is a page which will interact more to Database(SQL server 2005). Problem is when persons working on that page some times it throws an error message like "Timeout expired. the timeout period elapsed prior to completion of the operation or the server is not responding". I think it is because of SQL server but i don't find exactly. Plz tell me what is problem and how to solve it.

View 3 Replies


ADVERTISEMENT

Connecting To Remote SQL Server - Time Out Expired?

Mar 23, 2006

Hello

Im connecting to a remote SQL Server in Enterprise Manager Via VPN,

we checked the connection and everything but still o cant connect

to the remote server, Error message says "Time Out Expired",

we checked the firewall config, ADSL connection and it's all Ok


what seems to be the problem here??

View 1 Replies View Related

Time Out Expired Error When Using Ado And SQL Server 2005

Oct 18, 2007

Any help would be appreciated.

We have a C++ program that connects to a remote SQL Server database. Recently the system we pull data from upgraded to SQL Server 2005 and my program can no longer connect to the database. We're getting TimeOut expired errors (not login timeout expired) within 15 - 20 seconds after attempting to open the connection. I have confirmed with this other system that my id does not show up in any logs on their end.
Here is some background:
Nothing has changed on my end. We have another system that my team supports that is able to connect, and they have changed nothing. They're using a different connection method. We're using oledb and they use odbc and a different provider. I confirmed with the SQL Server team that this id made a connection.

Connect String:

Provider=SQLOLEDB.1;;User ID=XXX;Password=xxxx;Data Source=serverdb instance;Initial Catalog=xxxx;
From what i've read, etc this connect string should work still

Here is an example of the code and context of this connect string

'Set connection object
pTEST_HR(pConnect.CreateInstance(__uuidof(Connection)));
pConnect->ConnectionString = OurConnectString;
pConnect->Open("","","",adConnectUnspecified);
'Create and open recordset
TESTHR(pRstEmployee.CreateInstance(__uuidof(Recordset)));
pRstEmployee->Open("Employee", This is the point at which we get a timeout.
_variant_t((IDispatch *)pConnection,true), adOpenKeyset,
adLockOptimistic, adCmdTable);

pCmd->CommandText = SomeString;

pRstEmployee = pCmd->Execute(NULL,NULL,adCmdText);

Server Info:
I have succesfully pinged the server
The client is not in the same domain as the db server

Error:
Appl: A database error has occured ->
Error
Code = 80040e31
Code meaning = IDispatch error #3121
Source = Microsoft OLE DB Provider for SQL Server
Description = Timeout expired

Other info:
Not sure about my client database provider.
This is coded in Visual C++ 6.

I'm not knowledgeable on SQL Server configuration, etc.

Things i've tried so far
Change provider from SQLOLEDB.1 to SQLOLEDB
Change provider to SQLNCLI
Had SQL server query time out set to never time out. The remote login timeout changed to 600 seconds from 30 seconds. However we are getting a timeout in only a few seconds, so i find that interesting.

View 9 Replies View Related

Time Out Expired

Jun 18, 2008

Can anyone see a reason that the application keeps timing out, it was work fine a couple of days ago.
private DataTable Search6HostPlaces(string host)    {        DataTable dt;        host = lblHostname.Text;
        SqlConnection cn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);         SqlCommand cmd = new SqlCommand("matchHost", cn);        cmd.CommandType = CommandType.StoredProcedure;        cmd.Parameters.AddWithValue("@pHost", host);
        SqlDataAdapter sda = new SqlDataAdapter();        sda.SelectCommand = cmd;
        DataSet ds = new DataSet();        cn.Open(); <--------------------------------------------------------Timeout when is gets here
        sda.Fill(ds, "HostName");        dt = ds.Tables["HostName"];
        cn.Close();
        //dt.Rows.Count.ToString();
        return dt;    }
    public void CountRecords()    {
        DataTable dt = Search6HostPlaces("host");
        lblTest.Text = dt.Rows.Count.ToString();    }

View 1 Replies View Related

Time Out Expired.

Jan 23, 2008



hi all,


when developer to retreive the data through ssms it displays like this


Error source:- .Net Sql Client Data Provider
Error message :- Time out expired. The time out period elapsed prior to completion of theoperation or the server not responding.

i checked in ssms tools -->options-->query execution is 0.
Last week for all users it display the same above .wht may be the problem.
why it happens?


pls do the needfull..
thanks in advance
regards
manoj

View 1 Replies View Related

Time Out Expired

Apr 5, 2007

When I try to add an item in App_Data ,in ASP .NET it says "Time out expired.Timeout period elapsed prior to completion of the operator or the server is not responding."

View 1 Replies View Related

Got Time Out Expired Error After Pooling

Mar 4, 2008

The database connection was ok without specify any pooling parameter, however, after I decide to put pooling parameter to the connection string. I frequently expierence "Time out expired" exception.Here is the connection string: "Pooling = True; Min Pool Size = 5; Max Pool Size = 100;Server = servername; AttachDbFilename = database_file; Integrated Security = True;"As you see, it is not much different from default value. I was thinking may be I should give a "Time out" value to the connection, will this help? 

View 1 Replies View Related

Time Out Expired Error In .net Application

Apr 5, 2004

Hi,
I have a problem in my .net application.
I am executing a stored procedure from my .net application.
The scope of this stored procedure is,
1.It should filter the records using several conditions(say it is Customer)
2.Using the filtered records, again some details are fetched(say it is transaction details)
3.For each and every transaction , Some of the details has to be updated in more than three tables, meanwhile the data to be updated is to be calculated (like tax amount, commision amount)which in turn calls two more stored procedures.

my problem is ..
if there are few records like 1000 or 2000, it is working fine...
but if it exceeds like say 6000 records, i am getting Time out expired error in my application .
If i catch the stored procedure exectution statement in sql profiler and execute it in Sql Query analizer , the stored procedure is executing properly but it takes nearly 6 minutes.
How can i solve this problem.
Please suggest me if i can work with any of the following options.
1)go for web services
2)go for windows services
3)optimize the stored procedure

If any one know some better answer to solve my problem..please post it.

Advance thanks
bye
by
Durga

View 3 Replies View Related

SQL Server - Timeout Expired

Dec 19, 2004

While registering a SQL Server from the client software through Enterprise Manager (or) Query Analyzer, the following error occurs.

Unable to connect to server
[Microsoft][ODBC SQL Server Driver]Timeout expired.

Advice me to solve this issue.

The SQL Server is installed in Windows Server 2003 and the client is installed in Windows XP.

View 1 Replies View Related

MSSQL Database Server Expired !

Jul 19, 2006

Several months ago I installed what I thought was an unlimited license of MSSQL Database Server 2000. This weekend the database expired. What can I do? I don't want to lose the data. If I attempt to reinstall the software, will that work? We are in the process in purchasing the software but not for a few months. The database is used to store and retrieve data in our OutStart server. Any idea is helpful.

View 5 Replies View Related

SQL Server Evaluation Period Has Expired??!

Aug 15, 2006

Hi,

Today my SQL Server Express suddenly stopped working. After a few hours troubleshooting I finaly found something in the Event Viewer/Application Errors: SQL Server evaluation period has expired...Isnīt the express edition supposed to be free?.

By the way: Windows did 27 automatic updates just before this happened. Might have something to do with it.

Is there a easy way to deal with this or do I have to reinstall and just hoping that I can restore my database?

Most greateful for any answers!

Johan

View 8 Replies View Related

Timeout Expired SQL Server Express Edition

Feb 26, 2007

Hi
I am using .net 2005 and SQL server express edition. When I am running the application for the 1st time it gives
Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
I am using anonymous user for personalization of web part. And my web.config looks like
<webParts>
      <personalization defaultProvider="AnonProvider">
        <providers>
          <add name="AnonProvider" type="myControls.AnonSqlPersonalizationProvider" connectionStringName="localSQLServer" />
 
        </providers>
        <authorization>
 
          <allow users="Administrators" verbs="enterSharedScope"/>
        </authorization>
      </personalization>
    </webParts>
    <anonymousIdentification enabled="true" />
Please suggest what to do?
Regards
Smruti  

View 2 Replies View Related

SQL Server Express Problem - Timeout Expired

Jun 2, 2007

When I call for the first time ASP.NET got this exception:
 System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
[SqlException (0x80131904): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734947   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188   System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) +556   System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) +164   System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) +34   System.Data.SqlClient.TdsParser.ConsumePreLoginHandshake(Boolean encrypt, Boolean trustServerCert, Boolean& marsCapable) +73   System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +911   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105   System.Data.SqlClient.SqlConnection.Open() +111   _Default.Page_Load(Object sender, EventArgs e) in c:Inetpubwwwroot estdirPerfTestNonAsyncWebSiteDefault.aspx.cs:21   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34   System.Web.UI.Control.OnLoad(EventArgs e) +99   System.Web.UI.Control.LoadRecursive() +47   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
The strange fact is, that this I got everytime I manually restart aspnet_wp.exe. After I wait some time and all works fine, and I got no exception.
 

View 4 Replies View Related

SQL Server Does Not Exist Or Access Denied. Expired?

Mar 26, 2004

SQL Server does not exist or access denied.
I dread this error because I usually don't understand what it means.
I am using the Evaluation Version and I think it may have expired. Is this the error I would get? Also, If I buy it, will I be able to get my work back, because I cant even access it from Enterprise Manager.
Thanks!!

View 1 Replies View Related

ODBC SQL Server Driver : Timeout Expired

May 17, 2001

Hi,

I am using SQL Server 7.0 Desktop Edition on Windows NT 4.0 workstation with service pack 6. I'm connecting to my production servers using the Enterprise Manager.A couple of months back, I have installed SQL Server 2000 Evaluation Edition on my desktop and using it to access the production servers.A couple of days back, I was not able to connect to the Query Analyzer either through Enterprise Manager or directly. I am getting the following error:

ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired.
All our production servers are in a data center. I'm able to connect to the production servers in one particular cage but it is giving the above error if I try to connect to other servers which are in different cages. My colleague is able to connect to all the servers through Query Analyzer from his machine which has only SQL Server 7.0.I uninstalled SQL Server 2000 on his suggestion but it is giving the same error. I uninstalled and installed SQL Server 7.0 but I'm still getting the same problem.
Could you please throw some light on why this is happening ?

Thanks in advance,
MN Rao

View 1 Replies View Related

ODBC SQL Server Driver Timeout Expired

May 23, 2002

I am trying to populate a View. I can run the sql code successfully by using SQL Query Analyzer. However, When I try to open the View in SQL Enterprise Manager and request that all rows be returned, I receive the following error:

ODBC SQL Server Driver Timeout Expired

I cannot determine the cause, Can anyone help me determine why the message is occurring? Thank you.

View 2 Replies View Related

MSSQL Server 2000 Eval. Expired!

Jan 17, 2007

I was expecting a warning but I turned on my computer and discovered that MSSQL Server 2000 eval. has expired. At this time, and in the foreseeable future, I cannot afford a retail version. But I would like to upgrade to MSSQL Server 2005 Express.

Have I lost all my data? What can I do?

View 5 Replies View Related

Odbc Sql Server Driver Timeout Expired

Jul 20, 2005

Hi,Has anyone ever had trouble using the query analyzer tool through a vpnclient? I'm able to connect outside of work to a sqlserver db on mycompany lan with enterprise mgr, but the query analyzer times out everytime I try to connect from outside of work. Both utilities work fine atwork (no vpn tunnel).The exact error is:Unable to connect to server blahblahblah:ODBC: Msg 0, Level 16, State 1[Microsoft][ODBC SQL Server Driver] Timeout expiredI've tried increasing the sqlserver odbc driver's CPTimeout without success.Appreciate any advice.Eric

View 2 Replies View Related

SQL Server 2005 Timeout Expired Exception

Feb 13, 2006

Hi,

I have a program in C# that I used to run on Visual Studio 2000 and SQL Server 2000 without any problem.

Now I upgrade to VS2005 and SQL Server 2005 and get and exception while

insert via SqlCommand.ExecuteNonQuery(). the insert is after many inserts to the same table by that program. the CommandTimeout is set to 600 (in the 2000 version I never had to change the default value of 30 seconds).

the insert is through a connection that is kept open throughout the program for more than 30 minutes

the exception message is:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

the trace is:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()


Thanks for your help !

View 11 Replies View Related

[Microsoft][ODBC SQL Server Driver] Timeout Expired.

Jun 29, 2002

Hello,
When I connecting thru T-SQL, the following error was thrown.

Unable to connect to server 'SERVERNAME'

ODBC: Msg 0,Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired.

How to fix this?

regrads,
vnk.

View 2 Replies View Related

[Microsoft][ODBC SQL Server Driver]Timeout Expired

Aug 19, 1999

I am running a query which pulls back about 200,000 records.

When I run this in ISQL (SQL Server 6.5), it runs in almost 2 minutes.
When I put it in a store procedure and run it off my ASP application, I
get this error

[Microsoft][ODBC SQL Server Driver]Timeout Expired

We've tried many things including:
1) Increased connection and command time outs in Global ASA
2) Have the ODBC driver log long Quires to a file
3) Changed Query Time out in Enterprise Manager(360 seconds) Go to
tools --> Preferences/configure -->Connection Tab
4) Changed Maximum allowed open database from 20 to 200
5) Changed resource timeout to 360 seconds from 5 seconds
6) Changed remote query timeout to 0, allowing infinite wait.

What else can we try???

Thanks for taking the time to read this
Joyce

View 2 Replies View Related

Microsoft][ODBC SQL Server Driver]Timeout Expired

Feb 1, 1999

Hi all,

I inherited some really twisted asp pages from another developer that crank for a long time. They used to work, albeit slowly. Now when I try to run one I get the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Microsoft][ODBC SQL Server Driver]Timeout expired

Short queries run fine.

IIS4 & SQL Server are on the same box. I didn't the ASP pages or the IIS or SQL server config. I did install VStudio 6.0 a while back.

Anybody got any clues?

View 1 Replies View Related

[Microsoft][ODBC SQL Server Driver]Timeout Expired

May 29, 2002

Thank you to all who reply to this perplexing question.
Mike

Database VMFGSRVRVMFG is SQL 2000 Std.
Database NT002P_GL is SQL 7.0.
All SQL versions are at the current SP levels.

I receive the timeout message when I am in EM,
database,VMFG(database), Views, Open View, Return All
Rows. I can successfully run the code in QA. I believe I
am running up against a time parameter in SQL Server. I
have reviewed all time parameters that I can find.
However, I still receive the error. What parameters should
I be looking at? I am attempting to create a view with the
following code:
--------------
CREATE view uv_olap_adj_co_profit as
select customer.id as customer_number,
customer.name as customer_name,
customer_order.salesrep_id as salesperson,
isnull(customer.country, 'USA') as country,
'7' as business_unit,
customer_order.order_type as order_type,
uv_olap_co_profit.customer_order,
uv_olap_co_profit.work_order,
uv_olap_co_profit.close_date,
uv_olap_co_profit.period_year,
uv_olap_co_profit.gl_period,
isnull((uv_olap_co_profit.billing + ut_man_adj.billing)
*ut_fin_adj.billing,
uv_olap_co_profit.billing*ut_fin_adj.billing) as billing,
isnull((uv_olap_co_profit.material_cost +
ut_man_adj.material)*ut_fin_adj.material,
uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as
material,
isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor)
*ut_fin_adj.labor,
uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor,
isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden)
*ut_fin_adj.burden,
uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as
burden,
uv_olap_co_profit.service_cost as service
from uv_olap_co_profit,
ut_man_adj,
ut_fin_adj,
customer_order,
customer
where uv_olap_co_profit.customer_order *=
ut_man_adj.cust_order_id and
uv_olap_co_profit.work_order *= ut_man_adj.work_order and
uv_olap_co_profit.period_year = ut_fin_adj.year and
uv_olap_co_profit.customer_order = customer_order.id and
customer_order.customer_id = customer.id and
(customer_order.salesrep_id = 'LABELAIREP' or
customer_order.salesrep_id = 'OMOHUNDR' or
customer_order.salesrep_id = 'EGGERSR')
union all
select customer.id as customer_number,
customer.name as customer_name,
customer_order.salesrep_id as salesperson,
isnull(customer.country, 'USA') as country,
customer.user_2 as business_unit,
customer_order.order_type as order_type,
uv_olap_co_profit.customer_order,
uv_olap_co_profit.work_order,
uv_olap_co_profit.close_date,
uv_olap_co_profit.period_year,
uv_olap_co_profit.gl_period,
isnull((uv_olap_co_profit.billing + ut_man_adj.billing)
*ut_fin_adj.billing,
uv_olap_co_profit.billing*ut_fin_adj.billing) as billing,
isnull((uv_olap_co_profit.material_cost +
ut_man_adj.material)*ut_fin_adj.material,
uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as
material,
isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor)
*ut_fin_adj.labor,
uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor,
isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden)
*ut_fin_adj.burden,
uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as
burden,
uv_olap_co_profit.service_cost as service
from uv_olap_co_profit,
ut_man_adj,
ut_fin_adj,
customer_order,
where uv_olap_co_profit.customer_order *=
ut_man_adj.cust_order_id and
uv_olap_co_profit.work_order *= ut_man_adj.work_order and
uv_olap_co_profit.period_year = ut_fin_adj.year and
uv_olap_co_profit.customer_order = customer_order.id and
customer_order.customer_id

View 1 Replies View Related

Timeout Expired - Record A New Server In Enterprise Manager

Mar 21, 2001

Hi,
I have two windows 2000 server with sql server 2000 installed. I want to record one server in the enterprise manager of the other server.
But, I receive an error as "Timout expired". So the record could not success !

Please help me

Michel

View 1 Replies View Related

[microsoft][odbc Sql Server Driver] Timeout Expired

Apr 9, 2001

Hi!,

I am running sqlserver 2000 enterprise edition on windows 2000.
When I try to run a select statement. I am encountering

[microsoft][odbc sql server driver] timeout expired

How do fix this problem?

Thanks,
Ranjan

View 1 Replies View Related

Error - ODBC Sql Server Driver Timeout Expired

Sep 28, 2005

Hi everyone

I have installed SQL server on my server machine. using localsystem and mixmode option.
It is working fine.

I installed sql server with connectivity tools only option on my client computer.

now, When i try to connect to server using data source from control panel --> Administrative tools --> Data source(ODBC).

but I cant connect.It gives me error as below.

Connection Failed:
SQLState:'HYT00'
Sql Server Error:0
[Microsoft][ODBC SQL Server Driver] Timeout Expired.

I uninstalled sql server from my client and server computer. and installed again.

I tried to ping from client computer to server computer it is working.

even i tried telnet sqlservername 1433

this one is also ok.


But same error facing

Please help me out.

Regards,
ASIF

View 1 Replies View Related

[Microsoft] [ODBC SQL Server Driver] Timeout Expired

Oct 30, 2007

I've tried every websearch possible to try and get a solution for this problem but can't.

Development Software:
SQL Server 2000
Enterprise Manager 8.0
Query Analyzer 8.00.194

Error:
When I run a mildly complex view in Enterprise Manager I get the error:[Microsoft][ODBC SQL Server Driver]Timeout Expired
after about 30 seconds.

When I copy and paste and run the exact same code in Query Analyzer the Query runs for longer than 30 seconds and runs until completion. Now my question is since this apparently seems to be an Enterpise Manager problem and not on the server end, where do I go in Enterprise Manager to change that setting? I've looked everywhere in Enterpise manager and can't find a "command timeout" setting.

Thanks!

View 4 Replies View Related

[Microsoft][ODBC SQL Server Driver] Timeout Expired

May 18, 2004

Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.

:confused:


Could you please help me with that?
Thanks
DJ

View 3 Replies View Related

[Microsoft][ODBC SQL Server Driver]Timeout Expired

Mar 6, 2008

Hi,

I have tried updating the DSN configure option i.e. 30000 milliseconds.

But I am still facing the problem of Timeout Expired.

I am using sql server 2005 for daily importing data from Excel Dump Files into sql server table.
Everyday the database gets updated.
The Error mentioned in Subject normally gets once a month, due to daily updation of database whether each table structure gets changed like index, trigger, etc.

Kindly let me know how to resolve this error.

Regards,

Srinivas Alwala

View 1 Replies View Related

Problems Changing An Expired Password In SQL Server 2005

Oct 10, 2007

Hi All,

My application supports both SQL Server 2005 and Oracle. Now, while chaging the password for the user WHOSE PASSWORD IS ALREADY EXPIRED .... the following code works fine for Oracle , but I dont know how to handle the same thing in SQL Server 2005.Please reply at your earliest.I am posting the code below which is creating the problem.


public static boolean changeExpiredPassword(User user, User newUser) throws SQLException, Exception
{
if (_logger.isDebugEnabled())
{
_logger.debug("changeExpiredPassword(User user=" + user + ", User newUser=" + newUser + ") - start");
}

boolean passwordChanged = false;
String url = null;
Properties dalProps = null;
Connection conn = null;
String sysIdentifier = null;

try
{
dalProps = DALManager.getInstance().getProperties();
url = dalProps.getProperty(DALConfigurator.URL);
if (url != null && url.indexOf("thin") > -1 && url.lastIndexOf(":") > -1)
{
int index = url.lastIndexOf(":");
sysIdentifier = url.substring(index+1, url.length());
url = "jdbcracleci" + sysIdentifier;
}

Properties props = new Properties();
props.put("user", user.getUsername());
props.put("password", user.getDecryptedPassword());
props.put("OCINewPassword", newUser.getDecryptedPassword());

if (DALManager.getInstance().isOracle() &&
url != null)
{
conn = DriverManager.getConnection(url, props);

if(conn != null && !conn.isClosed())
{
passwordChanged = true;
conn.close();
}
}
if (DALManager.getInstance().isSqlServer() &&
url != null) // This condition becomes true if we are connected to SQL Server 2005
{
/// Over here , the connection object is Returning the NULL value since the I have loaded the Properties ( props.put ) with Oracle specifice syntax it ( i.e. OCINewPassword ) . I dont know what to code if its connected to the SQL Server 2005 itstead of Oracle.
conn = DriverManager.getConnection(url,props); // This part fails

if(conn != null && !conn.isClosed())
{
UsersQueryModule.changePassword(user.getUsername(), user.getDecryptedPassword(), newUser.getDecryptedPassword(), false);
passwordChanged = true;
conn.close();
}
}
}
catch (SQLException e)
{
_logger.error("changeExpiredPassword(user=" + user + ", newUser=" + newUser + ")", e);
throw new AxisFault("Expired password cannot be changed. Possible cause may be TNS Name does not match with Oracle SID. Please consult the System Administrator.");
}
catch (Exception e)
{
_logger.error("changeExpiredPassword(user=" + user + ", newUser=" + newUser + ")", e);
throw e;
}
finally
{
if (conn != null && !conn.isClosed())
conn.close();
}

if (_logger.isDebugEnabled())
{
_logger.debug("changeExpiredPassword(User, User) - end - return value=" + passwordChanged);
}
return passwordChanged;
}

View 3 Replies View Related

Linked Server Problem Login Timeout Expired

Aug 3, 2007



Hello All,

My application is dependent on two databases one is on sql 2005 machine and other is on sql 2000 machine. A linked server is establish between these two using sql account which has appropriate rights on both server's databases.

application works fine but after some time it crashes and if i see error from sql profiler i get the error

OLE DB provider "SQLNCLI" for linked server "sql2000machine" returned message "Login timeout expired".

Few days back applciation was working absolutly fine, but i was trying to make linked sever through windows account, i dnt know wat has i changed during achiveing that setup that now application (linked server) is not working even with sql account.

please help its urgent.

View 2 Replies View Related

SQL Server Error '80040e31' Timeout Expired Strange.

Oct 30, 2007



Hi All,

we are working on a web application created in ASP & SQL 2000 environment.
In the code , we have a single connectionstring to connect database.
The application was running fine for the past 3 years, but all of a sudden we are getting "timeout expired" error only in someparts of the application but not on all database access.
The code which raises this error is a bit large which need to look into table of 8k recs with more conditions.
The same sql query took 1:01 minutes to execute in query qnqlyser.
I changes the script timeout to 900secs,
I herd we need to upgrade MDAC or we need to change connection timeout or we need to cahnge the code.

we cannot change the query, it is the most possible way we could get that.

Can somebody help me with the possible solution.


Thanks & Regards,
Sai. K.K

View 5 Replies View Related

Linked Server Login Timeout Expired Error

Aug 3, 2007

Hello All,

My application is dependent on two databases one is on sql 2005 machine and other is on sql 2000 machine. A linked server is establish between these two using sql account which has appropriate rights on both server's databases.

application works fine but after some time it crashes and if i see error from sql profiler i get the error

OLE DB provider "SQLNCLI" for linked server "sql2000machine" returned message "Login timeout expired".

Few days back applciation was working absolutly fine, but i was trying to make linked sever through windows account, i dnt know wat has i changed during achiveing that setup that now application (linked server) is not working even with sql account.

please help its urgent.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved