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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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