SQL Server 2000 ODBC Error '80004005'

[SQLBI]

Hi,

We're trying to implement a SQL Server 2000 back end website and are receiving the following error message during testing

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.

/inc_home_ticker.asp, line 10

To our knowledge, the ODBC connection is configured correctly with the correct SQL Server login info but still no connection is possible.

The code for the .asp page is as follows:

<%
Dim rsTicker, DD, MM, YY, today
DD = Left(Now,2)
MM = Mid(Now,4 ,2)
YY = Mid(Now,7, 4)
strToday = (MM & "/" & DD & "/" & YY)
'Response.Write(strToday)

Set rsTicker = Server.CreateObject("ADODB.Recordset")
[b]rsTicker.ActiveConnection = vets4petsdb1_conn[/b]
rsTicker.Source = "SELECT * FROM ticker WHERE (expiry_dat >= '" & strToday & "') AND (active_int <> 0)"
rsTicker.CursorType = 0
rsTicker.CursorLocation = 2
rsTicker.LockType = 1
rsTicker.Open()
%>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
  <tr>
    <td>
	<marquee behavior="scroll" direction="left" loop="-1" scrollamount="1" scrolldelay="10" truespeed height="20" class="tickertext">
&lt;&lt; 
	<%
		While Not rsTicker.EOF AND Not rsTicker.BOF
	%>
<a href="article_viewer.asp?dbid=<%=(rsTicker("dbid"))%>"><%=(rsTicker("title_vch"))%></a> &lt;&lt; 
	<% 
		rsTicker.MoveNext()
		Wend
	%>
</marquee></td>
  </tr>
  <tr>
    <td><img src="images/spacer.gif" width="760" height="1"></td>
  </tr>
</table>
<%
rsTicker.Close()
Set rsTicker = Nothing
%>

The ODBC connection is configured as follows:

DSN=vets4pets_db1_conn; uid = V4PWeb; pwd=V4PW3b;

Can anyone suggest a fix for this as i have zero SQL DB/Web knowledge.

Thanks in advance.


Leigh Moore
Business Systems Manager
Vets4Pets Veterinary Group

http://www.vets4pets.eu.com

 

[Genimuse]

When you say the ODBC connection is configured that way, do you mean that you'd set the variable vets4petsdb1_conn to that?

I'm not sure how much you know about ASP, but in this line:

rsTicker.ActiveConnection = vets4petsdb1_conn

vets4petsdb1_conn is a variable... probably undeclared. If you wanted to use that value as the ActiveConnection then you'd use;

rsTicker.ActiveConnection = "vets4petsdb1_conn"

Yet that's not a valid connection. Your connection string should look something like:

rsTicker.ActiveConnection = "DSN=vets4pets_db1_conn;Uid = V4PWeb;Pwd=V4PW3b"

 

[Genimuse]

BTW, this site is great for connection strings -- just about any kind of ADO connection string you can imagine:

http://www.able-consulting.com/ADO_Conn.htm

 

[vongrunt]

Named Pipes + ODBC DSN = . Nuff said.