Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

runtime error -2147467259 (800004005) ??

any ideas what runtime error -2147467259 (800004005) is all about? this is the line that it shows as the debug'r

Conn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=<IP ADDRESS HERE>;DATABASE=registration;USER=username;PASSWORD=password;OPTION=3;"

the mysql version is MySQL5 and i have myODBC installed on my PC, and access hosts set to % on the server.. any ideas?
[395 byte] By [vchatlive] at [2007-11-11 10:06:55]
# 1 Re: runtime error -2147467259 (800004005) ??
Don't you need to specify the Port argument? It's probably 3306.
pclement at 2007-11-11 17:23:16 >
# 2 Re: runtime error -2147467259 (800004005) ??
tried that as well, still no go, getting the error still Thanks
vchatlive at 2007-11-11 17:24:16 >
# 3 Re: runtime error -2147467259 (800004005) ??
says access denied for user <database user> @ % to database <database name> any one with any ideas please let me know!!!! Thanks
vchatlive at 2007-11-11 17:25:14 >
# 4 Re: runtime error -2147467259 (800004005) ??
Are you getting a different error now?
pclement at 2007-11-11 17:26:19 >
# 5 Re: runtime error -2147467259 (800004005) ??
no more errors, just needed to have the odbc driver installed in order to make the program work properly, Thanks
vchatlive at 2007-11-11 17:27:18 >