Re: Connecting to Database

On Monday 10 December 2007 15:47:17 Tim Bunce wrote:
On Mon, Dec 10, 2007 at 08:35:34AM +0000, Martin Evans wrote:
ithier.ctr@xxxxxxxxxxxxx wrote:
Hello

At the present time I am using Perl, cgi, Apache Web Page, SQL, and
SYBASE database on a unix server(SUN Fire V 880). I have no problem
accessing the Sybase database, fetching records and display them on the
web page.

My Available Database Drivers are.
DBM
ExampleP
File
Proxy
Sponge
Sybase

Now, I would like to connect to another database on a Microsoft SQL
Server, using Perl from my unix server.

What do I need?

Where can I get information? (book or web page)

http://search.cpan.org/~mjevans/DBD-ODBC-1.15_2/ODBC.pm#Frequently_Asked_
Questions Scroll down to "How do I access a MS SQL Server database from
Linux?" The "Linux" could should be "Unix".

That needs updating to say something like "Use DBD::Proxy if you need
transactions and DBD::Gofer if you don't."

Tim.

I've had excellent results with freeTDS (see freetds.org)
I can send you some examples if needed

.

Relevant Pages

  • PostgreSQL and Customer Database
    ... I've been working on both SQL and Perl for a while now, ... get them all onto an SQL database, and be able to keep track of sales, as ... the database available to customers and potential customers, ...
    (perl.beginners)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)
  • Re: dbdebunk Quote of Week comment
    ... But SQL does not have a pointer data type or the ... More and more programmers who have absolutely no database training are ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)