On 02/26/2007 02:40 AM, Josep Molero i Puig wrote: > Hi friends ... > > I'm new on this list, and I just need to start with a query about using > OpenOffice database and spreadsheet to retrieve data from a Microsoft > SQL-Server 6.5 > > I am experiencing the following problem on a Ubuntu 6.10 GNU/Linux system. > > I have installed and set up a unixodbc package and freetds package in order > to be able to connect and retrieve data from my SQLServer. Freetds is the > driver for connecting to MS-Sqlserver servers. > I have created a DNS (data source) connection to connect form Linux to > SQLServer using ODBC (unixodbc) > > I have seen that when I connect from OpenOffice database (or OpenOffice > Calc, using a connection registerda at OpenOffice database) it creates 17 > connections at the server side. > > So, with 2 client-side connections I reach the limit of users that can be > connected to my SQLserver !!! > > WHEN I connect from a Linux command line, using the client tool "isql", I > have only one connection at the server side, so it works as expected (and I > am using the same DNS connection) > > Can any one help me on that ? > > Josep
You might try asking this on the OOo dba list/group: I'm not sure why it's not mentioned on here: http://www.openoffice.org/mail_list.html or here not prominately listed here: http://dba.openoffice.org/ But you can find information on the dba user list here: http://dba.openoffice.org/servlets/ProjectMailingListList [email protected] You may find it easier to access all of the OOo lists via the gmane news server, information on how to do that his here: http://www.gmane.org/ "To read the mailing lists stored in Gmane, point your news reader to news.gmane.org". So, for the dba users list, point your browser to: news://news.gmane.org/gmane.comp.openoffice.dba.user --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
