Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2009-10-12 10:08 PM

Write back to Database

I was trying to write back to the database using a macro, but I get this error message: Safety settings on this computer prohibit accessing a data source on another domain.

Can anyone tell me if this is a QlikView Setting or a Setting on the server itself that needs to be changed?

Thanks!



8,548 Views
0 Likes
1 Solution

Accepted Solutions
biester
Specialist
Specialist
‎2009-10-13 07:40 PM

In response to

Seems to be an IE security issue. Try to adjust IE security settings for Local intranet - enable Access data sources across domains.

Regards,
Joachim

View solution in original post

4,472 Views
0 Likes
8 Replies
prasad
Contributor III
Contributor III
‎2009-10-13 04:24 AM

Hi,

This is something to do with user access rights on that computer, please check the user access rights on that server and retry. Thanks!

Regards,

Prasad

4,472 Views
0 Likes
Not applicable
‎2009-10-13 06:32 PM
Author

In response to prasad

Prasad,

Could you be a bit more specific. Where are the access rights located and on which computer the one that has the QlikView or the one that has the database?

I have also tried running this from the script (which gives no error message but does not add the row)







Insert:


 SQL

Test:

 LOAD *;
 
SQL




SELECT * FROM CPOE.dbo.TEST1; SQL INSERT INTO TEST1(VISIT_NUMBER,Comment,Flag1,YNFlag,CommentDtm) values('3456','Testing 345','1', 'YES',getdate());LOAD *;

I have tried running this from a macro which gives the error above. I can connect fine to the database in the QlikView script for selecting the data. I can add the row using SQL Server Management studio using the same username and password from the same machine.

I set the permissions on the settings tab on the script to "open database in read/write mode" and also checked the ""can execute external progams" box. I've checked the User Accounts settings on my machine and it is set to Administrator. I'm at a loss as to where else to look for "user access rights".





4,472 Views
0 Likes
biester
Specialist
Specialist
‎2009-10-13 07:40 PM

In response to

Seems to be an IE security issue. Try to adjust IE security settings for Local intranet - enable Access data sources across domains.

Regards,
Joachim

4,473 Views
0 Likes
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2009-10-13 07:52 PM

In response to biester

If you are running it as a macro from the local Developer, open the Module Editor in QlikView and check "Current Local Security" on the bottom left side. Make sure it says "Allow System Access".

Oleg Troyansky
Call me for expert support, performance tuning, advanced training and more!
4,472 Views
Not applicable
‎2009-10-13 08:47 PM
Author

In response to Oleg_Troyansky

Thanks Joachim and Oleg. I think it was a combination of both of these. It now works fine from the macro. It still doesn't work from the script but the macro was really where I wanted to use it anyway.

4,472 Views
0 Likes
Not applicable
‎2010-08-06 10:48 AM
Author

In response to

This post is in regard to using a SELECT statement to write back to a database table.

I was exploring how to update an iSeries table from Qlikview yesterday and noticed these posts. I know this is a little late, but better late than never.

I eventually was able to write to a database table. In addition to what you mention about the script setup that you used, you have to add ", mode is write" to the end of the ODBC statement in your script, after the user ID and password parameters, and set the ODBC connection definition up to allow for writes, ie not restrict to reads.

Jerry

Top 25 Contributor
Points 2,303
Reply More
Answered (Verified) biester replied on 10-13-2009 6:40 PM
Verified by vboone

Seems to be an IE security issue. Try to adjust IE security settings for Local intranet - enable Access data sources across domains.

Regards,
Joachim

Quick Reply
  • | Post Points: 7

Top 10 Contributor
Points 6,276
Reply More
Answered (Verified) Oleg Troyansky replied on 10-13-2009 6:52 PM
Verified by vboone

If you are running it as a macro from the local Developer, open the Module Editor in QlikView and check "Current Local Security" on the bottom left side. Make sure it says "Allow System Access".

Oleg Troyansky

Natural Synergies, Inc.

Quick Reply
  • | Post Points: 7

Not Ranked
Points 82
Reply Suggest as Answer More
vboone replied on 10-13-2009 7:47 PM

Thanks Joachim and Oleg. I think it was a combination of both of these. It now works fine from the macro. It still doesn't work from the script but the macro was really where I wanted to use it anyway.

Quick Reply
  • | Post Points: 1
Page 1 of 1 (6 items) | RSS

.

4,472 Views
0 Likes
Not applicable
‎2010-08-06 10:52 AM
Author

In response to

I was exploring how to update an iSeries table from Qlikview yesterday and noticed these posts. I know this is a little late, but better late than never.

I eventually was able to write to a database table. In addition to what you mention about the script setup that you used, you have to add

", mode is write"

to the end of the ODBC statement in your script, after the user ID and password parameters, and set the ODBC connection definition up to allow for writes, ie not restrict to reads.

Jerry

4,472 Views
0 Likes
Not applicable
‎2010-11-23 07:38 AM
Author

In response to Oleg_Troyansky

thank you OLEG

"Current Local Security" solved the problem

4,472 Views
0 Likes