Re: Connecting to MySQL via ODBC

I would cut out the step of importing through ODBC,  exporting the table
from access to a .csv (comma delimited) then use import to MySQL

Chris Moos
Got WebFLuence...?
M Systems Software, LLC
http://msyssoft.com
cmoos(at)netfluence.com
U.S.A. 1-781-961-4566


----- Original Message -----
From: "Billy O'Connor" <billy(at)kennet1.freeserve.co.uk>
To: <hwg-servers(at)hwg.org>
Sent: Thursday, June 22, 2000 10:49 AM
Subject: Connecting to MySQL via ODBC


> Hi All,
>
> I've been trying to upload an Access table to a MySQL database via the
> MyODBC driver which I got from TCX and I keep getting a "Host
> 123.123.12.123 cannot connect to the database" type error. I know this is
a
> permissions problem so have tried the following at the telnet command
line:
>
> mysql mysql -u root -h domain.co.uk -p password
>
> mysql>insert into user values
> (%,user,passwd(passwd),Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,Y,)
>         ->mysqladmin reload
>         ->
>
> I then try to reconnect to the server, with appropriate username and
> password and get exactly the same error - Host cannot connect to server.
> I've tried the above SQL statement with and without single quotes ( ' ),
> but either way nothing !
>
> As I'm using the wildcard (%) for IP/hostname, it should allow me
> permission to connect from any IP, but it doesn't even seem to be entering
> any values into the user table.
>
> I've been trying this for over 6 hours now, trying different things and
> it's driving me nuts ! It must be something so simple that I'm not doing,
> but I cannot see what and this is my first attempt at MySQL.
>
> Hope someone can help.
>
> Regards,
>
> Bill.
>
>

HWG: hwg-servers mailing list archives, maintained by Webmasters @ IWA