Daniel Kasak, thank you very much. I will save your eMAIL to work it patiently. --------------------------------------------------------------- I'm new on Linux (and openOffice too) and I do not know anything about Perl and not too much about Linux's Shell.
>From my time at University when I made some practices with Unix running on a Digital VAX I have work it no more. I saw a Linux wkstation once there !! (1989-1990) The problem is that I have a big group of applications I developed using VBasic, MSSQLServer running on Windows, just for migrating from and IBM-AS400 to a visual environtment and LAN topology. My applications work fine, I have no problems with them. And I do not need to migrate them by now (I'm alone at my job to develop and program). I have a lot of EXCEL sheets that are connecting to our SQLServer Databases to perform some queries and manage data results (data pilots, etc...) BUT ... I would like to do the same under Windows + OpenOffice and Linux + OpenOffice. I am trying to test OpenOffice from Linux and Windows, just to see if we could change some Windows workstations for Linux workstations. I have set up an Ubuntu 6.10 + Samba like a trully member of my NT Domain, and I have user authentication against my PDC. (It works fine ;-) ) ON MY WINDOWS Workstartions, I would like to be able to use OpenOffice instead of MS-Office, at least. And the rest (using Linux instead of Windows) will come. I must say that for what is related to OpenOffice CALC, OpenOffice DataBASE, EXCEL, ACCESS and connecting to ODBC, I thing Excel and Access are better in the way of creating connections and performance. At least, running on similar PCs under Windows it goes faster the tandem Excel-Access (or Excel + ODBC). I WILL TRY TO EXPLAIN WHAT I'D LIKE TO DO My last test using OpenOffice under Windows locked my SQLServer and I had to re-start it !!! I created a Database under Windows + OpenOffice that uses and System ODBC connection to connect to a database on my SQLServer (let's call it DATABase_A). I have created a query on that OpenOffice.Database that retrieves data from a table that is on another SQLServer database (let's call this database DATABase_B, and the query QRY_B) This query is just a simple : Select * From DATABase_B..TableB. Then I try to retrieve data involving both a table at DATABase_A and the query QRY_B. Sometime it worked, sometimes no... and finally it locked my SQLServer. Using ACCESS, I can create a Database that links any table from any ODBC database, using one or more ODBC sources. Then I can created queryies using any linked table. Do you know if this is possible on OpenOffice ?? And if possible, in a manner that does not lock the server ? On the other hand, on a lot of my Excel sheets, I use Visual Basic to create a query string to refresh my querytables. The query string depends on one or more parameters given by the user. This querytables have usually a connection to a default ODBC data source (DSN). This DSN is neither a User DSN nor a System DSN, it's File DSN saved on a public shared folder. So, my querytables on EXCEL sheets use this connection as a basis, but the actual SQL statement retrieves data from any table of any SQLDatabase. Do you know what I mean ? This should be nice to do it under OpenOffice.. I do not know if I can do it.. Thank again !!! -----Mensaje original----- De: Daniel Kasak [mailto:[EMAIL PROTECTED] Enviado el: dilluns, 26 / febrer / 2007 22:20 Para: [email protected] Asunto: Re: [users] ODBC connections 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 > I can't really help much with this. It sounds a little odd, but I've certainly seen some odd things using SQL Server from Linux. I'll go through issues I've had in case it throws up some common problems that this might be related to. I mainly use Perl: DBD::ODBC ==> UnixODBC ==> FreeTDS ==> SQL Server I have to *continually* explicitly call $sth->finish on all statement handles otherwise I get errors about terminating an active statement handle. I also have to create a new connection per concurrent statement handle, as if I try to create 2 active statement handles on the 1 connection, things work OK ( mostly ) in testing, but as soon as I let the code loose in production, I get all sorts of strange things happening. So I'm constantly cloning connections when I need more than 1 active statement handle. Now, I'm not sure whether this is a problem with FreeTDS or with DBD::ODBC or whatever. But anyway, it's possible that someone else is cloning connections for the same reasons in OpenOffice, but not *closing* them when they're finished. It's not a problem with MySQL where you can crank up the number of connections as you please, but of course with SQL Server you can't do that. Anyway, good luck :) Sorry I can't really help you out further. You can try stuff like turning on ODBC logging on the client ( I assume it's in the unixODBC config file ), and either study it or post it here, or even better post it to the OpenOffice DBA list and see what they think about it. From memory, it defaults to logging into /tmp If I were you, and I were thinking about using Linux to talk to a database, I would make damned sure that database wasn't SQL Server. Why not start porting things to MySQL? Lastly, if you know some Perl, you might be interested in the work I've been doing at: http://entropy.homelinux.org/axis I'm currently working on a nice flashy GUI to wrap all the parts together, and it's actually happening easier than I thought it would :) -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
