INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Btrieve Error 35

Btrieve Error 35

(OP)
Hello

my company is using a very very old dos-base system which runs on a pervasive sql database. Now i have to provide dataexports for migration into a new system.

On the DB-Server itself i've tried whithin the "Pervasive SQL Control Center" to use the export function. I can see all tables but can only export a few o them.

Following error occurs:
Syntax Error: SELECT COUNT(*) FROM 071<<???>>KOSTENSTELLEN
Whereas the tables name is "071 Kostenstellen"

If i try to open this table, following error occurs:
ODBC Error: SQLSTATE = S1000, Native error code = 0
Unable to open table: 071 Kostenstellen.
The Btrieve file directory is invalid(Btrieve Error 35)


I have no idea??
Has anybody a clue why i can access only a few tables in this DB? The application itself is runing and used by its clients daily!

Any hint would be very appreciate
med

RE: Btrieve Error 35

What type of server, Netware or windows?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"What version of URGENT!!! are you using?"

RE: Btrieve Error 35

(OP)
Hi,

it's a windows server 2003.

I've also just recognized, that all tables which cannot be accessed, have another (wrong) "Table Location" than the once which work.

But i do not understand from where this information come from and why the clients are able to work with it.

thanks
med
 

RE: Btrieve Error 35

The "Table Location" value is stored in the X$FILE table (in XF$LOC).  You cannot directly edit the X$FILE (or any "X$" table) through the PCC or Function Executor.  You can change the value of the Table Location in the PCC to match where the data files are located or you can move the data files to match the Table Location.  There are also third party tools that can remove path information from the XF$LOC like my DDF Path Fixer (http://www.mirtheil.com/pathfixer.asp).  
 

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Btrieve Error 35

(OP)
When i move the data files or change the data path, can clients still work with it? This is the productive environment and must be available all the time.

How manage the clients by now to access those data in this tables?

Many Thanks

RE: Btrieve Error 35

Quote:

When i move the data files or change the data path, can clients still work with it? This is the productive environment and must be available all the time.
That's going to depend on the application.  If the application can be configured to open files in different locations, then it should be possible.  Then again, if the application is using the DDFs to find the data files, then changing the location of the data files to match the DDFs will work.  
 

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Btrieve Error 35

(OP)
Actually I don't know how the application is going to access those files.

Is there an other possibility to export Data from those tables without changing anything on the current configuration? I know where the data files are but I cannot access them whith PCC.

Thanks

RE: Btrieve Error 35

If you can't access them with PCC, then you probably won't be able to get to the data using ODBC, OLEDB, or any other Pervasive Relational method.  

You might be able to use Btrieve API but that would require you to know the exact record structure.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Btrieve Error 35

(OP)
Ok, so if I am right, the access method from the clients and the one from the PCC has nothing to do whitch each other, right?

So, then I could try to copy those data files to the directory, which is given in the table property within PCC. Just tu be sure that nothing is gonna change for client application.

Thanks very much!

RE: Btrieve Error 35

(OP)
Now, i get all the property informations but still the same errors on open or export...???

RE: Btrieve Error 35

This may be related to a situation I recently encountered when upgrading to V10 from V8. There is a configuration checkbox regarding whether or not embedded spaces are allowed in filenames. I can see that your generated Select statement in the PCC is choking on the embedded space. You may try editing the select statement and enclosing the file name in quotes before executing it. I ran into the problem with an executable using the Windows Client Btrieve API to access my data.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close