theniteowl
Programmer
Hi All,
I have two problems that I believe are related. I just know little about Pervasive and need a bit of guidance.
We have a vendor supplied application that uses Pervasive SQL 2000i as the database.
The application runs on a server that has no dev/test environment for me to muddle in.
A while back, for reasons unknown to me the vendor supplied replacement DDF files. I migrated these files to the server as the person who normally supported the application was on vacation. Some weeks later I received a complaint that an Access database that just links to the Pervasive database to do some reporting was giving errors. Upon inspection I found that the macros to create the links was failing because one of the tables no longer seem to exist in Pervasive.
I contacted the company for support and they sent another set of DDF files. When put in place we can no longer see ANY of the tables and get the following error:
ODBC--call failed.
They told me that it must be a file permissions issue on my end (this is a Windows 2000 server). I checked and permissions are identical on these files as they were on the old ones. When the old files are put back in place everything works except for the one missing table.
The path contains no spaces and as I said, the old files work except for the missing table, and permissions are the same so I suspect there is something wrong with the DDF files they sent. I do not know enough about the structure of these files to do more than guess but since error 94 seems to indicate permissions issues I do not know where else to look. I know some versions could cause permissions errors with spaces in the path but that is not the case here.
Any thoughts on other reasons this would happen? I want to find out what I can so we can avoid a fingerpointing argument with the vendor and just settle in to deal with the problem. The more I know the better I can influence them in the right direction rather than let them delay things saying our settings are wrong.
Thanks.
At my age I still learn something new every day, but I forget two others.
I have two problems that I believe are related. I just know little about Pervasive and need a bit of guidance.
We have a vendor supplied application that uses Pervasive SQL 2000i as the database.
The application runs on a server that has no dev/test environment for me to muddle in.
A while back, for reasons unknown to me the vendor supplied replacement DDF files. I migrated these files to the server as the person who normally supported the application was on vacation. Some weeks later I received a complaint that an Access database that just links to the Pervasive database to do some reporting was giving errors. Upon inspection I found that the macros to create the links was failing because one of the tables no longer seem to exist in Pervasive.
I contacted the company for support and they sent another set of DDF files. When put in place we can no longer see ANY of the tables and get the following error:
ODBC--call failed.
They told me that it must be a file permissions issue on my end (this is a Windows 2000 server). I checked and permissions are identical on these files as they were on the old ones. When the old files are put back in place everything works except for the one missing table.
The path contains no spaces and as I said, the old files work except for the missing table, and permissions are the same so I suspect there is something wrong with the DDF files they sent. I do not know enough about the structure of these files to do more than guess but since error 94 seems to indicate permissions issues I do not know where else to look. I know some versions could cause permissions errors with spaces in the path but that is not the case here.
Any thoughts on other reasons this would happen? I want to find out what I can so we can avoid a fingerpointing argument with the vendor and just settle in to deal with the problem. The more I know the better I can influence them in the right direction rather than let them delay things saying our settings are wrong.
Thanks.
At my age I still learn something new every day, but I forget two others.