dreamweaver has gone crazy on me!

i setup a dsn connection - test it - testing says "connection created successfully" - i've done this many many times with no issue.

now, for some reason, any of the sites i'm working on through dreamweaver the db connection will test fine - but when i go to do a recordset etc is gives this error

"unable to retreive tables from this connection, click on the 'define..." button to test this connection"

any clue what could be causing this???

thanks for the help!

r u using xp sp2 by any chance.
if so, you need to goto www.macromedia.com
and download the sp2 fix extension.
what version of dreamweaver you using?

that worked!

thanks so much for the help! i was about to pull my hair out with this!

thanks again!
Seth


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
r u using xp sp2 by any chance.
if so, you need to goto www.macromedia.com
and download the sp2 fix extension.
what version of dreamweaver you using?

<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>