Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > Timeout in connection string

Reply
Thread Tools

Timeout in connection string

 
 
kant
Guest
Posts: n/a
 
      06-16-2005
stringA= "Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=sa;PWD=password;Initial Catalog=DB;Data Source=127.0.0.1;Connect
Timeout=30"

stringB = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("DB.MDB") & ";Connect Timeout=30"


Hi All,

I have use the above connection string in an ASP application, stringA with
SQL Server, it works!
stringB with MS ACCESS, it doesnt works if I add the "connect timeout"
parameter!!
How can I solve it!? so that I can set the connection timeout when I using
MSACCESS as Database
(I dont want to use ODBC connection).

Thx alot


 
Reply With Quote
 
 
 
 
Bob Barrows [MVP]
Guest
Posts: n/a
 
      06-16-2005
kant wrote:
> stringA= "Provider=SQLOLEDB.1;Persist Security Info=False;User
> ID=sa;PWD=password;Initial Catalog=DB;Data Source=127.0.0.1;Connect
> Timeout=30"
>
> stringB = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> Server.MapPath("DB.MDB") & ";Connect Timeout=30"
>
>
> Hi All,
>
> I have use the above connection string in an ASP application, stringA
> with SQL Server, it works!
> stringB with MS ACCESS, it doesnt works if I add the "connect timeout"
> parameter!!
> How can I solve it!? so that I can set the connection timeout when I
> using MSACCESS as Database
> (I dont want to use ODBC connection).
>

What do you intend to gain by using that parameter. I'm not sure that
parameter is supported by the Jet provider. You can set the property
directly on the Connection object if you must have it:
set cn=createobject("adodb.connection")
cn.CommandTimeout=30

With an Access database, I really don't see what is being gained by the use
of this property.
Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


 
Reply With Quote
 
 
 
 
Kant
Guest
Posts: n/a
 
      06-17-2005
Hi Bob,

I found the error happened in IIS setting but not DB connection timeout,
here is the error message, what should I modify the Server.scripttimeout !?
Thx


Error Type:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. You can
change this limit by

specifying a new value for the property Server.ScriptTimeout or by changing
the value in the IIS administration tools.


"Bob Barrows [MVP]" wrote:

> kant wrote:
> > stringA= "Provider=SQLOLEDB.1;Persist Security Info=False;User
> > ID=sa;PWD=password;Initial Catalog=DB;Data Source=127.0.0.1;Connect
> > Timeout=30"
> >
> > stringB = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> > Server.MapPath("DB.MDB") & ";Connect Timeout=30"
> >
> >
> > Hi All,
> >
> > I have use the above connection string in an ASP application, stringA
> > with SQL Server, it works!
> > stringB with MS ACCESS, it doesnt works if I add the "connect timeout"
> > parameter!!
> > How can I solve it!? so that I can set the connection timeout when I
> > using MSACCESS as Database
> > (I dont want to use ODBC connection).
> >

> What do you intend to gain by using that parameter. I'm not sure that
> parameter is supported by the Jet provider. You can set the property
> directly on the Connection object if you must have it:
> set cn=createobject("adodb.connection")
> cn.CommandTimeout=30
>
> With an Access database, I really don't see what is being gained by the use
> of this property.
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
>

 
Reply With Quote
 
Kant
Guest
Posts: n/a
 
      06-17-2005
fixed...just click ths IIS setting menu, so silly....thx and pls ignore this
question.

"Kant" wrote:

> Hi Bob,
>
> I found the error happened in IIS setting but not DB connection timeout,
> here is the error message, what should I modify the Server.scripttimeout !?
> Thx
>
>
> Error Type:
> Active Server Pages, ASP 0113 (0x80004005)
> The maximum amount of time for a script to execute was exceeded. You can
> change this limit by
>
> specifying a new value for the property Server.ScriptTimeout or by changing
> the value in the IIS administration tools.
>
>
> "Bob Barrows [MVP]" wrote:
>
> > kant wrote:
> > > stringA= "Provider=SQLOLEDB.1;Persist Security Info=False;User
> > > ID=sa;PWD=password;Initial Catalog=DB;Data Source=127.0.0.1;Connect
> > > Timeout=30"
> > >
> > > stringB = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
> > > Server.MapPath("DB.MDB") & ";Connect Timeout=30"
> > >
> > >
> > > Hi All,
> > >
> > > I have use the above connection string in an ASP application, stringA
> > > with SQL Server, it works!
> > > stringB with MS ACCESS, it doesnt works if I add the "connect timeout"
> > > parameter!!
> > > How can I solve it!? so that I can set the connection timeout when I
> > > using MSACCESS as Database
> > > (I dont want to use ODBC connection).
> > >

> > What do you intend to gain by using that parameter. I'm not sure that
> > parameter is supported by the Jet provider. You can set the property
> > directly on the Connection object if you must have it:
> > set cn=createobject("adodb.connection")
> > cn.CommandTimeout=30
> >
> > With an Access database, I really don't see what is being gained by the use
> > of this property.
> > Bob Barrows
> > --
> > Microsoft MVP -- ASP/ASP.NET
> > Please reply to the newsgroup. The email account listed in my From
> > header is my spam trap, so I don't check it very often. You will get a
> > quicker response by posting to the newsgroup.
> >
> >
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection timeout (connection closing after 100 sec ) shmuel witman ASP .Net Web Services 2 12-06-2005 10:59 AM
Timeout::timeout and Socket timeout Mark Probert Ruby 1 10-06-2004 09:30 AM
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Guoqi Zheng ASP .Net 4 06-03-2004 06:39 PM
web.config session timeout and forms authentication timeout Do ASP .Net 2 11-23-2003 02:27 PM
Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Bob Johnson ASP .Net 0 08-07-2003 12:52 PM



Advertisments