Driver's SQLSetConnectAttr failed

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Re: Driver's SQLSetConnectAttr failed

    I suggest you avoid ODBC and use the native Jet OLEDB Provider. See
    [url]www.connectionstrings.com[/url] for help with creating the connection string. Or
    use a UDL file.

    For things to look into:
    [url]http://www.aspfaq.com/show.asp?id=2009[/url]

    HTH,
    Bob Barrows

    Sean wrote:
    > Building a new site with access running the dbase.
    > everything seems configured correctly, accept when
    > accessing a page that requires an ODBC connection the
    > page returns with the following message:
    >
    > Please try the following:
    >
    > Click the Refresh button, or try again later.
    >
    > Open the 192.168.2.1 home page, and then look for links
    > to the information you want.
    > HTTP 500.100 - Internal Server Error - ASP error
    > Internet Information Services
    >
    > ----------------------------------------------------------
    > ----------------------
    >
    > Technical Information (for support personnel)
    >
    > Error Type:
    > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    > [Microsoft][ODBC Driver Manager] Driver's
    > SQLSetConnectAttr failed
    > /breach/enter.asp, line 8
    >
    >
    > Browser Type:
    > Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
    > CLR 1.0.3705)
    >
    > Page:
    > GET /breach/enter.asp
    >
    > Time:
    > Saturday, 26 July 2003, 5:34:53 PM
    >
    > Please don't mind the IP its for internal use. also this
    > site sits on on ISA Server, which is configured correctly
    > as the site's splash screen is browserable (if that's
    > such a word!)
    >
    > What am i doing wrong??????
    >
    > Thanks in advance, [email]seanh@fit.net.au[/email]
    >
    > Sean


    Bob Barrows Guest

  2. Similar Questions and Discussions

    1. (0x8004E025) COM+ Activation failed because an initialization function failed. Check the event log for more information.
      Resolved this issue... Removed component from COM+ registration. Deleted DLL. Re-compiled DLL from source. Re-registered in COM+. Works fine. Mr...
    2. [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
      I have error handling in my application and I get this error message immediately after the conn.open call to an Oracle db... The only reason I...
    3. ftp to AIX failed
      I am using AIX4.3.3 ML10 and some ftp from the main frame machine may occassionally got stalled and failed. The system are very idle and the...
    4. CLI connection failed. SQL30082N Attempt to establish connection failed with security reason "24"
      Hi, have you found the failure? Because I'm now in the same situation and don't know how to go on??? :( Thanks Originally posted by Prince...
    5. OEM 901 & failed events
      -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 All my database events log in as a user who's password recently changed. I made the change in the...
  3. #2

    Default Re: Driver's SQLSetConnectAttr failed

    Bob, thanks, having a look now
    >-----Original Message-----
    >I suggest you avoid ODBC and use the native Jet OLEDB
    Provider. See
    >[url]www.connectionstrings.com[/url] for help with creating the
    connection string. Or
    >use a UDL file.
    >
    >For things to look into:
    >[url]http://www.aspfaq.com/show.asp?id=2009[/url]
    >
    >HTH,
    >Bob Barrows
    >
    >Sean wrote:
    >> Building a new site with access running the dbase.
    >> everything seems configured correctly, accept when
    >> accessing a page that requires an ODBC connection the
    >> page returns with the following message:
    >>
    >> Please try the following:
    >>
    >> Click the Refresh button, or try again later.
    >>
    >> Open the 192.168.2.1 home page, and then look for links
    >> to the information you want.
    >> HTTP 500.100 - Internal Server Error - ASP error
    >> Internet Information Services
    >>
    >> -------------------------------------------------------
    ---
    >> ----------------------
    >>
    >> Technical Information (for support personnel)
    >>
    >> Error Type:
    >> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    >> [Microsoft][ODBC Driver Manager] Driver's
    >> SQLSetConnectAttr failed
    >> /breach/enter.asp, line 8
    >>
    >>
    >> Browser Type:
    >> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET
    >> CLR 1.0.3705)
    >>
    >> Page:
    >> GET /breach/enter.asp
    >>
    >> Time:
    >> Saturday, 26 July 2003, 5:34:53 PM
    >>
    >> Please don't mind the IP its for internal use. also
    this
    >> site sits on on ISA Server, which is configured
    correctly
    >> as the site's splash screen is browserable (if that's
    >> such a word!)
    >>
    >> What am i doing wrong??????
    >>
    >> Thanks in advance, [email]seanh@fit.net.au[/email]
    >>
    >> Sean
    >
    >
    >
    >.
    >
    Sean Guest

Posting Permissions

  • You may not post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139