connection.open issue?? - ASP / Active Server Pages

This code usually works the first time I run it, but if I hit refresh it
fails with: "Unspecified error - /cosmetic/ask_dup.asp, line 12"

which is the connection.open statement.

Makes me think it's an ODBC driver issue since I am closing the recordset
and connection objects. Are there settings I should be checking on the DSN
for my database? I've never messed with the timeouts etc.

Thanks
Rich
<% @LANGUAGE="VBSCRIPT"%>
<HTML>
<HEAD>
</HEAD>
<BODY >

<SELECT NAME="category">
<OPTION>Select a category... </OPTION>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "cosmetic"
sql = "SELECT * FROM tblCategory"
Set rs = conn.execute(sql,inNumRecs, 1)

If (rs.EOF and rs.BOF) then
Response.End
else
rs.MoveFirst
do while not rs.EOF
%>
<OPTION VALUE="<%=rs("id")%>"> <%=rs("category")%> </OPTION>
<%
rs.MoveNext
Loop
end if
rs.close
conn.close
Set RS = nothing
Set conn = nothing
%>
</SELECT>

</BODY>
</HTML>

Jul 19 '05 #1

Subscribe Reply

5608

Ray at

What kind of database? Try using a dns-less connection string.

Ray at work

"RP" <ex*******@yahoo.com> wrote in message
news:v4********************@newsread2.prod.itd.ear thlink.net...

This code usually works the first time I run it, but if I hit refresh it
fails with: "Unspecified error - /cosmetic/ask_dup.asp, line 12"

which is the connection.open statement.

Makes me think it's an ODBC driver issue since I am closing the recordset
and connection objects. Are there settings I should be checking on the DSN for my database? I've never messed with the timeouts etc.

Thanks
Rich
<% @LANGUAGE="VBSCRIPT"%>
<HTML>
<HEAD>
</HEAD>
<BODY >

<SELECT NAME="category">
<OPTION>Select a category... </OPTION>
<%
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "cosmetic"
sql = "SELECT * FROM tblCategory"
Set rs = conn.execute(sql,inNumRecs, 1)

If (rs.EOF and rs.BOF) then
Response.End
else
rs.MoveFirst
do while not rs.EOF
%>
<OPTION VALUE="<%=rs("id")%>"> <%=rs("category")%> </OPTION>
<%
rs.MoveNext
Loop
end if
rs.close
conn.close
Set RS = nothing
Set conn = nothing
%>
</SELECT>

</BODY>
</HTML>

Jul 19 '05 #2

You know I would, but I am using Dreamweaver as an IDE and the helps system
is iffy. I can't get up the help reference for the Open statement to be able
to look up the syntax for the DNS less connection. Got any MS Access
examples?

Thanks!

Rich

Jul 19 '05 #3

worked like a charm. Now I hope the client's hosting company will provide
me with the path to the database when I deploy. :)
Thanks to both of you.

Rich

Jul 19 '05 #4

Similar topics

14494

Very slow initial connection on Oracle 8i

by: Harry | last post by:

Using Oracle 8i enterprise on win 2000 (sp3) Installed the standard configuration & whenever I make a connection it takes about 10 secs. It's running on a P1900 with 1gb Ram so no reason there...

Oracle Database

7366

Timeout issue when connection to SQL Server in Wireless environment

by: David Gamble | last post by:

I am having problems with long timeouts when connecting to or executing commands in SQL Server 2000 SP3. I am writing an application that will be used on laptops within an environment that is...

Microsoft SQL Server

2045

Open DB connection several times on a page

by: DP | last post by:

I read some articles and post how to optimize te speed of asp pages regarding opening and closing DB connections but I am still not sure about this. Is it true that it doesn't matter how many...

ASP / Active Server Pages

2489

Database connection object in shared variable

by: Daniel Fernandes | last post by:

Hi there Let's say due to several reasons I have an ASP.Net application that has a database access class that stores a database connection in a shared member : public class dataaccess ...

ASP.NET

3628

Error opening connection resulting in HTTP 500 - Internal server error

by: Saverio Tedeschi | last post by:

Hi all gurus, I'm getting a strange behaviour in Web services design: when I try to open a connection, or to fill a DataSet, I get the error in subj (totally unrelated to the actual error). I've...

.NET Framework

2843

Connection pooling questions

by: crbd98 | last post by:

Hello All, Some time ago, I implemented a data access layer that included a simple connectin pool. At the time, I did it all by myself: I created N connections, each connection associated with...

C# / C Sharp

6365

OracleClient connection pooling

by: =?Utf-8?B?RFNJU3VwcG9ydA==?= | last post by:

Hi, I have this ASP.NET application developed with VS.NET 2003 VB.NET and deplyed on Windows 2K server IIS 5. This application uses the following: - Oracle 10G databse - MS Data Access Block...

ASP.NET

3243

Connection pooling question

by: fniles | last post by:

I am using VS2003 and connecting to MS Access database. When using a connection pooling (every time I open the OLEDBCONNECTION I use the exact matching connection string), 1. how can I know how...

Visual Basic .NET

4749

SQL Server connection pooling

by: fniles | last post by:

I am using VB.NET 2003 and SQL 2005. To use connection pooling and avoid the error "There is already an open DataReader associated with this Connection which must be closed first." , I understand...

Visual Basic .NET

8139

Unable to read data from the transport Connection

by: Cintury | last post by:

Hi all, I've developed a mobile application for windows mobile 5.0 that has been in use for a while (1 year and a couple of months). It was developed in visual studios 2005 with a back-end sql...

Mobile Development

7331

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7054

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7501

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5633

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

5056

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4713

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3188

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1564

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

424

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General