You can test ODBC Data Sources using the ODBC Administrator.
If you cannot access the Data Source, check that you have filled out the various tabs with correct file and path names.