Connection to MySQL DB with MySQL Direct .NET Mobile
Connection to MySQL DB with MySQL Direct .NET Mobile
Hi User,
a question : i'm using Visual Studio .NET 2003 and MySQL Direct.NET Mobile. I have a mobile device, which runs with Windows CE 4.20.00(no Pocket PC!). Now I would like to combine on this device to a MySQL database on the Internet. Is that possible without problems? If so, is there somewhere code examples ?
Sorry for my bad english
a question : i'm using Visual Studio .NET 2003 and MySQL Direct.NET Mobile. I have a mobile device, which runs with Windows CE 4.20.00(no Pocket PC!). Now I would like to combine on this device to a MySQL database on the Internet. Is that possible without problems? If so, is there somewhere code examples ?
Sorry for my bad english
MySQLDirect .NET Mobile is designed for .NET Compact Framework 1.0 platform. This .NET Framework version can be installed on Windows CE device as well as on a Pocket PC device.
There is a set of demo projects in MySQLDirect .NET Mobile installation directory. These projects are designed for Pocket PC, but you can refer to them when creating Windows CE application using VS2003 wizards.
There is a set of demo projects in MySQLDirect .NET Mobile installation directory. These projects are designed for Pocket PC, but you can refer to them when creating Windows CE application using VS2003 wizards.
Hi Serious,
thanks a lot for your answer. I have taken the following code as an example:
Dim oMySqlConn As MySqlConnection = New MySqlConnection
oMySqlConn.ConnectionString = _
"User ID=uid;" & _
"Password=pw;" & _
"Host=ip;" & _
"Port=3306;" & _
"Database=db;" & _
"Direct=true;" & _
"Protocol=TCP;" & _
"Compress=false;" & _
"Pooling=true;" & _
"Min Pool Size=0;" & _
"Max Pool Size=100;" & _
"Connection Lifetime=0"
oMySqlConn.Open()
If I explain this, I get the error message "An unhandled exception of type 'CoreLab.MySql.MySqlException' occurred in CoreLab.MySql.dll
Additional information: Can't connect to MySQL server on '212.227.118.11' (10061)".
How can I remove this?
thanks a lot for your answer. I have taken the following code as an example:
Dim oMySqlConn As MySqlConnection = New MySqlConnection
oMySqlConn.ConnectionString = _
"User ID=uid;" & _
"Password=pw;" & _
"Host=ip;" & _
"Port=3306;" & _
"Database=db;" & _
"Direct=true;" & _
"Protocol=TCP;" & _
"Compress=false;" & _
"Pooling=true;" & _
"Min Pool Size=0;" & _
"Max Pool Size=100;" & _
"Connection Lifetime=0"
oMySqlConn.Open()
If I explain this, I get the error message "An unhandled exception of type 'CoreLab.MySql.MySqlException' occurred in CoreLab.MySql.dll
Additional information: Can't connect to MySQL server on '212.227.118.11' (10061)".
How can I remove this?
OK, the connection works fine. The mistake lay with me.
But i have a new problem : When i make a new project basend on Windows CE as a Smart Device Application, i haven't the tab mysqldirect in the tab window. When i placed a MySql Command on the form and rename it, the error "invalid property value" comes.
I reinstalled MySQLDirect.Net Mobile and the .NET Framework 1.1. The corelab modules have all the same version number "3.20.9.0".
how can i fix the problem ??
But i have a new problem : When i make a new project basend on Windows CE as a Smart Device Application, i haven't the tab mysqldirect in the tab window. When i placed a MySql Command on the form and rename it, the error "invalid property value" comes.
I reinstalled MySQLDirect.Net Mobile and the .NET Framework 1.1. The corelab modules have all the same version number "3.20.9.0".
how can i fix the problem ??