1. marko
  2. Valentina Studio
  3. 月, 5月 06 2024, 09:33 AM
  4.  メールで購読
Has anyone used valentina studio to design firebirdSQL databases?
I have an application that will used embedded local firebird engine as I need more than SQLite.
Can I connect and push sql to create tables via the ODBC connection?
Another option would be to design and create on Postgresql then migrate when the app is mature.

I would appreciate any thoughts on this approach.

thanks
Marko
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Hello Marko,

Yes, I have just tried the Firebird ODBC driver with Valentina Studio and it works.
It is possible to execute commands and receive results in the SQL Editor.
However, as I understand it, only individual commands are supported by the driver.

I noticed that it is necessary to specify the full path in the DSN configuration.
添付ファイル
コメント
There are no comments made yet.
marko 承諾済みの回答
Thanks Sergey,

we are on linux platform. I have linuxodbc working with connection to the firebird server and database and can query via the isql utility. DSN is specified in the /etc/odbc.ini file.

When I attempt valentina studio "Connect to a database server", ODBC the DSN dropdown is not populated and I cannot enter a DSN manually.
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
The unixODBC package is installed, correct?
Which distribution is being used?
コメント
There are no comments made yet.
marko 承諾済みの回答
yes, unixODBC is installed correctly and I can query via the command line odbc isql tool.


I'm on kubuntu 23.10.

I have attached a screen shot and /etc/odbc.ini contains:

[employee]
Description = Firebird
Driver = Firebird
Dbname = localhost:/var/lib/firebird/3.0/data/employee.fdb
User = SYSDBA
Password = *******
Role =
CharacterSet =
ReadOnly = No
NoWait = No
添付ファイル
コメント
There are no comments made yet.
  • ページ :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories