Re: How Can I Write a SQL Server Function that Returns a Memo Data Type in Access?

existential.philosophy@xxxxxxxxx wrote:
I have a SQL Server function which returns the data type VARCHAR(max).
When I use the function in a view and link to the view through ODBC,
it becomes a Text(255) data type in Access and most of the return
values get truncated.

After browsing this forum, I've seen many suggested alternatives to
VARCHAR, none of which translate correctly to Memo.
- All variations of VARCHAR and NVARCHAR get translated into Access'
Text data type.
- LONGTEXT, LONGCHAR, MEMO, and NOTE aren't recognized by SQL Server.
- TEXT generates the error "The text data type is invalid for return
values".

Can anyone point me in the right direction? All help is appreciated.

I'm using SQL Server 2005 and Access 2003. For an ODBC driver, I'm
using the one called "SQL Native Client", version 2005.90.4035.00.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm using SQL Server 2000 and Access XP and attaching a View w/ a
function that returns a varchar(3000). The function results in a Memo
column. My ODBC driver is "SQL Server," version 2000.85.1132.00, file
name SQLSRV32.dll.

Have you made sure the attached View has a unique index column? I'm not
sure that would cause the Varchar -> Text problem, but maybe??

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSdWWSoechKqOuFEgEQJr3ACgorkbo/42mMyi2XIyyiUqVNbnOVEAoO7h
g/YuoS+TIeZMlzdtU4cVvVAL
=qcHs
-----END PGP SIGNATURE-----
.

Relevant Pages
Loading