Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

hiii

how to connect to SQl server from qlikiew deskop

3 Replies
chiru_thota
Specialist
Specialist

(1) Create a ODBC connetion using server details

Control Panel -> System and Security --> Administrative Tools --> ODBC Data Source Administrator

(2) Connect from qlikview using that ODBC

      Edit script --> connect

walterlh
Creator II
Creator II

Luego de crear una conexión con el servidor con el "Administrador de Orígenes de Datos ODBC" de Windows. Ingresas a Qlikview y creas un nuevo documento. A continuación en el Editor de Script (Ctrl+e) vas a Insertar>Sentencia Connect  y eliges la conexión que anteriormente creaste y listo!Imagen1.png

maxgro
MVP
MVP

or using oledb

- Edit Script

- choose oledb and 32 or 64

- connect

- in the new window choose provider, set connection (second tab), when you save in the script you find a connection string

1.png