Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to create a ODBC connection

Hi can anyone gude me the steps for creating the ODBC connection in qlikview.

Thanks in advance

1 Reply
Not applicable

How to create a ODBC connection

Well, creating an ODBC connection is not necessarily a qlikview step, but more a windows step.

You can create one in the windows ODBC administrator: control panel->administrative tools->data sources(ODBC). There you can add a user DSN (data source name). When you click add you can select the ODBC driver (which has to be installed) and give the configuration.

In Qlikview you can just select the DSN.

For Access files it's not necessary to go through so much trouble, if you select acces as ODBC and click ok at the user/pw prompt, it asks for a location where you enter the path to the file.

hth Jeroen

Community Browser