FreeTDS Project is here: http://www.freetds.org/
Here is how to get ODBC working with FreeTDS http://www.freetds.org/userguide/odbcinionly.htm Yet, I do not know how well FreeTDS works with Sybase ASA. I do konw it works with ASE. http://www.unixodbc.org/ http://www.iodbc.org/ Sybase ASE (Adaptive Server Enterprise) version 12.0 and higher will work with Mono's Mono.Data.SybaseClient. For Oracle 8i, 9i, or 10g I would use System.Data.OracleClient instead of ODBC. Mono's System.Data.Odbc has been tested against, Microsoft SQL Server 2000 and Oracle 9i. I will try to see if it works with Sybase ASE 15.0. --- Mads Bondo Dydensborg <[EMAIL PROTECTED]> wrote: > fredag 22 december 2006 16:27 skrev Daniel Morgan: > > I'm only guessing here. > > > > Thanks for your reply! I have been away, and I will > go into this further, but > perhaps you could respond to my comments below. > > > Are you using an ODBC driver for Sybase ASA from > > Sybase? > > Yes. > > > > > Have you tried using the FreeTDS ODBC driver? > > No. I am quite unsure on how to do this. I did try > reading the docs, but I am > absolutely no expert at odbc, and so far am clueless > (I am a unix/linux > person, been given the task of making some Windows > C# software "work on > Linux". Odbc is "not my bag"). If you know of a > freetds for dummies guide, or > something, I would be very happy to try it out. > > > > > What ODBC manager are you using? unixODBC, iODBC? > > Again - I have no idea. This is debian sarge, and > there seems to be both > unixodbc and iodbc files on the system... > > > > > To be honest, I don't think anyone has tested the > > Mono's Odbc provider with Sybase ASA. > > I think you are right. > > Do you know of any database against which my test > program should work? I can > try with an Oracle database, if that can help? I am > in fact unsure wheter I > lack some C# calls to make the program work. > > > > > If there is not a bug for this already in > bugzilla, > > can you add it please? > > Could this bug: > http://bugzilla.ximian.com/show_bug.cgi?id=74917 be > related? > > Regards, > > Mads > > > > > http://bugzilla.ximian.com/ > > > > > > --- Mads Bondo Dydensborg <[EMAIL PROTECTED]> wrote: > > > > > Hi there > > > > > > I have a program using parameters for inserts > using > > > Odbc on a Linux platform > > > against a Sybase ASA 9.0.2 server. I have tried > to > > > make a minimal program to > > > illustrate the problem. It looks like the > parameters > > > are not substituted? > > > > > > The program below fails with: > > > > > > $ mono --debug MinTestOdbc.exe > > > > > > Unhandled Exception: > System.Data.Odbc.OdbcException: > > > [Sybase][ODBC Driver] > > > [Adaptive Server Anywhere]Column '@p1' not found > > > at System.Data.Odbc.OdbcCommand.ExecSQL > > > (System.String sql) [0x000a2] > > > in > > > > > > /home/madsdyd/xIntegra/MONOTRUNK/mcs/class/System.Data/System.Data.Odbc/OdbcCommand.cs:414 > > > at > System.Data.Odbc.OdbcCommand.ExecuteNonQuery > > > (Boolean freeHandle) > > > [0x0002a] > > > in > > > > > > /home/madsdyd/xIntegra/MONOTRUNK/mcs/class/System.Data/System.Data.Odbc/OdbcCommand.cs:440 > > > at > System.Data.Odbc.OdbcCommand.ExecuteNonQuery () > > > [0x00000] > > > in > > > > > > /home/madsdyd/xIntegra/MONOTRUNK/mcs/class/System.Data/System.Data.Odbc/OdbcCommand.cs:428 > > > at MinOdbcTest.Main (System.String[] args) > > > [0x0004c] > > > in > > > > > > /home/madsdyd/xIntegra/SybaseTest/Odbc/MinTestOdbc.cs:23 > > > > > > The Sybase server says : > > > > > > ** REQUEST conn: 33 STMT_PREPARE > > > "insert into mono_sql_test ( > > > char_value ) values ( @p1 )" > > > ** DONE conn: 33 STMT_PREPARE > > > Stmt=65539 > > > ** REQUEST conn: 33 STMT_DESCRIBE_OUTPUT > > > Stmt=-1 > > > ** DONE conn: 33 STMT_DESCRIBE_OUTPUT > > > ** REQUEST conn: 33 STMT_DESCRIBE_INPUT > > > Stmt=-1 > > > ** DONE conn: 33 STMT_DESCRIBE_INPUT > > > ** REQUEST conn: 33 STMT_EXECUTE > > > Stmt=65539 > > > ** ERROR conn: 33 code: -143 "Column '@p1' > not > > > found" > > > > > > This is mono/mcs from current svn. > > > > > > The program is this: > > > > > > using System; > > > using System.Data; > > > using System.Data.Odbc; > > > using System.Text; > > > > > > class MinOdbcTest { > > > static void Main(string[] args) { > > > > > > OdbcConnection cnc = new OdbcConnection > > > ( "DSN=SybaseASA;UID=DBA;PWD=SQL" ); > > > cnc.Open(); > > > > > > OdbcCommand insertCommand = > cnc.CreateCommand(); > > > insertCommand.CommandText > > > = "insert into mono_sql_test ( char_value > ) > > > values ( @p1 )"; > > > > > > OdbcParameterCollection parameters = > > > insertCommand.Parameters; > > > > > > parameters.Add ( "@p1", OdbcType.Char ); > > > parameters [ "@p1" ].Value = "This is a > char"; > > > > > > insertCommand.ExecuteNonQuery (); > > > > > > cnc.Close(); > > > } > > > } > > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > > > -- > 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 > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list