Mailing List Archive: Interchange: users

Perl odbc?

Index | Next | Previous | View Threaded

icdev at mrlock

May 6, 2008, 8:45 AM

Post #1 of 5 (148 views)
Permalink

Perl odbc?

Hello,

What or how do you connect to a live MS database via Perl?

I can connect to various databases via Linux with php and a special
program called odbtp. How do you do this with Perl?

Just curious,

Steve

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

racke at linuxia

May 6, 2008, 8:55 AM

Post #2 of 5 (143 views)
Permalink

Re: Perl odbc? [In reply to]

Steve Graham wrote:
> Hello,
>
> What or how do you connect to a live MS database via Perl?
>
> I can connect to various databases via Linux with php and a special
> program called odbtp. How do you do this with Perl?

Years ago it worked with DBI and DBD::Sybase.

Regards
Racke

--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

mike at perusion

May 6, 2008, 9:00 AM

Post #3 of 5 (143 views)
Permalink

Re: Perl odbc? [In reply to]

Quoting Stefan Hornburg (Racke) (racke[at]linuxia.de):
> Steve Graham wrote:
> > Hello,
> >
> > What or how do you connect to a live MS database via Perl?
> >
> > I can connect to various databases via Linux with php and a special
> > program called odbtp. How do you do this with Perl?
>
> Years ago it worked with DBI and DBD::Sybase.

You are talking about connecting to SQL Server, Racke. I don't think
that goes anymore, but now it can be made to work with DBI and
DBD::ODBC.

You can also connect directly to MySQL with DBD::MySQL, or PostGres, or
Solid, or DB2, or Oracle. Surprise, surprise -- Microsoft SQL Server is
the only one without a Linux driver.

--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.765.647.1295 tollfree 800-949-1889 <mike[at]perusion.com>

There comes a time when you should stop expecting other people to make
a big deal about your birthday. That time is age 12. -- Dave Barry

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

mike at perusion

May 6, 2008, 9:03 AM

Post #4 of 5 (143 views)
Permalink

Re: Perl odbc? [In reply to]

Quoting Mike Heins (mike[at]perusion.com):
> Quoting Stefan Hornburg (Racke) (racke[at]linuxia.de):
> > Steve Graham wrote:
> > > Hello,
> > >
> > > What or how do you connect to a live MS database via Perl?
> > >
> > > I can connect to various databases via Linux with php and a special
> > > program called odbtp. How do you do this with Perl?
> >
> > Years ago it worked with DBI and DBD::Sybase.
>
> You are talking about connecting to SQL Server, Racke. I don't think
> that goes anymore, but now it can be made to work with DBI and
> DBD::ODBC.

Surprise -- Sybase still works. From the DBI FAQ:

How do I access a MS SQL Server database from Linux/UNIX?

You have loads of choices (in no particular order):

* using DBI::ProxyServer or DBD::Gofer. You'll need the former if
you use transactions.

* using a commercial ODBC Driver or bridge like the ones from
Easysoft or Openlink.

* using FreeTDS an open source TDS library which includes an ODBC Driver.

* using DBD::Sybase and Sybase libraries.

--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.765.647.1295 tollfree 800-949-1889 <mike[at]perusion.com>

Being against torture ought to be sort of a bipartisan thing.
-- Karl Lehenbauer

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

icdev at mrlock

May 6, 2008, 9:40 AM

Post #5 of 5 (143 views)
Permalink

Re: Perl odbc? [In reply to]

>
>Surprise -- Sybase still works. From the DBI FAQ:
>
> How do I access a MS SQL Server database from Linux/UNIX?
>
> You have loads of choices (in no particular order):
>
> * using DBI::ProxyServer or DBD::Gofer. You'll need the former if
> you use transactions.
>
> * using a commercial ODBC Driver or bridge like the ones from
> Easysoft or Openlink.
>
> * using FreeTDS an open source TDS library which includes
> an ODBC Driver.
>
> * using DBD::Sybase and Sybase libraries.
>
>--
>Mike Heins

Thanks Mike,

That ought to give me some light reading this weekend.... :)

Steve

_______________________________________________
interchange-users mailing list
interchange-users[at]icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com