Skip to main content
Question

Unable to store connection

markcoopersdc
Contributor
Forum|alt.badge.img+6

Hi

I am currently trying to create a web connection in FME desktop but it says the following:

 

Unable to store connection. Please try again

SQL Query INSERT INTO fme_nc_namedconnections (connectionname, username, servicename, connectiontype) VALUES (?, ?, ?, ?) failed. Error: attempt to write a readonly database

 

This happens with any connection type I try with this particular windows user account. If I log in with a different account, I am able to save the connection, but I no longer use that account and need to run it through this one.

 

Does anyone know how to resolve this please?

 

Thanks

 

 

david_r
Evangelist

Sounds like a permissions issue on the file containing the named connections.

markcoopersdc
Contributor
Forum|alt.badge.img+6
david_r wrote:

Sounds like a permissions issue on the file containing the named connections.

I think you are right. Don't suppose you know how to fix that?

ebygomm
Influencer
Forum|alt.badge.img+32
  • ebygommInfluencer
  • Influencer
  • May 12, 2023

Have you checked what the Default Paths are set to in options?

david_r
Evangelist
markcoopersdc wrote:

I think you are right. Don't suppose you know how to fix that?

Depends on your OS and your network configuration, as well as what you're allowed to do (your own permissions). I suspect the best solution would be to talk to your IT support people.

markcoopersdc
Contributor
Forum|alt.badge.img+6
ebygomm wrote:

Have you checked what the Default Paths are set to in options?

Is it the fme_privatekey.jceks file that it is saved to? If so, this user has full control of the file according to explorer

Reply


Helpful Members This Week

Community Stats

31,031
Posts
117,601
Replies
38,810
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.