Search Postgresql Archives

Re: ADO and timestamp/date errors

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Shachar
 
I have confirmed that I am running the latest version.
The error that I get (in ADO .Net) is :
******************************************************************************
An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in system.data.dll
 
Additional information:
Specified argument was out of the range of valid values.\r\nParameter name: Year, Month, and Day parameters describe an unrepresentable DateTime

******************************************************************************
I have changed to using the ODBC and it is working fine.
 
Thanks
Craig
 
 
----- Original Message -----
From: "Shachar Shemesh" <psql@xxxxxxxxxxx>
To: "Craig Bryden" <postgresql@xxxxxxxxxxxx>
Cc: "pgsql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Tuesday, February 22, 2005 6:13 AM
Subject: Re: ADO and timestamp/date errors

> Craig Bryden wrote:
>
> >Hi
> >
> >I am trying to read a data set in ADO. If I exclude a timestamp field that I
> >have in the return type, all works wonderfully. The moment I include the
> >timestamp (i've even tried casting it as date) it bombs out with an OLEDB
> >Exception of some type.
> > 
> >
> Try reading the text of the exception. You are using an old version of
> OLE DB. Try the latest version
> (
http://gborg.postgresql.org/project/oledb). It should either work, or
> give you a proper error message.
>
> >Has anyone got any ideas?
> > 
> >
> OLE DB is a binary interface. As such, it needs to know the binary
> structure of any data type it encounters. It does not yet support all
> the data types returned by Postgres 8. Please place (CC to this list)
> the way you defined the column that offends OLE DB.
>
> Please note that a newer version of OLE DB did have some additions in
> the time types category, so I heartily suggest you try that first.
>
> >Thanks
> >Craig
> > 
> >
>        Shachar
>
> --
> Shachar Shemesh
> Lingnu Open Source Consulting ltd.
> Have you backed up today's work?
http://www.lingnu.com/backup.html
>
>
>

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux