xiaoyunwu
asked on
mysql for toad connect
I'm trying to connect to mysql via Toad, here is the error I got, any idea why?
System.ArgumentException
Format of the initialization string does not conform to specification starting at index 13.
Stack Trace:
at System.Data.Common.DbConne ctionOptio ns.GetKeyV aluePair(S tring connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue)
at System.Data.Common.DbConne ctionOptio ns.ParseIn ternal(Has htable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey)
at System.Data.Common.DbConne ctionOptio ns..ctor(S tring connectionString, Hashtable synonyms, Boolean useOdbcRules)
at System.Data.Common.DbConne ctionStrin gBuilder.s et_Connect ionString( String value)
at MySql.Data.MySqlClient.MyS qlConnecti on.set_Con nectionStr ing(String value)
at MySql.Data.MySqlClient.MyS qlConnecti on..ctor(S tring connectionString)
at Quest.Toad.MySQL.MySQLConn ection.Cre ateConnect ion()
at Quest.Toad.MySQL.MySQLConn ection.DoB eforeConne ct()
at Quest.Toad.Db.Connection.C onnect(Boo lean notify)
at Quest.Toad.Db.Provider.Bac kgroundCon nector.Cre ateBackgro undConnect ion()
System.ArgumentException
Format of the initialization string does not conform to specification starting at index 13.
Stack Trace:
at System.Data.Common.DbConne
at System.Data.Common.DbConne
at System.Data.Common.DbConne
at System.Data.Common.DbConne
at MySql.Data.MySqlClient.MyS
at MySql.Data.MySqlClient.MyS
at Quest.Toad.MySQL.MySQLConn
at Quest.Toad.MySQL.MySQLConn
at Quest.Toad.Db.Connection.C
at Quest.Toad.Db.Provider.Bac
ASKER
the connection string should be correct, since it's entered in a toad window.
This is a new mysql database. I can use Toad to connect to another old mysql database. I'm not sure if port 3306 is open, and don't know how to check, and don't know if firewall etc.
One thing I know is that I can connect to mysql database through Adminer.
This is a new mysql database. I can use Toad to connect to another old mysql database. I'm not sure if port 3306 is open, and don't know how to check, and don't know if firewall etc.
One thing I know is that I can connect to mysql database through Adminer.
without a bit more details about the mysql version, and the connection string ...
what version of the mysql toad are you using?
what version of the mysql toad are you using?
ASKER
We are using Toad for mysql 7.0.0.2038 and mysql server 5.1. I installed mysql Workbench 6 and am able to successfully connect to the database but still unable using Toad. Im not sure how to view the connection string within Toad. Any suggestions? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
used work around
If your connection string is correct, can you share more details like did this ever work, is this a new install, et cetera...
Other things to check include whether or not MySQL is running on default port. If it is not, you will need to specify the port with host. If I remember correctly, it will be IP:port in TOAD's host configuration.