Pervasive and Access 2000 ODBC

[edcp]

I'm using Pervasive as the ODBC to connect Access 2000 to Platinum for Windows.

One of the linked tables is only showing #NAME in all the fields, most of the other tables work fine for that DSN. What is this and what can I do to fix it?

Also, I have another DSN that is not showing any tables. How can that be?

 

[mirtheil]

The #NAME is usually caused by invalid data or some other error. Can you access the table through the PCC?
If the DSN doesn't show any tables, there's probably not any tables defined. If there were at one point, the DDFs may have been overwritten.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[edcp]

mirtheil -

I tried going through the Pervasive Control Center, when I choose Database (client) and I choose this particular database, and that particular table, I get an error of:

ODBC Error: SQLSTATE = 22008, Native error code = 0
Invalid date, time or timestamp value.

Is that what you wanted me to try? Any hints now?

 

[edcp]

I have isolated which column in the table has the bad data. It is bill_date which I have learned is a field that is imported from another system. I pulled a record to see if it was all records, or it must just be some, and the one record I pulled did pull everything, but the date shows 09/01/2026, and I'm pretty sure that isn't correct, we wouldn't be waiting until 2026 to bill a current project!

Any suggestions now?

 

[mirtheil]

Sounds like the application is marking a field as a date but isn't putting the correct data in the field.
You're going to want to go to Platinum and make sure you're using the right DDFs and they haven't seen anything like this.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[edcp]

How do I print the results of a Pervasive SQL query?

 

[mirtheil]

Using which tool? If you're using PCC, select the data and paste it into Notepad or something like that. If you want it formatted differently, you should use Access/Crystal Reports or something similar.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician