Need help w/ error mssg

[Matt Stanley]

I'm getting the following error message:

Microsoft OLE DB provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite(send()).

/library/includes/callouts.asp, line 17

The same error has been repeated in reference to line 25. Here's the code on
line 17:

<td width="16" background="/images/main/pg_callout_bg_left.gif"
align="center"><img src="/images/main/pg_callout_bg_left.gif" width="16"
height="1" alt="" border="0"></td>-->

The same error has been repeated in reference to line 25. Here's the code on
line 25:

Set NewsRs = Conn.Execute(SQL)


Is this a problem the site code is having connecting to the database or
what? When you click refresh in the browser the page loads just fine. It's a
mystery to me, and I could really use some help. Thanks in advance.

Matt
[email]mstanley@hwcs.com[/email]

[Ray at]

"Matt Stanley" <mstanley@hwcs.com> wrote in message
news:%23GULyI0kDHA.2244@TK2MSFTNGP12.phx.gbl...

> I'm getting the following error message:
>
> Microsoft OLE DB provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite(send()).

Use OLEDB. [url]www.connectionstrings.com[/url]

>
> /library/includes/callouts.asp, line 17
>
> The same error has been repeated in reference to line 25. Here's the code

on

> line 17:
>
> <td width="16" background="/images/main/pg_callout_bg_left.gif"
> align="center"><img src="/images/main/pg_callout_bg_left.gif" width="16"
> height="1" alt="" border="0"></td>-->

That is not line 17. Are you looking in the include file that is referenced
in the error? You have to look at line 17 in ~that~ file.

>
> The same error has been repeated in reference to line 25. Here's the code

on

> line 25:
>
> Set NewsRs = Conn.Execute(SQL)

What's the value of "SQL?"
response.write SQL
response.end

Ray at work

[Tom B]

I think
a) you are using the wrong type of connection string. Use the OLEDB for SQL
(see [url]www.connectionstrings.com[/url])
b) there's a problem with your sql statement try
Response.write SQL
Response.Flush
'BEFORE your Execute


"Matt Stanley" <mstanley@hwcs.com> wrote in message
news:%23GULyI0kDHA.2244@TK2MSFTNGP12.phx.gbl...

> I'm getting the following error message:
>
> Microsoft OLE DB provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite(send()).
>
> /library/includes/callouts.asp, line 17
>
> The same error has been repeated in reference to line 25. Here's the code

on

> line 17:
>
> <td width="16" background="/images/main/pg_callout_bg_left.gif"
> align="center"><img src="/images/main/pg_callout_bg_left.gif" width="16"
> height="1" alt="" border="0"></td>-->
>
> The same error has been repeated in reference to line 25. Here's the code

on

> line 25:
>
> Set NewsRs = Conn.Execute(SQL)
>
>
> Is this a problem the site code is having connecting to the database or
> what? When you click refresh in the browser the page loads just fine. It's

a

> mystery to me, and I could really use some help. Thanks in advance.
>
> Matt
> [email]mstanley@hwcs.com[/email]
>
>