QV中如何连接数据库

How to connect to database in Qlikview

1. You can find [Edit Scripts] from file in QV, then open it, as below show

2. We can choice database or Files to make a data source. If use database, we have some selections: ODBC, OLE DB and so on. Now I just use OLE DB for example. Click the [Connect] button, then select [Microsoft OLE DB Provider for SQL Server]. After that, next one is config the information of server [IP, USER, PASSWORD, DATABASE NAME], you can follow below pictures.