• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 719
  • Last Modified:

Connection String for Btrieve

I am trying to find a connection string to use to connect to a Btrieve Database.
I am using a Driver from Merant and developing VB6 programs which connect through DSN's.  Thus far I have just been creating the DSN's manually but now a program of mine is being distributed on a larger scale and I need to eliminate the extra process of having to create DSN's through the ODBC administrator.  I have found connection strings for Dbase, and Access but not for Btrieve.  I have also found some samples of creating DSN's in code but could not get them to work properly.  Any Ideas would be appreciated.

Thanks

David H
0
DHOPKINS
Asked:
DHOPKINS
  • 2
1 Solution
 
felichkoCommented:
How about using File DSN's that can be distributed with the installation?
0
 
DHOPKINSAuthor Commented:
Thanks, I will look into that. System DSN information seems to be held in the registry, I assume that file DSN'S are not, I will create one and search to locate its path.  I have discovered how to edit the registry, and create the DSN that way as well.  

Thanks David H.


 
0
 
felichkoCommented:
You are right.  The file DSN is stored in a separate file.

Kevin Felichko
0
 
cymbolicCommented:
Just examine the connect string returned from your rdo or ado connection object.connect property under debug when you have your code running on a manually created DSN.  You can generate this string in code, save it and read it from a file, or save/read from your own registry keys in code.  Easiest is to create a file dsn through the ODBC driver manager, then copy that to your client system, as well as using the same path for your btrieve files on the client system.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now