I have a form that I made in Designer 7.0 that pulls information from an SQL database. It works fine on my machine, but on some machines, we get an error that says "Connect Operation Failed - ODBC Driver Manager. Data source name not found and no driver specified". At first we thought it was because the office was using Professional 8.0, but when we rolled them back to 7.0 the problem remained. Here's what the connection piece looks like:
Have you verified that the ODBC connections are set up on the machines that are failing, and that the users at those workstations have rights to the database you are connecting to?
I often use MS/Query in Excel to fire a test query against a datasource to verify the Machine and User are valid to the datasource.
DataConnection using DSN is not going to work unless you have DSN defined on each of those machines that you want to use. I will blame on Adobe documentation. It is not detailed enough. This is just a useless option given in designer. Templates designed using other DataConnection methods tend to work good on other machines with no dependency on local settings.
