Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Miguel_Angel_Baeyens

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.

View solution in original post

6 Replies
Miguel_Angel_Baeyens

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
Author

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
Partner - Specialist
Partner - Specialist

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
Author

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





Miguel_Angel_Baeyens

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
Partner - Specialist
Partner - Specialist

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.