Re: [Firebird-net-provider] Problem with |DataDirectory| keyword in connectionstring

2010-02-26 Thread Jiri Cincura
2010/2/26 Γιάννης Μπουρκέλης : > Is it possible to set the |DataDirectory| path at design time so that Visual > Studio Query builder translates |DataDirectory| to the correct path of > my project bin/Debug folder? Use a different connection string for development a deploy. -- Jiri {x2} Cincura (

Re: [Firebird-net-provider] Problem with |DataDirectory| keyword in connectionstring

2010-02-26 Thread Γιάννης Μπουρκέλης
Thanks Jiri, Using the method you suggested solved this issue. What I did was this: AppDomain.CurrentDomain.SetData("DataDirectory", My .Application.Info.DirectoryPath) The appication that uses the embedded firebird is called from another assembly and without the above line it was not working.

Re: [Firebird-net-provider] Problem with |DataDirectory| keyword inconnectionstring

2010-02-26 Thread Jiri Cincura
2010/2/26 Γιάννης Μπουρκέλης : > It is complaining that it cannot find fbembed.dll. > I placed the fbembed.dll inside System32 folder and now finds it. > But now it cannot find the database. > > Still searching Because one time the query (and connection) is executed by VS and other time by your ap

Re: [Firebird-net-provider] Problem with |DataDirectory| keyword in connectionstring

2010-02-26 Thread Jiri Cincura
2010/2/26 Γιάννης Μπουρκέλης : > Hello, > I am trying to connect to an embedded database using the |DataDirectory| > keyword but without success. Depends on what you expect or in what environment your application is running respectively. The |DataDirectory| is defined as AppDomain.CurrentDomain.Ge

Re: [Firebird-net-provider] Problem with |DataDirectory| keyword inconnectionstring

2010-02-26 Thread Γιάννης Μπουρκέλης
Thank you Rick, removing the |DataDirectory| completly made it work. The other problem now is that VS2008 Query builder cannot find the database. I am using the query builder to customaze the Datasets, Dataadapters etc. Dataadapters use the same connectionstring (embedded) It is complaining that

Re: [Firebird-net-provider] Problem with |DataDirectory| keyword inconnectionstring

2010-02-26 Thread Rick
Hello, >My connectionstring is: >User=SYSDBA;Password=masterkey;DataSource=localhost;Database=|DataDirectory|\Database.fdb;Dialect=3;Charset=UTF8;ServerType=1;pooling=false; How about trying... User=SYSDBA;Password=masterkey;DataSource=localhost;Database=YourDatabase.fdb;Dialect=3;Charset=UTF8;S

[Firebird-net-provider] Problem with |DataDirectory| keyword in connectionstring

2010-02-26 Thread Γιάννης Μπουρκέλης
Hello, I am trying to connect to an embedded database using the |DataDirectory| keyword but without success. My connectionstring is: User=SYSDBA;Password=masterkey;DataSource=localhost;Database=|DataDirectory|\Database.fdb;Dialect=3;Charset=UTF8;ServerType=1;pooling=false; The error I get when I

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Jiri Cincura
On Fri, Feb 26, 2010 at 19:47, Scott Price wrote: > The Documentation link on the official site still points to the 1.7 > documents.  Perhaps that needs updating if we are going to ask people to > refer to them?  To whom do we need to ask to have the link updated? To what you want to update it? A

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Scott Price
Jiri, The Documentation link on the official site still points to the 1.7 documents. Perhaps that needs updating if we are going to ask people to refer to them? To whom do we need to ask to have the link updated? Kind regards Scott :) On 26/02/2010 17:46, Jiri Cincura wrote: > On Fri, F

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Jiri Cincura
On Fri, Feb 26, 2010 at 15:45, Steve Boyd wrote: > Forgive me for being thick, but where in MSDN am I going to find Firebird > specific documentation?  I have looked at the various descriptions for > BeginTransaction in MSDN and none of them mention FbTransactionOptions or > even anything similar.

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Steve Boyd
Forgive me for being thick, but where in MSDN am I going to find Firebird specific documentation? I have looked at the various descriptions for BeginTransaction in MSDN and none of them mention FbTransactionOptions or even anything similar. Intellisense shows a BeginTransaction that takes an

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Jiri Cincura
On Fri, Feb 26, 2010 at 14:25, Steve Boyd wrote: > Where is the version 2 documentation? MSDN, as it's ADO.NET 2 compatible and of course the "intellisense" (or sources) or whatever it's called in Prism. -- Jiri {x2} Cincura (CTO x2develop.com) http://blog.cincura.net/ | http://www.ID3renamer.c

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Steve Boyd
That was the latest version I could find. Where is the version 2 documentation? Jiri Cincura wrote: On Thu, Feb 25, 2010 at 22:39, Steve Boyd wrote: I'll grant that I am not fully up to speed on .Net yet but I do know C# and Pascal. When I see the signature given by this manual page:

Re: [Firebird-net-provider] Using .Net provider with Delphi Prism

2010-02-26 Thread Jiri Cincura
On Thu, Feb 25, 2010 at 22:39, Steve Boyd wrote: > I'll grant that I am not fully up to speed on .Net yet but I do know C# and > Pascal.  When I see the signature given by this manual page: > > http://www.firebirdsql.org/dotnetfirebird/documentation/api/1.7/index.html > > public FbTransaction Begi