Access 2003 using system DSN problem

[BBeck]

I have a system DSN, pervasive ODBC engine interface. In Access 2003 I can link to the DSN but can only link to some of the files. This started when I changed to a new computer. Before, I had a link to the same database using Access 2002 with no problems.

Any help will be greatly appreciated.

Brad

 

[ByteMyzer]

Upgrading from a computer w/A2002 to a new computer w/A2003 should not affect which tables you can link to via a System DSN to a Pervasive ODBC Data Source. Have there been any updates to the database on the Server Side? If there are tables to which you are unable to link, it is possible that the definitions for said tables are not contained in the FILE.DDF and FIELD.DDF files on the server. You will need to consult with your Database Administrator to determine this.

 

[BBeck]

Clarification

Upgrading from a computer w/A2002 to a new computer w/A2003 should not affect which tables you can link to via a System DSN to a Pervasive ODBC Data Source. Have there been any updates to the database on the Server Side? If there are tables to which you are unable to link, it is possible that the definitions for said tables are not contained in the FILE.DDF and FIELD.DDF files on the server. You will need to consult with your Database Administrator to determine this.

I realize I used a wrong term. I’m new at this. I can link to the table (file) but can only link to some of the fields in the file and this was not a problem before. On the fields that won’t link, the message is “ODBC – Call Failed” but other fields work just fine.

Thanks for your help,

Brad

 

[BBeck]

I realize I used a wrong term. I’m new at this. I can link to the table (file) but can only link to some of the fields in the file and this was not a problem before. On the fields that won’t link, the message is “ODBC – Call Failed” but other fields work just fine.

Thanks for your help,

Brad

 

[KeithG]

Sounds like the fields don't exist any more. Could the names of the fields been updated?

 

[ByteMyzer]

BBeck,

You don't link to fields; you link to tables. Are you saying that when you attempt to open a linked table, that you get the ODBC – Call Failed message?

Try refreshing the links using the Linked Table Manager (Tools > Database Utilities > Linked Table Manager). Select the tables that are giving you trouble and click the [OK] button.

If this doesn't work, try creating a query that looks at the table, but only query individual fields that are not the Date/Time type. If the query works, try adding the Date/Time fields to the query. If the query then fails, that means that Pervasive is unable to interpret the data in that field for one or more of the records in that table.

 

[BBeck]

More info

Sounds like the fields don't exist any more. Could the names of the fields been updated?

I realize I used a wrong term. I’m new at this. I can link to the table (file) but can only link to some of the fields in the file and this was not a problem before. On the fields that won’t link, the message is “ODBC – Call Failed” but other fields work just fine.

 

[BBeck]

More

BBeck,

You don't link to fields; you link to tables. Are you saying that when you attempt to open a linked table, that you get the ODBC – Call Failed message?

Try refreshing the links using the Linked Table Manager (Tools > Database Utilities > Linked Table Manager). Select the tables that are giving you trouble and click the [OK] button.

If this doesn't work, try creating a query that looks at the table, but only query individual fields that are not the Date/Time type. If the query works, try adding the Date/Time fields to the query. If the query then fails, that means that Pervasive is unable to interpret the data in that field for one or more of the records in that table.

I’m sorry… I was correct the first time. It’s some of the files I can’t link. The folder has around 40 files, I can link and some I can’t. They all show but… some link some don’t.

I hooked up my old computer to the network and all files in the folder link just fine in my Access 2002. Then I opened a new mdb on my new computer in Access 2003and tried to link with the same results, some fields will link some wont just like in my original mdb.

 

[ByteMyzer]

I hooked up my old computer to the network and all files in the folder link just fine in my Access 2002.

So we're talking about files, then?

Then I opened a new mdb on my new computer in Access 2003and tried to link with the same results, some fields will link some wont just like in my original mdb.

Now we're talking about fields, again. Would you please make up your mind?

I've worked extensively with Microsoft Access and Pervasive ODBC Data Sources, and I've had no trouble with links to Pervasive ODBC tables in any version of Access, from 97 to 2003.

Talk to your Pervasive Database Administrator, and make certain that the tables you are trying to link have the proper table definitions in the FILE.DDF and the respective field definitions for those tables in the FIELD.DDF. Your Database Administrator will know what you are talking about. (If he/she doesn't, fire him/her.)