I've created a dataAdapter in VB.NET using a System ODBC connection to a AS400 mainframe. The connection string in my dataAdapter is dynamic in that it is linked to the 'key' name and value used in my webconfig file under <appSettings> :
     <appSettings>
        <add key="salehistpConn" value="TRANSLATE=1;DSN=WBRRFC02DOTNET;PKG={QGPL/DEFAULT(IBM),2,0,1,0,512};DFTPKGLIB=QGPL;LANGUAGEI D=ENU;SYSTEM=WBRRFC02;DBQ={someDB *USRLIBL};UID=someUID" />
    </appSettings>

After the dataAdapter is configured, I'm able to Preview the dataSet that it returns with no problem. The issue I'm having is when I use this dataAdapter to populate a drowndownlist box on page load.
     Dim dsReg As New DataSet
      Try
         daRegion.Fill(dsReg)
         lblDataError.Visible = False
      Catch ex As Exception
         lblDataError.Text = "Database error: " & ex.Message
         lblDataError.Visible = True
         Exit Sub
      End Try

This is the error I'm getting:

Database error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Any ideas on how to resolve this issue.

Thank you very much