Содержание
Информационно-справочная система
Фильтровать
Советы
Реклама
Наши партнеры
Установка FireBird ODBC драйвера
Для работы версии программы МедЗаказ Учет требуется установка FireBird ODBC драйвера.
2. Находим последнюю версию соответствующую Вашей операционной системы
3. Загружаем и устанавливаем драйвер на свой компьютер
4. После установки драйвера заходим в Панель управления — Администрирование — Источники данных (ODBC)
5. Добавляем источник данных. Параметры источника следующие:
Имя источника данных — CASH
База данных — путь к базе данных согласно правилам СУБД FireBird
Клиент — имя библиотеки для подключения к СУБД FireBird. Обычно это библиотека gds32.dll
Пользователь — обычно SYSDBA
Пароль — обычно masterkey
Символьная таблица — WIN1251
Свойства идентификатора — оставить галочку около "в кавычках", остальные убрать.
После выстановки всех параметров можно нажать кнопку "Проверка соединения". Должна выйти надпись об успешном соединении.
После настройки этих параметров программа регистратора версии выше 305 запустится успешно.
.NET libraries
OLE DB providers
ODBC drivers
Wrappers and others
Firebird ADO.NET Data Provider
Standard
Using the Firebird embedded server
It’s the key/value ServerType=1; that tells the driver it’s in embedded mode.
Disable pooling
IBPhoenix Open Source ODBC Driver (aka Firebird ODBC driver)
Local database Firebird
Remote connection to Firebird
The default TCP/IP port 3050 will be used.
Specifying TCP/IP port number
Using alias (aliases.conf)
Example record in aliases.conf, aliasname = C:databasemyData.fdb
Using alias (aliases.conf) for remote connections
Specifying dialect Firebird
SQL dialects were introduced in InterBase 6.0, to support a number of new SQL features including delimited identifiers.
DRIVER = Firebird/InterBase(r) driver; UID = SYSDBA; PWD = masterkey; DBNAME = C:databasemyData.fdb; DIALECT = 3;
DIALECT=1 — Parser processes as it did in InterBase V5.
DIALECT=2 — Transitional flagger. InterBaseV6, and Firebird flags ambiguous SQL constructs and issues an error or warning message.
DIALECT=3 — Parser processes anything delimited by single quotes as string constants and any thing delimited by double quotes as SQL delimited identifiers.
Autoquote identifiers
The driver will quote (") your table names in SQL statements automatically.
DRIVER = Firebird/InterBase(r) driver; UID = SYSDBA; PWD = masterkey; DBNAME = C:databasemyData.fdb; AUTOQUOTED = YES;
‘SELECT A.Field FROM Table A’ will be transformed into ‘SELECT "A.Field" FROM "Table" A’
Be aware that upper case SQL keywords must be used, ie SELECT and FROM etc, not Select and From, else transformation will fail.
Read Only connection (Firebird)
This one is for Firebird file with the .fdb extension.
DRIVER = Firebird/InterBase(r) driver; UID = SYSDBA; PWD = masterkey; DBNAME = C:databasemyData.fdb; READONLY = YES;
Return with error on lock conflict (Firebird)
Normally the transaction will wait if it encounters a lock conflict. This connection string will cause an error instead.
Wait timeout for error on lock conflict (Firebird)
Normally the transaction will wait if it encounters a lock conflict. This connection string will raise an error after 4 seconds.
.NET Framework Data Provider for ODBC
Use an ODBC driver from .NET
See the respective ODBC driver’s connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.
Join Firebird! |
Follow Us |
Newsletter |
Release Date | File Name | Size | Description |
Version 2.0.5 Release | |||
May 18, 2017 | changes-v20.log | 48 KB | What’s New, Log file, Text |
May 18, 2017 | OdbcJdbc-src-2.0.5.156.tar.gz | 1.4 MB | Source code |
May 18, 2017 | Firebird_ODBC_2.0.5.156_Win32.exe | 1.0 MB | Windows 32-bit Full Install |
May 18, 2017 | Firebird_ODBC_2.0.5.156_x64.exe | 1.6 MB | Windows 64-bit Full Install |
May 18, 2017 | OdbcFb_DLL_2.0.5.156_Win32.zip | 1.3 MB | Win 32-bit DLL |
May 18, 2017 | OdbcFb_DLL_2.0.5.156_x64.zip | 1.7 MB | Win 64-bit DLL |
May 18, 2017 | OdbcFb-LIB-2.0.5.156.i686.gz | 309 KB | Linux x86 Library |
May 18, 2017 | OdbcFb-LIB-2.0.5.156.amd64.gz | 348 KB | Linux AMD64 Library |
Version 2.0.4 Release | |||
March 9, 2016 | changes-v20.log | 46 KB | What’s New, Log file, Text |
March 9, 2016 | OdbcJdbc-src-2.0.4.155.tar.gz | 1.4 MB | Source code |
March 9, 2016 | Firebird_ODBC_2.0.4.155_Win32.exe | 1.0 MB | Windows 32-bit Full Install |
March 9, 2016 | Firebird_ODBC_2.0.4.155_x64.exe | 1.6 MB | Windows 64-bit Full Install |
March 9, 2016 | OdbcFb_DLL_2.0.4.155_Win32.zip | 1.3 MB | Win 32-bit DLL |
March 9, 2016 | OdbcFb_DLL_2.0.4.155_x64.zip | 1.7 MB | Win 64-bit DLL |
March 9, 2016 | OdbcFb-LIB-2.0.4.155.i686.gz | 309 KB | Linux x86 Library |
March 9, 2016 | OdbcFb-LIB-2.0.4.155.amd64.gz | 347 KB | Linux AMD64 Library |
Version 2.0.3 Release | |||
November 26, 2014 | changes-v20.log | 45 KB | What’s New, Log file, Text |
November 26, 2014 | OdbcJdbc-src-2.0.3.154.tar.gz | 1.1 MB | Source code |
November 26, 2014 | Firebird_ODBC_2.0.3.154_Win32.exe | 1.0 MB | Windows 32-bit Full Install |
November 26, 2014 | Firebird_ODBC_2.0.3.154_x64.exe | 1.6 MB | Windows 64-bit Full Install |
November 26, 2014 | OdbcFb_DLL_2.0.3.154_Win32.zip | 1.3 MB | Win 32-bit DLL |
November 26, 2014 | OdbcFb_DLL_2.0.3.154_x64.zip | 1.7 MB | Win 64-bit DLL |
November 26, 2014 | OdbcFb-LIB-2.0.3.154.i686.gz | 1.0 MB | Linux x86 Library |
November 26, 2014 | OdbcFb-LIB-2.0.3.154.amd64.gz | 1.4 MB | Linux AMD64 Library |
Version 2.0.2 Release | |||
July 08, 2013 | changes-v20.log | 44.3 KB | What’s New, Log file, Text |
July 08, 2013 | OdbcFb-Source-2.0.2.153.gz | 1.5 MB | Source code |
July 08, 2013 | Firebird_ODBC_2.0.2.153_Win32.exe | 10.0 MB | Windows 32-bit Full Install |
July 08, 2013 | Firebird_ODBC_2.0.2.153_x64.exe | 1.6 MB | Windows 64-bit Full Install |
July 08, 2013 | OdbcFb_DLL_2.0.2.153_Win32.zip | 1.3 MB | Win 32-bit DLL |
July 08, 2013 | OdbcFb_DLL_2.0.2.153_x64.zip | 1.7 MB | Win 64-bit DLL |
July 08, 2013 | OdbcFb-LIB-2.0.2.153.i686.gz | 306.4 KB | Linux x86 Library |
July 08, 2013 | OdbcFb-LIB-2.0.2.153.amd64.gz | 344.0 KB | Linux AMD64 Library |
Version 2.0.1 Release | |||
March 19, 2012 | changes-v20.log | 42.2 KB | What’s New, Log file, Text |
March 19, 2012 | OdbcFb-Source-2.0.1.152.tar.gz | 4.5 MB | Source code |
March 19, 2012 | Firebird_ODBC_2.0.1.152_Win32.exe | 989.7 KB | Windows 32-bit Full Install |
March 19, 2012 | Firebird_ODBC_2.0.1.152_x64.exe | 1.5 MB | Windows 64-bit Full Install |
March 19, 2012 | OdbcFb_DLL_2.0.1.152_Win32.zip | 1.3 MB | Win 32-bit DLL |
March 19, 2012 | OdbcFb_DLL_2.0.1.152_x64.zip | 1.7 MB | Win 64-bit DLL |
March 19, 2012 | OdbcFb-LIB-2.0.1.152.i686.gz | 306.9 KB | Linux x86 Library |
March 19, 2012 | OdbcFb-LIB-2.0.1.152.amd64.tar.gz | 344.3 KB | Linux AMD64 Library |
Version 2.0 Release from Alexander Potapchenko |
|||
April 04, 2011 | changes-v20.log | 38 KB | What’s New, Log file, Text |
April 04, 2011 | OdbcFb-Source-2.0.0151.tar.gz | 1.4 MB | Source code |
April 04, 2011 | Firebird_ODBC_2.0.0.151_Win32.exe | 966 KB | Windows 32-bit Full Install |
April 04, 2011 | Firebird_ODBC_2.0.0.151_x64.exe | 1.5 MB | Windows 64-bit Full Install |
April 04, 2011 | OdbcFb_DLL_2-0-0151_Win32.zip | 1.3 MB | Win 32-bit DLL |
April 04, 2011 | OdbcFb_DLL_2-0-0151_x64.zip | 1.7 MB | Win 64-bit DLL |
April 04, 2011 | OdbcFb-LIB-2.0.0151.i686.gz | 307 KB | Linux x86 Library |
April 04, 2011 | OdbcFb-LIB-2.0.0151.amd64.tar.gz | 344 KB | Linux AMD64 Library |
Version 2.0 Release Candidate 2 (RC2) from Alexander Potapchenko |
|||
November 16, 2010 | changes-v20.log | 38 KB | What’s New, Log file, Text |
November 16, 2010 | OdbcFb-Source-RC2-2.0.0150.tar.gz | 2 MB | Source code |
November 16, 2010 | Firebird_ODBC_2.0.0.150_Win32.exe | 966 KB | Windows 32-bit Full Install |
November 16, 2010 | Firebird_ODBC_2.0.0.150_x64.exe | 2 MB | Windows 64-bit Full Install |
November 16, 2010 | OdbcFb_DLL_RC2_2-0-0150_Win32.zip | 2 MB | Win 32-bit DLL |
November 16, 2010 | OdbcFb_DLL_RC2_2-0-0150_x64.zip | 2 MB | Win 64-bit DLL |
November 16, 2010 | OdbcFb-LIB-RC2-2.0.0150.i686.tar.gz | 299 KB | Linux x86 Library |
November 16, 2010 | OdbcFb-LIB-RC2-2.0.0150.amd64.tar.gz | 335 KB | Linux AMD64 Library |
Version 2.0 Release Candidate 1 (RC1) First V.2 release candidate from Alexander Potapchenko |
|||
November 19, 2008 | changes-v20.log | 36 KB | What’s New, Log file, Text |
November 19, 2008 | OdbcFb-Source-RC1-2.0.0148.tar.gz | 2 MB | Source code |
November 19, 2008 | Firebird_ODBC_2.0.0.148_win32.exe | 545 KB | Windows 32-bit Full Install |
November 19, 2008 | Firebird_ODBC_2.0.0.148_x64.exe | 783 KB | Windows 64-bit Full Install |
November 19, 2008 | OdbcFb_DLL_RC1_2-0-0148_Win32.zip | 297 KB | Win 32-bit DLL |
November 19, 2008 | OdbcFb_DLL_RC1_2-0-0148_x64.zip | 351 KB | Win 64-bit DLL |
November 19, 2008 | OdbcFb-LIB-RC1-2.0.0148.i686.tar.gz | 248 KB | Linux x86 Library |
November 19, 2008 | OdbcFb-LIB-RC1-2.0.0148.amd64.tar.gz | 284 KB | Linux AMD64 Library |
Version 2.0 Beta | |||
Please regard this set as superseded. It will be removed when the Release Candidate cycle is completed. | |||
September 5, 2007 | v2-0-beta.log | 28 KB | What’s New, Log file, Text |
September 5, 2007 | Firebird_ODBC_2.0.0-Win32.exe | 501 KB | Windows 32-bit Full Install |
September 5, 2007 | OdbcFb32_DLL_Beta_2-0-0144.zip | 248 KB | Windows 32-bit DLLs |
September 5, 2007 | OdbcFb32_Source_Beta_2-0-0144.zip | 1060 KB | Windows 32-bit Source code |
September 5, 2007 | OdbcFb32-beta-2.0.0144.tar.gz | 433 KB | Linux x86 Shared Libraries |
September 5, 2007 | OdbcFb32-beta-2.0.0144-src.tar.gz | 811 KB | Linux x86 Source code |
Version 1.x Beta, Most Recent | |||
June 6, 2006 | OdbcJdbc_DLL_Beta_1-3.zip | 217 KB | Windows 32-bit DLLs |
June 6, 2006 | OdbcJdbc_Source_Beta_1-3.zip | 255 KB | Windows 32-bit Source code |
June 6, 2006 | OdbcJdbc-beta-1.3.0096.tar.gz | 969 KB | Linux x86 Shared libraries |
June 6, 2006 | OdbcJdbc-beta-1.3.0096-src.tar.gz | 736 KB | Linux x86 Source code |
Version 1.2 | |||
September 5, 2004 | OdbcJdbc_dll-1-2-1.zip | 197 KB | Windows 32-bit DLLs |
September 5, 2004 | OdbcJdbc_Source-1-2-1.zip | 255 KB | Windows 32-bit Source code |
September 5, 2004 | v1-2-1-beta.log | 21 KB | Change log, Text |
August 26, 2004 | Firebird_ODBC_1.2.0.69-Win32.exe | 596 KB | Windows 32-bit full install |
August 26, 2004 | v1-2-1-beta.log | 243 KB | Linux x86 Full install |
August 26, 2004 | OdbcJdbc_1.2.0.69.src.tar.gz | 347 KB | Linux x86 Source code |
Supporting Documentation | |||
November 25, 2017 | Firebird ODBC/JDBC Driver Manual (in Documentation Library) |
On-line, PDF (824 Kb) and CHM (in zipfile, 845 Kb) (English) | |
December 23, 2004 | OdbcJdbcHtmlHelp.zip | 22 KB | Windows HTML Help Files (English) |
December 23, 2004 | OdbcJdbcHtmlHelpEs.zip | 15 KB | Windows HTML Help Files (Spanish) |
December 23, 2004 | OdbcJdbcHtmlHelpPt.zip | 16 KB | Windows HTML Help Files (Portuguese) |
December 23, 2004 | OdbcJdbcHtmlHelpRu.zip | 168 KB | Windows HTML Help Files (Russian) |
December 23, 2004 | OdbcJdbcHtmlHelpUk.zip | 170 KB | Windows HTML Help Files (Ukrainian) |
February 22, 2003 | OdbcJdbc_Examples.zip | 27 KB | Use SQLPutData and SQLGetData, SQLBindCol, SQLBindParam (for blob TEXT and blob BLR), insert procedure, select data from procedure (suspend), select data from execute procedure (1 row). Using multiple threads over a single connection. Two phase commit. |
December 17, 2003 | OdbcJdbc_ExamplesAdo.zip | 7 KB | This sample demonstrates the use of ADO from VBScript and HTML, and shows how VBScript and HTML on the client can be used to build a two tier web application for an Intranet. |
October 17, 2007 | Installing Firebird ODBC driver on Ubuntu Linux from Source | Detailed how-to by Marius Popa |
Developers
If you are cons >or
- You can also fork the project on GitHub
- There is an MSVC workspace for building the driver for Win32. Make OdbcJdbcSetup the active project and do a build all. There are also make files for other platforms (e.g. Linux and FreeBSD).
Support and Development list
Subscribe to the firebird-odbc-devel list server dedicated to the discussion of driver development and usage issues.
Open Source Licensing
The driver source is available under the Initial Developers Public Licence (IDPL), a variant of the InterBase Public Licence (IPL) that is a variant of the Mozilla Public License 1.1. To read the licences, click here.