why Postgres inserts null value for parameterized statement?

[kishoramballi]

Hi,

I have created table using following sql statement through psql tool in test database using
create table t1(f1 int);
table is created.
Now I am using an odbc script to insert 5 records. But it inserts 6 records NULL value being the first one inserted.
the code snippet is as below.

...
...
retVal = SQLDriverConnec t(dbHdl, NULL, (SQLCHAR*)"psql ",
SQL_NTS,outstr, sizeof(outstr), &outstrlen, SQL_DRIVER_NOPR OMPT);
SQLSetConnectAt tr(dbHdl, SQL_ATTR_AUTOCO MMIT, SQL_AUTOCOMMIT_ OFF, 0);
int f1 = 0;
ret = SQLPrepare(stmt ,(unsigned char*)"INSERT INTO T1 VALUES(?);" ,
SQL_NTS);
ret = SQLBindParamete r (stmt, 1, SQL_PARAM_INPUT , SQL_C_SLONG,
SQL_INTEGER,0,0 ,&f1,0,NULL);
int i,count=0;
// EXECUTE THE STATEMENT
for(i=0;i<5;i++ )
{
f1++;
ret = SQLExecute(stmt );
ret = SQLTransact(env ,dbc,SQL_COMMIT );
count++;
}
...
...

I am using unixodb driver and my odbc.ini file reads as follows.

$ vi ~/.odbc.ini

[psql]
Description = CP resources db
Driver = postgres
Trace = No
TraceFile = sql.log
Database = test
Servername = localhost
UserName = kishoramballi
Password = kishoramballi
Port = 5432
Protocol = 6.4
ReadOnly = No
RowVersioning = No
ShowSystemTable s = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
ExtraSysTablePr efixes =

$ vi /etc/odbcinst.ini

[ODBC]
Trace = yes
TraceFile = /tmp/sql.log

[postgres]
Driver = /usr/lib/libodbcpsql.so
Setup = /usr/lib/libodbcpsqlS.so
Description = Connector Driver DSN
SERVER = localhost
Database = test
ReadOnly = No

[PostgreSQL]
Description = PostgreSQL ODBC driver for Linux
Driver = /usr/lib/libodbcpsql.so. 1
Setup = /usr/lib/libodbcpsqlS.so .1
ExtraSysTablePr efixes =
UsageCount = 1


Am I missing something or have I added some thing more than required for this problem to occur.

Please help
thanks