[Mono-dev] Connection to a sybase ASA database

[Mads Bondo Dydensborg]

mandag 11 december 2006 11:16 skrev Nagappan:
> Hi,
>     I'm having only ASE (Sybase Adaptive Server Enterprise) v12.5.

OK, thanks.

As I was trying to indicate in the subject, my issue is with a ASA server.

I believe it is still widely used as an embedded database - at least it is for 
us ;-)

Regards,

Mads

> 
> Thanks
> Nagappan
> 
> Mads Bondo Dydensborg wrote:
> > 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
> >>
> >>
> >>
> >>
> >>     
> >
> >   
> 
> -- 
> 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