odbc & access xp(2002)

[BlueJester]

Hello,
I need help
Objective: What I am trying to do is link tables from our pervasive database to a table in access for our shipping computers using an odbc connection.
Situation: ODBC connection is in place and working correctlly from what i can tell.. ive ran a trace, and when linking to about 10% of our files it works great.. but with the other 90% i get error #238 in access (ODBC--call failed [Pervasive Software][ODBC Interface][Pervasive Software SQL Engine] The named index does not exist. (#238)) which is strange because I know it does exist.. cuz im looking at the darn files that im trying to link to and the ddf is in the same directory..
Solution: I have pretty much run out of guesses and now i hope one of you guys/gals can help me out with this
Thanks In Advance,
Chris

 

[mirtheil]

Sounds like you're running Pervasive.SQL V7 or earlier. The 238 error usually indicates DDFs and data files that don't match correctly. Also, with old version of Btrieve/Pervasive, indexes were not required to be named. With v7.0 and later, the engine prefers (and requires in 2000 and V8) named indexes. If these are third party data files, go back to the vendor and get updated DDFs.


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

 

[BlueJester]

thank you very much for your help,
the ddf files are actually up to date from our third party software company (powerflex), but what you said made me think... since we have a server with our live data and a server with our backup data, live running v7 and backup running 2000... i tried to tie to those data files via odbc with their ddfs and the thing is working perfectly.. must be something w/ the version 7 engine.
thanks again

 

[zedsded]

blue,
i have almost exactly the same problem.
objective: convert database from access 2.0 to access 2002.
: link tables from pervasive 7.0 btrieve files
using psql2000 odbc drivers.
Im getting "ODBC call failed". I got the newer version of the shipping application that we are using supposedly for PSQL2000. Does this mean I just need to upgrade my shipping application? what risks should I consider? Could you email me instructions based on you experience? My ACCESS files/tables are coming from two locatons (each I have created DSNs for). Is this a problem, each location has its own DDFs. CONNECTIONS ARE OKAY.
thank you very much!