you may be up against a design restriction.
the following note is from the OLEDB provider notes in the MS SQL SDK:
<quote>
These restrictions exist if a linked server is defined using the OLE DB
Provider for ODBC and accesses a SQL Server database:
- Tables cannot be referenced if they have one or more timestamp
columns.
- Tables cannot be referenced if they have nullable char,
varchar, nchar, nvarchar, binary, or
varbinary columns and the ANSI_PADDING option was set OFF when the
table was created.
</quote>
rgds
-ns
----- Original Message -----
Sent: Wednesday, 21 August 2002
12:24
Subject: [DUG]: ADO MSSQL7
ANSI_PADDING
Hi all
Slightly off topic but does anyone know how to
set ANSI_PADDING OFF
using ADOExpress (connecting via the OLEDB
Driver)
I've got it out of the tables but seem to still
have trailing spaces coming back
TIA
Regards Neven
N.K. MacEwan B.E.
E&E
Ph 649 621 0001
Fax 649 621 0400
[EMAIL PROTECTED]
|
