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
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,
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.
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.
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, not
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 use
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 not
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
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 content) not able to
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 added
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(inputstring)
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
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
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 it may
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
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
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,
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
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
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
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
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
23 matches
Mail list logo