473,324 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Timeout in connection string

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
Jul 22 '05 #1
3 55622
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.
Jul 22 '05 #2
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.

Jul 22 '05 #3
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.

Jul 22 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Paul Robinson | last post by:
I am developing a website in ASP that connects to a Sybase database. However, when I try to open a connection to the database the page will not load. The script does not timeout, nor the...
1
by: Jennifer | last post by:
I've inherited a C# program that inserts some records from a text file into a table. Everything worked fine until I was asked to change the server and database that the tables are on. Now I am...
4
by: Mark | last post by:
OK. Here we go. I have an ASP.NET application that does many hits to a SQL Server DB on a separate server. When I first created this application (2 years ago) and was very new to ASP/ASP.NET, to...
6
by: Mike Moore | last post by:
I'm not very familiar with the web config file. I would like to use the timeout item in the session state for our connection string, but not use the stateconnection string and sqlconnectionstring...
2
by: Jake | last post by:
Hello, We are in the process of setting up ssl on our sql box. What do we need to do to modify our connection string to send/receive info from the app to sql? Thanks in advance. strConnect =...
3
by: rhepsi | last post by:
HII all, im doin a vb project (vs.net 2003) im trying to uload the data from mysql (tbl_students) to postgresql (tbl_students_new) ... in the upload button_click: connection string is as...
2
by: mfuribondo | last post by:
I have a solution with three projects in it. Two are windows forms applications and the third is a class library. I am trying to deploy the projects which use a single database located in one of...
4
by: jmohan | last post by:
Hi everybody, How to write the connection string and sql queries in the XML. I use the mysql database. I use the following connection string and query using asp.net with C#. Connection...
6
by: little83 | last post by:
Dear all i wrote one class to deal with sql database to insert and read data from that class only...and based on that one of the parmeters or the class is the sqlconnection SqlConnection...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.