Professional Web Applications Themes

DBD for SQL Server? - PERL Beginners

Is there a DBD for SQL Server so that I can connect to our SQL Server 2000 database with DBI? I've hunted all over CPAN but I can't seem to find one. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / ucdavis.edu...

  1. #1

    Default DBD for SQL Server?

    Is there a DBD for SQL Server so that I can connect to our SQL Server
    2000 database with DBI? I've hunted all over CPAN but I can't seem to
    find one.

    --
    Richard S. Crawford
    Programmer III,
    UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
    (916)327-7793 / ucdavis.edu

    Richard Guest

  2. #2

    Default Re: DBD for SQL Server?


    --- Richard Crawford <ucdavis.edu>
    wrote: 
    Windows uses the Open Database Connectivity (ODBC)
    Model. You can connect to an MS-SQL server using
    Win32::ODBC, available at
    http://search.cpan.org/~gsar/libwin32-0.191/ODBC/ODBC.pm

    More info - perldoc Win32::ODBC


    HTH,
    Alok





    __________________________________
    Do you Yahoo!?
    Yahoo! Movies - Buy advance tickets for 'Shrek 2'
    http://movies./showtimes/movie?mid=1808405861
    Alok Guest

  3. #3

    Default Re: DBD for SQL Server?

    NYIMI Jose (BMB) wrote:
     
    >>
    >>Windows uses the Open Database Connectivity (ODBC)
    >>Model. You can connect to an MS-SQL server using
    >>Win32::ODBC, available at[/ref]
    >
    >
    > Then you will no longer be using DBI API (what OP wanted) !
    >
    > The advantage of DBD::ODBC (or DBD::ADO )
    > Is the portability of your code since you
    > Will be using the same api syntax regarless the
    > The database driver (DBD) you are dealing with behind DBI.
    >
    > The connection is always
    > my $dbh=DBI->connect(...);
    >
    > Not a new api like:
    > $Data = new Win32::ODBC(...);
    > Which obviously will not work if you need
    > To use your same code on a database running on unix box.
    >
    > HTH,
    >
    > José.[/ref]

    I've learned that in order to use DBD::ODBC I will still need to install
    an ODBC driver on the machine (which is actually running Solaris 9).
    Not a problem, if I can find one.


    --
    Richard S. Crawford
    Programmer III,
    UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu)
    (916)327-7793 / ucdavis.edu
    Richard Guest

  4. #4

    Default Re: DBD for SQL Server?

    On Tue, 2004-05-11 at 18:40, Richard Crawford wrote: 

    Richard,

    I'm running a mod_perl site connected to a SQL Server 2000 backend via
    DBD::ODBC with a driver from OpenlinkSW.

    Go to http://www.openlinksw.com. They will let you download a full
    working driver, but it has a 30 license. If you need more than 30 days
    you'll have to redownload the driver and it'll email you another 30 day
    license. It took us about 6 months of "testing" before we bought the
    driver for about $600, buti it was well worth it.

    They'll also give you the iODBC SDK (driver manager) and phone support
    even if you're evaluating. Lot's of praise on the phone support as they
    worked with me for 5 days and had a developer helping me as I was having
    trouble getting it interfaced with mod_perl for some weird reason. Long
    story short mod_perl was only seeing unixODBC (another driver manager)
    and so I had use unixODBC instead of iODBC. No biggie, it was tracking
    this down that was the problem.

    Hope this helps,
    Kevin
    --
    Kevin Old <homelinux.com>

    Kevin Guest

  5. #5

    Default RE : DBD for SQL Server?


     
    > >
    > >
    > > Then you will no longer be using DBI API (what OP wanted) !
    > >
    > > The advantage of DBD::ODBC (or DBD::ADO )
    > > Is the portability of your code since you
    > > Will be using the same api syntax regarless the
    > > The database driver (DBD) you are dealing with behind DBI.
    > >
    > > The connection is always
    > > my $dbh=DBI->connect(...);
    > >
    > > Not a new api like:
    > > $Data = new Win32::ODBC(...);
    > > Which obviously will not work if you need
    > > To use your same code on a database running on unix box.
    > >
    > > HTH,
    > >
    > > José.[/ref]
    >
    > I've learned that in order to use DBD::ODBC I will still need to[/ref]
    install 

    http://www.unixodbc.org/

    José.


    Jose Guest

Similar Threads

  1. Replies: 2
    Last Post: September 12th, 10:44 PM
  2. Replies: 0
    Last Post: August 23rd, 05:27 PM
  3. Replies: 0
    Last Post: January 31st, 11:30 AM
  4. Replies: 0
    Last Post: July 6th, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139