Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

DSN using Access

Locked

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

Topic

DSN using Access

In reply to DSN using Access

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

DSN using Access

In reply to DSN using Access

Poster rated this answer

DSN using Access

In reply to DSN using Access

This question was closed by the author

[Author]

Replies