General discussion

  • Creator
    Topic
  • #2131937

    DSN using Access

    Locked

    by desmondm ·

    I have developed an application using VB6. The application connects to the database using the system DSN, which is connected to access.

    The problem is that when I try to run reports, I get an error that missing DNS name and ODBC driver. The reports are using the Data Environment.

    What can I do to make this work.

    Is there a way of getting information from the DSN so that I can get the path to where the database is located, because I can then pass this path to the connection string and should be able to get my reports running.

    Jerita Chiyanike
    desmondm@nyaradzo.co.zw

All Comments

  • Author
    Replies
    • #3547854

      DSN using Access

      by sl-campbell ·

      In reply to DSN using Access

      Try setting the reports .Connect property to the DSN, or the .SessionHandle

    • #3438918

      DSN using Access

      by desmondm ·

      In reply to DSN using Access

      This question was closed by the author

Viewing 1 reply thread