index > SQL Server Everywhere Edition > Buffer size not specified error

Buffer size not specified error

Error: "The specified buffer size is not valid. [buffer size specified = 0]

Hello, im very new to SQL 2005 everywhere but looked like it could do the job for what i needed:

Im working on a c# (.net 2.0) project and loaded data

(one column from one table, 800 rows, text, no greater than 80characters in length)

from an access db into a data set, then lnserted the data in SQLce, great it works fab!

but as soon as I select another field(text, <=10) from the access db, and try to insert it into sql i get the error...

what have i missed???

ziwez0

could you post the code you are using to do the insertion and some info about the schema of the table you are inserting the records into? then we can see what's going on here.

thanks,

Darren




.NET Compact Framework MVP
Darren Shaffer
The problem was due to a field size not being long enough, i increased the field size and works great.
ziwez0
reply 3

You can use google to search for other answers

 

More Articles

• ANN: VistaDB 3 as world's first managed SQL database engine for ....
• Funny problem (bug?) using MAX() on SQL Mobile
• Error during Synchronization
• Obtain sqlceresultset table schema with GetSchemaTable
• Header Corruption Error
• SQL 2005 Mobile loading 2003 Cabs
• SQL Server Everywhere engine instancing
• "SQL Everywhere" is a Sybase trademark
• Using resultset.IsDBNUll and getting error
• using sql Mobile Databases
Bookmark and Share
Welcome to Bokebb   New Update  
 

New Articles

• An error has occurred on the computer ru
• Walkthrough Failure: "Creating a Mo
• SQL Server Mobile vs SQL Server Everywhere
• Can it be a bug in SQL CE?
• Is IIS always required for replication?
• RDA SQL MOBILE ERROR 28037 HResult = -2
• Import data to SQL Server Mobile
• SQL Server Mobile Stored Procedure?
• OMAP850 support?
• Extracting Data from SQL CE SDF file
• possible to connect to SQL Server Mobile
• Sos..
• Upgrade scripts for SQL Server Mobile Da
• Parameterized Query Using Wildcards in V
• Delete Update Behavior of the SSEv Engine

Hot Articles

• How to deploy SQL Server Everywhere with
• A request to send data to the computer r
• Error during Synchronization
• an error while trying to read .sdf file
• OMAP850 support?
• Synchronizing Data Within SQLCE and SQL
• Dling support?
• How do I install SQL Mobile 2005/Everywh
• Id getting generated differently
• SQL Server 2005 Mobile: problem with con
• DateTime.Min won't insert into SQL Serve
• Parameterized queries with RDA
• SqlCe Memory issue
• Will PPC 2003 DLL's for SQL CE work on W
• sqlce 3.0 vs sqlce 2.0 memory issue

Recommend Articles

• Is there something similar to SQL 2005 r
• Connection String Encryption for SQL Ser
• SQL Mobile in pocketpc 2003 se desktop c
• What are the performance characteristics
• INSERT Not Working via Emulator SmartPho
• Ole DB Example For Windows Mobile 5.0
• Add connction Fails in VS.NET with SQL S
• SQL 2005 Mobile vs .NET CF 2.0 SP1?
• SQL Server Mobile Merge Replication walk
• Setting up publication for merge replica
• Query:how to transfer data from a .net a
• Merge Replication Question
• Please help : A call to SQL Server Recon
• Datasource cannot connect in vs2005
• System.Data from NETCF and System.Data f