[Microsoft][ODBC SQL Server Driver]Communication link failure

[mobyshaikh]

I am using ASP to connect to SQL7 and read data only and I get the following error.
Any help would be appreciated. Thanks!

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver]Communication link failure

 

[cmmrfrds]

Please show the code you are executing and your connection string.

 

[mobyshaikh]

Code Fails on connection time.

I have put this code in my Global.asa so that all pages should use the same connection string. Is this a good way??? If not what is a better way.
Application("oConnStr&quot = "DSN=TT;uid=TT;pwd=TT"
Set Application("oConn&quot = Server.CreateObject("ADODB.Connection&quot
Application("oConn&quot.Mode = 3 '3 = adModeReadWrite
Application("oConn&quot.Open Application("oConnStr&quot


Then inside asp pages i am using this:
Set rs1 = Server.CreateObject("ADODB.Recordset&quot
sql1 = "Select * From InNile_Members"
Sql1 = Sql1 & " where MemberID= '" & Request("RefferalID&quot & "'"

rs1.open sql1, Application("oConnStr&quot, AdopenStatic
'Counting the records matched
MemberCount = rs1.recordcount