I understand that alot of programmer prefer DSNless over DSN connection. 
Ken (Schaefer), if you are reading this post, I have a question to ask 
you, I have read your article on www.adopenstatic.com regarding prefering 
OLEDB connection over ODBC connection, but now I am having a problem with 
my recordsets. When I am defining my recordsets with the OLEDB connection, 
it gives me a blank error alert box but when I switch to the ODBC(DSN) 
connection and define that same recordset, it works... whats going on, 
please advice. I really want to use OLEDB connections since I realize the 
benefits of it, but if I can't get it to work... please advice.

Thanks in advance

Why don't you post some code?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <joyce@j...>
Subject: [access_asp] DSN vs DSNless


: I understand that alot of programmer prefer DSNless over DSN connection.
: Ken (Schaefer), if you are reading this post, I have a question to ask
: you, I have read your article on www.adopenstatic.com regarding prefering
: OLEDB connection over ODBC connection, but now I am having a problem with
: my recordsets. When I am defining my recordsets with the OLEDB connection,
: it gives me a blank error alert box but when I switch to the ODBC(DSN)
: connection and define that same recordset, it works... whats going on,
: please advice. I really want to use OLEDB connections since I realize the
: benefits of it, but if I can't get it to work... please advice.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi Ken,

Thanks for the reply! The reason why I got the error above was because I 
am using a reserve word in my recordset, now everything is working fine 
and I am still using my DSNless/OLEDB connection!

Thanks again.