Re: ADO and timestamp/date errors

[Jonel Rienton <jonel@xxxxxxxxxx>]

Hi Craig,

Out of curiosity,  beside portability, why haven't you use Npgsql?

regards,

-----
Jonel Rienton
http://blogs.road14.com
Software Developer, *nix Advocate
On Feb 23, 2005, at 1:48 PM, Craig Bryden wrote:

> Hi Shachar
>
> Unfortunately due to a Non disclose agreement that I have on the  
> project, I
> cannot send the whole table creation statement. But I have included  
> some
> fields below:
> CREATE TABLE tb_Player (
>  PlayerID SERIAL NOT NULL PRIMARY KEY ,
>  Firstname varchar (100) NOT NULL ,
>  Lastname varchar (100) NOT NULL ,
>  Initials varchar (15) NULL ,
>  EMail varchar (255) NOT NULL ,
>  DateCreated timestamp NOT NULL DEFAULT current_timestamp
> ) WITHOUT OIDS;
>
> The C# code is:
> string connString = "Location=MyDB;Provider=\"PostgreSQL.1\";User
> ID=XXX;Data Source=localhost;Extended Properties=;Password=XXX";
> System.Data.OleDb.OleDbConnection dbConn = new
> System.Data.OleDb.OleDbConnection(connString);
> dbConn.Open();
> DSet1 = new DataSet();
> System.Data.OleDb.OleDbCommand comm = new
> System.Data.OleDb.OleDbCommand("select datecreated from
> pr_GetPlayerByID(2500 )",dbConn);
> System.Data.OleDb.OleDbDataAdapter da = new
> System.Data.OleDb.OleDbDataAdapter(comm);
> DataTable dt = new DataTable("Table1");
> DSet1.Tables.Add(dt);
> da.Fill(DSet1.Tables["Table1"]);
> dgResults.DataSource = DSet1;
> dgResults.DataMember = "Table1";
>
> The type that is returned by the function is:
> CREATE TYPE pr_getplayerbyid_returntype AS
>    (playerid int4,
>     firstname varchar(100),
>     lastname varchar(100),
>     initials varchar(15),
>     email varchar(255),
>     datecreated timestamp);
>
> Thanks
> Craig
>
> ----- Original Message -----
> From: "Shachar Shemesh" <psql@xxxxxxxxxxx>
> To: "Craig Bryden" <postgresql@xxxxxxxxxxxx>
> Cc: "pgsql" <pgsql-general@xxxxxxxxxxxxxx>
> Sent: Tuesday, February 22, 2005 9:26 PM
> Subject: Re:  ADO and timestamp/date errors
>
>
> > Craig Bryden wrote:
> >
> > > 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
> > Can you please send me the table creation command, and the command  
> > that
> > failed? It sounds to me like a bug in the time handling by the OLE DB.
> >
> >           Shachar
> >
> > --
> > Shachar Shemesh
> > Lingnu Open Source Consulting ltd.
> > Have you backed up today's work? http://www.lingnu.com/backup.html
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 8: explain analyze is your friend


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq