CODEWITHSUNDEEP
firebirdfirebird-3.0firebird-.net-provider
Netstrata
Netstrata

Reputation: 75

FirebirdSql Data Client I/O error during "CreateFile (open)" operation for file

One of our clients is getting this error very randomly. Once or twice a week. It has only been happening for the last month or so.

Error message: 
I/O error during "CreateFile (open)" operation for file "ttt"
Error while trying to open file
Stack trace:
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()
   at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnection(FbConnectionString connectionString, FbConnection owner)
   at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.CreateNewConnectionIfPossibleImpl(FbConnectionString connectionString, FbConnection owner)
   at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Pool.GetConnection(FbConnection owner)
   at FirebirdSql.Data.FirebirdClient.FbConnectionPoolManager.Get(FbConnectionString connectionString, FbConnection owner)
   at FirebirdSql.Data.FirebirdClient.FbConnection.Open()
   at TTT.DALFirebird.FbSocket.ExecuteScalar(CommandType commandType, String commandText, String connectionString, FbParameter[] parameters)
   at TTT.LibGlobal.Data.FirebirdHelper.TestConnection(String connectionString)
------
Error message: 
I/O error during "CreateFile (open)" operation for file "ttt"
Error while trying to open file
Stack trace:
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ProcessResponse(IResponse response)
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadResponse()
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadGenericResponse()
   at FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.Attach(DatabaseParameterBuffer dpb, String dataSource, Int32 port, String database)
   at FirebirdSql.Data.FirebirdClient.FbConnectionInternal.Connect()

The database is hosted on a dedicated PC with Windows 8.1.

Firebird version: 3.0.7.33374 (x64)

Firebird Sql Data Client version: 4.6.1.0

I checked the security settings for the database file and gave full control for the system and users. Not sure what else it could be as the 3050 port is open and there's no issue with users connecting 99% of the time. Is a particular test their I.T. can run to diagnose?

The connection string for the desktop application is:

dialect=3;initial catalog=<Database Alias>;data source=<IP ADDRESS>;user id=<User>;password=<Password>;character set=ISO8859_1;pooling=True;connection lifetime=30;server type=Default;port number=3050

Please let me know if you require any further information.

Upvotes: 2

Views: 7559

Answers (1)

user13964273
user13964273

Reputation: 1221

They are trying to connect to database "ttt". This database (or alias) is not found so they get the error. As the developer of the application you should know what "TTT" object in the call stack may be and how connection string is formed.

Upvotes: 1

Related Questions