Subject Re: [IBO] CreateDatabase() causing AV
Author Sampo Ahokas
Helen,

Thank you for the quick reply and bunch of helpful information. However,
I managed to track the problem down a bit, and seems that it is caused
by something else.

Appears that if I just start the app and run the above mentioned piece
of code, no firebird client DLL is loaded at all. Thus, if I connect (or
try to) connect to a database first, it will cause the DLL to be loaded
and after that database creation works just fine.

This is easy work-around for the original problem, but I wonder if I
have missed something. Is it ok to just try to create a database as
first thing or am I supposed to do some kind of initialization first?

>> At that point CreateString is as follows:
>> 'CREATE DATABASE 'E:\ibotest\testi1.fdb' USER 'sahokas' PASSWORD
>> 'salasana' PAGE_SIZE = 1024'
>
> Where are you reading this string?
>
>> The exactly same string (without ' in the beginning and end of course)
>
> The "string" that works is a valid SQL statement. If the above

It was taken using a "watch" in Delphi's debugger, and indeed what I was
trying to clarify was that the SQL statement itself was formed correctly
and the problem was caused by something else.

> Also, you don't mention whether you are running a Classic or
> Superserver. If it is a Classic server, then cpLocal is not
> supported. For a local connection to a Classic server you must use
> cpTCP_IP as your protocol and provide 'localhost' or '127.0.0.1' as
> the Server property.

Actually I have no server installed at all on the machine where I am
doing the development on, wanted to make sure the app works with just
the minimum DLLs installed in the app directory.


-Sampo