Question

Unable to store connection

  • 12 May 2023
  • 5 replies
  • 17 views
markcoopersdc
Rank
Badge +4

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

 

 

5 replies

david_r
Rank
Userlevel 4

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

markcoopersdc
Rank
Badge +4

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
Rank
Userlevel 1
Badge +21

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

david_r
Rank
Userlevel 4

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
Rank
Badge +4

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


Community Stats

28,724
Posts
109,519
Replies
36,564
Members
Terms & ConditionsCookie 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.