Pervasive.SQL 2000i and Access 2000

[maggieb]

When trying to insert data from an access table to a SQL linked table I am getting:
ODBC--insert on a linked table 'APHDR' failed.
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager]error in assignment. (#-1065)
It seems as if the query works once, and then fails. It has worked (honestly!) but now fails every time. I have checked for a unique key field in the linked table, and it does have one.
Any suggestions, I am desperate!

 

[mirtheil]

Usually the "Error in Assignment" error means there's a problem with the data itself. One thing you can try is to access only one field at a time to see which field is causing the error. Another thing to try it to open the table in the PCC. Open the table in PCC and see if there are any records that show "Invalid value" or something similar.
mirtheil@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[maggieb]

mirtheil:

Here are my findings for the day:

1. I tried inserting on line of the data in the Pervasive control center, and was able to do this.
2. Converted my query in Access to a Pass-through to insert a list of values (using CURDATE and CURTIME for date/time values) rather than from a select, and got the same 'error in assignment' message.
3. relinked the table in Access using 'get external data' from the main menu bar rather than right-clicking and 'link table'. When I did this, I was able to insert a line of data manually, and also delete it! But still was unable to use a query to insert data.
4. Tried creating a stored procedure in Pervasive to insert a line of values (just for the heck of it). The procedure saved, but when I tried to run it I got a 'unable to open table X$Proc' error.
5. I ran the Pervasive monitor to see the status of the table when opened in Access: the open mode shows as read-only (even though I can insert data manually).

I would really appreciate any help you could give me!

Thanks

Maggie