Re: [Firebird-net-provider] 2.0.0.0 works, not 2.0.1.0

2007-02-01 Thread Jiri Cincura
You have a wrong references in your SW. Look at all projects in solution, whether is referenced right version. There must be one wrong. Tha last chance is re-mapping 2.0.0.0 to 2.0.1.0 in app.config. But it's not clean. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

Re: [Firebird-net-provider] Express editions of VS and DDEX

2007-02-04 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: Have you tested it and is not working ?? you have done the test by modify the package less reg file ?? No I haven't test it yet. As I said, I don't have VS Express, only VS Prof. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Problems with DDEX

2007-02-05 Thread Jiri Cincura
Félix González wrote: Hi, I´ve VS2005 profesional, .NET SDK 2, I´ve instaled FirebirdClient 2.0.0 the GAC are OK, I´ve changed FirebirdDDEXprovider.reg and and it to registry, but DDEX dosen´t work. Any idea? If I uninstall all (VS2005, sdk….) could be work? Do you have VS SDK?

Re: [Firebird-net-provider] Problems with DDEX

2007-02-06 Thread Jiri Cincura
Félix González wrote: I have SDK and I´ve changad machina.config Are you sure that it's *VS SDK* (it's *not* .NET SDK), 'cause you don't write anything about this in your first message. thanks -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de Carlos

Re: [Firebird-net-provider] Problems with DDEX

2007-02-06 Thread Jiri Cincura
Hmmm, seems OK. Did you get any specific error in i.e. Server Explorer? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support web services,

Re: [Firebird-net-provider] Problems with DDEX

2007-02-07 Thread Jiri Cincura
Tri Mardiono wrote: Your typo should be FirebirdSql.Data.FirebirdClient. AFAIK here it's case insensitive. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more?

Re: [Firebird-net-provider] Problems with DDEX

