topic Re: ODBC CONNECT TO with connection string parameters? in QlikView

ODBC CONNECT TO with connection string parameters?

aritting — Fri, 27 Jan 2017 22:24:35 GMT

Is it possible to create an ODBC Connection string similar to the one created for OLEDB CONNECT TO. So that the connection information is in the QlikView load script instead of in a Machine or or file DSN on a computer?

For example My OLEDB Connection statement looks like:

OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=True;User ID=REDACTED;Mode=Read;Extended Properties="DRIVER={iSeries Access ODBC Driver};UID=REDACTED;SYSTEM=REDACTED;DBQ=QGPL;DFTPKGLIB=QGPL;LANGUAGEID=ENU;PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;QRYSTGLMT=-1;BLOCKSIZE=32768;LAZYCLOSE=1;TRANSLATE=1;UNICODESQL=1;CONNTYPE=2;COMPRESSION=0;";Initial Catalog=REDACTED] (XPassword is REDACTED);

But if I create a ODBC CONNECT TO statement it looks like this:

ODBC CONNECT TO REDACTED;

I would like a ODBC CONNECT string that looks like :

ODBC CONNECT TO [DRIVER={iSeries Access ODBC Driver};UID=REDACTED;SYSTEM=REDACTED;DBQ=QGPL;DFTPKGLIB=QGPL;LANGUAGEID=ENU;PKG=QGPL/DEFAULT(IBM),2,0,1,0,512;QRYSTGLMT=-1;BLOCKSIZE=32768;LAZYCLOSE=1;TRANSLATE=1;UNICODESQL=1;CONNTYPE=2;COMPRESSION=0;";Initial Catalog=REDACTED] (XPassword is REDACTED);

Re: ODBC CONNECT TO with connection string parameters?

vinieme12 — Sat, 28 Jan 2017 07:25:19 GMT

May be this

File DSN Connection Problem

Re: ODBC CONNECT TO with connection string parameters?

aritting — Wed, 16 Aug 2017 19:27:33 GMT

I was able to come up with a work around. Use the OLEDB connection in QlikView and then microsoft's OLEDB for ODBC . Then use an ODBC Connection string

Here is a QlikView connect statement example to an Azure SQL Database:

OLEDB CONNECT TO [Provider=MSDASQL.1;Persist Security Info=True;User ID=YOURUSERID;Extended Properties="DRIVER=ODBC Driver 13 for SQL Server;SERVER=YOURDATABASEHOST.database.windows.net;UID=YOURUSERID;Trusted_Connection=No;APP=Microsoft® Windows® Operating System;WSID=YOURPCNAME;DATABASE=YOURDATABASE;ApplicationIntent=READONLY;";Initial Catalog=DataWarehouse] (XPassword is YOURENCRYPTEDPASSWORD);