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]
