my connection string is "Server=serv-iis;User
ID=root;Password=blabla;Persist Security
Info=True;Database=gepi1501;Allow Zero Datetime=True" the connection
works fine in the server explorer, but when test it via Dblinq it
occurs thirs error
"Unable to convert MySQL date/time value to System.DateTime error"
my code is :
Dim MyConnexionString As New
MySql.Data.MySqlClient.MySqlConnectionStringBuilder
MyConnexionString.ConnectionString =
ConfigurationManager.ConnectionStrings("gepi1501ConnectionString").ConnectionString
Dim MyConnexion As MySqlConnection = New
MySqlConnection(MyConnexionString.ConnectionString)
Dim db As GePi1501 = New GePi1501(MyConnexion)
Dim MyUsers = From u In db.UtIlIsaTeURS _
Select u _
Order By u.NoM
GridView2.DataSource = MyUsers
GridView2.DataBind()
in the web.config the connectionString is :
<connectionStrings>
<add name="gepi1501ConnectionString" connectionString="Server=serv-
iis;User ID=root;Password=blabla;Persist Security
Info=True;Database=gepi1501;Allow Zero Datetime=True"
providerName="MySql.Data.MySqlClient"/>
</connectionStrings>
any idea ?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en
-~----------~----~----~----~------~----~------~--~---
