[Mono-dev] Connection to a sybase ASA database

[Nagappan]

Hi,
    I'm having only ASE (Sybase Adaptive Server Enterprise) v12.5.

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