Hi, I tried with SqlSharp and connected to Sybase server
SQL# \Provider Tds The default Provider is LOADEXTPROVIDER Assembly: Mono.Data.TdsClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756 Connection Class: Mono.Data.TdsClient.TdsConnection SQL# \ConnectionString Server=mono-server,5000;Database=monotest;User ID=monotester;Password=monotester SQL# \open Opening connection... Loading external provider... External provider loaded. Open was successfull. SQL# \ConnectionString Server=mono-server,5000;Database=monotest;User ID=monotester;Password=monotester SQL# \Provider Sybase The default Provider is LOADEXTPROVIDER Assembly: Mono.Data.SybaseClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=0738eb9f132ed756 Connection Class: Mono.Data.SybaseClient.SybaseConnection SQL# \Open Opening connection... Loading external provider... External provider loaded. Open was successfull. Thanks Nagappan Mads Bondo Dydensborg wrote: > mandag 11 december 2006 07:48 skrev Mads Bondo Dydensborg: > >> fredag 08 december 2006 17:44 skrev Daniel Morgan: >> >>> No one is maintaining the Mono.Data.TdsClient. >>> Mono.Data.SybaseClient might be better. Both of these >>> including System.Data.SqlClient use Mono.Data.Tds >>> which implements the TDS protocol. >>> >> OK - I will try those instead. >> > > I have now tried the sqlsharp program instead, which uses the SybaseClient > implementation. > > Here is a dump: > > SQL# \defaults > > The default Provider is LOADEXTPROVIDER > Assembly: Mono.Data.SybaseClient, Version=1.0.5000.0, Culture=neutral, > PublicKeyToken=0738eb9f132ed756 > Connection Class: Mono.Data.SybaseClient.SybaseConnection > > The default ConnectionString is: > "Server=localhost,2638;Database=asademo;User ID=DBA;Password=SQL" > > > SQL# \open > Opening connection... > Loading external provider... > External provider loaded. > Exception Caught Opening. ASA Error -83: Specified database not found > > ------- > > Now, here is what my sybase database says: > > TCP/IP: Received connection request from 127.0.0.1:37335. > Connection from 127.0.0.1:37335 assigned connection ID 2 > TDS 2: connection created > TDS 2: login > TDS 2: using TDS version 5.0.0.0 > TDS 2: login: user 'DBA', database '', application 'Mono SybaseClient Data > Provide', host 'localhost.localdomain', host_pid '37876', charset 'iso_1' > TDS 2: request complete > > As you can see, the sybase database reckons that no database name is passed. > > I have seen this described earlier, but no resolution. > > Running SybaseTest gives very much the same results. > > I tried tracking the code in mono, and it does appear that the database name > gets lost in there in my case. It should reside in "ITds".parms which is a > TDSConnectionParameters, but if I try dumping it, after calling open (which > fails), no database is set. However, I find tracking the code to the Tds > system a bit complex, so I can not at this point figure out why that would be > the case. > > Any advice much appreciated. > > 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 _______________________________________________ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list