CGI::Sessions with MSSQL DB

[pmu...@berkeley.edu]

Hello,

I'm not to sure if this is the right place to write this to but here it
goes....I'm fairly new to perl and I'm trying to add CGI::Sessions to an
application written in perl (on FreeBsd) that writes to a MSSQL database.
Currently it uses the sybase.pm to connect to the database but how can i
go about storing sessions information on the mssql database? What driver
do you suggest i use to accomplish this(ODBC)? Any advise would be great.

Thank you
-pm

[Martin Gainty]

http://dev.mysql.com/doc/refman/5.1/en/activestate-perl.html

use ODBC only if DBI wont install (with windows you'll need ActiveState Perl 5.6 or newer)
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.

> Date: Wed, 7 Oct 2009 11:24:58 -0700
> Subject: CGI::Sessions with MSSQL DB
> From: pmu...@berkeley.edu
> To: dbi-...@perl.org

_________________________________________________________________
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/177141665/direct/01/

[Martin J. Evans]

Ron said: "Grrr. Stupid list manager s/w does not default Reply to list..."
- me too.

Your choices to access MS SQL Server from FreeBSD are:

o DBI and ODBC Driver manager and an ODBC Driver e.g., unixODBC and one
of the many commercial (Easysoft, Openlink Software, DataDirect) or free
ODBC drivers (freeTDS).

o DBI and ODBC Driver manager and an ODBC-ODBC Bridge (some of the
vendors above do these)

o DBI and DBD::Sybase and Openclient or freeTDS

o DBI and DBI::ProxyServer

o DBD::Gofer

Further explanation http://www.martin-evans.me.uk/node/20#perl

The things that may determine which you choose are a) transactions b)
ability to install something on a windows machine c) whether you need
unicode support d) level of API you are prepared to program to e)
whether you need a support contract f) encrypted connections.

If anyone has any other options, I'd like to hear them.

Martin
--
Martin J. Evans
Easysoft Limited
http://www.easysoft.com

[John Scoles]

A little off topic yes but here is my 5cents worth anyway

I would go with

http://search.cpan.org/~rsoliv/Session-0.01/Session.pm

which is a wrapper for CGI::Session which hides all the nasty details
for you.

All you need to do is make sure you can connect to your DB and bob is
you uncle.

I use it for example to hold the session info for a web sited with a
MySQL back end on an oracle DB.

Cheers
John Scoles

[Ron Savage]

Hi John

On Thu, 2009-10-08 at 07:08 -0400, John Scoles wrote:
> A little off topic yes but here is my 5cents worth anyway
>
> I would go with
>
> http://search.cpan.org/~rsoliv/Session-0.01/Session.pm
>
> which is a wrapper for CGI::Session which hides all the nasty details
> for you.

Err, Around Apache::Session...

> All you need to do is make sure you can connect to your DB and bob is
> you uncle.

Actually, Bob really is my uncle.

> I use it for example to hold the session info for a web sited with a
> MySQL back end on an oracle DB.
>
> Cheers
> John Scoles
>
>
>
> pmu...@berkeley.edu wrote:
> > Hello,
> >
> > I'm not to sure if this is the right place to write this to but here it
> > goes....I'm fairly new to perl and I'm trying to add CGI::Sessions to an
> > application written in perl (on FreeBsd) that writes to a MSSQL database.
> > Currently it uses the sybase.pm to connect to the database but how can i
> > go about storing sessions information on the mssql database? What driver
> > do you suggest i use to accomplish this(ODBC)? Any advise would be great.
> >
> > Thank you
> > -pm
> >
> >
>

--
Ron Savage
r...@savage.net.au
http://savage.net.au/index.html