FirebirdClient for .Net 2.0

View: New views
8 Messages — Rating Filter:   Alert me  

FirebirdClient for .Net 2.0

by Kjell Rilbe-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I need to install the FirebirdClient for .Net for .Net version 2.0 (as
it seems SQL Server 2005 import/export supports 2.0 and not 3.5).

How do I do that?

Install 3.5 then copy the dll for 2.0 to Program Files\FirebirdClient?

Anything else?

The imp/exp wizard for SQL Server doesn't list Firebird as a soure...
Anything else I need to do?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64






------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: FirebirdClient for .Net 2.0

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Thu, Oct 22, 2009 at 12:41, Kjell Rilbe <kjell.rilbe@...> wrote:
> I need to install the FirebirdClient for .Net for .Net version 2.0 (as
> it seems SQL Server 2005 import/export supports 2.0 and not 3.5).

The 3.5 is only added stuff to 2.0. Hence if on that machone 3.5 is
available you don't need to worry.

> The imp/exp wizard for SQL Server doesn't list Firebird as a soure...
> Anything else I need to do?

I don't know the wizard, but did you added record into machine.config?
99% applications depends on this information.

--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: FirebirdClient for .Net 2.0

by Kjell Rilbe-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jiri Cincura wrote:

> On Thu, Oct 22, 2009 at 12:41, Kjell Rilbe <kjell.rilbe@...> wrote:
>
>>I need to install the FirebirdClient for .Net for .Net version 2.0 (as
>>it seems SQL Server 2005 import/export supports 2.0 and not 3.5).
>
>
> The 3.5 is only added stuff to 2.0. Hence if on that machone 3.5 is
> available you don't need to worry.

Not sure .net 3.5 is installed on this system. Can i just replace the
DLL or will that break anything?

>>The imp/exp wizard for SQL Server doesn't list Firebird as a soure...
>>Anything else I need to do?

> I don't know the wizard, but did you added record into machine.config?
> 99% applications depends on this information.

Where is this? Is it a file with that name?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: FirebirdClient for .Net 2.0

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Thu, Oct 22, 2009 at 14:50, Kjell Rilbe <kjell.rilbe@...> wrote:
> Not sure .net 3.5 is installed on this system. Can i just replace the
> DLL or will that break anything?

Probably yes. As the file should be in GAC.

> Where is this? Is it a file with that name?

Yes, that name. It's somewhere in %windir%\Microsoft.NET\....

--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: FirebirdClient for .Net 2.0

by Kjell Rilbe-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Found the file and four drivers, three of which appear in the guide, and
if I change the description, it appears changed in the guid. So thats
where to add the FB provider.

But... what should I add, in detail?

The current provider says:

<add
name="SqlClient Data Provider"
invariant="System.Data.SqlClient"
description=".Net Framework Data Provider for SqlServer"
type="System.Data.SqlClient.SqlClientFactory, System.Data,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
/>

What's the right entry for FB?

<add
name="FirebirdClient Data Provider"
invariant="System.Data.FirebirdClient"
description=".Net Framework Data Provider for Firebird"
type="System.Data.FirebirdClient.FirebirdClientFactory, System.Data,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
/>

Please help....

Thank you!
Kjell

Kjell Rilbe wrote:

> Jiri Cincura wrote:
>
>
>>On Thu, Oct 22, 2009 at 12:41, Kjell Rilbe <kjell.rilbe@...> wrote:
>>
>>
>>>I need to install the FirebirdClient for .Net for .Net version 2.0 (as
>>>it seems SQL Server 2005 import/export supports 2.0 and not 3.5).
>>
>>
>>The 3.5 is only added stuff to 2.0. Hence if on that machone 3.5 is
>>available you don't need to worry.
>
>
> Not sure .net 3.5 is installed on this system. Can i just replace the
> DLL or will that break anything?
>
>
>>>The imp/exp wizard for SQL Server doesn't list Firebird as a soure...
>>>Anything else I need to do?
>
>
>>I don't know the wizard, but did you added record into machine.config?
>>99% applications depends on this information.
>
>
> Where is this? Is it a file with that name?
>
> Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: FirebirdClient for .Net 2.0

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

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

--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: FirebirdClient for .Net 2.0

by Kjell Rilbe-3 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Jiri Cincura wrote:

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

Thank you! Finally found the same info on the web, but had real problems
finding gacutil.exe. This is not a dev system and I don't have VS available.

So, how am I REALLY supposed to find thiese things out if I just want to
get the Firebird provider installed on a non-dev system and into
machine.config? Seems odd that this info is tucked away in a VS related
location, since it seems to have nothing to do with VS per se.

Also, after doing all that, the import/export wizard still fails,
becuase it can't extract column info from FB. It says "Specified method
is not supported".

Could this be some (still) missing config, or is it a feature that the
FB provider doen not implement? I have no idea what method the wizard
was trying to call I'm afraid.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Re: FirebirdClient for .Net 2.0

by Jiri Cincura :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

On Thu, Oct 22, 2009 at 17:24, Kjell Rilbe <kjell.rilbe@...> wrote:
> real problems
> finding gacutil.exe. This is not a dev system and I don't have VS available.

You can copy it from other machine or use SDK. The VS isn't necessary.

> So, how am I REALLY supposed to find thiese things out if I just want to
> get the Firebird provider installed on a non-dev system and into
> machine.config? Seems odd that this info is tucked away in a VS related
> location, since it seems to have nothing to do with VS per se.

machine.config isn't VS related.

> Could this be some (still) missing config, or is it a feature that the
> FB provider doen not implement? I have no idea what method the wizard
> was trying to call I'm afraid.

Me neither.

--
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.cincura.net/ | http://www.ID3renamer.com

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider