Thread: ODBC Error while selecting a numeric data field
I have tried PostgreSQL version 7.1.3 with iODBC-3.0.5 and PostgreSQL version 7.2.1 with iODBC-3.0.6 and in both cases I get an error when attempting to do a select on a field with the numeric data type. Using the psql program I do the following : CREATE TABLE test (lat numeric(9,6) ); INSERT INTO test VALUES (12.23); SELECT * FROM test; When I do the select in the psql program I get : lat ---------- 12.230000 (1 row) Now, I have an application attempting to perform the same SELECT statement using the iODBC drivers SDK. When calling SQLFetch with a SELECT statement attempting to pull data from a field of type NUMERIC, I get the error : 07006 Received an unsupported type from Postgres. Please help....
Well, I have managed to get the ODBC SQL select call to work with the NUMERIC database type. In the Windows ODBC Help file there is a section called "Converting Data from SQL to C Data Types" In this section there is a chart which shows the default conversion for the SQL_NUMERIC data type to a C data type is SQL_C_CHAR. So I made a stab and used that in my SQLBindCol statement and it worked! Here is my SQLBindCol statement that didn't work : rc = SQLBindCol ( hstmt, i+1, SQL_C_NUMERIC, &fields[i].variant.f_numeric, fields[i].size, &fields[i].length ); and here is the one that now works : rc = SQLBindCol ( hstmt, i+1, SQL_C_CHAR, &fields[i].variant.f_char, fields[i].size, &fields[i].length ); I am still a little curious as to why the original way did not work, if anyone can point that out to me it would be greatly appreciated... "Tom Ince" <tom.ince@netzero.net> wrote in message news:_CEX8.812$ak5.680@nwrddc01.gnilink.net... > I have done a test and created the table with the field being a float > instead > of numeric and everything works fine. > > Any help please??? > > > "Tom Ince" <tom.ince@netzero.net> wrote in message > news:OLCX8.718$ak5.93@nwrddc01.gnilink.net... > > I have tried PostgreSQL version 7.1.3 with iODBC-3.0.5 > > > > and > > > > PostgreSQL version 7.2.1 with iODBC-3.0.6 > > > > and in both cases I get an error when attempting to do a select on a field > > with the numeric data type. > > > > Using the psql program I do the following : > > > > CREATE TABLE test (lat numeric(9,6) ); > > INSERT INTO test VALUES (12.23); > > SELECT * FROM test; > > > > When I do the select in the psql program I get : > > > > lat > > ---------- > > 12.230000 > > (1 row) > > > > > > Now, I have an application attempting to perform the same SELECT statement > > using the iODBC drivers SDK. > > When calling SQLFetch with a SELECT statement attempting to pull data from > a > > field of type NUMERIC, I get > > the error : > > > > 07006 > > Received an unsupported type from Postgres. > > > > > > Please help.... > > > > > > > >
I have done a test and created the table with the field being a float instead of numeric and everything works fine. Any help please??? "Tom Ince" <tom.ince@netzero.net> wrote in message news:OLCX8.718$ak5.93@nwrddc01.gnilink.net... > I have tried PostgreSQL version 7.1.3 with iODBC-3.0.5 > > and > > PostgreSQL version 7.2.1 with iODBC-3.0.6 > > and in both cases I get an error when attempting to do a select on a field > with the numeric data type. > > Using the psql program I do the following : > > CREATE TABLE test (lat numeric(9,6) ); > INSERT INTO test VALUES (12.23); > SELECT * FROM test; > > When I do the select in the psql program I get : > > lat > ---------- > 12.230000 > (1 row) > > > Now, I have an application attempting to perform the same SELECT statement > using the iODBC drivers SDK. > When calling SQLFetch with a SELECT statement attempting to pull data from a > field of type NUMERIC, I get > the error : > > 07006 > Received an unsupported type from Postgres. > > > Please help.... > > >
> -----Original Message----- > From: Tom Ince > > Well, I have managed to get the ODBC SQL select call to work with the > NUMERIC database type. > > In the Windows ODBC Help file there is a section called "Converting Data > from SQL to C Data Types" > > In this section there is a chart which shows the default > conversion for the > SQL_NUMERIC data type to > a C data type is SQL_C_CHAR. So I made a stab and used that in my > SQLBindCol statement and it worked! > > Here is my SQLBindCol statement that didn't work : > rc = SQLBindCol ( hstmt, i+1, SQL_C_NUMERIC, &fields[i].variant.f_numeric, > fields[i].size, &fields[i].length ); > > and here is the one that now works : > rc = SQLBindCol ( hstmt, i+1, SQL_C_CHAR, &fields[i].variant.f_char, > fields[i].size, &fields[i].length ); > > I am still a little curious as to why the original way did not work, if > anyone can point that out to me it would be > greatly appreciated... SQL_C_NUMERIC is an ODBC3.X type. Psqlodbc driver is ODBC2.50. regards, Hiroshi Inoue