I have all that. I have this database connection working on Insert and Results pages. As I said, I couldn't set it up in DW because of that error that means nothing so I had to copy from another site.
I just figured it out! Because I had to copy the login page, etc from another site (because DW was being stupid), I neglected to change 2 places where the code was looking for the old connection. Ah ha! That's why it didn't get what I was looking for.
These are very awesome programs! A bit frustrating but then I've never not become frustrated when trying to connect a web page to a database. But I surely do appreciate WA doing all the 'real thinking' for me.