ODBC or OLEDB for different BD: Oracle or Sql Server- Which is best?

[#1]

I have a qlikview document that I distribute to my customers. This document connect to database with ODBC, with a user and pwd.

The conexion in the script is this:

CONNECT32 TO NAME_ODBC (XUserId is WVDcXUZNULZOGZFMRSVGN, XPassword is EIaYUUZNULZOGZFMOJUMFcB);

My customers may have sql server database or oracle database. Same database that me, same name and same tables. They create the ODBC with their user and password. Is possible that their password is different.

When I send them my qlikview document and they reload directly, then reload doesn´t run. To resolve this, the customer create their self connection in the script with the qlikview destock.

I want send them my qlikview document and that it runs and reload ok.

Is it better use the OLEDB connection? How can I do to send them a qlikview document that runs and reload perfect?

Thank you.

[jaimeaguilar]

The password is encrypted when you generate the string connection, then you can copy this string to a external file:

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Data Source=SOURCE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=USER;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is LRWZOcFPaDXA);

If you want more security, you can set the "Encryption for data" to true and also you can store user and source in variables in a hidden tab protected with password inside script

[#3]

Thanks. For mi example this runs ok. But I send the qlikview document to other cliente, this doesn´t run because his password is different. I imagine that the encryption must be different.

Regards,

Marta.

[Anonymous]

The best solution is not to use passwords - use Windows Authentication.  The only condition for this is that each user has Windows Auth Access to the database.

If use password and read it from a file, I don't know if password can be encrypted there.  The file itself can be protected, but it may not be secure enough.

[Anonymous]

Use OLEDB.

[#6]

Hola Jaime, cuando decís:

Jaime Aguilar 26-mar-2014 13:07 (en respuesta a Marta Lopez Martin )

The password is encrypted when you generate the string connection, then you can copy this string to a external file:

Dónde está el archivo del que puedo tomar el string de conexión con las claves encriptadas y copiarmelo a un archivo externo.