error 10061 - Connection to MySQL server failed - help

[Dethia]

So I was able to set-up sqlite with no issues.

I then tried configuring a mysql connection but it gives me an error that I had included in the subject.

This is my sqlite configuration
-----------------------------------------
# The function class that is provided by this plugin
#class = SQL

# The database file that the SQLite engines stores its data in
file = D:\Games\NWN2\DB\sqlite.db

# How much information should be written to xp_sqlite.txt:
# 0=nothing, 1=only errors, 2=everything
loglevel = 2
------------------------------------------

This is mysql config
------------------------------------------
# The function class that is provided by this plugin
class = SQL
# MySQL server connection parameters
server = 127.0.0.1
user = Dethia
password = my_pass
schema = mgs_item_db

# How much information should be written to xp_mysql.txt:
# 0=nothing, 1=only errors, 2=everything
loglevel = 2
-----------------------------------------

Below is the error log:
-----------------------------------------
NWNX MySQL Plugin V.0.0.9
(c) 2007 by Ingmar Stieger (Papillon)
(c) 2008 by virusman
visit us at http://www.nwnx.org
(built using mysql-5.0.27 source)

* Log level set to 2 (everything)
o SCO located at 78f440.
o RCO located at 78f090.
* Hooking successful
* Connecting to server 98.14.35.19
* Connection to MySQL server failed:
Can't connect to MySQL server on '98.14.35.19' (10061)
* Plugin initialized.
* Registering under function class SQL
* Plugin unloaded.
------------------------------------------
(I know the i[ is not localhost in the log but i get the same error regardless of what servername I use)

I am running win xp pro (sp3) and ms sql express 2008

The sql server is configured properly, I can log-in via windows authentication, 127.0.0.1, lan IP and out of frustration I even opened up the ports to enable a wan connection to rule it out as a possible issue. For some reason nwnx4 refuses to connect to the server and I have no idea why at this point so any help will be appreciated.

[PlasmaJohn]

[Dethia]

Thanks big error on my part heh.

[Gryphyn]

You can run SQLServer via the ODBC plugin.

however your database CANNOT contain any of the large data-types.
ie varchar, varbinary etc CANNOT be defined as more than 8000 bytes otherwise retrieval will fail. [using <type>(max) will fail]

[Zebranky]

Also, you should set class = SQLoff in your sqlite config, lest weirdness occur.
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?