Intersolv 3.01 ODBC with Decimal datatypes
I have done more investigation into my problem earlier with the stored proc
returning decimal 10.
I created a simple table as follows;
Column name Type
col1 integer
col2 float
col3 decimal(8,2)
I then inserted the following data using dbaccess;
col1 col2 col3
5 5.000000000000 5.00
15 15.00000000000 15.00
10 10.00000000000 10.00
There is a problem when retrieving the value 10.00 from col3 using ADO.
I am already using ADO v2.0.
Is there a newer version of the ODBC driver I can try ?
This is the HTML output I get
----------------------------------------
<HTML>
<HEAD>
<TITLE>ActiveX Data Object (ADO)</TITLE>
</HEAD>
<BODY BGCOLOR=#FFFFFF>
<H3>Test1 - using a table with different numeric datatypes</H3>
<P>
<TABLE BORDER=1>
<TR>
<TD><B>col1</B></TD>
<TD><B>col2</B></TD>
<TD><B>col3</B></TD>
</TR>
<TR>
<TD VALIGN=TOP> 5</TD>
<TD VALIGN=TOP> 5</TD>
<TD VALIGN=TOP> 5</TD>
</TR>
<TR>
<TD VALIGN=TOP> 15</TD>
<TD VALIGN=TOP> 15</TD>
<TD VALIGN=TOP> 15</TD>
</TR>
<TR>
<TD VALIGN=TOP> 10</TD>
<TD VALIGN=TOP> 10</TD>
<TD VALIGN=TOP> <font face="Arial" size=2>
<p>Response object</font> <font face="Arial" size=2>error 'ASP 0101 :
80070057'</font>
<p>
<font face="Arial" size=2>Unexpected error</font>
<p>
<font face="Arial" size=2>/TEST/test1.asp</font><font face="Arial" size=2>,
line 38</font>
<p>
<font face="Arial" size=2>The function returned |.
</font>