Frank, I'm sorry I don't have a "why" for you. Frankly, I haven't had much time to investigate the whole of the "why". However, I can tell you that if you take two RH 7.x systems identically configured with identical FreeTDS, Perl, and Bundle::DBI installations, then try to install 0.95 ... well, it doesn't seem to want to play nice. I then tried the 0.95 on some other installs and found the same (fairly exasperating) results. The problem is not memory leaks. The problem is it's ability to work with the shared memory libraries, as in not finding the ones it needs to build out okay and run.
What OS (and version) did you apply your Sybase 9.95/freetds 0.61rc combo to? I haven't had any luck. Karyn -----Original Message----- From: Frank Wu [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 2:28 PM To: 'Karyn Ulriksen'; '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: connecting perl to MS SQL on Linux Hi Karyn, We just upgraded our perl application from Sybase 0.91/freetds 0.53 to Sybase 0.95/freetds 0.61rc to fix memory leak issue and it's suprised to me that your suggestion of using Sybase 0.94 instead of current version Sybase 0.95. Could you advise me the reasons and how memory leak issue is handled in Sybase 0.94? Thanks Frank -----Original Message----- From: Karyn Ulriksen [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 8:05 AM To: '[EMAIL PROTECTED]'; Karyn Ulriksen; [EMAIL PROTECTED] Subject: RE: connecting perl to MS SQL on Linux okay... what you'll want to do is this... download latest FreeTDS to your src directory gzip -d freetds-xxx.tar.gz tar xvf freetds-xxx.tar cd freetds-xxx ./configure --prefix=/usr --sysconfdir=/etc make make install edit the /etc/freetds.conf: find where it says: [JDBC] host = 192.138.151.39 port = 4444 tds version = 5.0 right after this add: [mydatabase] host = mydbhost.domain.com port = 1433 tds version = 7.0 save it out. ## this completes the Freetds install and config If you have CPAN ("perl -MCPAN -e shell")setup on your server, install the Bundle::DBI. Make sure all installs cleanly. Exit the CPAN module. (If you don't use the CPAN module, make certain that you install DBI, Storable, and any files that they declare as a prerequesite.) ## this completes installation of the basic DBI and supporting perl modules Assuming that you are using the Bourne shell (/bin/sh) or Bourne Again shell (/bin/bash) for your login, type the following command: export SYBASE=/usr ## this completes setting the SYBASE environmental variable Download DBD::Sybase 0.04 from your favorite CPAN mirror. gzip -d ... tar xvf ... cd ... perl Makefile.PL make make test (see note below) make install Note regarding 'make test': unless you have a database "test" and appropriate administrative privileges setup for the user you declare when asked during the "perl Makefile.PL" questions, it will complain it doesn't have permissions during 'make test'. I, generally, make sure that that is pretty much all it's complaining about. If it's complaining about shared libraries, you probably are installing DBD::Sybase 0.95, which seems to indicate that the rift is widening between MS SQL and Sybase's implementation of the TabularData Stream (the TDS of FreeTDS). If you're using Redhat Linux, this setup works like a charm on all RH versions 6.x through 7.x with the above steps. Have fun! Karyn -----Original Message----- From: Russell Kroboth [mailto:[EMAIL PROTECTED] Sent: Monday, February 24, 2003 12:49 PM To: 'Karyn Ulriksen'; [EMAIL PROTECTED] Subject: RE: connecting perl to MS SQL on Linux I did download .94 and attempted 'perl Makefile.PL', but I get the following error: Please set SYBASE in CONFIG, or set the $SYBASE environment variable at Makefile.PL line 90, <IN> line 39. I'm not sure what it's asking for? > -----Original Message----- > From: Karyn Ulriksen [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 2:22 PM > To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] > Subject: RE: connecting perl to MS SQL on Linux > > > Use the DBD::Sybase Driver... BUT!!! Don't use the current > version (0.95), > use the last version (0.94). I've been using FreeTDS for > about the past two > years. Works like a charm. Don't use ODBC, since it adds an > unnecessary > layer. FreeTDS speaks to the MS SQL natively. > > Karyn > > > -----Original Message----- > From: Russell Kroboth [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 11:04 AM > To: [EMAIL PROTECTED] > Subject: RE: connecting perl to MS SQL on Linux > > > > I think I just found a database driver, something called > FreeTDS, which is billed as just that. I downloaded > (www.freetds.org) and installed the rpm without error. But I > still get the same error when trying to do the final step of > installing the DBD::ODBC package. I wonder home I can make > this link between my unixODBC driver manager and DBD::ODBC, > which the Makefile.PL says I need to have... > > > > -----Original Message----- > > > From: Tim Howell [mailto:[EMAIL PROTECTED] > > > Sent: Monday, February 24, 2003 12:35 PM > > > To: [EMAIL PROTECTED] > > > Subject: RE: connecting perl to MS SQL on Linux > > > > > > > > > Rusty-- > > > > > > In addition to the DBD driver (in this case, DBD::ODBC), > you need a > > > database specific ODBC driver for MS SQL. AFAIK, there are > > no freely > > > available MS SQL ODBC drivers for linux. > > > > > > I've had a similar problem recently in trying to connect to > > SQL Server > > > from a RedHat box. The solution I've gone with is DBD::Proxy with > > > DBD::ODBC on the Windows machine to allow the linux box > to connect. > > > There's a page somewhere with instructions on doing just this; > > > unfortunately, I don't have the URL. > > > > > > FWIW, in order to make this setup work reliably, I had to patch > > > Net::Daemon and PlRPC on the Windows machine with a patch supplied > > > [EMAIL PROTECTED] > > > > > > Let me know if you have any questions. =) > > > > > > --TWH > > > > > > -----Original Message----- > > > From: Russell Kroboth [mailto:[EMAIL PROTECTED] > > > Sent: Monday, February 24, 2003 9:27 AM > > > To: [EMAIL PROTECTED] > > > Subject: connecting perl to MS SQL on Linux > > > > > > > > > I have a number of perl scripts used under Windows that I > > am trying to > > > port to a Redhat 8 Linux machine. All my scripts use DBI.pm and > > > DBD::ODBC to connect to an MS SQL Server database. > > > > > > I have seen this question several times here, and found > several FAQs > > > that all say that I need to simply install a driver manager > > > and a driver > > > on my Linux machine. So I thought I would install unixODBC as > > > the driver > > > manager, and then DBD:ODBC as my driver. I downloaded > and installed > > > unixODBC-2.2.2-3.i386.rpm. However, during the next step - > > > installation > > > of DBD:ODBC - I get the following error: > > > > > > Using DBI 1.32 installed in > > > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto > > > /DBI > > > > > > The DBD::ODBC module needs to link with an ODBC 'Driver > > Manager'. (The > > > Driver Manager, in turn, needs one or more database specific ODBC > > > drivers. The DBD::ODBC module does _not_ include any ODBC > drivers!) > > > > > > You need to indicate where your ODBC Driver Manager is > > installed. You > > > can do this ether by setting the ODBCHOME environment > variable or by > > > runing 'perl Makefile.PL -o odbcdir'. > > > > > > If you do not have an ODBC Driver Manager you can try > > > building the free > > > iODBC Driver Manager in the iodbcsrc directory. > > > > > > Makefile.PL aborted. > > > > > > > > > > > > According to the FAQ's I can find, and the unixODBC manual, > > > this should > > > not occur since I have installed the driver manager. Am I missing > > > something? Or doing this wrong? > > > > > > > > > Thanks! > > > Rusty > > > > > > > >
