RE: [Mono-list] ADO.NET plans for Mono 1.0
I updated the bug you mentioned... Mono.Data.SybaseClient / Mono.Data.Tds works for me with: Microsoft Windows XP Pro with SP1 Mono Beta 3 (Mono 0.96) Sybase Adaptive Server Enterprise 12.5.1 (ASE or SQL Server) They both work as Microsoft Visual Studio .NET 2002 (1.0) solution too. I have a vs solution for these and the dependent projects if anyone is interested. I had to define NET_1_0 for Mono.Security.dll to build successfully. There are two things that are different: - he is using Red Hat Linux 9 while I'm using Windows XP Pro SP1 - he is using Sybase 11.5 while I am using Sybase 12.5.1 Sybase has an ADO.NET data provider for Sybase ASE 12.5 and above, but it seems like you have to be a paid customer to get it. They say their ADO.NET provider will only work with Sybase ASE 12.0 and above. I wonder if the character encoding between Sybase 11.5 and 12.5 is different. Or maybe the encoding works differently between Windows XP Pro SP1 and Red Hat Linux 9. Or maybe there is a i18n or l10n problem with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sébastien Robitaille Sent: Thursday, June 17, 2004 11:12 PM To: Daniel Morgan; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: [Mono-list] ADO.NET plans for Mono 1.0 Hi Daniel, What problems are you having with Mono.Data.SybaseClient? With SybaseClient, I cannot open a connection (exception thrown, see http://bugzilla.ximian.com/show_bug.cgi?id=60320) I also tried the Generic Tds Provider. With this one, the connection opens, but as soon as I execute a simple SQL request (SELECT) with the datareader, the program hangs (I did not investigate why). 1. You could use our System.Data.OleDb or GDA# (found in GTK#) and libgda to connect to freetds. 2. An interesting alternative to try is use the jtds JDBC provider on IKVM running on Mono. I will have a look at OleDb and GDA#. The alternative #2 is not interesting for me, because it is actually an argument against using mono for our project (The other option for the project is to use Java). As I said in my original message, we have to do a proof of concept that will influence the choice of platform (mono vs Java). I would personnaly prefer mono, but the risk must be acceptable... If the database access is shaky for Sybase, we will undoubtedly choose Java. The choice of Database is very important for us since all our actual products use Sybase. I would look at freetds and jtds to see what's going on. Use my favorite debug tool Console.WriteLine(). Since I do not have any TDS background, I think that the learning curve is too high for now and it would require too much of my time. I will probably invest some time tracking bugs in the Odbc provider instead ... Please let me know if there is any progress for the SybaseClient provider. Regards Sébas ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] ADO.NET plans for Mono 1.0
On Thu, 2004-06-17 at 23:12 -0400, Sébastien Robitaille wrote: Hi Daniel, What problems are you having with Mono.Data.SybaseClient? With SybaseClient, I cannot open a connection (exception thrown, see http://bugzilla.ximian.com/show_bug.cgi?id=60320) I also tried the Generic Tds Provider. With this one, the connection opens, but as soon as I execute a simple SQL request (SELECT) with the datareader, the program hangs (I did not investigate why). 1. You could use our System.Data.OleDb or GDA# (found in GTK#) and libgda to connect to freetds. 2. An interesting alternative to try is use the jtds JDBC provider on IKVM running on Mono. I will have a look at OleDb and GDA#. please choose GDA# instead of OleDb :-) cheers ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] ADO.NET plans for Mono 1.0
Mono.Data.SybaseClient is modeled after the System.Data.SqlClient provider. Both use Mono.Data.Tds. The System.Data.SqlClient support is good because people have been maintaining it. Unfortuantely, people have not been maintaining the parts of the TDS protocol which works for Sybase. I would look at freetds and jtds to see what's going on. Use my favorite debug tool Console.WriteLine(). Alternatives: 1. You could use our System.Data.OleDb or GDA# (found in GTK#) and libgda to connect to freetds. 2. An interesting alternative to try is use the jtds JDBC provider on IKVM running on Mono. What problems are you having with Mono.Data.SybaseClient? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sébastien Robitaille Sent: Thursday, June 17, 2004 3:13 PM To: [EMAIL PROTECTED] Subject: [Mono-list] ADO.NET plans for Mono 1.0 Hi, Can somebody tell me what are the plans for ADO.NET regarding the functionnalities that will be supported in Mono 1.0, particulary for ODBC and SybaseClient ? Will there be any service packs after 1.0 to fix bugs ? What efforts are actually put into fixing bugs for these two adapters? I am presently trying to use these two adapters in order to access a Sybase 11.5 database, but I encountered many problems with both (I filled several bug reports...). I also started looking at the code myself to see if I can help, but unfortunately time is running against me. We presently have an un-official GO to develop a new project using Mono, but a proof of concept has to be done and the database access is a major part of it. If I had the choice, I would prefer to use SybaseClient instead of ODBC since it doesn't require any external tools (such as unixODBC and freeTDS). But actually, ODBC is the only adapter that works in my environment, and it has many problems (Resource leaks, connections never closed, datatypes not supported by the DataReader). Ideally, what I would like to hear is a clear commitment that at least one of them will work in Mono 1.0 :-) I am also interested to hear about any commercial success story with Mono since it could really help in the acceptance of the platform for our new project. Regards Sébas ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
RE: [Mono-list] ADO.NET plans for Mono 1.0
Hi Daniel, What problems are you having with Mono.Data.SybaseClient? With SybaseClient, I cannot open a connection (exception thrown, see http://bugzilla.ximian.com/show_bug.cgi?id=60320) I also tried the Generic Tds Provider. With this one, the connection opens, but as soon as I execute a simple SQL request (SELECT) with the datareader, the program hangs (I did not investigate why). 1. You could use our System.Data.OleDb or GDA# (found in GTK#) and libgda to connect to freetds. 2. An interesting alternative to try is use the jtds JDBC provider on IKVM running on Mono. I will have a look at OleDb and GDA#. The alternative #2 is not interesting for me, because it is actually an argument against using mono for our project (The other option for the project is to use Java). As I said in my original message, we have to do a proof of concept that will influence the choice of platform (mono vs Java). I would personnaly prefer mono, but the risk must be acceptable... If the database access is shaky for Sybase, we will undoubtedly choose Java. The choice of Database is very important for us since all our actual products use Sybase. I would look at freetds and jtds to see what's going on. Use my favorite debug tool Console.WriteLine(). Since I do not have any TDS background, I think that the learning curve is too high for now and it would require too much of my time. I will probably invest some time tracking bugs in the Odbc provider instead ... Please let me know if there is any progress for the SybaseClient provider. Regards Sébas ___ Mono-list maillist - [EMAIL PROTECTED] http://lists.ximian.com/mailman/listinfo/mono-list
