Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Microsoft OLE DB Provider for ODBC Drivers error '		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Corey_Bryant
New Member

USA
66 Posts
Posted - 31 July 2002 :  12:49:15  Show Profile
I receive this error when trying to add a link:
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

/forum/links_add_url.asp, line 77

I have my field for the Description set to 1500 (char) and Keywords set to 1000 (char). I do not see any limits in the ASP pages & I did this on the other fields & it worked.

I am using MS SQL2000. Not too sure what else I might be missing?

Thanks!

Corey

Doug G
Support Moderator

USA
6493 Posts
Posted - 01 August 2002 :  16:16:23  Show Profile
I haven't looked at the code, perhaps there is another DB field that's too small for the data you're posting? If you are using unicode datatypes the available # of characters is 1/2 the size of the field.


======
Doug G
======
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.81 seconds. Powered By: Snitz Forums 2000 Version 3.4.07