Hmm a weird one. Let me have a look at the code and see if I can spot
something :)
Karan
frevidoc wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
