Win32::ODBC to Unix

otijim has asked for the wisdom of the Perl Monks concerning the following question:

I'm using the WIN32::ODBC module (in ActivePerl for Windows) to access a database on a network. I use an NT4 Workstation and the code works fine, but ultimately we want to port this to a unix box on the network. So, how can I port this? I need thy great wisdom! Help!

Comment on Win32::ODBC to Unix

Replies are listed 'Best First'.
Re: Win32::ODBC to Unix by clemburg (Curate) on Nov 14, 2000 at 00:09 UTC
Use DBI with DBD::ODBC. Christian Lemburg Brainbench MVP for Perl http://www.brainbench.com	[reply]
Re: Win32::ODBC to Unix by Caillte (Friar) on Nov 21, 2000 at 15:00 UTC
In general you will find that using the more generic DBI module will save you a lot of pain when it comes to porting programs to other platforms. For example, if you wish to change your ODBC database to a MySQL dayabase then all you have to do is change the initialisation line for the DBI program (and the database, of course ;))	[reply]