Thread: [Firebird-net-provider] question

A powerful, cross platform, SQL database system

Brought to you by: alexpeshkoff, asfernandes, awharrison, cincura_net, and 5 others

firebird-net-provider

[Firebird-net-provider] question

From: Pavol S. <pa...@st...> - 2003-02-04 11:20:53

i downloaded fresh CVS and i have problem with connection to database:

it was working with older version :(

using Firebird 1.5 beta1

Unhandled Exception: System.TypeLoadException: Invalid PInvoke metadata 
format.
    at FirebirdSql.Data.Firebird.ConnectionPool.Create(Byte dialect, 
String chars
et, String role, String user, String password, String database)
    at FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(Byte dialect, 
String cha
rset, String role, String user, String password, String database, Int64 
lifetime
)
    at FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(Byte 
dialect, Str
ing charset, String role, String user, String password, String database, 
Int64 l
ifetime)
    at FirebirdSql.Data.Firebird.FbConnection.Open()
    at NovyCas.DBArticle.GetArticle(Int32 iID) in 
C:\Projekty\NetStarek\NovyCas\D
BArticle.cs:line 157
    at NovyCas.DBArticle..ctor(Int32 iID) in 
C:\Projekty\NetStarek\NovyCas\DBArti
cle.cs:line 136
    at Tests.TestDBArticleConstructor() in 
C:\Projekty\NetStarek\Tests\Main.cs:li
ne 9
    at Tests.Main(String[] args) in 
C:\Projekty\NetStarek\Tests\Main.cs:line 42

[Firebird-net-provider] question

From: nasim H. <nas...@gm...> - 2007-12-15 09:48:02

hi;

i have some question aboute firebird(installation and connection)
i have just a datababe(DB.fdb file) and .dll file of database.
can i connect to it without install firebird or not?
and what OS regired ?
i search a provider to connect to firebird with c#.what is differnt between
ibprovider(LCPI.IBProvider) and FirebirdNETProvider1.7?
i don't konw how do i use these providers?
and i don't konw what is client library?

plz help me an guide me.i have any information about connect to firebird.

best ragrds,

Re: [Firebird-net-provider] question

From: Jiri C. <di...@ci...> - 2007-12-15 11:23:22

On 12/15/07, nasim Hemmati <nas...@gm...> wrote:
> i have just a datababe(DB.fdb file) and .dll file of database.

You mean DLL of Firebird, right?

> can i connect to it without install firebird or not?

You can use Firebird Embedded; FirebirdClient supports it.

> and what OS regired ?

FirebirdClient is limited only to place where .NET FW can be
installed. Firebird Embedded builds you can find on firebirdsql.org
site.

>  i search a provider to connect to firebird with c#.what is differnt between
> ibprovider(LCPI.IBProvider) and FirebirdNETProvider1.7?

http://downloads.sourceforge.net/firebird/FirebirdClient-2.1.0.msi?use_mirror=osdn

> i don't konw how do i use these providers?
> and i don't konw what is client library?
>
> plz help me an guide me.i have any information about connect to firebird.
>
> best ragrds,
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>


-- 
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] question

From: nasim H. <nas...@gm...> - 2007-12-15 16:53:31

Hi;
I have some question again about installation DDEX provider and thanks for help;
I found this guide for installation but have some problem about it;

*      DDEX and Firebird .NET Data Provider
*         Well, in this article I'm going do describe step-by-step
how-to add     *Firebird .NET Data Provider into Visual Studio 2005.
So I assume, I have   *downloaded and installed the provider (be sure
that's for .NET2).
*You have to download the VS SDK (not the Framework SDK). It's
available on *MSDN.
*It's not the standard part of installation.

In my MicrosoftVisualStudio Directory exist sdk direc , is this VS SDK?

*Check whether (installation should add them in) the provider
assemblies are in *GAC (you can use the gacutil util from provider
directory or the Framework GUI). *You have to focus to
FirebirdSql.Data.FirebirdClient (gacutil.exe /l
*FirebirdSql.Data.FirebirdClient).

What is GAC and where is it?

*Locate your machine.config and add into <configuration> -> <configSections>
*add <section name="firebirdsql.data.firebirdclient"
*type="System.Data.Common.DbProviderConfigurationHandler, System.Data,
*Version=2.0.0.0, Culture=neutral,
*PublicKeyToken=PublicKeyToken_of_System.Data_assembly" />.

What's the meaning of machine.cofig and where do I copy these sentences?

*Into <system.data> -> <DbProviderFactories> add <add
name="FirebirdClient Data *Provider"
invariant="FirebirdSql.Data.FirebirdClient" description=".Net
Framework *Data Provider for Firebird"
*type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory,
*FirebirdSql.Data.FirebirdClient, Version=2.0.0.0, Culture=neutral,
*PublicKeyToken=PublicKeyToken_of_your_FB_client_assembly" />.

Is the <system.data> in reg file of  provider and Do I open it with
notepad and edit it?

*Then open the FirebirdDDEXProvider.reg file and replace the %Path%
variable with *the correct path for your installation, i.e.:
C:\Program Files\FirebirdClient , and load *it into the registry (also
check whether all entries were successfuly added).
*But! If you're adding the path to the reg file you have input
C:\\Program *Files\\FirebirdClient (backslash the backslashes).
*Now you can startup the VS and try to add database to Database
Explorer toolbox.

I  replace  the (%path%) with (c:\program files\...)  without double
backslash and without  % is it correct?

Plz Don't laugh me:) . I haven't any information and my English is
very  bad? :)
best regards;

