SQL permissions error

Created at 10 Sep 2019, 20:31
Subscribe
How’s your experience with the cTrader Platform?
Your feedback is crucial to cTrader's development. Please take a few seconds to share your opinion and help us improve your trading experience. Thanks!
CA

calgodemo

Follow

Joined 28.05.2019

SQL permissions error
10 Sep 2019, 20:31

Hi everyone,

Trying to write some indicator outputs to a DB and I get the following error when I try to open the connection:

 

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.'

I've done some research into this and the internet suggests I change the security on the project to full access, only the security tab where this setting resides doesn't exist when I go to the project settings. 

I've seen on here others are connecting to Sql databases, how?!

Thanks!

CaD

 

@calgodemo
Replies

PanagiotisCharalampous
11 Sep 2019, 08:26

Hi calgodemo,

Did you try changing the access rights of the cBot to FullAccess? See below

namespace cAlgo.Robots
{
    [Robot(TimeZone = TimeZones.UTC, AccessRights = AccessRights.FullAccess)]
    public class NewcBot : Robot
    {

Best Regards,

Panagiotis

@PanagiotisCharalampous

calgodemo
11 Sep 2019, 20:20

That did it - Thanks!

I think what threw me off was in doing my research I saw other indicators/bots where the access level was still set to none. I don't know but your suggestion has fixed it for me. 

Much appreciated!

CaD

@calgodemo
Copyright © 2024 Spotware Systems Ltd. All rights reserved.
The services provided by Spotware Systems Ltd. are not available to citizens or residents of the USA. Neither is the information on our websites directed toward soliciting citizens or residents of the USA.