firebirdsql: db.Ping() returns Error op_response:92 for Firebird 3.0

Hello, I’ve been using this library to connect to a few different FirebirdSQL databases and came across this error. I’m using go1.19 and sqlx to connect to the databases.

Basically, I’m just creating the sqlx.DB connections, and if no error occurred, call db.Ping() to check if it can connect to the database.

The first FirebirdSQL databases that I tested were running with firebird version 2.5 and had no issues with the Ping() and further operations, however, testing with two different databases running with firebird 3.0 returned the error Error op_response:92 after db.Ping()

I’m using the connection string as instructed in the README with no params. In the cases that the error occurred with firebird 3.0, both the application and database were running on Windows 10

db, err = sqlx.Open("firebirdsql", "user:password@localhost:3050/C:\\path\\to\\database"
if err != nil {
	return nil, err
}

db.SetMaxOpenConns(10)
db.SetMaxIdleConns(10)
db.SetConnMaxLifetime(5 * time.Minute)

err = db.Ping() // <- returns Error op_response:92
if err != nil {
	return
}

I need some help understanding what is causing this error and how to resolve it, I couldn’t find anything related in the issues, is there any configs or params that I’m missing? Please let me know if you need more info.

About this issue

  • Original URL
  • State: closed
  • Created a year ago
  • Comments: 15 (8 by maintainers)

Most upvoted comments

You may want to specify Srp in auth_plugin_name as follows.

db, err = sqlx.Open("firebirdsql", "user:password@localhost:3050/C:\\path\\to\\database?auth_plugin_name=Srp"