Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Sybase to MSSQl migration for Perl in Linux RHEL

by talexb (Canon)
on Jan 18, 2021 at 02:51 UTC ( #11127051=note: print w/replies, xml ) Need Help??


in reply to Sybase to MSSQl migration for Perl in Linux RHEL

I used FreeTDS to connect to an MSSQL database. The documentation is available here.

The configuration file I use (slightly sanitized for obvious reasons) is here:

# $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $ # # This file is installed by FreeTDS if no file by the same # name is found in the installation directory. # # For information about the layout of this file and its settings, # see the freetds.conf manpage "man freetds.conf". # Global settings are overridden by those in a database # server specific section [global] # TDS protocol version ; tds version = 4.2 # Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) dump file = /tmp/freetds.log debug flags = 0xffff # Command and connection timeouts ; timeout = 10 ; connect timeout = 10 # If you get out-of-memory errors, it may mean that your clien +t # is trying to allocate a huge buffer for a TEXT field. # Try setting 'text size' to a more reasonable limit text size = 64512 # A typical Microsoft server [SqlServer] database = ABCDAT host = 192.0.0.1 port = 1433 tds version = 7.4 client charset = UTF-8 dump file = /tmp/foo.log debug flags = 0x001e

There is a Microsoft driver, but this one worked for me (although it doesn't allow multiple active statement handles). I set this up about three years ago, so I may not be able to explain how I got it working.

If I had time, I'd love to try the Microsoft driver .. but for now, this works.

Alex / talexb / Toronto

Thanks PJ. We owe you so much. Groklaw -- RIP -- 2003 to 2013.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (5)
As of 2021-09-28 12:46 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?