On 12/15/07, Jiri Cincura <di...@ci...> wrote:
> On 12/15/07, nasim Hemmati <nas...@gm...> wrote:
> > i have just a datababe(DB.fdb file) and .dll file of database.
>
> You mean DLL of Firebird, right?
>
> > can i connect to it without install firebird or not?
>
> You can use Firebird Embedded; FirebirdClient supports it.
>
> > and what OS regired ?
>
> FirebirdClient is limited only to place where .NET FW can be
> installed. Firebird Embedded builds you can find on firebirdsql.org
> site.
>
> >  i search a provider to connect to firebird with c#.what is differnt
> between
> > ibprovider(LCPI.IBProvider) and FirebirdNETProvider1.7?
>
> http://downloads.sourceforge.net/firebird/FirebirdClient-2.1.0.msi?use_mirror=osdn
>
> > i don't konw how do i use these providers?
> > and i don't konw what is client library?
> >
> > plz help me an guide me.i have any information about connect to firebird.
> >
> > best ragrds,
> >
> > -------------------------------------------------------------------------
> > SF.Net email is sponsored by:
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services
> > for just about anything Open Source.
> >
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> > _______________________________________________
> > Firebird-net-provider mailing list
> > Fir...@li...
> > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> >
> >
>
>
> --
> Jiri {x2} Cincura (Microsoft Student Partner)
> http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
>
> -------------------------------------------------------------------------
> SF.Net email is sponsored by:
> Check out the new SourceForge.net Marketplace.
> It's the best place to buy or sell services
> for just about anything Open Source.
> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

Re: [Firebird-net-provider] question

From: Jiri C. <di...@ci...> - 2007-12-15 18:37:42

Look at http://firebird.svn.sourceforge.net/viewvc/firebird/NETProvider/trunk/DataDesignerExtensibility/ReadMe.txt?view=markup

It's step by step. Try to perform these steps and if something goes wrong, ask.
-- 
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

[Firebird-net-provider] question

From: nasim <nas...@gm...> - 2007-12-24 09:15:11

hi;
i download firebirdSqlclient (.net provider) and after 3 week i successful
to access to database but connection to database wisard (in tools) don't
work, and don't open the tree structure of table,why?
so i can't access to another database with this and i diden't see data of
table in VS.

i have firebird database and i want conversion to mysql and use c#.net .
i downlaod the covertor and conert it to my sql but i have sql code for
export data from tables.

can guide me!!

best regards,

Re: [Firebird-net-provider] question

From: <car...@gm...> - 2007-12-24 10:04:34

Hello:
> hi;
>  
> i download firebirdSqlclient (.net provider) and after 3 week i 
> successful to access to database but connection to database wisard (in 
> tools) don't work, and don't open the tree structure of table,why?
Could you please, explain in detail what you are trying to do ??

-- 
Carlos Guzmán Álvarez
Vigo-Spain

Blog		: http://carlosga.wordpress.com/
FirebirdClient	: http://www.firebirdsql.org/
XMPP Client	: http://code.google.com/p/xmppclient/
ohloh		: http://www.ohloh.net/accounts/4138

Re: [Firebird-net-provider] question

From: <car...@te...> - 2003-02-04 11:45:02

Hello:


> using Firebird 1.5 beta1

I have made some tests using Fb 1.5 beta 1 without problems in 
connection, you have the same problem connecting to Fb 1.0.x ??




Best regards
Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] question

From: Pavol S. <pa...@st...> - 2003-02-04 13:27:18

Carlos Guzm=E1n =C1lvarez wrote:

> Hello:
>
>> i downloaded fresh CVS and i have problem with connection to database:
>>
>> it was working with older version :(
>>
>> using Firebird 1.5 beta1
>>
>> Unhandled Exception: System.TypeLoadException: Invalid PInvoke=20
>> metadata format.
>>    at FirebirdSql.Data.Firebird.ConnectionPool.Create(Byte dialect,=20
>> String chars
>> et, String role, String user, String password, String database)
>>    at FirebirdSql.Data.Firebird.ConnectionPool.CheckOut(Byte dialect,=20
>> String cha
>> rset, String role, String user, String password, String database,=20
>> Int64 lifetime
>> )
>>    at FirebirdSql.Data.Firebird.FbConnectionPool.GetConnection(Byte=20
>> dialect, Str
>> ing charset, String role, String user, String password, String=20
>> database, Int64 l
>> ifetime)
>>    at FirebirdSql.Data.Firebird.FbConnection.Open()
>>    at NovyCas.DBArticle.GetArticle(Int32 iID) in=20
>> C:\Projekty\NetStarek\NovyCas\D
>> BArticle.cs:line 157
>>    at NovyCas.DBArticle..ctor(Int32 iID) in=20
>> C:\Projekty\NetStarek\NovyCas\DBArti
>> cle.cs:line 136
>>    at Tests.TestDBArticleConstructor() in=20
>> C:\Projekty\NetStarek\Tests\Main.cs:li
>> ne 9
>>    at Tests.Main(String[] args) in=20
>> C:\Projekty\NetStarek\Tests\Main.cs:line 42
>
>
>
>
> Can you test it setting pooling to false and tell to me if it works or=20
> not??

with pooling=3Dfalse there is same exception

p.