APM: which ODBC do-dads?

[David Bluestein II]

Jeremy-

Having just gone through all of this on a strictly windows platform, DBI w/the ODBC module is the way to go. You'll just need to make sure DBD::ODBC has whatever it needs to function on Linux. You can also use something like DBI::Proxy to do the same thing, but I forget the specifics of how that is supposed to work.

David


On Thu, Aug 19, 2004 at 09:24:08PM -0500, Jeremy Brooks wrote:
> I'm going to look into using unixodbc as the odbc manager and freetds as
> the driver.  The site for iODBC was an immediate turn-off and didn't
> appear well organized.  
> 
> thanks to all,
>   Jeremy 
> 
> 
> On Thu, 2004-08-19 at 16:23, Leeland H wrote:
> > Re: APM: which ODBC do-dads?
> > Jeremy Brooks <jbrooks4 at austin.rr.com> writes:
> > >  I need to access a Microsoft SQL server from a Perl application
> > >running on a Linux machine.  I have DBI installed and have been using it
> > >for quite sometime with the mysql driver.  I've downloaded DBD-ODBC-1.09
> > >and now I need to get a "driver manager" and a driver to access the
> > >Microsoft SQL database... hmmm.  It looks like there are several
> > >option.  Who here has experience enough to give me some suggestions on
> > >which "driver manager" and driver to use?   
> > 
> > I've used iODBC Driver Manager, you can find info about it here:
> > 
> > http://www.openlinksw.com/iodbc/
> > 
> > The other major choice is unixODBC, which you can find here:
> > 
> > http://www.unixodbc.org/
> > 
> > A further source for information, and another option is to use
> > DBD-Sybase and FreeTDS (TDS is the wire level protocol both Sybase
> > and MS-SQL Server use (MS-SQL Server was originally based on code
> > licensed from Sybase).
> > 
> > http://www.freetds.org/
> > 
> > Hope that helps.
> > 
> 
> _______________________________________________
> Austin mailing list
> Austin at mail.pm.org
> http://mail.pm.org/mailman/listinfo/austin

-- 
David H. Bluestein II
President & Lead Developer        dbii at interaction.net
ii, inc.                          http://www.interaction.net
 -- Specializing in Designing Interactive Database Driven Websites --