Error using DAAB (January 2006) and AddInParameter

Error using DAAB (January 2006) and AddInParameter

Postby 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
rogerio.bassete
 
Posts: 15
Joined: Sat 05 Aug 2006 20:55
Location: Brazil

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

version 2.55

Postby rogerio.bassete » Thu 05 Apr 2007 11:23

PostgreSQLDirect .NET 2.55 for VS 2005 and Windows Vista Business
rogerio.bassete
 
Posts: 15
Joined: Sat 05 Aug 2006 20:55
Location: Brazil

Postby 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

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL