Subject Re: [firebird-support] Firebird protocol
Author Helen Borrie
At 03:51 PM 23/10/2007, you wrote:
>Does anybody have protocol format ? Which bit location stands for what ?
>
>I was just tested with traffic. Now i know somewhat about 4 byte
>request-- then some id's and length and later other data.
>
>But i dont exactly how the id and length stands for.

You can study the IB6.0 Beta docs ApiGuide.pdf document to see what those connection structures are.

>Now lets talk
>about connect method.
>
>The request is 0x 00 00 00 01 after that comes service name and then
>user name. But i dont the rest part. Can anybody tell me what will be
>the packet format for connect to database?

You don't need to know it. Firebird has an API that is surfaced in the client library. The API translation for Perl has already been done (to a great degree).

>Also does anyone know perl script to access remote database ?

If you speak Perlspeak, you would probably work out quite a bit from studying the DBD::Interbase code that Ed Pratomo has developed from the past works of Bill Karwin, who originally developed a connectivity layer for Perl 5 and Interbase. 5.x I don't think Bill actively maintains IBPerl these days but the stuff that Ed has produced is here:

http://www.cpan.org/modules/by-authors/id/E/ED/EDPRATOMO/

You can find all of the C defines, macros, et al., in ibase.h, in Firebird's /include/ directory.

./heLen