Re: ADO and timestamp/date errors - Mailing list pgsql-general

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@shemesh.biz>
To: "Craig Bryden" <postgresql@bryden.co.za>
Cc: "pgsql" <pgsql-general@postgresql.org>
Sent: Tuesday, February 22, 2005 9:26 PM
Subject: Re: [GENERAL] 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
>
>
>