Firebird 2.0 Errors

[sandeep_c24]

Hi

I have an application using Zeos and it works fine with FB1.5, but doesn't work at all with FB2.0.1.

I have "CreateNewDataBase=..." in TZConnection's Properties property and I get following exception when I try to connect.

Project TestApp.exe raised exception class EZSQLException with message 'SQL Error: unavailable database. Error Code: -904. Unsuccessful execution caused by an unavailable resource.'.

The above works fine with FB1.5.

Regards

Sandeep

[gto]

It's the connection property localhost
With firebird 2, apparently, you cannot create a local connection. So, fill the localhost parameter with your network IP or 127.0.0.1 (loop back) may resolve your problem.

[sandeep_c24]

That didn't work. Is there anything else I should try?

Regards

Sandeep

[firstrose]

Use absolute pathes for your database.

None business of local connection.I do use localhost and it works well on Firebird 2.0.1

[Bottleneck]

Hello everybody

to create a new Database try this code.
Put Create string into connection properties. Works fine with Firebird.


ZConnection1.Database := 'd:\db1.fdb';
ZConnection1.Protocol := 'firebird-1.5';
ZConnection1.Properties.Add ('CreateNewDatabase=CREATE DATABASE ' +
QuotedStr ('d:\db1.fdb') + ' USER ' +
QuotedStr ('sysdba') + ' PASSWORD ' + QuotedStr ('masterkey') +
' PAGE_SIZE 4096 DEFAULT CHARACTER SET ISO8859_1');
ZConnection1.Connect;



Regards
Peter