Assuming the database you want is on your local machine...
Try setting the data source is setup under the System DSN tab on the ODBC admin tool. This makes it visible to all users on the system.. Setting it up under the User DSN makes it visible only to the user who set it up.
also check that the driver for your database type is installed under the drivers tab.
Hope this helps..