I've got a database that I've been mucking about with, trying to set
up Crystal Reports X.

Actually, I've got three separate databases, that are related to each
other. However, Crystal is giving me grief about having tables from
three separate databases. As these are all btrieve databases at their
heart, I though I would simply create a new ODBC/SQL database,
combining the btrieve files I needed into one database. As all of the
btrieve files are managed by the same application and related to each
other, I didn't figure this would be a problem.

So, I took the field definitions from the DDFs for the existing
databases, and started combining them as necessary to create the new
DDF for the new database. Everything seemed to be going swimingly.

I set up some relations among these databases within Crystal (you know
the drill, this field in this table relates to that field in that
table). Somewhere along the line, things got all pukey and btrieve
started spitting out this error. Problem is, when I look at the
databases involved using PCC, there are no RI constraints shown on ANY
of the databases. I even deleted the new databases I created,
thinking that maybe there was something going on there. No dice, same
issue.

I'm running P.SQL 2000i SP4 with hotfixes, on WinXP SP2 on my
development box. Anyone got any ideas what I've gone and messed up,
and how to get it unmessed?

Look att he first part of the file with a Hex Editor/Viewer (while
nobody is using it, of course) and see if you see the name of one of
your Named Databases embedded in the file. If so, then the file has
somehow become "bound" to this database. If you find it, let me know,
and we can get it "unbound".
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 08/28/2007 ***


Gizmo wrote:



--

Hi Bill!

You probably don't remember me, but I came up in 2000 from DVI in
Joplin, Mo for your BTrieve developer's class. We had you come down
and do a BTrieve training class at our facility in Joplin, too. Those
classes were great! Good to see you are still around.

I've looked in the files, and two of them do indeed contain the named
database. What do we do now?

Later,
Chris


On Jul 12, 11:41 am, "Bill Bach" <golds... (AT) speakeasy (DOT) net> wrote:

I hadn't recognized your "Gizmo" id. ;-)

For you, I can probably fix it - NC.

Send me one of the files, and I'll see if my idea works. I've never
had to force one out of being bound before -- I've only needed to do it
in the process of a data file recovery, where it is simple enough to
create the required NamedDB -- quite easy to do. If we have to hack
the file, we'll probably need to rebuild it, too. Is that OK?
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 08/28/2007 ***


Gizmo wrote:



--

Heh, yeah, Gizmo is a handle if used for about 25 years, even back to
the early FidoNet days.

I'll send you one of the files from my DVI address. Rebuilding it is
fine.

I'm curious though; since this problem happened while the NamedDB
existed, how would creating the named DB again allow me to recover the
data? Or did I miss something there?

Later,
Chris

On Jul 13, 5:53 pm, "Bill Bach" <golds... (AT) speakeasy (DOT) net> wrote:

Hmm......

I opened the file up in my handy-dandy hex editor, replaced the DBName
and table name with spaces (so that I didn't change the size of the
file), and that seems to have made the thing happy. I used butil -
clone, -recover, -load to rebuild the database and things seem to be
working again.

Later,
Chris


On Jul 13, 5:53 pm, "Bill Bach" <golds... (AT) speakeasy (DOT) net> wrote: