Thank you Carlos.
This problem got solved by adding the path of the embedded server file as in
"C:\DMFCC.fdb" in the connection string.
The reason why this was happening is that when the application uses an
OpenFileDialog and the user chooses a file in a directory that is not the
same as the directory as the Database file, the connection fails.
I think this is not good as the documentation states that the path of the
fdb file would be relative to the "Server executable or FBEmbed" and this
doesn't seem to work accordingly. Common file dialogs seem to change the
working directory which caused this problem.
The solution as I found out was to include the complete path of the database
file and not use relative paths (relative to the application exe file) as
this doesn't work.
Thanks anyhow.
- S
Message: 1
Date: Tue, 18 Jul 2006 15:36:36 +0200
From: Carlos Guzm?n ?lvarez <[EMAIL PROTECTED]>
Subject: Re: [Firebird-net-provider] Help: FBException - : I/O error
for file CreateFile (open)
To: "For users and developers of the Firebird .NET providers"
<[email protected]>
Message-ID: <[EMAIL PROTECTED]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello:
>
>
>
connectionString="ServerType=1;User=sysdba;Password=masterkey;Dialect=3;Data
base=DMFCC.fdb;Connection
> lifetime=15;Pooling=true;MinPoolSize=0;MaxPoolSize=100"
>
It maybe some connection is being done from a different process and the
embedded server didn't support that
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider