I've checked with the test database (a Northwind variant): in this db, all
dates are declared as TIMESTAMP, and the driver succeeds in reading those
dates.The npgsql.dll driver used in DbLinq is version 1.98.3.0.
Can you check the differences with your system?
On Wed, Oct 1, 2008 at 18:27, frevidoc <[EMAIL PROTECTED]> wrote:
>
> stack trace :
> [MySqlConversionException: Unable to convert MySQL date/time value to
> System.DateTime]
> MySql.Data.Types.MySqlDateTime.GetDateTime() +139
> MySql.Data.MySqlClient.MySqlDataReader.GetDateTime(Int32 i) +258
> DbLinq.Util.IDataRecordExtensions.GetAsNullableDateTime(IDataRecord
> dataRecord, Int32 index) in D:\Mes Documents\01-téléchargements\LINQ
> \DbLinq-0.18\src\DbLinq\Util\IDataRecordExtensions.cs:137
> lambda_method(ExecutionScope , IDataRecord , MappingContext ) +5236
> DbLinq.Data.Linq.Sugar.Implementation.<Select>d__0`1.MoveNext() in
> D:\Mes Documents\01-téléchargements\LINQ\DbLinq-0.18\src\DbLinq\Data
> \Linq\Sugar\Implementation\QueryRunner.cs:131
>
>
> System.Web.UI.WebControls.GridView.CreateAutoGeneratedColumns(PagedDataSource
> dataSource) +284
> System.Web.UI.WebControls.GridView.CreateColumns(PagedDataSource
> dataSource, Boolean useDataSource) +418
> System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable
> dataSource, Boolean dataBinding) +640
>
>
> System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable
> data) +57
> System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable
> data) +14
>
>
> System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable
> data) +114
> System.Web.UI.DataSourceView.Select(DataSourceSelectArguments
> arguments, DataSourceViewSelectCallback callback) +31
> System.Web.UI.WebControls.DataBoundControl.PerformSelect() +142
> System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
> System.Web.UI.WebControls.GridView.DataBind() +4
> AdminGepi.gepiLinq.Page_Load(Object sender, EventArgs e) in D:\Mes
> documents\Mes sites Web\gepi\WebApplication1\gepiLinq.aspx.vb:16
> System.Web.UI.Control.OnLoad(EventArgs e) +99
> System.Web.UI.Control.LoadRecursive() +50
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> +627
>
>
> On 25 sep, 22:41, "Pascal Craponne" <[EMAIL PROTECTED]> wrote:
> > Hi,
> > could you provide a stack trace?
> >
> > Thanks.
> >
> >
> >
> >
> >
> > On Thu, Sep 25, 2008 at 11:48, frevidoc <[EMAIL PROTECTED]> 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 ?
> >
> > --
> > Pascal.
> >
> > jabber/gtalk: [EMAIL PROTECTED]
> > msn: [EMAIL PROTECTED] Masquer le texte des messages précédents -
> >
> > - Afficher le texte des messages précédents -
> >
>
--
Pascal.
jabber/gtalk: [EMAIL PROTECTED]
msn: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
