New MX Install - Data Source Verifies

[schep]

I'm using the built in web server (works fine), and the Data Source verifies in
Administrator but query in application pages fails with the error message in
debug: "Error Executing Database Query."

I tried changing the account MX uses to "system account" and for some reason
JRUN command line appears and sometimes MX hangs when I try to stop it

I'm on XP Home, SQLServer2000 and had a MX6.1 installation running fine (the
MX7 install blew away the ODBC DSNs for some reason)

[hatethisnamegame]

I have had experiences where the dsn's are case sensitive. Try checking for identical case usage.

[ksmith]

Enable Robust Exception Information on the debug settings page. Include the
errors that show when you run your queries.

In terms of your odbc DSNs, did they just disappear from the cfadmin or are
they gone from windows' odbc administrator too? If they are just gone from
cfadmin, just create new DSNs of type odbc socket pointing to your windows odbc
datasources. Realize you are always better off using a JDBC connection when
possible and a true DBMS.