Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

DBI!! (was: Win32::ODBC undefined DSN)

by BBQ (Curate)
on Jul 07, 2000 at 09:25 UTC ( [id://21411]=note: print w/replies, xml ) Need Help??


in reply to Win32::ODBC undefined DSN

wabranty, since you are starting off, I'd seriously give some thought at checking out DBI and the DBD drivers. DBI has become the de facto database interface for all your perl needs. While Win32::ODBC works on Win (doh), DBI will run on virtually all platforms provided you have the requirements to load the correct database driver (read DBD).

On Win, you can use almost the same amount of drivers (DBD::Oracle, DBD::mysql, DBD::CSV, etc) and if you run out of options on DBD's, there is always DBD::ODBC. The nice thing about DBI is works cross-platform, cross-database! You can develop on one database/platform and deliver on another entirely diferent system.

Tim Bunce should probably hire me as a marketing guy for DBI, since I think this is the 3rd time or so that I answer a Win32::ODBC question by pointing towards DBI. Beleive me when I say its well worth the shot!

#!/home/bbq/bin/perl
# Trust no1!

Replies are listed 'Best First'.
RE: DBI!! (was: Win32::ODBC undefined DSN)
by buzzcutbuddha (Chaplain) on Jul 07, 2000 at 16:15 UTC
    I too have answered this question many times, and BBQ is right on the money. Connecting to databases can be confusing, especially trying to use Win32::ODBC. If you intend to work on other platforms, then start learning the DBI now, and you will be greatly rewarded for your effort (not like it's hard to learn) :). Otherwise, if you just need a quick and dirty way to get at data in an existing database with an existing DSN connection then look at this node which states the same thing I just said above and shows how to use ADO from Perl.

    Good question though. Good luck!

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (7)
As of 2024-04-24 10:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found