[Mono-dev] Connection to a sybase ASA database

Mads Bondo Dydensborg mbd at dbc.dk
Mon Dec 11 04:58:10 EST 2006


mandag 11 december 2006 10:17 skrev Nagappan:
> Hi,
> 
> I tried with SqlSharp and connected to Sybase server

Thanks a lot for your help.

Could you perhaps let me know which version the Sybase server was/is?

Regards,

Mads


> 
> 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 <anagappan at novell.com>
> 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




More information about the Mono-devel-list mailing list