Board index » delphi » Upgrade from Access 2000 to SQL Server 2000 - table values are padded with spaces

Bart Garssen

Delphi Developer
Sat, 24 Jan 2004 20:41:36 GMT

Upgrade from Access 2000 to SQL Server 2000 - table values are padded with spaces

Hi everyone

I'm converting my application from access 2000 to also work on SQL 2000. I upgraded the database using access, altered the ADO connect string in my app, & it worked! There is one problem however, all text fields are now padded with spaces. So I recreated the database with ANSI_PADDING off, and it works beatifully when I'm in the enterprise manager. However, when I want to use it with ADO I still have this problem. The SQL server OLEDB driver obviously thinks that ANSI_PADDING should be on in my session. Do you have a suggestion how to turn this off? ODBC is really no option, this is too difficult for the end-users to maintain.

Regards

Bart

 
Vassil Nazaro

Delphi Developer
Sun, 25 Jan 2004 06:59:00 GMT

Re:Upgrade from Access 2000 to SQL Server 2000 - table values are padded with spaces


Quote
> problem however, all text fields are now padded with spaces.

You need to re-declare all text fields as varchar(n).

--
Vassil Nazarov
http://web.orbitel.bg/vassil/

Bart Garsse

Delphi Developer
Sun, 25 Jan 2004 14:29:10 GMT

Re:Upgrade from Access 2000 to SQL Server 2000 - table values are padded with spaces


What a job! I have a lot of them! But it works great. Thanks!

Quote
"Vassil Nazarov" <vas...@mail.orbitel.bg> wrote:
>> problem however, all text fields are now padded with spaces.

>You need to re-declare all text fields as varchar(n).

>--
>Vassil Nazarov
>http://web.orbitel.bg/vassil/

Other Threads

1. Problem upgrading Sql Server from 6.5 to 2000

2. Windows 2000, SQL Server 2000 and ADO Problem?

3. Access 2000 to SQL 2000

4. ACCESS 2000 padded fields problem

5. Retreive values from text columns (sql server 2000)

6. Help: Upgrading from MS SQL 6.5 to MS SQL 2000

7. Sql Server 2000 & Sql Server 7.0

8. Heeeelp - Access Violation on D6 + SQL Server 2000 + Win 2K

9. ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000

10. SQL Server 2000 access via BDE