Problems with data retrieval from SQL Server through an ODBC connection

[jjordaan]

Hi everyone,

For a customer I'm creating a dashboard.
Normally we always have a connection to the database via OLEDB but this customer has a connection via ODBC.

When requesting the tables I get the message below (see attachment).
I have never problems when I connect via OLEDB.

Has this to do with the ODBC connection?

Thx

[jvitantonio]

How's your ODBC sintax in your QV script?

[rsark · Accepted solution]

- 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 !!