[Mono-dev] Connection to a sybase ASA database
Mads Bondo Dydensborg
mbd at dbc.dk
Mon Dec 11 02:23:15 EST 2006
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
Here is a dump:
The default Provider is LOADEXTPROVIDER
Assembly: Mono.Data.SybaseClient, Version=1.0.5000.0, Culture=neutral,
Connection Class: Mono.Data.SybaseClient.SybaseConnection
The default ConnectionString is:
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 184.108.40.206
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
Any advice much appreciated.
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