Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: export ODBC information

    Is there a way to export ODBC information from one computer and import onto another?

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Do you mean DSNs? If so, then you can create a File DSN and copy the resulting file to the other computer. The only issue might be the ODBC driver. The driver will have to be installed.

    Another possibilty is a DSNless connection. You can put all the information about how to connect to the database in the connection string. Each driver is different (what parameters it needs, etc.) The easiest way I have found is to create a DSN, link to a table using the DSN and then examine the connection string by clicking on the linked table and designing it. It will give you a warning and then it will go into design view. From there View/Properties and look at the Description property. That is the connection string. Use that along with DoCmd.TransferDatabase to link to the tables you need.

Posting Permissions

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