2007-02-07 Thread Jiri Cincura
Félix González wrote: Thanks all for your help Now DDEX are working, but the only solution was cloning HD from a backup I`d make after install the system Did you install VS, .NET FW etc. from scratch? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Connection pooling in embedded

2007-02-08 Thread Jiri Cincura
Yes, it does. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology

Re: [Firebird-net-provider] Problems with DDEX

2007-02-08 Thread Jiri Cincura
Tri Mardiono wrote: Well Jiri, I was failed to run DDEX (packageless) when I did the case insensitive, but success when I changed to case sensitive. I don't know if it's a different with the package? I don't have experience with packageless, I'm using full. Maybe it was the problem. --

Re: [Firebird-net-provider] [Problems with DDEX] full vs less

2007-02-08 Thread Jiri Cincura
Tri Mardiono wrote: Actually, my question which never be answered to find out, is what the advantages of full over less? The full requires VS SDK installed; the less not. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Next release

2007-02-10 Thread Jiri Cincura
HI Carlos, no pending stuff from me. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with

Re: [Firebird-net-provider] Newbie on Current Transaction

2007-02-13 Thread Jiri Cincura
marco wrote: Howdy! Please help this newbie here. My question is how to process something in the current transaction, for example, how to perform a select/insert/update/delete using the current transaction but without knowing it (I don't have access to the transaction object). I hope this

Re: [Firebird-net-provider] TransactionScope and Interbase

2007-02-20 Thread Jiri Cincura
Daniel Letecky wrote: Carlos/Jiri, Does the provider 2.1.0.0 (beta) support TransactionScope when connecting to an Interbase database? AFAIK our provider doesn't care about IB (maybe Carlos, but I'm not testing it with IB, only pure FB). Some old versions are supported but only thanks to

Re: [Firebird-net-provider] Connection string enhancing

2007-02-27 Thread Jiri Cincura
sasha wrote: Do you think with specified path to DLL? I think path should be optional. Yes, but this will not work with DllImport. It accepts only constant string as param. And using LoadLibrary will work only on Windows, so for Linux/Mono it will be out. BTW if the DLL is in standard dirs

Re: [Firebird-net-provider] Connection string enhancing

2007-02-27 Thread Jiri Cincura
Dean Harding wrote: You can make it work using Reflection.Emit and dynamically generating the FirebirdSql.Data.Client.Embedded.FbClient class at runtime, with the full path to the fbembed.dll file in the [DllImport] attributes. I have 2 questions. Why to change somethig what's working and

Re: [Firebird-net-provider] Connection string enhancing

2007-02-27 Thread Jiri Cincura
sasha wrote: I do not want to recompile provider for using it with fbclient.dll instead of fbembed.dll. Seems I have lost myself. All these changes care about fbclient vs. fbemded DLL name? I think it was about full path to DLL and not full path. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] Connection string enhancing

2007-02-28 Thread Jiri Cincura
sasha wrote: In my case yes, but i think other people may want to specify full path to client dll. What should i do if my application should work with both embedded and normal server or on mono in windows and linux or i have a few instances of diffirent fb server? Well, still don't see the

Re: [Firebird-net-provider] Firebird Backup

2007-02-28 Thread Jiri Cincura
[EMAIL PROTECTED] wrote: Hi all, Now that i can make speedy backups of my firebird db with Visual Basic.net i have one question can firebird perform a backup when users are connected to the database?? Time ago i can view a installation of Yes, it can. Interbase 7 and it can perform

Re: [Firebird-net-provider] Îòã: Running para metrised query

2007-03-01 Thread Jiri Cincura
Mercea Paul wrote: FbCommand.Parameters.Add(int position, FbParameter value); This way I could assign value without knowing param name, only his position sql statement! Use unnamed parameter (?) to do this. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Memory leaks with Firebird standalone and ADO.Net

2007-03-02 Thread Jiri Cincura
IMHO it's not memory leak. .NET has a budget of memory, and has it's own MM. So until garbage collector doesn't need memory from some used space, there's no real freeing. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Parallel transactions

2007-03-05 Thread Jiri Cincura
manish shukla wrote: Hi, I think parallel transactions are not supported by .net provider. So, is there any way to achieve this? It depends on your understanding of term parallel transactions. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Connection string enhancing

2007-03-06 Thread Jiri Cincura
Jiri Cincura wrote: My tests on my were OK. He wants to say ... on my tree were ... ;) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence the Future

Re: [Firebird-net-provider] Provider hangs

2007-03-06 Thread Jiri Cincura
sasha wrote: Ive thought about this - this is strange behavior. I've inserted into database a text from American site. I'm not an expert in UNOCODE, but i looked in that text hundred times and do not see a big amount of two- or three- bytes characters. Most of all characters are 7-bit ANSI

Re: [Firebird-net-provider] Provider hangs

2007-03-06 Thread Jiri Cincura
sasha wrote: No, because of performance issues. Few weeks ago i discussed this OK, it was just hint. It's obvious that with blob it's slower. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] How can I show firebird provider in the data explorer in Delphi IDE ?

2007-03-07 Thread Jiri Cincura
Madars Vitolins wrote: Hmm... How ever, firebird comes from Borland Interbase, so there should be greate support in Delphi Firebird is a branch from InterBase OE. But it was a long time ago. Now Firebird isn't related to Borland (except a lot of garbage in code) or InterBase. So thinking

Re: [Firebird-net-provider] How can I show firebird provider in the data explorer in Delphi IDE ?

2007-03-07 Thread Jiri Cincura
Florentino S. Filho wrote: Borland Data Provider supports interbase 7.x incompatible with firebird 1, 1.5 and 2. FB .NET Provider has it's own BDP. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

[Firebird-net-provider] Testing

2007-03-10 Thread Jiri Cincura
Just ignore ... -- Bc. Jiri Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ICQ: 314711544 | Yahoo!: x2develop - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel

Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Jiri Cincura
Sean wrote: Question: In scenario 1, the average execution time for an iteration dropped from 1.2s to 4s when 2 threads competed for 1 connection from the pool. Is this a performance problem? Theoretically yes, in real world IMO not so. The pool has great impact on speed when line or

Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Jiri Cincura
Sean wrote: In my case, I have a client-server architecture. Client collects data and server saves them into embedded firebird database. Clients collect data automaticly and report to server periodically. The number of clients are different in different deployment, from 1 to 500. When

Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-12 Thread Jiri Cincura
Sean wrote: For every client tcp connection, a bunch of transactions are performed consecutively to insert different types of data into different tables. A db connection is opened and closed for each transaction. There is no explicit Keep connection opened. There's no need to open/close it

Re: [Firebird-net-provider] unsupported on-disk structure error again!

2007-03-13 Thread Jiri Cincura
Can you connect thru isql using this client library? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel

Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Jiri Cincura
Sean wrote: BTW, shall I keep Connection Lift Time forever, or set it to some number? What is the Connection Lift Time? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn

Re: [Firebird-net-provider] Connection pool performance issue?

2007-03-13 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: Hope he means Connection Life Time ( when it's 0 connections never dead ) Ha, damn. AFAIR my advice, you're application doesn't have any benefit from pool, so connection lifetime is off-topic. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

Re: [Firebird-net-provider] Documentation for the .NET Provider?

2007-03-14 Thread Jiri Cincura
CStuhldreier (GMX) wrote: Hello Dan, sure, there is. Try this: http://www.dotnetfirebird.org/documentation/api/1.7/index.html It's a 1.7 version. It's not the HEAD. It's kept for .NET 1.1 FW. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] TransactionScope support

2007-03-14 Thread Jiri Cincura
Jon Ege Ronnenberg wrote: servers. Can anyone please tell me if the firebird provider (v. 2.0.1.0 http://2.0.1.0) support IPromotableSinglePhaseNotification or which No. Provider has implementetation for IEnlistmentNotification (but I don't know if this info helps you). -- Jiri {x2}

Re: [Firebird-net-provider] Problem with Gridview update:Generated table adapter + ObjectDataSource

2007-03-18 Thread Jiri Cincura
Try this with latest (v2.1.0 Beta 3) provider. We have improved with Carlos a little bit params handling especially in ASP.NET. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys.

Re: [Firebird-net-provider] How to determine MaxPoolSize

2007-03-22 Thread Jiri Cincura
Vlad Orlovsky wrote: Hi All, Is there a rule of thumb on how to determine MaxPoolSize in connection string property for Firebird Embedded 2.0? My current MaxPoolSize is 100. Is that too large too small? Please advise. This depends on application's behavior and on environment where the

Re: [Firebird-net-provider] reclaim space from deleted records

2007-03-28 Thread Jiri Cincura
Mercea Paul wrote: If you have very big difference between oldest transaction and next transaction it could be a problem with that. You never make a commit ... !!! I'm not sure if this is best comparison but maybe someone else could correct me. Well, it's not only about this difference. It's

Re: [Firebird-net-provider] Getting No message for error code 335544344 found when initial catalog contains Russian chars

2007-03-29 Thread Jiri Cincura
Vlad Orlovsky wrote: Hi All, My app with Firebird.Net provider runs fine when .fdb path only contains English characters. But when I try to open .fdb where path contains Russian characters: I think, this is problem of fbclient. It doesn't accept these characters (it's probably some

Re: [Firebird-net-provider] Getting No message for error code 335544344 found when initial catalog contains Russian chars

2007-03-29 Thread Jiri Cincura
Vlad Orlovsky wrote: Hi Jiri, Is there a way to escape/convert them? Some end-users of the program may not like this restriction... No. The safe solution is not to use special characters, until fbclient will be able to work with (probably) unicode. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] reader.hasrows always true

2007-03-31 Thread Jiri Cincura
Rick Roen wrote: Is this something with VS.NET (2005) or with the fb provider? It's a provider feature. It's always true. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn

Re: [Firebird-net-provider] reader.hasrows always true

2007-03-31 Thread Jiri Cincura
Rick Roen wrote: So then basically, it has no use? With Firebird absolutely. :) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence the Future of IT Join

Re: [Firebird-net-provider] Problem creating a DataGridView

2007-03-31 Thread Jiri Cincura
If you add empty DataGridView and the add BindingSource (i.e. from SmartTag and following wizard), are column generated? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn

Re: [Firebird-net-provider] Problem creating a DataGridView

2007-03-31 Thread Jiri Cincura
Marvin Cook wrote: Jiri, The table does not show up on the list generated by the smart tag. In DataGridView's SmartTag isn't any table (by default). You can add here data source (default BindingSource) and then it's all generated. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

Re: [Firebird-net-provider] Problem creating a DataGridView

2007-03-31 Thread Jiri Cincura
Marvin Cook wrote: Jiri, The table does not exist in any drop down list. I can send you a screen print if that will help. That's correct. Common way of working with DataGridView is to bind it to the BindingSource. The chain is then DataGridView - BindingSource - DataSetTableAdapter

Re: [Firebird-net-provider] Problem creating a DataGridView

2007-03-31 Thread Jiri Cincura
Marvin Cook wrote: Yes. see: http://www.cw-infotech.com/Data/ScreenCapture.jpg So, this seems to be some problem in VS. If it's in DataSet, it should be visible in BindingSource. Really weird... -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Problem creating a DataGridView

2007-04-01 Thread Jiri Cincura
Marvin Cook wrote: Why does it always happen to me :) Because you're unique. :) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - Take Surveys. Earn Cash. Influence the Future of IT Join

Re: [Firebird-net-provider] Parameter overflow

2007-04-01 Thread Jiri Cincura
Kevin Donn wrote: and zip_code is defined to be varchar(5), you'll receive an isc_arith_except error. In the Delphi TDataSet world, if you write a parameterized query like this, and then supply a value that is too long, it will in general be shortened to fit and no error returned or

Re: [Firebird-net-provider] table limits

2007-04-02 Thread Jiri Cincura
manish shukla wrote: oh, i am sorry. thanks for the info. can you tell me how to do backup and restore by using data provider? i am using embedded version. public void BackupTest() { FbBackup backupSvc = new FbBackup();

Re: [Firebird-net-provider] Transactions or no transactions

2007-04-02 Thread Jiri Cincura
The easiest way is to use TransactionScope. using (TransactionScope scope = new TransactionScope()) { //do your code sc.Complete(); } Or you can make TableAdapter's connection public visible and start transaction manually (this is some kind of old-school way). -- Jiri {x2} Cincura

Re: [Firebird-net-provider] FbConnection.CreateDatabase w/ embedded

2007-04-06 Thread Jiri Cincura
Vlad Orlovsky wrote: Is there a way to tell the FbConnection not to CreateDatabase() with all uppercase characters for .fdbs? AFAIK no. This is done by client library and it's creating all with upper case. Maybe somebody in support list knows some way. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] table limits

2007-04-08 Thread Jiri Cincura
manish shukla wrote: In an application, i am using embedded version. I am opening db, performing some operations, closing the connection, backing up and restoring it. But restoring fails because db is still open, though have disposed connection. Any idea, how can i achieve this? Are you

Re: [Firebird-net-provider] table limits

2007-04-09 Thread Jiri Cincura
manish shukla wrote: No, I am not using connection pool, should I? No, you shouldn't, but this looks like connection in connection pool (and still opened). -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] table limits

2007-04-10 Thread Jiri Cincura
manish shukla wrote: Thanks Dan, it worked. Pooling is enabled by default. This is really crazy. In first mail, you said, that you're not using connection pooling and now you find that something like connection pool is and it's enabled. :D -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

Re: [Firebird-net-provider] Help with FB client for the compac framework...

2007-04-13 Thread Jiri Cincura
Adrián Avila Mtz. wrote: But it shows and unknow exception in he line: con.Open() What does unknow exception mean? The exception must be some type of. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Help with FB client for the

2007-04-14 Thread Jiri Cincura
Adrián Avila Mtz. wrote: This is the exception I get: FbException was unhandled No messsage for error code 335544721 found Thie error means: Unable to complete network request to host {0}. So your PDA/emulator isn't properly presetted for using network. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] Events question

2007-04-19 Thread Jiri Cincura
Christian Nylund wrote: I always get six events every time a trigger in my database is fired. Is that always the case or am I doing something wrong? obviously I only want to respond to one of them. Any ideas on how to achieve that? You're probably doing something wrong. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] Write Large BLOB

2007-04-23 Thread Jiri Cincura
Miroslav Lences wrote: I want to implement a binary blob in my database app. I have read the docs and understand how to use getBytes to read from the blob in small chunks. How do I write to a blob in small chunks? My blob may be larger than my memory so using a byte[] is not possible. AFAIK

Re: [Firebird-net-provider] Unique Constraint Bug

2007-04-24 Thread Jiri Cincura
paha wrote: And now try to read the data with FbDataAdapter.Fill The Problem is - there will be created two different Unique Contraints for every column instead of one constraint with two columns and obviously you get the exception cannot activate constraints. Is it a bug or missing

Re: [Firebird-net-provider] Unique Constraint Bug

2007-04-24 Thread Jiri Cincura
paha wrote: da.MissingSchemaAction = MissingSchemaAction.AddWithKey; This is doing wrong job. :) da.Fill(result); // Here we get exception Transaction.Commit(); I should notice, that with complex PrimaryKey is everything ok - many columns in one primary key, so should be done for

Re: [Firebird-net-provider] Unique Constraint Bug

2007-04-24 Thread Jiri Cincura
paha wrote: Jiri Cincura wrote: da.MissingSchemaAction = MissingSchemaAction.AddWithKey; This is doing wrong job. :) Why? Worked always for me, without this there are no constraints at all. Is there any option to this? Exactly. This will not create any constaints. :) Jiri Cincura

Re: [Firebird-net-provider] Unique Constraint Bug

2007-04-24 Thread Jiri Cincura
Well, seems to be little bit weird. No matter what I do, I'm not able to make MS SQL server SQL Client to provide these values (it's probably the reason why it worked): IsUnique: False IsKey: it's always False and empty. But the PK or unique is there, if I try to insert some data I got error.

Re: [Firebird-net-provider] Unique Constraint Bug

2007-04-24 Thread Jiri Cincura
A. Another point. When I create PK on 2 columns or unique on 2 columns. VS always creates a key on these columns on DataTable level. No unique is set for columns. It seems to me, that unique and PK is from MS SQL's provider and VS's view the same and they're handling it in a special way.

Re: [Firebird-net-provider] Unique Constraint Bug

2007-04-24 Thread Jiri Cincura
paha wrote: maybe i don't understand what is made behind the curtain, but ... when provider populates schema for table, it checks if primary key for the table consists of 1..x fields (if any pk at all :-) ), and creates an array of DataColumn for the PrimaryKey property of DataTable, doesn't

Re: [Firebird-net-provider] Running client in x64 mode

2007-04-24 Thread Jiri Cincura
Vlad Orlovsky wrote: Hi All, Is there a way to run FirebirdSql client in true x64 mode? Or will it still have problems loading gds32.dll? FBClient has no problem with running in 64bit. But because it's loading fbclient.dll there's problem, that this library cannot run in 64bit mode (AFAIK

Re: [Firebird-net-provider] Some minor improvement in provider's code

2007-04-26 Thread Jiri Cincura
Hi, nice job. But shouldn't be the ProcessRecordsAffectedBuffer method be improved too (and some others on other place (i.e. ParseQueryInfo from FbService, etc.), that are checking IscCodes.isc_info_end)? So I suppose to check (and improve) these methods and then test the changes. If Carlos

Re: [Firebird-net-provider] Some minor improvement in provider's

2007-04-26 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: That is why we need to check the changes in firebird 2.1, check how they affect the provider, create a new GDS implementation and add a new Server Type. I agree. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Some minor improvement in provider's code

2007-04-27 Thread Jiri Cincura
sasha wrote: Common advice. Carlsos. What about if I review current code for checking buffer length too? Then we can create something with FB2.1 improvements. :) -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Some minor improvement in provider's code

2007-04-27 Thread Jiri Cincura
Jiri Cincura wrote: Carlsos. Sorry Carlos. Damn typo. :D -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE

Re: [Firebird-net-provider] Some minor improvement in provider's code

2007-04-27 Thread Jiri Cincura
sasha wrote: Yet one. Do you know about such wonderful VS plugin as resharper? If no, you can try it and I'm sure you will like it. http://www.jetbrains.com/resharper/ this plugin can help keep codes much more clear and found some mistakes in code. When i opened providers sources then

Re: [Firebird-net-provider] Some minor improvement in provider's code

2007-04-27 Thread Jiri Cincura
sasha wrote: Isn't ReSharper paid? It's paid, but it has 30 days trial. But it's trial. Not for working. I don't think, that provider's code is ugly. I think, that it's very good readable and pretty printing. It's not ugly, but it can be better. I can send you screenshots from my VS

Re: [Firebird-net-provider] Some minor improvement in provider's

2007-04-27 Thread Jiri Cincura
Carlos Guzmán Álvarez ™ wrote: Hello: Carlsos. What about if I review current code for checking buffer length too? Please don't, i want to release the rc of the 2.1 Not for v2.1 It's not FB2.1 related. It's general. But if you want, I can wait with commits. Whatever you want... :) Then

Re: [Firebird-net-provider] Some minor improvement in provider's

2007-04-27 Thread Jiri Cincura
sasha wrote: But i want to say that: 1) Buffer length not related to FB 2.1. Yes, I know. I'm now in talk with Vlad. I'll discuss the problem with him. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Preparing the sources for the RC 1

2007-04-30 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: Hello: I hope to create a new brach for the 2.1. RC 1 tomorrow Just yesterday I fixed version number for web providers. :) After that current trunk will be the development sources for the next version -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/

Re: [Firebird-net-provider] Preparing the sources for the RC 1

2007-04-30 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: I have done the branching yet. OK. I will release 2.1.0 RC 1 from that branch this weekend, all bug fixes for 2.1.0 will be done in that branch ( along with doing it on the devel trunk of course ) I'm now refactoring web providers. But this will take more time

Re: [Firebird-net-provider] New protocol implementation: Internal namespace changes

2007-05-02 Thread Jiri Cincura
Carlos Guzmán Álvarez ™ wrote: FirebirdSql.Data.Client.Gds - FirebirdSql.Data.Client.Managed.Version10 This looks better for me. 2. FirebirdSql.Data.Client.Embedded - FirebirdSql.Data.Client.Native Should be in this word embedded too? To not confuse programmers. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] New protocol implementation: Internal namespace changes

2007-05-02 Thread Jiri Cincura
Carlos Guzmán Álvarez ™ wrote: Hello: Should be in this word embedded too? To not confuse programmers. I don't think so as right now you can give the dll used as library in the connection string, so calling it Native will be more according to this fact, IMHO Web can think on

Re: [Firebird-net-provider] New protocol implementation: Internal namespace changes

2007-05-02 Thread Jiri Cincura
Carlos Guzmán Álvarez ™ wrote: Hello: OK, I was just think from POV of new programmer taking our assembly. It's an internal namespace, so i think there souldn't be any problem with the name change XD Damn. I'm not focused. So with this (new) :) info it's ok. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] New protocol implementation: Internal namespace changes

2007-05-02 Thread Jiri Cincura
sasha wrote: What is version 10 ? Maby Version_1, Version_2, ets... ? It's the version of FB Protocol. AFAIK. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored

[Firebird-net-provider] Membership providers

2007-05-03 Thread Jiri Cincura
Hi *, I'm thinking about adding some prefix to SQL scripts for creating tables, etc. for membershipshiping. Why to do this. First there's some inconsistency in these scripts. So this would help keep stuff readable and clean. And second, if there will be prefix for these objects, on first look

Re: [Firebird-net-provider] Membership providers

2007-05-04 Thread Jiri Cincura
Madhu Sasidhar, MD wrote: Jayadev On trying to build, it is asking for the key for a pssword encrypted file SC_TemporaryKey.pfx what is that - I think it has to do with ClickOnce First, how is this related original thread? If it's new thread, create new thread!!! Second, what are you

Re: [Firebird-net-provider] Membership providers

2007-05-04 Thread Jiri Cincura
sasha wrote: So I propose MP$SOMETHING Looks good, too. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE

Re: [Firebird-net-provider] Membership providers

2007-05-04 Thread Jiri Cincura
le roy arnaud wrote: So I propose MP$SOMETHING Looks good, too. Yes so for tables : MemberShip Proprider : MP$ Role Provider : RP$ Profile Provider : PP$ and the same for proc ? OK. Ill update names with creating FB2.0 scripts. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/

Re: [Firebird-net-provider] Membership providers

2007-05-04 Thread Jiri Cincura
BTW do you think, that prefix should be each for every provider or same for all ASP.NET web providers? I vote for same. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is

Re: [Firebird-net-provider] Membership providers

2007-05-07 Thread Jiri Cincura
le roy arnaud wrote: for the tables i think that the same prefix could be a good idea but for sp i think that there are already a prefix ex : MEMBERSHIP_CREATEUSER ROLES_ADDUSERTOROLE PROFILES_GETPROPERTIES We can create a) aliases to keep thinks working b) diff script for SP. --

[Firebird-net-provider] Data vs. Web trunk structure

2007-05-08 Thread Jiri Cincura
Hi Carlos, if we're in huge changes in codebase, I think, there's some problem with *.csproj files. The FirebirdSql.Web.Providers.csproj is located on other place (level) than FirebirdSql.Data.FirebirdClient.csproj . And also some same files (with same I think with same purpose in project)

Re: [Firebird-net-provider] Data vs. Web trunk structure

2007-05-08 Thread Jiri Cincura
Jiri Cincura wrote: \trunk\NETProvider\source\FirebirdSql\UnitTests Sorry. UnitTests should be placed in Data. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email

Re: [Firebird-net-provider] Data vs. Web trunk structure

2007-05-09 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: Looks fine, please, do the changes. I'll do the changes in weekend (probably saturday). I'll post echo into list about 12hrs before. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Data vs. Web trunk structure

2007-05-11 Thread Jiri Cincura
OK, during saturday (between 2-10 pm GMT+2) I do proposed changes (directories structure, project files paths and content). Please if you have any pending commits, do it ASAP. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com

Re: [Firebird-net-provider] Data vs. Web trunk structure

2007-05-12 Thread Jiri Cincura
It's done. I hope all path are fixed and everything is working fine. Small changes will be done on-the-fly. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This SF.net email is sponsored

Re: [Firebird-net-provider] Provider 2.1.0.0 FBBackup Execute Method throws Object Ref Exception

2007-05-13 Thread Jiri Cincura
Muthu Annamalai wrote: Thanks for replying, here is my code, Hi, I've rewrite your code into C#, because I'm not familiar with VB.NET, but should be same: if (backupPath == string.Empty) { return false; } try { FbBackup b = new FbBackup(); b.ConnectionString =

Re: [Firebird-net-provider] SQL syntax for inserting data into stored procedure

2007-05-13 Thread Jiri Cincura
Yes, you're right. But if you want to use this statement as SP, use it like: using (FbConnection conn = new FbConnection(cs)) { conn.Open(); using (FbCommand cmd = conn.CreateCommand()) { cmd.CommandText = test_insert; // NO test_insert(@id, ...) cmd.CommandType =

Re: [Firebird-net-provider] SQL syntax for inserting data into

2007-05-13 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: The First example you have sent has a valid syntax too, and should work fine too, the query should be changed by the provider adding the execute procedure before executing the query. Looks like we have some woodoo in SPs. :) -- Jiri {x2} Cincura

Re: [Firebird-net-provider] Compact Framework help

2007-05-13 Thread Jiri Cincura
You only need to reference provider for CF. You can download it from firebirdsql.org site. The 1.7 isn't needed (it's for .NET FW 1.1). -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com - This

Re: [Firebird-net-provider] SQL error - Different windows user accounts

2007-05-14 Thread Jiri Cincura
Jiří Neužil wrote: Dynamic SQL error SQL error code = -104 Token unknown - line 1, char 35 35 That's all. Could someone tell me how is this possible? Same application, same database How the statement looks like? -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

[Firebird-net-provider] Enlisting transaction

2007-05-16 Thread Jiri Cincura
Hello, this code works on MS SQL (returns always 0 (table was empty)): using (TransactionScope ts = new TransactionScope()) { InsertTestMS(); //ts.Complete(); } Console.WriteLine(SelectTestMS()); private static int SelectTestMS() { using (SqlConnection conn = new

Re: [Firebird-net-provider] Enlisting transaction

2007-05-18 Thread Jiri Cincura
Carlos Guzmán Álvarez wrote: Hello: But on FB it inserts record no matter that no call of Complete method was done. Did I miss something? Ok i will try to review it later. I'll look at this too. I was just asking to be sure that I'm not doing something wrong. -- Jiri {x2} Cincura

Re: [Firebird-net-provider] Connection String Question

2007-05-18 Thread Jiri Cincura
This is in fact not related to net provider, so for next time better to ask in support list. But. This is about aliases. Look at some Quick Start Guide for this topic and you'll understand. - This SF.net email is sponsored by

Re: [Firebird-net-provider] Need FirebirdSql.Data.Firebird.Dll File

2007-05-29 Thread Jiri Cincura
On 5/28/07, Atif Khan [EMAIL PROTECTED] wrote: The IDbCommand and IDbConnection implementation in the assembly FirebirdSql.Data.Firebird could not be found. Ensure that the assembly FirebirdSql.Data.Firebird is located in the application directory or in the Global Assembly Cache. If the

Re: [Firebird-net-provider] batch query support

2007-06-01 Thread Jiri Cincura
On 6/1/07, Mercea Paul [EMAIL PROTECTED] wrote: I think u can use 'EXECUTE BLOCK' for that Yes, execute block works fine. But you have to put it manually. In designer it's not possible, 'cause VS is validating SQL in own way. :( -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ |

<    1   2   3   4   5   6   7   8   9   10   >