Datasource is requiring login/password

[Dagny]

Just did a reformat & upgrade to WinXP from w2k and only have 2 MySql
databases. Although CF Administrator validates all the databases, which have
been set up correctly in OBDC and MySQL, for some reason when I try to
preview a page, I am getting an Error Executive Database Query, "General
error: No database selected" for either of these 2 mySQL databases. They
both show up in the DW2004 Database Panel, but when you click on the
database table, you see "Loading . . . " and then a small "Datasource login"
window opens. In MySQL, my username is root and there is no password, which
is how I had it before and it worked fine. My logins for CF Administrator
don't work. I don't have passwords set for these databases, so why are they
asking for logins? I looked at the Sandbox stuff in the Administrator, but I
don't think that applies.

Can someone help me with this?

Thanks very much,
Dagny

[Dagny]

Thank you.

"Dagny" <Heiny@NOSPAMheinline.com> wrote in message
news:dfdbmq$3p1$1@forums.macromedia.com...

> Just did a reformat & upgrade to WinXP from w2k and only have 2 MySql
> databases. Although CF Administrator validates all the databases, which
> have been set up correctly in OBDC and MySQL, for some reason when I try
> to preview a page, I am getting an Error Executive Database Query,
> "General error: No database selected" for either of these 2 mySQL
> databases. They both show up in the DW2004 Database Panel, but when you
> click on the database table, you see "Loading . . . " and then a small
> "Datasource login" window opens. In MySQL, my username is root and there
> is no password, which is how I had it before and it worked fine. My logins
> for CF Administrator don't work. I don't have passwords set for these
> databases, so why are they asking for logins? I looked at the Sandbox
> stuff in the Administrator, but I don't think that applies.
>
> Can someone help me with this?
>
> Thanks very much,
> Dagny
>
>

[Neculai Macarie]

> Just did a reformat & upgrade to WinXP from w2k and only have 2 MySql

> databases. Although CF Administrator validates all the databases, which

have

> been set up correctly in OBDC and MySQL, for some reason when I try to
> preview a page, I am getting an Error Executive Database Query, "General
> error: No database selected" for either of these 2 mySQL databases. They
> both show up in the DW2004 Database Panel, but when you click on the
> database table, you see "Loading . . . " and then a small "Datasource

login"

> window opens. In MySQL, my username is root and there is no password,

which

> is how I had it before and it worked fine. My logins for CF Administrator
> don't work. I don't have passwords set for these databases, so why are

they

> asking for logins? I looked at the Sandbox stuff in the Administrator, but

I

> don't think that applies.

Did you specify a default database in the ODBC Admin ?

--
<mack />