Creating & linking to a MySQL DSN

[PeterHar]

Hi,
I'm trying to move my website from an Access driven database to a MySQL driven database.

I use Win98, developing the pages on my PC and then downloading them to a host which already has MySQL set up on it. Now i've managed to download MySQL and get it working with MySQL Front, install the MyODBC driver and convert my Access tables to MySQL, but i'm making a mistake somewhere in setting up the DSN, both on my PC and on my Host, i just keep getting:

unknown 'database' on line n

Any suggestions most welcome.
Peter H

 

[piti]

looks like the database name u specified does not exist on the server