Re: Driver's SQLSetConnectAttr failed

Tech-Archive recommends: Fix windows errors by optimizing your registry

sankari wrote:
here is a simple form. it works well in my system. I hosted my site.
but i get the error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

/join.asp, line 57

i've highlighted the line 57. pl. help me. without this fix, i cannot
tell anybody abt my web site.


I cannot find it. Can you please snip out everything that is not
relevant?
In the meantime, perhaps your error is covered here:
http://www.aspfaq.com/show.asp?id=2009

Seeing that you are using ODBC, I can recommend that you switch to using
the native OLE DB provider:
http://www.aspfaq.com/show.asp?id=2126

Further points to consider:
Your use of dynamic sql is leaving you vulnerable to hackers using sql
injection:
http://mvp.unixwiz.net/techtips/sql-injection.html
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=23

See here for a better, more secure way to execute your queries by using
parameter markers (tokens):
http://groups-beta.google.com/group/microsoft.public.inetserver.asp.db/msg/72e36562fee7804e

Personally, I prefer using stored procedures:
http://groups.google.com/group/microsoft.public.inetserver.asp.general/msg/5d3c9d4409dc1701?hl=en




--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: SQL INJECTION - ORACLE
    ... SQL INJECTION - ORACLE: ... > Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ...
    (Pen-Test)
  • SQL INJECTION - ORACLE
    ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... This list is provided by the SecurityFocus Security Intelligence Alert ...
    (Pen-Test)
  • Re: SQL issue
    ... Microsoft OLE DB Provider for ODBC Drivers error '80040e14' ... DB provider instead of ODBC. ... Please reply to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: PostgreSQL Query Errors?
    ... > Microsoft OLE DB Provider for ODBC Drivers error '80004005' ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Amish School Recovery Fund
    ... This is what Christianity is really about: ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (misc.rural)