[Mono-dev] Connection to a sybase ASA database

[Nagappan]

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 <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