Remote connection to MySQL database

-------------------------------1142871603
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hi,

I am trying to establish a remote connection to an MySQL database (version
4.0.26). I am on Windows XP using OpenOffice version 2.0 (BASE) trying to
connect to my database at my website _www.dianalundwriter.com_
(http://www.dianalundwriter.com) .

First I successfully configured a MyODBC DSN on Windows using the ODBC Data
Source Administrator, using the MySQL ODBC 3.51 driver. (I tried the test and
it came back successful).

But then when I open up OpenOffice Base and select the link to this database
and then
try to access the tables, I get:

[MySQL][ODBC 3.51 Driver] Access Denied for '_dianalund@%'_
(mailto:'dianalund@) to database Customer.

I ran a trace and have included it below. Like others before me, I could not
find the myodbc3d.dll driver (as indicated in the manual) and instead used
odbctrace.dll.

Any help here would be very appreciated. BTW, I am able to establish a
remote connection
in some perl script I wrote. So I think this problem is particular to the
interface with OpenOffice.

Thank you,
Diana Lund

soffice b04-b08 ENTER SQLDriverConnectW
HDBC 04B815E8
HWND 00000000
WCHAR * 0x74329A38 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x74329A38
SWORD 2
SWORD * 0x00000000
UWORD 0

soffice b04-b08 EXIT SQLDriverConnectW with return code -1
(SQL_ERROR)
HDBC 04B815E8
HWND 00000000
WCHAR * 0x74329A38 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x74329A38
SWORD 2
SWORD * 0x00000000
UWORD 0

DIAG [HYT00] [MySQL][ODBC 3.51 Driver]Access denied for user:
_'dianalund@%'_ (mailto:'dianalund@) to database ' Customer' (1044)



-------------------------------1142871603--