[Firebird-odbc-devel] Connection problem

[Johan A. <jo...@an...>]

Hi

On server machine I got firebird version 2.0.4.13130 installed, and I 
can connect to my database with ib_sql and my own application on that 
machine.

On client machine I have the latest firebird odbc driver installed and I 
have fbclient.dll version 2.0.4.13130 in  folder C:\windows\system32. I 
had the firebird engine installed on it before, but I uninstalled it. I 
can't connect to the database on my server machine or my client machine 
using ib_sql, odbc driver or my own application.

Is there a way to solve? What files should I have and what do I have to 
get rid of?

// Johan

Helen Borrie skrev:
> At 06:56 AM 24/06/2008, you wrote:
>   
>> Hi, i get this error when trying to connect using firebird odbc driver 
>> to a remote firebird database:
>>
>> odbc_pconnect() [function.odbc-pconnect]: SQL error: [ODBC Firebird 
>> Driver]unsupported on-disk structure for file [...]; found 32779.10, 
>> support 0.0, SQL state 08004 in SQLConnect in
>>
>> It's the latest drivers of both odbc and firebird engine on both client 
>> and server machine. I can connect to the database with ib_sql on my 
>> server machine without any problems.
>>
>> What could be wrong?
>>     
>
> The error happens when the on-disk structure (ODS) of the database is higher than is supported by the server version. 
>
> It would occur if, for example, you had created or restored the database on a machine that was running Fb 2 and you just copied that database to the remote machine, where Fb 1.5 is running.  That's because Fb 2 creates a database with an ODS of 11.0, whereas Fb 1.5 can't read one with an ODS higher than 10.1.  IB_SQL shows you the ODS on the Characteristics tab.
>
>   
>> And another question: what exactly do I need to install on my client 
>> machine, except the odbc driver, to be able to remotely connect to a 
>> firebird database?
>>     
>
> Well, the fact that you are running a Firebird server on the client machine makes one a little suspicious.  On a Windows client, you need fbclient.dll and the relevant Microsoft runtimes, nothing more.  (*Which* Microsoft runtimes depends on the build version of fbclient.dll).
>
> Helen
>
> -------------------------------------------------------------------------
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services for
> just about anything Open Source.
> http://sourceforge.net/services/buy/index.php
> _______________________________________________
> Firebird-odbc-devel mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel
> ------------------------------------------------------------------------
>
>
> No virus found in this incoming message.
> Checked by AVG. 
> Version: 8.0.101 / Virus Database: 270.4.1/1516 - Release Date: 2008-06-24 07:53