Board index » delphi » btrieve - table does not exist

btrieve - table does not exist

I am having trouble connecting to a btrieve 5.x database.  I have an
odbc driver and an alias set up in the bde.  When I set the database
alias in a table component (or look at it i nthe database desktop), I
can see all of the tables that are listed in my file.ddf.  However,
when I try to open the table in delphi or dbd, I get the message that
the table is not found.  The table is definately there.  I can use
access to get at the table so there is nothing wrong with the file.ddf
or the odbc setup, it must be some problem with bde or the way I have
the alias set up.

Does anyone have any suggestions?

Thanks,

 

Re:btrieve - table does not exist


Quote
Dave.Fa...@Dal.Ca (Dave Fagan) wrote:
>I am having trouble connecting to a btrieve 5.x database.  I have an
>odbc driver and an alias set up in the bde.  When I set the database
>alias in a table component (or look at it i nthe database desktop), I
>can see all of the tables that are listed in my file.ddf.  However,
>when I try to open the table in delphi or dbd, I get the message that
>the table is not found.  The table is definately there.  I can use
>access to get at the table so there is nothing wrong with the file.ddf
>or the odbc setup, it must be some problem with bde or the way I have
>the alias set up.

I just tried something else as well, I used the database desktop to
create a new table in one of my current file.ddfs, and it seemed to
create fine.  When I went to open it, I got the same error as my
previous tables (the exact message is

[Microsoft][ODBC Single-Tier Driver][ODBC File Library]No such table
or object.

Here's the kicker though, I was still able to use Access to open up
the table I had created in DBD but couln't open in DBD.  Access sees
it fine!

Re:btrieve - table does not exist


Did you run Control Panel to add a new Data Source with the Btrieve ODBC
driver? From the data source, you can specify the data path. Maybe this
can help?
I did the same thing using Delphi 1.0 and Btrieve 5.x. It was
ok.

Other Threads