Hi,
I had a similar problem before. In my case, it took more than 10 seconds to
open a connection.
It was a network setting problem but it took me so long to find out the
remedy. The chance is, probably we do not share the same cause, so I do not
get into the detail at first. Instead, let me as
Hi,
> why not ?
You're right! It seems that I was missing an obvious way.
Thanks a lot.
Nobuya
-
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.co
Hi,
>If I understood, you try to create a relation between some datatables,so
>fill the same dataset with table1 and table >2 (call fill for both) and
>then something like this :
I don't know how to fill the second table.
Without batch query support, we can't do like,
strSQL = "select custome
Hi Carlos,
>Couldn't you use TableAdapters ( and fill them with data ) or fill the
>dataset table using the TableAdapter ??
Yes, I use DataAdapter to fill a DataSet (I do not use TableAdapter as a policy
to avoid design-time GUI dependancy). But because I have to create a DbCommand
(FbCommand)
Hi,
I would like to set relation (parent-child) between multiple tables, but,
unfortunately, I don't understand how to do it with FB provider. All the
textbooks I have show it with MS SQL server where batch query (multiple
queries separated by ; ) is supported. With FB, batch query is not
supp
Hi,
Just for the information. I am experiencing a similar problem. My
Firebird2.0 DB resides on a PC server that has two NICs. When I try to
install my application server program onto the same PC server, it seems that
the application server program cannot connect to the DB on the same machine.
> BTW in FB default UDF pack is ascii_char and ascii_val function. Why
> not to use it for getting values from DB.
>
> Note.: Depends on your needs and performance issues.
Finally, you tell me how, and I thank you profundly. ascii_val sounds
promising.
I have been using my own UDF and didn't look
> FW means Framework.
There are many framework, but here, you seem to mean .NET framework.
> I'm sorry, but it is. Every piece of code in FW is written to work
> primarily with unicode. The way, that you can use any other character
> set is the feature.
As for string or text, yes, but that is no
> 0xA0 ISN'T valid char because EVERYTHING in FW is unicode. You have to
> convert your value to unicode first fo be able to cast it to byte.
Well, so I have been asking how. Let me put it this way. I have a byte in
the database (FB2.0). and we have a Byte type in .NET world. I would like
to us
> First convert the char(1) in your charset into unicode (cause
> everything in FW work with unicode), then use simple conversion:
> char c = 'a';
> byte b = (byte)c;
You can do
char c = 'a'
because 'a' is a Char.
You can't do
char c = (byte)'\xA0'; // a byte with the value of hexadecimal A0,
> DataTable dt = new DataTable();
> dt.Columns.Add("dtd"); // "dtd" is the name of the database field
>
> then read the value into string and convert with
>
> byte val=byte.Parse(inputstring);
I'm sorry but this is exactly where it started.
with the single-byte value being '\xA0'
byte.Parse(inp
> Try to add column as object not as byte. Probably there's some
> casting. The look what's inside object (it'll be probably char). When
> you will know this, do casting to byte just before filling datatable.
>
> --
> Jiri {x2} Cincura
I don't understand whay you are saying. How can I cast the ad
> Try this
>
> DataTable dt = new DataTable();
> dt.Columns.Add("dtd", System.Type.GetType("System.Byte")); // "dtd" is
> the
> name of the database field
>
> K.
Result:
It produces the same error as in case of
dt.Columns.Add("dtd", typeof(byte));
System.ArgumentException : <(the byte conten
> What's your connection string charset?
>
> --
> Jiri {x2} Cincura
CharSet=NONE
Regards,
Nobuya
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of
Hi,
I'm trying to read a single-byte in FB2.0 database as char(1) field with
charset/NONE. I am using the byte as binary information ranging 0-255, not
as a letter in text. With FbDataAdapter's Fill method, the data is
translated into a string in a DataTable. It seems that when the value of the
Hi Carlos,
> It can be the case have you tried to connect using a .net socket against
> that firebird server ??
Oh, it did not occur to me that Win32 and .NET socket would be different.
I'll set up a test
Thank you, Carlos and Jiri, for the clue. I hope I'll find the source of the
problem s
> INET/inet_error: read errno = 10054 or 10038 or 10093
> Error showings
>
> Multiple entries in interbase.log with errors 10054, 10038, 10093, etc.
> Probable Reason
>
> These errors caused by network problems - check your hubs, network
> adapters, etc. It is not an InterBase error itself, but i
Hi,
> I haven't tested the provider against IB 6.0 since a long time, but, are
> you sure it's not a network related problem ??
I can make a query to the same IB6.0 database via Win32/IBX without
significant delay, while it takes about 20 seconds to run a test-unit query
with Provider2.0.1/.NE
Hi, Carlos
> It's not supported.
Thanks. I can live with that.
Regards,
Nobuya
-
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limit
Hi,
I'm migrating from IB6.0/Win32 to FB2.0/.NET. So far, my test application
works fine with FB2.0/Provider2.0.1/.NET2.0. But, for some transition
period, I need to run Provider2.0.1/.NET2.0 applications with old IB6.0. In
my test unit, it seems to work but it takes too long (25seconds) to con
Hi,
FB2.0.1/FBClinet2.0.1/.NET2.0
Is batch query supported with FB2.0/Provider2.0.1? By batch query, I mean
putting two or more SQL sentences into a single FbCommand (e.g.
FbDataAdapter's UpdateCommand) like:
update xxx set x1 = @x1, ...;
select x1, x2, ... from xxx ... ;
thanks in advance,
Scott, Jiri, thank you for your repsonses.
> Can you connect thru isql using this client library?
I don't understand whay you mean by 'the client library'.
I can connect to FB2.0 database files with IBExpert even with my UDF dlls in
the UDF direcotry, whereas the .net data provider gives me the
Hi,
After additional rebooting, now I seem to be back in the previous condition.
With myUDF removed, I can connect to FB2.0 database via .net data privider.
But with myUDF dll (not working) in the UDF directory, I can still connect
to FB2.0 database through a third-party admin tool, but cannot
Hi all,
About a week ago, I posted here for seeking a clue to solve my unsuccessful
fb data provider installation. I got an error saying
unsupported on-disk structure for file C:\; found 32779, support 10
when I tried to connect to FB2.0 database.
I got several kind responses from the list
Hello, Carlos, thank you for creating the FB data provider.
>Post here your connection string please.
character set=NONE;data source=localhost;Dialect=1;Initial
Catalog=C:\FBRadsysData\FBRADSYS;user id=HIGUCHI;password=xx
Will it do?
Nobuya
--
Oops, I sent a reply to wrong address
Let me do it right.
Hi, Scott,
Thank you for the help.
> To what disk File System type are you trying to restore this file to? Is
> it an NTFS formatted disk, or FAT32?
NTFS.
> Have you tried restoring the data to a Firebird 1.0x or 1.5x database
> i
Hi,
> Check for correct DB file path. I have no other ideas what can it be...
The path seems ok. Further tests on my side reveals that I can connect to
old IB6.0 database (ODS ver 10) from VS 2005 via Firebird .NET data provider
2.1.0.0 but not to any FB 2.0 database (ODS ver11). Maybe I should
Hi,
> Maybe you should restore your database on 1.0, than on 1.5 and than on
> 2.0.1...
I created a test database with an admin tool, specifying type as Firebird
2.0. Then, I tried to connect to the database from VS 2005 and I got the
exactly the same error. So, it has nothing to do with the da
Hi, Paul, thank you for the hint.
> Just a hint, I think you need to verify gds32.dll version from system32 .
> If you made all operations on that machine, could you have the old
> gds32.dll
> from previos IB6 instalation.
I checked the gds32.dll in system32. It's property shows that its make is
Hi,
I am a newbie trying to migrate from IB6.0/IBX to FB2.x/.NET.
FirebirdSql.Data.FirebirdClinet.dll version 2.1.0.0
FirebirdSql.VisualStudio.DataTools.dll 2.0.1.0
Windows XP, SP2, VS 2005
I installed VS SDK (not framework SDK).
I downloaded firebird .net data provider and DDEX. I put entries i
30 matches
Mail list logo
