Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Open network folder in different domain

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

Tags (2)
1 Solution

Accepted Solutions

Re: Open network folder in different domain

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

4 Replies

Re: Open network folder in different domain

What kind of database is it ?

Not applicable

Re: Open network folder in different domain

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

Re: Open network folder in different domain

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

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