onsdag 03 januar 2007 10:36 skrev Nagappan: > Hi, > > Could you please send your changes ?
Yes, I can do that, but I do not think it makes sense. The SqlTest.cs program seems to be made to test things specific to MS SqlServer. I had to remove some stuff, such as MS specific SQL statements, to make the rest work. So, I would rather send you a "SybaseASAOdbcTest.cs" file, if you are interessted. And, in any case, I would think it was useful as a starting point for Sybase ASA work. Regards, Mads > > svn diff SqlTest.cs > SqlTest.diff > > send SqlTest.diff, to the list > > Thanks > Nagappan > > Mads Bondo Dydensborg wrote: > > tirsdag 02 januar 2007 18:35 skrev Daniel Morgan: > > > >> FreeTDS Project is here: > >> > > > > [...] > > > > Thanks for all your pointers. > > > > Unfortunately, Sybase ASE is not an option for me - while ASA is a must. > > (Sigh). > > > > It turns out, that it was all my bad. Odbc does not support named parameters, > > except when calling stored procedures. > > > > So, changing > > > > insertCommand.CommandText > > = "insert into mono_sql_test ( bit_value, int_value ) values ( 1, > > @p1 )"; > > > > OdbcParameterCollection parameters = insertCommand.Parameters; > > > > parameters.Add ( "@p1", OdbcType.Int ); > > parameters [ "@p1" ].Value = 42; > > > > to > > > > insertCommand.CommandText > > = "insert into mono_sql_test ( bit_value, int_value ) values ( 1, ? )"; > > > > OdbcParameterCollection parameters = insertCommand.Parameters; > > > > parameters.Add ( "int_value", OdbcType.Int ); > > parameters [ "int_value" ].Value = 42; > > > > makes it all work. > > > > So, Mono does work with Sybase ASA 9.0.2 using Odbc, as long as one does not > > try to use named parameters. > > > > I have modified a copy of the SqlTest.cs program to test the various calls. > > Should I submit this somewhere? (Could perhaps help others along the way). > > Regards, > > > > Mads > > > > > > -- > Nagappan A <[EMAIL PROTECTED]> > Novell Software Development (I) Pvt. Ltd. > Linux Desktop Testing Project - http://ldtp.freedesktop.org > http://nagappanal.blogspot.com/ > > Novell, Inc. > SUSE® Linux Enterprise 10 > Your Linux is ready™ > http://www.novell.com/linux > > > > -- Med venlig hilsen/Regards Systemudvikler/Systemsdeveloper cand.scient.dat, Ph.d., Mads Bondo Dydensborg Dansk BiblioteksCenter A/S, Tempovej 7-11, 2750 Ballerup, Tlf. +45 44 86 77 34 _______________________________________________ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list