topic Re: Open network folder in different domain in QlikView

Open network folder in different domain

Fri, 25 Sep 2015 09:35:45 GMT

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

Re: Open network folder in different domain

Anonymous — Fri, 25 Sep 2015 09:40:58 GMT

What kind of database is it ?

Re: Open network folder in different domain

Fri, 25 Sep 2015 09:43:25 GMT

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

Re: Open network folder in different domain

Anonymous — Fri, 25 Sep 2015 09:52:44 GMT

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.

Re: Open network folder in different domain

Peter_Cammaert — Fri, 25 Sep 2015 09:56:43 GMT

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