Hello:
Microsoft has a survey for that you can get more info here:
http://blogs.msdn.com/buckh/archive/2007/07/19/survey-which-databases-should-visual-studio-team-edition-for-database-professionals-support.aspx
-
This SF.net
Hello:
> Carlos,
> Wrapping the process in a single transaction reduced the time to only 4mins.
>
Are you using the embedded server or the standalone one ??
-
This SF.net email is sponsored by: Microsoft
Defy all challenges
Hey all,
It's absolutely the last chance to vote in the Sourceforge Community
Choice Awards. We are finalists in four categories. It's easy to
vote - log in to your sourceforge account and vote. However long is
left before midnight on July 20 is how long you have left to vote.
http://sourcef
At 04:42 AM 21/07/2007, bob k. wrote:
>i ran dependency walker (terrific piece of software), and corrected all the
>descrepencies except one. i don't have dwmapi.dll on my system. should this
>have come with the firebird install?
Definitely not. dwmapi.dll is a Vista-only library - it is the
de
On 7/20/07, Eduardo Gamboa <[EMAIL PROTECTED]> wrote:
> Is there a way to use a single transaction with multiple database
> connection?
In Firebird yes. FB has support for 2PC protocol. But with .net
provider you can't use this.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvoja
Is there a way to use a single transaction with multiple database
connection?
""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello:
>
>> The problem with this approach is that FbDataAdapter.Update() is too
>> slow.
>> It takes almost 1 hour to copy apro
Carlos,
Wrapping the process in a single transaction reduced the time to only 4mins.
Thanks,
Eduardo
""Carlos Guzmán Álvarez"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello:
>
>> The problem with this approach is that FbDataAdapter.Update() is too
>> slow.
>> It takes almo
On 7/20/07, Eduardo Gamboa <[EMAIL PROTECTED]> wrote:
> Is there a faster way to do this? or am I missing something?
With .net provider? AFAIK QLI (old tool, like isql) can do this as
fast as possible.
BTW I'll try to use DataReader and not filling dataset and pump it
into in one foreach loop.
U
Hello:
> The problem with this approach is that FbDataAdapter.Update() is too slow.
> It takes almost 1 hour to copy aprox 500.000 rows.
>
> Is there a faster way to do this? or am I missing something?
Can you try to wrap the inserts inside a single ( or several ones )
transaction ??
Dean,
i ran dependency walker (terrific piece of software), and corrected all the
descrepencies except one. i don't have dwmapi.dll on my system. should this
have come with the firebird install?
bob k.
- Original Message -
From: "Dean Harding" <[EMAIL PROTECTED]>
To: "'For users and
Hi Guys,
Does anybody know how to make a bulk copy of a table from one database to
another using Fb Net provider?
I am trying to achieve this goal using something like this:
FbDataAdapter sourceDA = new FbDataAdapter("SELECT * FROM TEST_TABLE",
fbSourceConn);
DataSet ds = new DataSet();
source
On 7/20/07, André Knappstein, Controlling <[EMAIL PROTECTED]> wrote:
> 1.)
> update
> rdb$database
> set
> rdb$character_set_name = "WIN1252";
This isn't required. This is default charset for new columns if it's
not specified.
> 2.)
> update
> rdb$Fields
> set
> rdb$character_set_ID = 53
Just for confirmation:
I was testing with a backup of several production databases. All
results were the same: changing charset from ISO8859_1 to WIN1252 for
all objects in the database does the trick.
I can then read and write the Euro-sign not only via ODBC and .net for
ODBC and via other drive
Jiri Cincura wrote:
>
> It's not possible. Embedded version is not listening for network
> connection.
>
i believe you, that's why i was surprised, but I'll try it on weekend again
--
View this message in context:
http://www.nabble.com/Visual-C--and-Firebird-embedded-database-connection-fail
On 7/20/07, Dean Harding <[EMAIL PROTECTED]> wrote:
> Yes, it works under Vista (I have tried it). I believe the "local protocol"
> used to connect to the server is totally different to how fbembed works. The
Yes.
> "local protocol" uses Named Pipes, I believe and because it doesn't - by
> defaul
On 7/20/07, paha <[EMAIL PROTECTED]> wrote:
>
>
> Dean Harding wrote:
> >
> >> i mean it works whether i write 127.0.0.1:c:\my.fdb or c:\my.fdb
> >> , i'm eager why :-) ?
> >
> > Do you have a firebird server running as well? If you specify
> > 127.0.0.1:c:\my.fdb then you'll be connect via the ser
On 7/19/07, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
> Hello:
>
> > Just to provide some service to community :), here's short simple KB
> > article, how to view in dialog specified assemblies.
> > http://support.microsoft.com/kb/306149
>
> that is what is being done in the old Ghost instal
Dean Harding wrote:
>
>> i mean it works whether i write 127.0.0.1:c:\my.fdb or c:\my.fdb
>> , i'm eager why :-) ?
>
> Do you have a firebird server running as well? If you specify
> 127.0.0.1:c:\my.fdb then you'll be connect via the server (the fbembed DLL
> can act as a regular network client
> > Microsoft Visual C# codename Orcas Version 9.0 Beta 1
>
> Correct me if i'm wrong but Orcas didn't use the .NET Framework 2.0
> right ??
It uses "3.5" but it should be backwards compatible from what I understand.
You can also set it to target "2.0" apps specifically in your project
settings.
Hello:
> Microsoft Visual C# codename Orcas Version 9.0 Beta 1
Correct me if i'm wrong but Orcas didn't use the .NET Framework 2.0 right ??
Could you try to build the provider using Orcas ?? and retry ??
> string connStr;
> connStr = "User=SYSDBA;" +
> "Password=masterkey;" +
> "Database=C:/Pho
20 matches
Mail list logo
