Re: [Firebird-net-provider] [ Regarding connection speed with .Net
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 ask you a question: Do you switch the network settings on the problematic client machine, say by using netsh commands, trying to use two separate networks? I did, and in my case, the cause of the slow connection was neglecting to delete dns settings on the tail-side network with which I tried to connect to FB. Nobuya - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to use relation
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.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to use relation
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 customerid from customers; select orderid, customerid from orders"; FbDataAdapter da = new FbDataAdapter (strSQL, strConn); // strConn being connection string da.TableMappings.Add("Table", "Customers"); da.TableMappings.Add(Table1", "Orders"); da.Fill(ds); can we? Am I supposed to do something like this? DataSet ds = new DataSet(); DataTable tbl; tbl = ds.Tables.Add("Customers"); // add colums tbl = ds.Tables.Add("Orders"); // add colums strSQL1 = "select customerid from customers"; strSQL2 = "select orderid, customerid from orders"; FbDataAdapter da = new FbDataAdapter (strSQL1, strConn); da.TableMappings.Add("Table", "Customers"); da.Fill(ds); // create FbCommand cmd from a factory method cmd.Connection = strConn; cmd.CommandText = strSQL2; da.SelectCommand = cmd; // re-assigning SelectCommand da.TableMappings.Add(Table1", "Orders"); da.Fill(ds); I hope I am not. >Dim wRel As New DataRelation("Relat_dp", _ > ds.Tables(0).Columns("id"), ds.Tables(1).Columns("id_fk")) > ds.Relations.Add(wRel) >bind your child controls to "Relat_dp" I know this part. To do this, I need to have two tables filled with date within a single DataSet, boiling down to the above first question. Thanks, Nobuya - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to use relation
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) using only a single SQL statement (since batch query is not supported), the Fill method of the DataAdapter populates only a single DataTable in the DataSet with data. On the other hand, as I understand, we need to add a Relation to the DataSet to obtain parent-child relation between two tables. So my question is, how can I populate the second table in the same DataSet? Or can I set tables from different DataSets into a Relation, and adding it to one of the DataSets' Relation will work to get parent-child relationship? Maybe I'm missing something very basic but please enlighten me. I want to establish parent-child relationship in the detached data objects level, not in the original database level. Regards, Nobuya - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] how to use relation
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 supported, right? So how can I create multiple tables in a DataSet, and fill them with data, and set relation ? Or, is it not necessary to have the tables within a single DataSet to establish relation? I'm aftraid that this might be a silly question, ... Nobuya - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Connection problem from Win2003Standard
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. I tries "localhost", "127.0.0.1", and "192.168.x.x" in vain. Dean, thank you for your expert comment. Nobuya - This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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 into FB's standard UDF package. I'm porting socket-server apprecations from Win32/C++ to .NET. In those fields, you often have no choice but going down to bytes. You usually have no control over what is sent to your server. Sometimes you need to read binary protocol. Although this is not socket, a third party apprecation writes a byte into char(1) field in DB and I need to read it, willy-nilly. Thank you for your help. I'm still wondering why .net provider does not support direct byte read in FbDataAdapter's Fill method, though. 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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 everything. .NET has Byte type too. > Store byte values in DB as bytes and not as chars. Using these hacks > is like writing code in C++ (sorry for any C++ experts). ;) So are you saying I should store this single byte as BLOB in FB2.0 database? I'm from C++ background. I have been using char(1) field with charset=NONE practically as byte field. No offence, but I'm simply curious about your comment. I appreciate your response. 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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 the byte information in .NET as a byte. I'm not sure if there is a way to bring it without temporally converting it into unicode, so that's one of the reason I posted this question. I don't know what FW stands for. If it means .NET environment, surely not everything is unicode, although every character might be. If, unfortunately, converting it into a unicode char is unavoidable, then, I would like to know what is the simplest and standard way to do it. Anyway, I would like to know how to do byte-to-byte transfer :-). 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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 letter 'a' in ASCII. you need some decoding. If I do, byte b = (byte)'\xA0'; byte[] bytearray = { b }; char [] chararray = Encoding.UTF8.GetChars(bytearray); int charCount = Encoding.UTF8.GetCharCount(bytearray); then charCount = =0 // decoding fails if I do byte b = (byte)'\xA0'; byte zero = 0; byte[] bytearray = { b, zero }; char [] chararray = Encoding.UTF8.GetChars(bytearray); int charCount = Encoding.UTF8.GetCharCount(bytearray); then charCount is 1. // decoding is successful. if byte b = (byte)'\x10'; // below 128, so ASCII range byte[] bytearray = { b }; char [] chararray = Encoding.UTF8.GetChars(bytearray); int charCount = Encoding.UTF8.GetCharCount(bytearray); then charCount is 1. // decoding is successful. Now, you see the problem. 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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) emits an error saying incorrect input format. This would probably work only if the byte value is less than 128. But I need full range of 0-255. 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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 column into byte before filling datatable, assuming the column is added like: datatable.Columns.Add("dtd", typeof(object)); 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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 be stored in the column dtd. Required type is (translated into English) -> System.Format Exception: Incorrect format of the input string (translated into English) Thanks, 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] how to read a single-byte from databasae
> 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 your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] how to read a single-byte from databasae
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 single-byte data exceeds 127, the byte turns into two-byte unicode char with a default encoding. I do not want the original single byte to be translated into unicode char. So I did something like: DataTable dt = new DataTable(); dt.Columns.Add("dtd", typeof (byte)); // "dtd" is the name of the database field using(DbDataAdapter da = MyFbDataAdapterFactoryMethod(...)) { da.Fill(dt); } then I got an error at Fill() method saying: incorrect input data format, it should be 'Byte' type (translated into English). What is a simple way to accomplish this kind of task? I'm new to .NET /.NET data provider environment. It is a no-brainer with Win32/C++/IBX, but I cannot figure it out with .NET. Thanks, 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] connection to IB6.0 is slow, still no luck
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 soon. 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] connection to IB6.0 is slow, still no luck
> 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 impact > InterBase. > > -- > Jiri {x2} Cincura Hi, I'm afraid this is not the case, since, as I wrote in the post, I reagularly get a quick response from the same IB 6.0 server (same network route) via Win32/IBX but get a constant delay of 20 seconds via FB.net provider 2.0.1/.NET2.0. So I suspect that the provider is trying connections under certain assumptions, something like "the database be FB2.0, no?, then FB1.0, ..., and finally, could it be IB6.0?." Maybe I'm a way off the mark. I would like to know if the connection to IB6.0 should not be any different from that to FB1.0, or, to know what I can do to specify that the connection is to IB6.0 and circumvent failed connection try on the provider side. 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] connection to IB6.0 is slow, still no luck
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/.NET2.0. It seems that the connection with the .net provider is established only after lots of failed negotiations (just my guess). I am getting no error on the test run. I checked the Interbase.log on the server and I found lots of socket error 10054, but I am not sure about its relevance to my problem. How should I proceed from here? I appreciate any help. Nobuya > Hello: > >> 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 >> connect >> to IB6.0. My connection string is: >> strConn = @"character set=NONE;data >> source=192.168.xxx.xxx;dialect=1;initial >> catalog=d:\test\test.gdb;user id=abcde;password=xyz123"; >> Any advice? > > > 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 ?? > - 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] batch query support
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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] connection to IB6.0 is slow
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 connect to IB6.0. My connection string is: strConn = @"character set=NONE;data source=192.168.xxx.xxx;dialect=1;initial catalog=d:\test\test.gdb;user id=abcde;password=xyz123"; Any advice? 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] batch query support
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, 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 limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] unsupported on-disk structure error again!
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 error at the same time. > Have you tried downloading the source code and reading through to find > where the exception message is raised/thrown? Might be worth compiling > a debug version and using that to help isolate the cause of the problem. That sounds a bit tall order for me. Maybe I should work on getting my UDFs work properly with FB2.0 and see what happens. It seems that nobody is familiar with this error message and this let me suspect my PC environment is the culprit. I still have IB6 on my machine. I installed FB1.5 and uninstalled it. Is there any chance that UDF related dll-conflict produces this? I did not find old ib_util.dll in windows/system32 directory, though. Regards, Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] unsupported on-disk structure error again!
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 connect with .net data provider, getting 'unsupported on-disk structure ...' error message. Why am I getting this message with .net data provider ? Regards, Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] unsupported on-disk structure error again!
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 but I could not find the exact cause. Then I uninstalled everything (data provider, ddex, VS 2005 SDK) and reinstalled with slight change in versions (provider 2.0.1.0; ddex 2.0.1.0 and less- configuration; FB2.0 classic server). Fortunately, this time, I was able to connect to FB2.0 database file form VS 2005. I was happy and since then I have been testing FB2.0/.Net from a test C# application with a help of tutorials. I was able to query with datareader, execute a storedprocedure, and use dataadapter. When I tried to use a storedprocedure with FbDataAdapter today, I found that I forgot to put my UDFs into FB2's UDF directory. So I recompiled my UDFs with new inlude files of FB2 and put regenerated my UDFs into FB2's UDF directory. I restarted FB2's service and tried again but it didn't work. Somehow, FB2 service failed ,showing 'Hang Application' in the event log. I thought "Ok, maybe I need some work to convert my UDFs compatible with FB2 but I have no time for this today" and I removed my UDFs from the UDF directory and reboot my PC. This time FB2 service started ok (I could connect to FB2 databases successfully with admin tool). But when I resume my test application / tutorials, I got the same error! unsupported on-disk structure for file C:\xxx ; found 32779, support 10 Now I can't execute the tutorials that I could do successfully before I put UDFs. With UDFs removed and rebooted, why can't I go back to the previous candition? And, more fundamentally, why does this 'unsupported ODS" stuff bothers me? I will appreciate any help! Tia, Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] un-supported disk structure
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 - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] un-supported disk structure
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 > instead of a version 2.x? ... As I described in the previous posts, now I believe that the issue is not so much a migration of data from IB6 to FB 2 as a proper data provider / FB setup, since, besides the the business database restored from IB6 backup, I cannot connect to test databases created de novo as FB2 (ODS v.11) with IBExpert either. At the same time I can look into, and manipulate with SQL queries, those business and test databases via IBExpert (admin tool) without a problem. Getting back to fundamentals, should I be able to connect to Firebird 2.0 database (ODS v.11) with Firebird .NET data provider 2.1.0.0 ?? Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] un-supported disk structure
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 uninstall everything and re-install everything ... but let me die hard. How can I make sure I am using correct versions of necessary dll/exe, either FB itself or data provider, or else, if I am to use ODS ver 11 FB database? Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] un-supported disk structure
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 database originated from old IB6.0. What am I doing wrong? Regards, Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] un-supported disk structure
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 Firebird with the version of 6.3.1.12810. Judging from the file date, it was replaced recently. Correct me if I am wrong, but I doubt Firebird .Net data provider uses gds32.dll or fbclient.exe. I forgot to mention, in the origial post, the version of Firebird. It is 2.0.1.12810. Regards, Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] un-supported disk structure
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 into machine.config and set path in the DDEXProvider.reg and put it into the registry. Then, I opened a new project in VS 2005 and tried to add a new data source. In the Wizard, I could successfully select Firebird Data Provider from the pull-down. In the next window, I filled database path, user, etc. and hit Test connection button, and I go an error saying: unsupported on-disk structure for file c:\blah, blah : found 32779, support 10 Please help me with this. The target database file was restored from a IB6.0 backup (I used IB6.0 gbak for backup, and FB2.x gbak for restoration) . I can see the content of database with IBExpert. It says the target database' s properties are: Server version WI-V6.3.1.12810 Firebird 2.0 ODS version 11.0 Page Size 8192 Pages Allocated 730531 DB file size 5707MB client library c:\program files\firebird\firebird_2_0\bin\fbclient.dll client library version 2.0.1.12810 Thanks, Nobuya - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider