November 2002
Intermediate to advanced
758 pages
19h 45m
English
Content preview from Computer Science & Perl ProgrammingBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 62. Win32::ODBC
Joe Casadonte
I was once told, “Look to your hobbies to start a business.” About three years ago, I thought about starting a company that combined my hobbies: Perl and the Internet. I found a store in Delaware that sold thousands of hot sauces, another of my passions, and an idea came to me—I could sell the hot sauces for the store online. I would put the product data into a database and take orders over the Web, using Perl to generate the HTML and keep track of sales.
One part was missing. How would I connect to a database? Outside of work, I had access only to a Win95 machine. It ran Perl for Win32 from ActiveState. OraPerl and DBI hadn’t yet been ported to the Win32 platform. For a long time I was stuck.
What I really wanted was an ODBC (Open Database Connectivity) solution. ODBC is Microsoft’s attempt to standardize database access. If a program needs to connect to an Oracle database, an Informix database, and an Access database, it needs three different versions of the database code for each, because each of those databases has its own proprietary access scheme. With ODBC, you simply write your program to conform to the ODBC API and let the ODBC Manager and Driver take care of the database language specifics. Initially just a Windows solution, ODBC is now finding its way onto many Unix boxes.
Along came Dave Roth’s Win32::ODBC module. Dave married the ODBC toolkit with Perl, giving me (and countless others) access to databases from Perl on Windows. I began ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.