Error using DAAB (January 2006) and AddInParameter

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
rogerio.bassete
Posts: 15
Joined: Sat 05 Aug 2006 20:55
Location: Brazil

Error using DAAB (January 2006) and AddInParameter

Post by rogerio.bassete » Wed 04 Apr 2007 14:37

Hi,

Error call my Function in VS 2005 SP1, ex:

Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetStoredProcCommand("dclarion");
db.AddInParameter(cmd, "datax", DbType.Int32,75350);
string DataNova = (String)db.ExecuteScalar(cmd);
MessageBox.Show(DataNova);

Function in PostgreSQL 8.1.3

CREATE OR REPLACE FUNCTION dclarion(datax integer)
RETURNS character varying AS
$BODY$
select to_char(to_timestamp(($1 + 2378858)::varchar,'J'),'dd/mm/yyyy')
$BODY$
LANGUAGE 'sql' VOLATILE;


Debug Error: The DataRowVersion enumeration value, Default, is invalid.


Regards

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Thu 05 Apr 2007 07:24

What version of PostgreSQLDirect .NET do you use? We cannot reproduce any problem with beta version of our provider.

rogerio.bassete
Posts: 15
Joined: Sat 05 Aug 2006 20:55
Location: Brazil

version 2.55

Post by rogerio.bassete » Thu 05 Apr 2007 11:23

PostgreSQLDirect .NET 2.55 for VS 2005 and Windows Vista Business

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 06 Apr 2007 10:06

Thanks to the received project I was able to reproduce the error mentioned on my Windows XP SP2.
Now we are investigating this problem. Look forward to the results.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Wed 11 Apr 2007 15:19

This problem doesn't pertain to PostgreSQLDirect .NET because you do not use CoreLab.PostgreSql.EnterpriseLibrary.dll assembly.
For more information please read "Enterprise Library Data Access Block" topic of our help documentation.

Post Reply