Re: [Mono-dev] Connection to a sybase ASA database
mandag 11 december 2006 18:48 skrev Daniel Morgan: > Ah. I missed that part in your email earlier. No wonder - I am blaming sybase for using acronyms that so much look the same, for two products that are fundamentally quite different. > > Currently, ASA (Sybase SQL Anywhere) does not work. OK - I guess, that if one knows that, it is documented in the web pages - however, I did not know that ;-) Since you seem to know: What is the recommended way of connecting to a Sybase ASA 9.0.2 database? ODBC? (What class in mono should I use - I am honestely confused. Sorry about that ;-) > 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 already traced the communication between mono (sqlsharp) and an ASA 9.0.2/10.0.0. It _almost_ works for 10.0.0 - that is, you can connect (first connection fails, but doing a connect again works), you can issue sql statements, but mono (apparently) fail to understand the result. The statements are executed though - at least the server reports they are. Both of these servers claim to at least support TDS 4.2.0 and 5.0.0. > 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/ Tried: bug 80232 Regards, Mads -- 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 ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
Re: [Mono-dev] Connection to a sybase ASA database
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 <[EMAIL PROTECTED]> 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
Re: [Mono-dev] Connection to a sybase ASA database
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 <[EMAIL PROTECTED]> > >> 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 <[EMAIL PROTECTED]> > 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 Systemud
Re: [Mono-dev] Connection to a sybase ASA database
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 <[EMAIL PROTECTED]> >> 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 <[EMAIL PROTECTED]> 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 ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
Re: [Mono-dev] Connection to a sybase ASA database
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 <[EMAIL PROTECTED]> > 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 ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
Re: [Mono-dev] Connection to a sybase ASA database
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 <[EMAIL PROTECTED]> 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 ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
Re: [Mono-dev] Connection to a sybase ASA database
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 -- 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 ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
Re: [Mono-dev] Connection to a sybase ASA database
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. > What do you mean it does not work? connecting, > selecting data, what? How are you connecting? Are > you using a specific port number or not? The provider > may not be defaulting the TCP/IP port you expect. It appears not to correctly pass on the database name (asademo in my example), even though the code looks quite reasonable (that is, the mono Tds.cs code). > It helps to provide a stack trace. Error messages. > Connection string info. Of course, you can rename any > hostname, ip address, user id, and password info. I did supply very little information - perhaps to little - but I was only really interessted in knowing if it was the right approach. It is not easy for me to figure out from the webpages, which method to use to access a Sybase SQL AnyWhere installation, so I was mostly interessted in checking if I had the right approach. Apparently not, so I will check the SybaseClient instead. If I can not make that work, rest assured I will bug you with more information ;-) Thanks, and regards, Mads > > --- Mads Bondo Dydensborg <[EMAIL PROTECTED]> wrote: > > > (I am reposting this to the dev list, as I can see > > from google that earlier > > discussions on Sybase have taken place on the dev > > list). > > > > Hi there > > > > I am trying to use the information (example program, > > mainly) found on > > > > http://www.mono-project.com/TDS_Generic > > > > to connect to at Linux SyBase SQL Anywhere 9.0.2 > > server. > > > > However, I can not seem to make it work... > > > > Is this the right approach at all to do this? > > > > I could use about any kind of advice at this point. > > > > > > > Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail beta. > http://new.mail.yahoo.com > > -- 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 ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list
Re: [Mono-dev] Connection to a sybase ASA database
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. However, your database is old, so it may not work. Could be something with unicode encoding or language character set problems. What do you mean it does not work? connecting, selecting data, what? How are you connecting? Are you using a specific port number or not? The provider may not be defaulting the TCP/IP port you expect. It helps to provide a stack trace. Error messages. Connection string info. Of course, you can rename any hostname, ip address, user id, and password info. --- Mads Bondo Dydensborg <[EMAIL PROTECTED]> wrote: > (I am reposting this to the dev list, as I can see > from google that earlier > discussions on Sybase have taken place on the dev > list). > > Hi there > > I am trying to use the information (example program, > mainly) found on > > http://www.mono-project.com/TDS_Generic > > to connect to at Linux SyBase SQL Anywhere 9.0.2 > server. > > However, I can not seem to make it work... > > Is this the right approach at all to do this? > > I could use about any kind of advice at this point. > Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail beta. http://new.mail.yahoo.com ___ Mono-devel-list mailing list Mono-devel-list@lists.ximian.com http://lists.ximian.com/mailman/listinfo/mono-devel-list