Noozer wrote:
> Hi!
>
> Working with an MS Access database from an ASP webpage and I'm
> getting an Exception error...
>
> Error Type:
> (0x80020009)
> Exception occurred.
> /Projects/App/Mypage.asp, line 184
>
> The SQL statement looks like so...
>
> strSQL = "SELECT Cat, MyNote FROM Notes WHERE KeyLink = " & SelKey
> rsSet.Open strSQL, adoCon
>
> Cat is a 10 character text field, MyNote is a Memo field (and I think
> the memo field is causing the issue), KeyLink is a number, as is the
> variable SelKey.
>
> I can't update or change any of the components/software on the server.
>
> Can someone explain why this is happening? I've found a few similar
> issues through Google, but nothing really helpful.

Noozer wrote:
> "Noozer" <dont.spam@me.here> wrote in message
> news:4REEc.915266$Pk3.429789@pd7tw1no...
>> Hi!
>>
>> Working with an MS Access database from an ASP webpage and I'm
>> getting an Exception error...
>>
>> Error Type:
>> (0x80020009)
>> Exception occurred.
>> /Projects/App/Mypage.asp, line 184
>
> Oops... I goofed. I actually fixed the SQL statement I posted about
> by adding an extra field, and the error I pasted was located further
> down the page...
>
> The second error is now also corrected. I was referencing a single
> field, but naming two tables.
>
> It all looks related to querying a database and having a TEXT or MEMO
> field as the first column.

Noozer wrote:
>>> Error Type:
>>> (0x80020009)
>>> Exception occurred.
>
>> Are you using ODBC for your connection? If so, switch to the native
>> OLEDB Provider for Jet (www.able-consulting.com/ado_conn.htm)
>
> Thanks... Made the change and it's working fine.
>
> Just wondering if OLEDB is the "preferred" method or just works
> better in this case.

"Noozer" <dont.spam@me.here> wrote in message
news:4REEc.915266$Pk3.429789@pd7tw1no...
> Hi!
>
> Working with an MS Access database from an ASP webpage and I'm getting an
> Exception error...
>
> Error Type:
> (0x80020009)
> Exception occurred.
> /Projects/App/Mypage.asp, line 184

> > Error Type:
> > (0x80020009)
> > Exception occurred.

> Are you using ODBC for your connection? If so, switch to the native OLEDB
> Provider for Jet (www.able-consulting.com/ado_conn.htm)

> > Just wondering if OLEDB is the "preferred" method or just works
> > better in this case.
> Yes, it's the preferred method, not ony because it works better in this
> case, but also because it works better in a lot of other circumstances.
See
> here:
>