I'm trying to make an insert into a SqlServer table using a statement like this:

SqlExec(nHandle, 'Insert Into Table(Table.field1, Table.field2...) Values (?Table.field1, ?Table.field2...)')

having a local cursor 'Table' with valued fields (with 77 fields).

When i try to exec the command sqlexec above, under some undiscovered circumstances i receive a value of -1 and the error from server is:

"Connectivity error: Unable to retrieve specific error information. Driver is probably out of resources"


The odd aspect of all is that the record is on server (infact i can retrieve it with a select).

I've noticed that the behaviour is linked with values inserted on table local cursor, infact if i try to insert the record with a minimun set of data the error don't occur.

I can't minimize the problem witha little program (for now) because the table is involved in a Master-Detail (table is the Detail) relationship and there are manby constraint on both tables (Master-Detail).

Has anyone some suggestion to solve the problem ?