?
Solved

Firebird error with Terminal Services

Posted on 2007-10-17
5
Medium Priority
?
3,587 Views
Last Modified: 2013-12-09
I am running Firebird 1.5.3 on a windows2003 server with terminal services. Firebird is installed as a service. The frontend of the program is written in Delphi7. Clients connect through with remote desktop via terminal services. When I try to run the application I get the following error when the program reaches the point where it tries to open the firebird database: "operating system directive CreateFile failed. The requested operation cannot be performed on a file with a user-mapped section open"
0
Comment
Question by:emocke
4 Comments
 
LVL 19

Expert Comment

by:NickUpson
ID: 20094809
THis sounds like:
a) the database is on a mapped-drive, this is not permitted
b) the database has not been excluded from virus-scanning
c) you are attempting to connect without including the machine name in the path, please show your connection string
0
 
LVL 19

Expert Comment

by:Gary Benade
ID: 20099275
This is a know problem for local connections in terminal services, try changing the firebird.conf file add or change the following line:
IpcName = Global\FIREBIRD
0
 

Accepted Solution

by:
emocke earned 0 total points
ID: 20099444
Figured it out after a few hours trying all different solutions. In the end it worked when I installed firebird as the administrator running as a service. The problem was caused by me trying to install firebird through terminal services instead of at the console. It also has to be installed as a service, installing it as an application causes the error after the third or fourth person logs in. Because I didn't have physical access to the machine I used VNC instead of Remote Desktop. Everything works fine now.
0
 
LVL 1

Expert Comment

by:Vee_Mod
ID: 20176494
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question