Firebird ODBC Connector DTC errors

[Stephen Williamson]

We have a linked server to a firebird database using the ODBC connector, I can query the server using openquery and create views that are running on the server

Both Databases, FB and SQL are on the same box

When I try to create a linked table in our ERP system, it tries to run the table, then creates errors, the query was rolled back, and the following one

the following sql error was unexpected, The operation could not be performed  because OLE DB Provider "MSDASQL" for linked server "FIREBIRD" was unable to begin a distributed transaction

I have read up on the error and tried everything I can find, DTCPing works correctly across both servers and no firewall is up.

Any advice

[Mark Rotteveel]

You might want to consider posting your question on the
firebird-odbc-devel list (see
https://sourceforge.net/projects/firebird/lists/firebird-odbc-devel).

It has been very quiet over there lately, but it is probably the better
place to ask your question there.

Mark
--
Mark Rotteveel

[P-Soft - Fabio Codebue]

Is there an ODBC driver I can use with filemaker?

Or some driver to connect firebird from Filemaker?

Fabio Codebue

P-SOFT di Codebue Fabio

Via Nuova n. 9 - 24060 Tavernola B.sca (BG)

P.I. 03624950162

C.F. CDBFBA72A11C618T

Mobile: +39.348.3515786

Fax: +39.030.5100306

Web: http://www.p-soft.biz

 

pec: amminis...@pec.p-soft.biz
cod.intermediario SDI: KRRH6B9
 

[Mark Rotteveel]

On 21-04-2021 16:45, P-Soft - Fabio Codebue wrote:
> Is there an ODBC driver I can use with filemaker?
> Or some driver to connect firebird from Filemaker?

I have no idea what Filemaker is, but if it can use ODBC, then you can
download the ODBC driver here: https://www.firebirdsql.org/en/odbc-driver/

You need to use the 32-bit or 64-bit variant depending on the bitness of
Filemaker.

Mark

--
Mark Rotteveel

[P-Soft - Fabio Codebue]

It's a Apple product

https://www.apple.com/it/shop/product/HP8H2ZM/A/claris-filemaker-pro-19

Fabio Codebue

P-SOFT di Codebue Fabio

Via Nuova n. 9 - 24060 Tavernola B.sca (BG)

P.I. 03624950162

C.F. CDBFBA72A11C618T

Mobile: +39.348.3515786

Fax: +39.030.5100306

Web: http://www.p-soft.biz

 

pec: amminis...@pec.p-soft.biz
cod.intermediario SDI: KRRH6B9
 

------ Messaggio originale ------

Da: "Mark Rotteveel" <ma...@lawinegevaar.nl>

A: firebird...@googlegroups.com

Inviato: 21/04/2021 17:11:10

Oggetto: Re: [firebird-support] Firebird connection from Filemaker app

-- You received this message because you are subscribed to the Google Groups "firebird-support" group.

To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/d300e992-0537-17d8-e52b-b5147f201676%40lawinegevaar.nl.

[Dimitry Sibiryakov]

21.04.2021 16:15, Mark Rotteveel wrote:
>> the following sql error was unexpected, The operation could not be performed  because
>> OLE DB Provider "MSDASQL" for linked server "FIREBIRD" was unable to begin a distributed
>> transaction
>>
>> I have read up on the error and tried everything I can find, DTCPing works correctly
>> across both servers and no firewall is up.
>

> You might want to consider posting your question on the firebird-odbc-devel list (see
> https://sourceforge.net/projects/firebird/lists/firebird-odbc-devel).

Better would be contact Microsoft support asking for a way to find out what exactly
error happen because quoted message is completely useless for investigation: ODBC as such
has no support for distributed transactions at all.

--
WBR, SD.

[Fred Evans]

Hello mark-
Sorry about this "stupid " question but please humour me !!
I am 79 years old and in my "youth" I did a lot of programming using various dos- based
Programming languages.
I haven’t programmed for many years and the new terminology has got me scratching my head
I read a lot about "ODBC drivers" . what is an ODBC driver and how is it used?
Regards

Fred

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/d300e992-0537-17d8-e52b-b5147f201676%40lawinegevaar.nl.

--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

[Mark Rotteveel]

On 2021-04-22 10:17, Fred Evans wrote:
> Hello mark-
> Sorry about this "stupid " question but please humour me !!
> I am 79 years old and in my "youth" I did a lot of programming using
> various dos- based
> Programming languages.
> I haven’t programmed for many years and the new terminology has got me
> scratching my head
> I read a lot about "ODBC drivers" . what is an ODBC driver and how is
> it used?

ODBC or Open DataBase Connectivity is a standard for database drivers.
It was created by Microsoft in the late '80s or early '90s for a common
API for database drivers.

See also this page from Microsoft:
https://docs.microsoft.com/en-us/sql/odbc/reference/what-is-odbc?view=sql-server-ver15
and the Firebird ODBC driver documentation:
https://www.firebirdsql.org/file/documentation/html/en/refdocs/fbodbc20/firebird-odbc-driver-20-manual.html

Mark

[Tomasz Tyrakowski]

On 22.04.2021 at 10:17, Fred Evans wrote:
> Hello mark-
> Sorry about this "stupid " question but please humour me !!
> I am 79 years old and in my "youth" I did a lot of programming using various dos- based
> Programming languages.
> I haven’t programmed for many years and the new terminology has got me scratching my head
> I read a lot about "ODBC drivers" . what is an ODBC driver and how is it used?
> Regards
>
> Fred

Maybe start here:

https://en.wikipedia.org/wiki/Open_Database_Connectivity

or here:

https://docs.microsoft.com/en-us/sql/odbc/reference/what-is-odbc?view=sql-server-ver15

and just follow the links if you get interested.

cheers
Tomasz
________________________________


Ta wiadomość zawiera poufne informacje przeznaczone tylko dla adresata. Jeżeli nie jesteście Państwo jej adresatem, bądź otrzymaliście ją przez pomyłkę, prosimy o powiadomienie o tym nadawcy oraz trwałe jej usunięcie.

[Fred Evans]

Thank you ver much

Regards

Fred


-----Original Message-----
From: firebird...@googlegroups.com <firebird...@googlegroups.com> On Behalf Of Tomasz Tyrakowski
Sent: 22 April 2021 14:38
To: firebird...@googlegroups.com
Subject: Re: [firebird-support] Firebird connection from Filemaker app

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/9ad372dc-be3b-cdc0-953c-010e2ed1bd00%40sol-system.pl.