Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
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.
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,
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.
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 isencrypted 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.
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.