Interesting! When I started to develop SP's a few years ago I was told to
make the maximum size of my varchar variables 255 but never new why! The
company I worked for didn't use ColdFusion so I assume this is due to the
ODBC restriction you are talking of. I am confused though because if you
are using a DSN for both CF and ASP then it will be using the same ODBC
driver for SQL Server and so you should see the same results. I'm confused
as to where the source of the problem is. I'll have a think!.......
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: Jay White [mailto:[EMAIL PROTECTED]]
Sent: 01 November 2000 15:00
To: CF-Talk
Subject: SQL Server 7.0 Stored Procedures
Hello
I am having touble with output parameters when running SQL Server 7.0
stored procedures. All varchar output parameters get truncated to
255(when using ODBC) or 256(when using OLEDB) characters.
I can run the same stored procedure from ASP (with either ODBC or
OLE) without truncation. I have tried both CF 4.0 and 4.5 with updated
service packs. CF is running on a NT 4.0 Server with most recent service
pack and updated MDAC.
I find it hard to believe that this is a limitation to ColdFusion,
so I am guessing that I do not have something set up correctly. Please
email directly if anyone has any ideas.
Thanks,
Jay White
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
