MySQL Connection
-
Hi, Im trying to connect to a mysql server, the connection detials are below: ("Network Address=ip:3306" + "Initial Catalog='db1';" + "Persist Security Info=no;" + "User Name='login';" + "Password='pass'"); The problem is it complains that the first piece of the string isnt correcty formed. Any ideas? Regards, Gareth.
-
Hi, Im trying to connect to a mysql server, the connection detials are below: ("Network Address=ip:3306" + "Initial Catalog='db1';" + "Persist Security Info=no;" + "User Name='login';" + "Password='pass'"); The problem is it complains that the first piece of the string isnt correcty formed. Any ideas? Regards, Gareth.
I don't use MySQL myself but just looking at your string there are three comments: 1) shouldn't "Network Address=ip:3306" be something like "Network Address=127.0.0.1:3306" 2) you use the ";" as a seperator but it's missing from the first aurument. 3) you've got quote marks "'" around most of the arguments except the first. This would give the first line the following format: ("Network Address='127.0.0.1:3306';" Just an idea..
Regards Wayne Phipps ____________ Time is the greatest teacher... unfortunately, it kills all of its students View my Blog
-
I don't use MySQL myself but just looking at your string there are three comments: 1) shouldn't "Network Address=ip:3306" be something like "Network Address=127.0.0.1:3306" 2) you use the ";" as a seperator but it's missing from the first aurument. 3) you've got quote marks "'" around most of the arguments except the first. This would give the first line the following format: ("Network Address='127.0.0.1:3306';" Just an idea..
Regards Wayne Phipps ____________ Time is the greatest teacher... unfortunately, it kills all of its students View my Blog
I found this page which lists different connection strings dependant on the API (driver) you use: http://www.connectionstrings.com/?carrier=mysql I don't know if it helps?
Regards Wayne Phipps ____________ Time is the greatest teacher... unfortunately, it kills all of its students View my Blog
-
I found this page which lists different connection strings dependant on the API (driver) you use: http://www.connectionstrings.com/?carrier=mysql I don't know if it helps?
Regards Wayne Phipps ____________ Time is the greatest teacher... unfortunately, it kills all of its students View my Blog
Hi Wayne, Thanks for the website, looks very helpful. Though, i have a new problem now. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Any ideas? Regards, Gareth.