Connect to MS SQL Data base

[khan_imran]

Hello All,

I would like to know what all things required to connect to MS SQL database through ODBC.

Thanks in advance for help.

Regards,

Imran Khan

[vishsaggi]

I usually do this:

1.Create a DS using odbc 32bit.

2. Once connected using the ODBC from Edit script of Qlikview.

Eg:

ODBC CONNECT32 DATABASECONNECTIONNAME; created from above.

You can see the name in the Connect window in QV edit script.