FreeTDS Development Group

["Nicki Handy" <nhandy AT assumption.edu>]

Thanks- the latest snapshot worked. I then went to cpan and got dbd::sybase
but I haven't been able to get a perl test to run (I didn't get too many
failed tests either when I make installed, seemed to connect ok). Is it
required that I set up odbc? I've edited all the odbc.ini files I could find
but none of them resided where the docs thought they should. I have
everything in /usr/local/ not /usr/local/freetds
I also couldn't locate the isql command but tsql seems to connect fine.
This is the test I am using with perl: (I suspect I should change things but
I named everything
in odbc.ini as the example named things and substituted my server info, but
'guest' should not work)

#!/usr/bin/perl
#
use DBI;

my $dbh = DBI->connect("dbi:Sybase:server=JDBC", 'guest', 'sybase',
{PrintError => 0});

die "Unable for connect to server $DBI::errstr"
    unless $dbh;

my $rc;
my $sth;

$sth = $dbh->prepare("select \@\@servername");
if($sth->execute) {
    while(@dat = $sth->fetchrow) {
                print "@dat\n";
    }
}



The output I get is
tds_connect: 192.138.151.39:4444: Operation timed out

I suspect I am not finding the correct odbc to edit b/c that's not my server
nor the port I use. When I was setting the parameters when installing
DBD::Sybase, I did put in my server info and it liked it. Somehow I thought
that would be set as a system var, but now I think there's more to do.
Thanks a lot,
Nicki

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org]On Behalf Of
freetds-request AT lists.ibiblio.org
Sent: Tuesday, July 13, 2004 12:05 PM
To: freetds AT lists.ibiblio.org
Subject: FreeTDS Digest, Vol 18, Issue 14


Send FreeTDS mailing list submissions to
        freetds AT lists.ibiblio.org

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.ibiblio.org/mailman/listinfo/freetds
or, via email, send a message with subject or body 'help' to
        freetds-request AT lists.ibiblio.org

You can reach the person managing the list at
        freetds-owner AT lists.ibiblio.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of FreeTDS digest..."


Today's Topics:

   1. Re: Use TSD library under MacOS X 10.3 (Frediano Ziglio)
   2. make fails in macosx 10.3 libtools section (Nicki Handy)
   3. Re: make fails in macosx 10.3 libtools section (Frediano Ziglio)
   4. Re: make fails in macosx 10.3 libtools section (James K. Lowden)


----------------------------------------------------------------------

Message: 1
Date: Mon, 12 Jul 2004 19:00:59 +0200
From: Frediano Ziglio <freddyz77 AT tin.it>
Subject: Re: [freetds] Use TSD library under MacOS X 10.3
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID: <1089651659.3996.4.camel@freddy>
Content-Type: text/plain

Il lun, 2004-07-12 alle 11:54, Fabrizio Taretto ha scritto:
> Hi all,
>
> I would like to use the TDS library to develop C/C++ application using
> Metrowerks Code Warrior 8.3 on OS X 10.3.4 (my final idea is to use the
> TDS library to develop a InDesign CS plug-in).
>
> Could anyone tell me if it is possible?
>
> Regards,
> Fabrizio
>

Hi Fabrizio,
I think it's possible. It's possible to compile and use all FreeTDS
libraries under Mac OS X. ODBC seems to be a bit difficult to build but
recent snapshot seems to work flawlessly

ciao
  freddy77




------------------------------

Message: 2
Date: Mon, 12 Jul 2004 15:39:18 -0400
From: "Nicki Handy" <nhandy AT assumption.edu>
Subject: [freetds] make fails in macosx 10.3 libtools section
To: <freetds AT lists.ibiblio.org>
Message-ID: <HFEHIFOEINBAIMCDDJCLIEBBCFAA.nhandy AT assumption.edu>
Content-Type: text/plain;       charset="iso-8859-1"


Hello- I have a novice question, but I couldn't find anything in the
documentation or the archives. I am getting an error on make in max osx
10.3.4. i am logged in as root. i read in the known problems with OSes that
one line in the libtool should be edited for osx so I think that might be my
problem. unfortunately, the directions seem to be a bit outdated- they say
to edit a line that is different in the version I have but I did delete out
the variable $deplibs after i started getting these errors. That did not
help. Any ideas?

/usr/bin/libtool: unknown option character `B' in: -Bsymbolic
Usage: /usr/bin/libtool -static [-] file [...] [-filelist
listfile[,dirname]] [-arch_only arch] [-sacLT]
Usage: /usr/bin/libtool -dynamic [-] file [...] [-filelist
listfile[,dirname]] [-arch_only arch] [-o output] [-install_name name]
[-compatibility_version #] [-current_version #] [-seg1addr 0x#]
[-segs_read_only_addr 0x#] [-segs_read_write_addr 0x#] [-seg_addr_table
<filename>] [-seg_addr_table_filename <file_system_path>] [-all_load]
[-noall_load]
make[3]: *** [libtdsodbc.la] Error 1
make[2]: *** [all-recursive] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive] Error 1
[ast:assumpti/Desktop/freetds-0.62.4] root#
-------------------------------------------------------------------
this is what the docs say to change: (i'm not sure how i would apply this
patch but as i said i simply deleted the var i thought it might not like)
Figure 2-1. libtool patch for OS X 10.3
--- libtool-orig Thu Nov 6 15:34:53 2003
+++ libtool Thu Nov 6 15:38:45 2003
@@ -202,7 +202,7 @@
old_archive_from_expsyms_cmds=""

# Commands used to build and install a shared archive.
-archive_cmds="\$CC \$(if test .\$module = .yes; then echo -bundle; else
echo -dynamiclib; fi) \$allow_undefined_flag -o \$lib \$libobjs \$deplibs
\$linkopts -install_name\$rpath/\$soname \$verstring"
+archive_cmds="\$CC \$(if test .\$module = .yes; then echo -bundle; else
echo -dynamiclib; fi) \$allow_undefined_flag -o \$lib \$libobjs
\$linkopts -install_name\$rpath/\$soname \$verstring"
archive_expsym_cmds=""
postinstall_cmds=""
postuninstall_cmds=""

This patch was contributed by <Daniel Fazekas>, and has been used
successfully by three people that we know of. As you can see, the only
effect is to remove \$deplibs from line 202.

Thanks a lot
Nicki




------------------------------

Message: 3
Date: Mon, 12 Jul 2004 21:48:14 +0200
From: Frediano Ziglio <freddyz77 AT tin.it>
Subject: Re: [freetds] make fails in macosx 10.3 libtools section
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID: <1089661694.28708.1.camel@freddy>
Content-Type: text/plain

Il lun, 2004-07-12 alle 21:39, Nicki Handy ha scritto:
> Hello- I have a novice question, but I couldn't find anything in the
> documentation or the archives. I am getting an error on make in max osx
> 10.3.4. i am logged in as root. i read in the known problems with OSes
that
> one line in the libtool should be edited for osx so I think that might be
my
> problem. unfortunately, the directions seem to be a bit outdated- they say
> to edit a line that is different in the version I have but I did delete
out
> the variable $deplibs after i started getting these errors. That did not
> help. Any ideas?
>
> /usr/bin/libtool: unknown option character `B' in: -Bsymbolic
> Usage: /usr/bin/libtool -static [-] file [...] [-filelist
> listfile[,dirname]] [-arch_only arch] [-sacLT]
> Usage: /usr/bin/libtool -dynamic [-] file [...] [-filelist
> listfile[,dirname]] [-arch_only arch] [-o output] [-install_name name]
> [-compatibility_version #] [-current_version #] [-seg1addr 0x#]
> [-segs_read_only_addr 0x#] [-segs_read_write_addr 0x#] [-seg_addr_table
> <filename>] [-seg_addr_table_filename <file_system_path>] [-all_load]
> [-noall_load]
> make[3]: *** [libtdsodbc.la] Error 1
> make[2]: *** [all-recursive] Error 1
> make[1]: *** [all-recursive] Error 1
> make: *** [all-recursive] Error 1
> [ast:assumpti/Desktop/freetds-0.62.4] root#
> -------------------------------------------------------------------
> this is what the docs say to change: (i'm not sure how i would apply this
> patch but as i said i simply deleted the var i thought it might not like)
> Figure 2-1. libtool patch for OS X 10.3
> --- libtool-orig Thu Nov 6 15:34:53 2003
> +++ libtool Thu Nov 6 15:38:45 2003
> @@ -202,7 +202,7 @@
> old_archive_from_expsyms_cmds=""
>
> # Commands used to build and install a shared archive.
> -archive_cmds="\$CC \$(if test .\$module = .yes; then echo -bundle; else
> echo -dynamiclib; fi) \$allow_undefined_flag -o \$lib \$libobjs \$deplibs
> \$linkopts -install_name\$rpath/\$soname \$verstring"
> +archive_cmds="\$CC \$(if test .\$module = .yes; then echo -bundle; else
> echo -dynamiclib; fi) \$allow_undefined_flag -o \$lib \$libobjs
> \$linkopts -install_name\$rpath/\$soname \$verstring"
> archive_expsym_cmds=""
> postinstall_cmds=""
> postuninstall_cmds=""
>
> This patch was contributed by <Daniel Fazekas>, and has been used
> successfully by three people that we know of. As you can see, the only
> effect is to remove \$deplibs from line 202.
>
> Thanks a lot
> Nicki
>

Please try snapshot version. Or you can try to remove -Bsymbolic and add
a -module in src/odbc/Makefile.am and rebuild build tools (automake,
autoconf and recent libtool needed).

freddy77




------------------------------

Message: 4
Date: Mon, 12 Jul 2004 21:03:07 -0400
From: "James K. Lowden" <jklowden AT schemamania.org>
Subject: Re: [freetds] make fails in macosx 10.3 libtools section
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID: <20040712210307.01c0aaf1.jklowden AT schemamania.org>
Content-Type: text/plain; charset=US-ASCII

On Mon, 12 Jul 2004 <nhandy AT assumption.edu> wrote:
> I am getting an error on make in max osx
> 10.3.4. i am logged in as root. i read in the known problems with OSes
> that one line in the libtool should be edited for osx so I think that
> might be my problem. unfortunately, the directions seem to be a bit
> outdated- they say to edit a line that is different in the version I
> have but I did delete out the variable $deplibs after i started getting
> these errors. That did not help.

You're right about the docs being out of date on that point.  Patching
libtool was necessary through 0.62.3.  With 0.62.4, we switched libtool
versions.  I *think* 0.62.4 builds out of the box on OS X, but in any case
the patch you found is not needed.  It applies only to earlier 0.62.x
releases.

On July 7, Daniel Fazekas reported the nightly snapshot built correctly.
At the time, that was with version 0.63.dev.20040702.

--jkl




------------------------------

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest, Vol 18, Issue 14
***************************************