Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

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

by Anonymous Monk
on Jul 17, 2014 at 14:28 UTC ( [id://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

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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1094060]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others having an uproarious good time at the Monastery: (2)
As of 2024-03-19 06:39 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found