Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

ODBC Connection String with Username & Password

Dear All,

How can I add the username and password into the odbc connection string:

ODBC CONNECT TO [INTDB;DBQ=INTDB.THYNET.THY.COM;];

When I reload my file it prompts for the username and password of the ODBC connection. I want to add these information into my ODBC connection string.

Best Regards,

1 Solution

Accepted Solutions

ODBC Connection String with Username & Password

Hello Asim,

It will likely depend on your ODBC driver. Mine is working fine with

ODBC CONNECT TO database (XUserID is xxx, XPassword is yyy)


where "xxx" and "yyy" is user and password respectively and ciphered automatically by the driver (not in plain text). I'm using QV 9.00 SR1, so it may vary should your version is different.

Hope this helps.

6 Replies

ODBC Connection String with Username & Password

Hello Asim,

It will likely depend on your ODBC driver. Mine is working fine with

ODBC CONNECT TO database (XUserID is xxx, XPassword is yyy)


where "xxx" and "yyy" is user and password respectively and ciphered automatically by the driver (not in plain text). I'm using QV 9.00 SR1, so it may vary should your version is different.

Hope this helps.

Not applicable

ODBC Connection String with Username & Password

Hello Miguel,

I'm using Oracle 10g Client. But I cannot add username and password to the ODBC connection string. But I solved the problem by using OLE DB.

Thanks for your answer.

Best Regards,

peter_turner
Valued Contributor

ODBC Connection String with Username & Password

Hello Miguel,

I have a similar problem with the ODBC connection, but when i create the ODBC connection in windows it does'nt save the User/Password parameters.

Is there a way to 'generate' or retrieve the ciphered userid and password?
I know the plain text details, and need to pass the ciphered details to pass to my program.

Thanks,
Peter.

Not applicable

ODBC Connection String with Username & Password

Hello Peter,

You can use OLE DB instead of ODBC. For Example



CONNECT

TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=USERNAME;Data Source=SOURCENAME;Extended Properties=""] (XPassword is

encrypted password);





ODBC Connection String with Username & Password

Hello Peter,

As far as I know, (I'm using QV 9) when you click on the "Connect" button in the script interface, a window shows up with the list of available ODBCs and two fields, for username and password. Just type there both and you will get your connection string ciphered.

Hope this helps.

peter_turner
Valued Contributor

ODBC Connection String with Username & Password

Hi Guys,

Thanks for the quick responses!

I need to review the implications of OLE DB and ODBC, as my application is very data/time intensive.

Unfortunately my project gets distributed to different servers and each requires a new Xuser Xpassword parameters, and they don't have developer access. The result is the QVS is unable to get the data.

However i have found a way around this, by using the ODBC connection with windows authentication, and making a QV user so my QVS can use the account to start-up.

Thanks,
Peter.