Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Accessing Microsoft SQL Server from Linux using DBD::Sybase

by Anonymous Monk
on Jul 17, 2014 at 14:28 UTC ( #1094060=note: print w/ replies, xml ) Need Help??


in reply to Accessing Microsoft SQL Server from Linux using DBD::Sybase

A very useful and clear article, thank you!

Worth knowing: By default, if you use the tsql date commands, you get the date from DBD::Sybase in a rather inconvenient format, with the year, day and month like this: "Jul 8 2014".

If you add

$dbh->syb_date_fmt('ISO');

Just after you open the database handle, DBD::Sybase then presents date data in a more useful format, "2014-07-08".

More details at Stack Overflow:
http://stackoverflow.com/questions/14286821/perl-rewrite-sql-date-format/14287790#14287790


Comment on Re: Accessing Microsoft SQL Server from Linux using DBD::Sybase
Download Code
Replies are listed 'Best First'.
Re^2: Accessing Microsoft SQL Server from Linux using DBD::Sybase
by srini.here (Initiate) on Oct 16, 2014 at 14:53 UTC
    I get the following error :  perl: symbol lookup error: /usr/bin/perl5/DBI/1.607/exec/5.10/lib/perl5/auto/DBI/DBI.so: undefined symbol: Perl_Istack_sp_ptr But I can connect perfectly with the below:  /efs/dist/fsf/freetds/0.82/exec/bin/tsql -S DBName -I $HOME/freetds.conf -U userName -P passwOrd what might be the issue?

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1094060]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (15)
As of 2015-07-31 13:33 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (277 votes), past polls