ServerHead
Programmer
Dear All,
I have a db in Access 2000 and SQL Server 7.0 with some varchar fields. The db is used through code in VC++ using ADO library over ODBC DSN. There was a problem in using SQL Server as all varchar fields were returned in full size with space paddings. Access was working fine. Also this problem was not seen when the code was written in VB. I set the ANSI Padding option OFF in DSN and then the SQL Server was working fine as well.
I resently ported the database to SQL Server 2000 and the padding has returned. I tried setting the Padding option in DSN OFF again which didn't work. Then setting the db compatibility level to 7.0 also did not work.
For the time being all calls are trimmed before using but it is not the solution as we might manuualy add some spaces at end in data.
If any of you have any experience or solution in this regard the help would be great.
I have a db in Access 2000 and SQL Server 7.0 with some varchar fields. The db is used through code in VC++ using ADO library over ODBC DSN. There was a problem in using SQL Server as all varchar fields were returned in full size with space paddings. Access was working fine. Also this problem was not seen when the code was written in VB. I set the ANSI Padding option OFF in DSN and then the SQL Server was working fine as well.
I resently ported the database to SQL Server 2000 and the padding has returned. I tried setting the Padding option in DSN OFF again which didn't work. Then setting the db compatibility level to 7.0 also did not work.
For the time being all calls are trimmed before using but it is not the solution as we might manuualy add some spaces at end in data.
If any of you have any experience or solution in this regard the help would be great.
