Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I know what the B in ODBC stands for ! (access97)

    OK, is this Access or is it local to my laptop ?
    I have a system DSN that references a Btrieve DB. I have an access DB that links to 5 of the Btrieve tables. When the links are freshly made the access tables will open and show all rows. The next time the database is opened, opening the table results in
    "error 3184 - couldn't execute query; couldnt find linked table"
    any ideas why ?

  2. #2
    dave_hill
    Guest

    Re: I know what the B in ODBC stands for ! (access97)

    Benediction?

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: I know what the B in ODBC stands for ! (access97)

    I don't know if it's Access or just the ODBC driver for Btrieve. If you have a slow network connection, you can get messages like that sometimes, but if it's local to your drive the only thing I can suggest is to build some code to refresh the links when you open the database.
    Charlotte

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    My network link is 100Mb but some of the tables have 50k + rows of data so speed may be the issue.
    Is this a time out problem?
    How would i code the database to refresh the links ?
    This code would be useful as the database is likely to be used by people without an ODBC link already created so it would make it a lot more portable.

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    Any chance that Btrieve has issued an OLE DB provider? With that, you could create a DSN-less connection.

    In the meantime, head into the properties for the DSN you have set up and see if tweaking the time out property gets you anywhere.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    BTrieve - now known as Pervasive - has an OLE DB provider available in exchange for about

  7. #7
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    Unfortunately, I suspect the documentation you need to find the specifics of the Pervasive OLE DB provider are bundled with the provider itself. I've poked around on the web a bit to try to find a free BTrieve OLE DB provider or documentation about the connection string, but to no avail. And even if we could find the syntax, you'd need the OLE DB provider installed for it to be of much use, anyhow.

    Darn it, painted into a corner again. Good luck.
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  8. #8
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    Our experience with Btrieve ODBC links has not been good. It always seems to be flaky and SLOW. If you can convert the tables to Jet you should see significant performance boosts, especially for tables as large as your are dealing with.
    Wendell

  9. #9
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    Not to rub salt in the wound, and a bit off topic, but do you know what motivated the choice of Btrieve in the first place?
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  10. #10
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    SLOW - you're not kidding. Something we are getting used to unfortunately.

  11. #11
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: I know what the B in ODBC stands for ! (access97)

    We didnt get a choice, the client software came with the PervasiveSQL(Btrieve decendant) database at the back end. As we as an IT dept have no control over the client software so we are building satellite databases to add functionality and pump data to our intranet/website. Personally I would have gone for SQL7 for many reasons.
    ah well, back to the ODBC Control Panel !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •