ODBC CONNECT TO with connection string parameters?

[aritting]

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);

[vinieme12]

May be this

File DSN Connection Problem

[aritting · Accepted solution]

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);