Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

jjordaan
Valued Contributor

Problems with data retrieval from SQL Server through an ODBC connection

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

1 Solution

Accepted Solutions
rsark
New Contributor III

Re: Problems with data retrieval from SQL Server through an ODBC connection

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

2 Replies
jvitantonio
Valued Contributor III

Problems with data retrieval from SQL Server through an ODBC connection

How's your ODBC sintax in your QV script?

rsark
New Contributor III

Re: Problems with data retrieval from SQL Server through an ODBC connection

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

Community Browser