i am connecting to mssql server7.0 thru vb6.0 (either using odbc driver or oledb provider)
when i open recordset with some numeric column zeros get truncated

e.g if i have value 30 in database for that column ,
then it returns 3
OR it returns 0

same problem arises for sybase also

what could be the problem? pls help...

thanks in advance