can't connect to DB with eqitems

[jsr]

Error =
MYSQL connection FAILED!- Check db.ini and did you install by ODBC drivers?

I have -

- unzipped the files
- ran eqitems.exe
- got the error
- found the mysql drivers
- installed
- ran eqitems.exe
- got the error
- read the readme.txt
- registered the OCX files
- ran eqitems.exe
- got the error

Searched forums and can't find next steps :-)

DB.ini--
host=(db IP)
user=(user)
password=(pass)
database=peq
everquest_folder=f:\eqemu\titanium

Drivers/OCX--
Downloaded drivers from: http://www.georgestools.eqemulator.net/ODBC_DRIVERS.zip
Registered OCX files

DB version--
Mysql 5.0.89

can connect via commandline with above details (and mysql query browser).

Anything I should look for next?

[joligario]

You used an ip? Are you trying to connect remotely?

[pfyon]

If the DB is on the same computer, you should use host=localhost, if it's on another machine, you have to make sure that a) the ports are forwarded properly, b) there isn't a firewall blocking access to the port, and c) that mysql is set up to allow remote connections.

[jsr]

Great advice, thanks guys :)

[GeorgeS]

In my tools download, I have a connection checker that you should try.

Otherwise, you have done what's needed. Sometimes port 3306 needs to be forwarded to you server pc.

GeorgeS