- You will need to create a ODBC connection (system or file) DSN via (Cntrl Pnl-Admin tools-ODBC Data source). - - Once you have a successfull connection you can use the QlikView ODBC "Connect" button to connect to your new source (DSN), which should now appear in the list of available data sources. Hope this helps !!
Also, If you don't have a problem with the connection...Then you may have a problem with your syntax....Trying using the Select button (see attached) to make a simple selection from the source and let QlikView build the script. Good Luck !!