topic Write back to Database in QlikView

Write back to Database

Tue, 13 Oct 2009 02:08:58 GMT

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!

Write back to Database

prasad — Tue, 13 Oct 2009 08:24:30 GMT

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

Write back to Database

Tue, 13 Oct 2009 22:32:15 GMT

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".

Write back to Database

biester — Tue, 13 Oct 2009 23:40:13 GMT

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

Regards,
Joachim

Write back to Database

Oleg_Troyansky — Tue, 13 Oct 2009 23:52:14 GMT

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".

Write back to Database

Wed, 14 Oct 2009 00:47:10 GMT

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.

Write back to Database

Fri, 06 Aug 2010 14:48:39 GMT

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

Points 2,303

Reply More

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

Points 6,276

Reply More

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

Points 82

Reply Suggest as Answer More

vboone replied on 10-13-2009 7:47 PM

Quick Reply

| Post Points: 1

Previous | Next

Page 1 of 1 (6 items) | RSS

Community

Home Forums Blogs Share QlikViews User Groups Wiki Getting Started

Forums » QlikView Product Forums » QlikView Desktop (Developer/Professional/Analyzer) » Write back to Database

RSS Feed

Write back to Database

Fri, 06 Aug 2010 14:52:55 GMT

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

Write back to Database

Tue, 23 Nov 2010 12:38:19 GMT

thank you OLEG

"Current Local Security" solved the problem

topic Write back to Database in QlikView

Write back to Database

Write back to Database

Write back to Database

Write back to Database

Write back to Database

Write back to Database

Write back to Database

jmgarwood

Edit

Conversations

Friends

Change Password

Sign Out

Customer Portal

Phone & Email Support

Product Upgrades

Downloads

Partner Portal

Call +1 (888) 828-9768 (N. America)

Contact QlikView Sales

Contact QlikView Support

Directory of Worldwide Offices

Directory of Worldwide Offices

Find a Partner

Our Product

Our Solutions

Our Customers

Experience QlikView

Resource Library

How to Buy

Write back to Database

Write back to Database