topic Re: Connecting to Database in QlikView https://community.qlik.com/t5/QlikView/Connecting-to-Database/m-p/402460#M149779 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use ODBC instead and store the user and password in it, so you are not prompted each time you reload the script or connect, unless your Oracle security does require you to do. Although I never tried with OLE DB, you can also store passwords there, so the connection string has the password scrambled, and therefore not prompting each time you reload.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Thu, 11 Oct 2012 07:25:49 GMT Miguel_Angel_Baeyens 2012-10-11T07:25:49Z Connecting to Database https://community.qlik.com/t5/QlikView/Connecting-to-Database/m-p/402459#M149778 <HTML><HEAD></HEAD><BODY><P>hello all,</P><P></P><P>i am able to connect Database to Oracle but its asking each time password while connecting to Oledb connection.</P><P></P><P></P><P>Please suggest.</P><P></P><P></P><P></P><P></P><P>Thanks In Advandce</P><P>SKC</P></BODY></HTML> Thu, 11 Oct 2012 06:27:27 GMT https://community.qlik.com/t5/QlikView/Connecting-to-Database/m-p/402459#M149778 SunilChauhan 2012-10-11T06:27:27Z Re: Connecting to Database https://community.qlik.com/t5/QlikView/Connecting-to-Database/m-p/402460#M149779 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use ODBC instead and store the user and password in it, so you are not prompted each time you reload the script or connect, unless your Oracle security does require you to do. Although I never tried with OLE DB, you can also store passwords there, so the connection string has the password scrambled, and therefore not prompting each time you reload.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Thu, 11 Oct 2012 07:25:49 GMT https://community.qlik.com/t5/QlikView/Connecting-to-Database/m-p/402460#M149779 Miguel_Angel_Baeyens 2012-10-11T07:25:49Z