You do not need to specifically "use" DBD::mysql, or DBD::ODBC, you are already using it correctly: use DBI, then refer to the driver in the connect() call and DBI will load the DBD for that driver automatically. And yes, changing ODBC for mysql is the main thing you will have to do. (I'm assuming you have DBD::ODBC installed, if not use ppm to get it or go here to download DBD::ODBC). You will probably need to set up a system DSN for your database or else google for DSN-less connection to create on-the-fly ODBC connections. Other needed changes may or may not be simple, depending on whether you used SQL that is specific to MySQL, if you're just doing simple connections and queries, you should be fine. The docs for DBD::ODBC (and all perl modules) are in the modules themselves, you can get to them with perldoc DBD::ODBC on the command line, or by Start Menu - Programs - ActivePerl - Documentaion, or by looking on CPAN, for example the DBD::ODBC documentation online.
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|