Hello,

I have a question about Connection String, it keeps saying that
Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Please help.

Thanks.

/student_action.asp, line 90

Line90 is conn.open

-----connect.asp file ----
strConnect="driver={SQL Server};Server=xxx;database=xxx; UID=xxx; PWD=xxx;"

----student_action.asp file ------

<%

DIM name, strSQL, Email_address, conn

Email_Address = trim(Request.Form("EmailAddress"))
Name = Trim(Request.Form("Name"))


set conn = server.CreateObject("ADODB.Connection")

conn.ConnectionString=strConnect
conn.ConnectionTimeout=30
conn.open
strSQL = "Select * From Echoes Where Email_Address = '" & email_Address & "'"
set pRS = server.CreateObject("ADODB.Recordset")
pRS.open strSQL, conn, 3,1,1

if not(pRS.eof) then
        pRS.close
        set pRS = nothing
        conn.close
        set conn=nothing
        session("strMsg") = "Email exists. Please enter a unique email address."
        response.redirect "student.asp?Name=" & Name & " & "&EmailAddress=" & Email_Address
end if

strSQL = "Insert into Echoes (name, email_address) values ('" & name & "', '" & email_address & "')"

conn.execute strSQL
conn.close
set conn = nothing

http://www.asiafuns.com/asian_friends/

__________________
---------------------
There is NO stupid question.

Try this and see if you get this far. Are you able to connect to the SQL server through Enterprise Manager with the connection string you have in the code?

Response.Write(strConnect & "<br>")
set conn = server.CreateObject("ADODB.Connection")
conn.open strConnect
Response.Write("Good to here.")
Response.End

I think that will most certainly result in the same error. The problem I believe you are encountering is that the user you have defined in your query string does not have rights to access X database. Have you ensured that the user does, in fact, have rights to the catalog?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

Hello,
I defined the Id by ID=request( "id" ), no more syntax errors. But it shows all blank text boxes.
What did I do wrong?
thanks.

http://www.asiafuns.com/asian_friends/