[Mono-dev] Connection to a sybase ASA database

Daniel Morgan monodanmorg at yahoo.com
Mon Dec 11 12:48:50 EST 2006


Ah.  I missed that part in your email earlier. 

Currently, ASA (Sybase SQL Anywhere) does not work. 
Perhaps it is with unicode or lack of unicode encoding
or language or character set.  Maybe the TDS protocol
is different and something needs to be set.  Not sure
what TDS protocol version sybase asa uses.  I would
visit the freetds or jtds projects to see.

I did a search on google, and this came up.

http://lists.ximian.com/pipermail/mono-devel-list/2006-June/018712.html

Care to add a bug in bugzilla please?

http://bugzilla.ximian.com/


--- Mads Bondo Dydensborg <mbd at dbc.dk> wrote:

> 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.
> 
=== message truncated ===



 
____________________________________________________________________________________
Need a quick answer? Get one in minutes from people who know.
Ask your question on www.Answers.yahoo.com



More information about the Mono-devel-list mailing list