Re: ADO and timestamp/date errors
От | Jonel Rienton |
---|---|
Тема | Re: ADO and timestamp/date errors |
Дата | |
Msg-id | 264253b01e57e168ae59710d11cdfe11@road14.com обсуждение исходный текст |
Ответ на | Re: ADO and timestamp/date errors ("Craig Bryden" <postgresql@bryden.co.za>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: