×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

(OP)
Trying a simple insert statment, but for some reason it returns the following error no matter what i try and insert into the table:

ODBC Error: SQLSTATE = S1000, Native error code = -4977
The data buffer parameter is too short(Btrieve Error 22)

can anybody tell me what this error means and why i might be getting this error.

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

Typically that error is returned if your DDFs and data files don't match.  WHat version of PSQL are you using?  If it's V8.x, run a Database COnsistency Check from the PCC.  If it's V9, download the Database CHecker from the Component Zone (http://www.pervasive.com/ComponentZone/Component/Lookup.asp?Function=ShowDetail&ID=343&Component=DB+Consistency+Check+for+PSQL+v9&AuthorID=235405&CategoryID=6&Page=1&CategoryName=Tools+%2F+Utilities) and run it.

Post any failures related to the table you are trying to insert into.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

(OP)
using v8.5, where abouts would i find the consistency checker?

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

Right click the database name in the PCC, select "Tasks" then "CHeck database".

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

(OP)
If the database fails the consistency checker with general dictionary inconsistencies on a particular table, then what?

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

Depends on the failures.  What are they?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

(OP)
all it tells me is that its failed, on general dictionary inconsistencies.  Does the database need re-indexing?

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

(OP)
===============================================
Database consistency test results.
Test was run on:  23 May 2006 14:47:47

DSN: TSNew

Database name: TSNEW

Database Location: D:\SHARE\APPS\TSPIRIT\DATA\RCI
===============================================


===============================================
Database Check Statistics
===============================================
Pervasive.SQL Compatibility Mode  =  8
Tables Checked  =  1
Tables Passed  =  0
Tables Failed  =  1

Illegal Object Names  =  0
Record Length Inconsistencies  =  0
Variable Length Column Inconsistencies  =  0
Data Type Inconsistencies  =  0
Column Overlaps  =  0
Full Path (instead of Relative) Table Locations  =  0
Table Files Don't Exist  =  0
Index Inconsistencies  =  0
System Table Inconsistencies  =  0
General Dictionary Inconsistencies  =  1


===============================================
===============================================
Problems Detected with Database Definitions
===============================================
+++++++++++++++++++++++++++++++++++++++++++++++
Table Name  =  PEEMAD

[Pervasive][ODBC Client Interface]Error in assignment.


===============================================

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

I've never seen that.  Save the report (click the Diskette icon), and then post the entire report.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

(OP)
have done

RE: Pervasive SQL - ODBC Error: SQLSTATE = S1000, Native error code =

Looks like we posted at the same time.  

Sounds like your DDFs are really messed up. Are these for a third party application?  If so, you should contact the vendor of the application to get updated ODBC compliant DDFs.  
If not, I would suggest rebuilding the DDFs from scratch with the exact record structure.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close