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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
