Re: ADO and timestamp/date errors - Mailing list pgsql-general
From | Craig Bryden |
---|---|
Subject | Re: ADO and timestamp/date errors |
Date | |
Msg-id | 002501c51aa0$7bb55ca0$0ed217c4@amd2800 Whole thread Raw |
In response to | ADO and timestamp/date errors ("Craig Bryden" <postgresql@bryden.co.za>) |
List | pgsql-general |
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 > >
pgsql-general by date: