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?

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

|||The problem was due to a field size not being long enough, i increased the field size and works great.

broker and mirroring

Hi,

I tried to setup a service broker from one database to another that is mirrored. I specified the mirror address in the create route sql. When I tried to failover to the mirror database, the message was never sent to the mirror database. I do not see any error in transmission_status of sys.transmission_queue. I do see the following errors in the sql log

Service Broker login attempt failed with error: 'Connection handshake failed. The certificate used by the peer is invalid due to the following reason: Certificate not found. State 89.'. [CLIENT: 10.76.223.38]

The mirror route is not operational. 'TCP://11.78.223.54:4022' is acting as 'Mirror' []. 'TCP://11.78.223.38:4022' is acting as 'Unknown' [].

what should I be checking here?

thanks

P

Hi P,

Looks like you did set up the endpoint authentication between the sender and the mirror, but you did not set up the endpoint authentication between the sender and the principal. Therefore the sender cannot connect to the principal. Exchange the certificates, create the login, grant CONNECT permission etc.

In order to use the mirrored route, the sender's instance must be able to connect and authenticate with both instances involved in the mirroring session (principal and mirror).

HTH,
~ Remus