Solved: Open network folder in different domain - Qlik Community

Report Inappropriate Content · ‎2015-09-25

Hi,

i'm working on a server A with my QV. I created an'application that take the data from a database on a server B (in a different domain).

To access to the database i need to enter a username and password.

Now, I enter username and password through Windows Active Directory and then i charge the data with QV.

How can i do automatically with a macro?

Thank you,

Fra

Peter_Cammaert · ‎2015-09-25

If the two domains have a trust relationship (ask your SysAdmin about this), it will be sufficient to share the directory containing Access files and assign proper share & NTFS rights to your account (or the account with which you are reloading documents). Access ODBC is not a real DBMS connection, it just reads files in a directory.

Peter

View solution in original post

Anonymous · ‎2015-09-25

What kind of database is it ?

Report Inappropriate Content · ‎2015-09-25

An access DB. I connect to it with a ODBC Connection

Anonymous · ‎2015-09-25

I am more an Oracle database than an MS Access person.

Notwithstanding that I am pretty certain you can embed the authentication to an Access database in the ODBC link. An MS Access forum may be better placed to help you.

Although there are probably those on this forum experienced with MS Access.

Peter_Cammaert · ‎2015-09-25

If the two domains have a trust relationship (ask your SysAdmin about this), it will be sufficient to share the directory containing Access files and assign proper share & NTFS rights to your account (or the account with which you are reloading documents). Access ODBC is not a real DBMS connection, it just reads files in a directory.

Peter