SQLBindParameter on a text field with a C string >16k

FAQ

Profile

SQLBindParameter on a text field with a C string >16k

Database Help (Home) -> ODBC

Next: schulungen frankfurt beruf privatdetektiv sicherh..

Author

Message

Sean Johnston

External

Since: Aug 29, 2008
Posts: 1

(Msg. 1) Posted: Fri Aug 29, 2008 5:27 am Post subject: SQLBindParameter on a text field with a C string >16k Archived from groups: microsoft>public>sqlserver>odbc (more info?)

I can't seem to find anything in the documentation about maximum sizes for binding C strings. I'm getting an invalid precision error (HY104) when attempting to bind a string of approximately 16k. This is being inserted into a text column in the database. (using SQL_C_CHAR / SQL_CHAR). Is there a limit on the size here? If so, where is this documented and what is the alternative for inserting long strings into text fields? >> Stay informed about: SQLBindParameter on a text field with a C string >16k

Display posts from previous:

Related Topics:

Exporting Rich Text Field data - I have an SQL 2000 database (used by a CRM package), and the field that contains what we call 'History' is a Rich Text Field. It basically starts like this: {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;} [more follows here]. If I cut and paste..

DateTime Convert Error When Insert String (SS2K) - Okay, I've got the raw data table created, and a trigger on it, and record concatenating, but I can't get around the datetime conversion problem. Can you see anything I'm doing wrong on any of these? [Microsoft][ODBC SQL Server Driver][SQL..

help,a difficult text how to sql table code ? - help,a difficult text how to sql table code ? i have a text as follow, line with ¡°|¡±and {LF}, 8|-000000186075919.|+000000000387820.|2008-03-31|20010423| 9|-000000000003919.|-000000000123620.|2008-03-31|20010123|..

Create DSN programmatically cannot set Port (VBA) - Hello, I have tried for the past three days to find all of the possible attributes for SQL Server ODBC, most specifically how to 'uncheck' the "Dynamically determine port" option and set the port number to 1435. Here is what I have so far,...

SQLOLEDB Error 7302 - Upgraded a server to MS SQL SP3a and Windows Server 2003. Now when in SQL Enterprise Manager and I try to access a linked server from this upgraded server I get the following error: Error 7302: Could not create an instance of OLE DB provider..

	Database Help (Home) -> ODBC	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum