FreeTDS Development Group

["Thompson, Bill D (London)" <ThompBil AT exchange.uk.ml.com>]

Hi Lakh,

I've got sybperl/freetds in production here, although we don't recall the
compilation issue you've run into.
However if you get the basics working you should be able to proceed with
confidence. 
Sybperl is a thin wrapper around the db-library functions, and the
db-library API in freetds is the most robust and well-understood API we
support.

I would also download sqsh (www.sqsh.org) as a tool worth using ( the old
version 1.4 you can find there also used db-library , the newer 1.7 uses
ct-library )
Notice you at Nomura in London. I'm at Merrill Lynch (just around the corner
I believe). 
So if you want a precedent for using FreeTDS - I'm happy to provide a
reference.

If you run into anything else, just let the list know....

good luck,

Bill


> -----Original Message-----
> From: Gill, Lakh [SMTP:lakh.gill AT uk.nomura.com]
> Sent: 23 July 2003 15:14
> To:   'FreeTDS Development Group'
> Subject:      RE: [freetds] Building sybperl ontop of freeTDS to connect
> to MS Sqlserver
> 
> Hi Bill,
> 
> It does seem to work although I was surprised it was required !
> Thanks for the quick response, any views on what I'm trying to do, as I
> said
> I'm very new to freeTDS ?
> I already have quite a few classes built upon sybperl for sybase so I was
> hoping to reuse them for ms sqlserver.
> 
> Regards
> 
> Lakh
> 
> -----Original Message-----
> From: Thompson, Bill D (London) [mailto:thompbil AT exchange.uk.ml.com]
> Sent: 23 July 2003 13:02
> To: 'FreeTDS Development Group'
> Subject: RE: [freetds] Building sybperl ontop of freeTDS to connect to
> MS Sqlserver
> 
> 
> Hi Lakh,
> 
> welcome to freeTDS.
> 
> Your workaround seems reasonable. Sybase's sybdb.h has MAXNAME #define'd
> although comments around it suggest that its there for backwards
> compatibility only.
> In my sybase sybdb.h it seems to be replaced going forward with DBMAXNAME
> ,
> as less likely to conflict with any #define in applications.
> 
> Bill
> 
> > -----Original Message-----
> > From:       Gill, Lakh [SMTP:lakh.gill AT uk.nomura.com]
> > Sent:       23 July 2003 12:53
> > To: 'FreeTDS Development Group'
> > Subject:    RE: [freetds] Building sybperl ontop of freeTDS to connect
> > to MS Sqlserver
> > 
> > Guys,
> > 
> > I've managed to compile it by adding the macro to sybdb.h but is what I
> am
> > doing valid anyway ?
> > 
> > Regards
> > 
> > Lakh
> > 
> > -----Original Message-----
> > From: Gill, Lakh [mailto:lakh.gill AT uk.nomura.com]
> > Sent: 23 July 2003 12:37
> > To: 'FreeTDS Development Group'
> > Subject: [freetds] Building sybperl ontop of freeTDS to connect to MS
> > Sqlserver
> > 
> > 
> > Hi,
> > 
> > 
> > freeTDS newee here although I've been using sybperl with sybase
> > openclientc
> > for a while.
> > 
> > I've tried compiling sybperl into a version of perl that I want to use
> to
> > access sqlserver and I get the following errors when I run the "make":
> > 
> > cc -c -I/data/sybase/freeTDS/include -D_LARGEFILE_SOURCE
> > -D_FILE_OFFSET_BITS=64 -O    -DVERSION=\"2.14\"  -DXS_VERSION=\"2.14\"
> > -KPIC
> > -I/data/sybase/DbaPerl4Msql/lib/perl5/5.6.1/sun4-solaris/CORE
> > -DDBLIBVS=1000
> > -DSYBPLVER='"2.14"' -DDO_TIE DBlib.c
> > "DBlib.xs", line 912: undefined symbol: MAXNAME
> > "DBlib.xs", line 4351: warning: assignment type mismatch:
> >         pointer to char "=" pointer to const char
> > "DBlib.xs", line 4430: warning: argument #3 is incompatible with
> > prototype:
> >         prototype: pointer to uchar :
> > "/data/sybase/freeTDS/include/sybdb.h", line 576
> >         argument : pointer to char
> > "DBlib.c", line 5084: warning: assignment type mismatch:
> >         pointer to char "=" pointer to const char
> > cc: acomp failed for DBlib.c
> > *** Error code 2
> > make: Fatal error: Command failed for target `DBlib.o'
> > Current working directory /data/sybase/tmp/sybperl-2.14/DBlib
> > *** Error code 1
> > make: Fatal error: Command failed for target `subdirs'
> > 
> > Am I being silly here 
> > 
> > Regards
> > 
> > Lakh
> > 
> > 
> > PLEASE READ: The information contained in this email is confidential
> > and intended for the named recipient(s) only. If you are not an intended
> > recipient of this email you must not copy, distribute or take any 
> > further action in reliance on it and you should delete it and notify the
> > sender immediately. Email is not a secure method of communication and 
> > Nomura International plc cannot accept responsibility for the accuracy
> > or completeness of this message or any attachment(s). Please examine
> this
> > email for virus infection, for which Nomura International plc accepts
> > no responsibility. If verification of this email is sought then please
> > request a hard copy. Unless otherwise stated any views or opinions
> > presented are solely those of the author and do not represent those of
> > Nomura International plc. This email is intended for informational
> > purposes only and is not a solicitation or offer to buy or sell
> > securities or related financial instruments. Nomura International plc is
> > regulated by the Financial Services Authority and is a member of the
> > London Stock Exchange.
> > 
> > 
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> > 
> > 
> > PLEASE READ: The information contained in this email is confidential
> > and intended for the named recipient(s) only. If you are not an intended
> > recipient of this email you must not copy, distribute or take any 
> > further action in reliance on it and you should delete it and notify the
> > sender immediately. Email is not a secure method of communication and 
> > Nomura International plc cannot accept responsibility for the accuracy
> > or completeness of this message or any attachment(s). Please examine
> this
> > email for virus infection, for which Nomura International plc accepts
> > no responsibility. If verification of this email is sought then please
> > request a hard copy. Unless otherwise stated any views or opinions
> > presented are solely those of the author and do not represent those of
> > Nomura International plc. This email is intended for informational
> > purposes only and is not a solicitation or offer to buy or sell
> > securities or related financial instruments. Nomura International plc is
> > regulated by the Financial Services Authority and is a member of the
> > London Stock Exchange.
> > 
> > 
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 
> 
> PLEASE READ: The information contained in this email is confidential
> and intended for the named recipient(s) only. If you are not an intended
> recipient of this email you must not copy, distribute or take any 
> further action in reliance on it and you should delete it and notify the
> sender immediately. Email is not a secure method of communication and 
> Nomura International plc cannot accept responsibility for the accuracy
> or completeness of this message or any attachment(s). Please examine this
> email for virus infection, for which Nomura International plc accepts
> no responsibility. If verification of this email is sought then please
> request a hard copy. Unless otherwise stated any views or opinions
> presented are solely those of the author and do not represent those of
> Nomura International plc. This email is intended for informational
> purposes only and is not a solicitation or offer to buy or sell
> securities or related financial instruments. Nomura International plc is
> regulated by the Financial Services Authority and is a member of the
> London Stock Exchange.
> 
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds