Re: ADO and timestamp/date errors

Hi Jonel

In our project, we have some Visual C++ Applications that will also talk to0
the database. We are trying to stick to common drivers. The VC++ clients are
having the same problem as I am reporting.

Thanks
Craig


----- Original Message -----
From: "Jonel Rienton" <jonel@road14.com>
To: "Craig Bryden" <postgresql@bryden.co.za>
Cc: "Shachar Shemesh" <psql@shemesh.biz>; "pgsql"
<pgsql-general@postgresql.org>
Sent: Wednesday, February 23, 2005 11:09 PM
Subject: Re: [GENERAL] ADO and timestamp/date errors


> 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@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
> >>
> >>
> >>
> >
> >
> > ---------------------------(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
>
>