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

DBD::ODBC on linux

by sdyates (Scribe)
on Oct 04, 2001 at 23:27 UTC ( #116801=perlquestion: print w/replies, xml ) Need Help??

sdyates has asked for the wisdom of the Perl Monks concerning the following question:

I am connecting to SQL Database v7.0, not 6.5. Therefore, I have to use DBD::ODBC. Using Linux 7.0. I have read previous posts, but do not want to duplicate previous errors. Which is the best way to do this? Thanks.

Replies are listed 'Best First'.
Re: DBD::ODBC on linux
by MrCromeDome (Deacon) on Oct 04, 2001 at 23:52 UTC
    I'm assuming you mean Microsoft SQL Server 7.0. . . and as for Linux, I'll make no assumptions (but it doesn't really matter).

    Given that, the following should be of some use to you:

    Linux, unlike Windoze, does not have a built-in ODBC manager. As such, you will need to install one of these packages to connect to SQL server. DBD::ODBC can take care of the rest (that is, unless you use DBD::Sybase. Why Sybase? Because MSSQL Server is derived from it).

    For even more information, do a Perl Monks Super Search for SQL Server.

    Next time, please be a little more descriptive ;)


Re: DBD::ODBC on linux
by kb2yht (Acolyte) on Oct 05, 2001 at 12:40 UTC
    ok ... Stick with DBD::ODBC
    just for style and maintanablity of your code stick to DBD calls rather than using ODBC or Sybase unique calls.
    but you allready knew that .....
    the largest problem I've had with ODBC is geting a connected to NT servers. Once connected ODBC/MySQL/Oracal all work the same.
    as for using ODBC on linux rather than any other sys.... if you use DBD::ODBC the same code should run on linux 2.2 2.4 or win2k with out changes.

Re: DBD::ODBC on linux
by sdyates (Scribe) on Oct 05, 2001 at 19:47 UTC
    I have tried various driver manager: none of which install properly. I keep a tight system and am not willing to install a bunch of crap just to have a nice GUI to manage things. Is anyone aware of a simple ODBC driver which is set up in a simple manner, rpm would be best. I just need DBD::ODBC to use this in relation to perl. I just want something tight and easy to install. Any one been trhough this before? Please advise, Simon

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://116801]
Approved by root
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others contemplating the Monastery: (5)
As of 2023-12-01 19:28 GMT
Find Nodes?
    Voting Booth?
    What's your preferred 'use VERSION' for new CPAN modules in 2023?

    Results (5 votes). Check out past polls.