Re: DSN less connection to MySQL 4.1

[Greg Covey]

Ankur,

Have you resolved this issue? Try setting your option value to:
OPTION=16387.

That has fixed many of my issues. What client are you using, BTW? If you're using ADO, this might be the trick.

Good luck,
Greg

Ankur Shah wrote:
> It generates "Catastrophic failure"
> We had just found the reason for this i.e. it
> requires any single database name according to us
> it should be better if it is not require.
>
> i.e.
> connstr="driver={MySQL 3.51 ODBC
> driver};server=localhost;uid=root;pwd=;option=1642
> 7;DATABASE=test"
>
> will work but we prefer
>
> connstr="driver={MySQL 3.51 ODBC
> driver};server=localhost;uid=root;pwd=;option=1642
> 7"
>
>
> Thanks.