Beefy Boxes and Bandwidth Generously Provided by pair Networks chromatic writing perl on a camel
more useful options
 
PerlMonks  

Re: Re: Differences with methods to access SQL Server 2000.

by tinman (Curate)
on Apr 20, 2001 at 20:06 UTC ( #74218=note: print w/ replies, xml ) Need Help??


in reply to Re: Differences with methods to access SQL Server 2000.
in thread Differences with methods to access SQL Server 2000.

From some experience trying to interface with MS-SQL 2000 with Perl, these are the things that I've discovered..

MSSQL::* libraries don't work from Unix.. I may have looked at an outdated version of the pages, but this page is what I saw and it wasn't very encouraging about working on Unix, or getting these libraries to work with SQL server 2000.

DBD::ODBC as mentioned above, worked well for me..I'd really not advise using something like DBD::Proxy, although that is indeed one option, because of the potential heavy traffic... instead use a Unix ODBC bridge such as iODBC in conjunction with DBD::ODBC... it may not be the fastest, perhaps.. but on what I implemented, it survived a load test of 150 concurrent users with no problems..
HTH


Comment on Re: Re: Differences with methods to access SQL Server 2000.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (6)
As of 2014-04-19 06:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (478 votes), past polls