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

im very new to perl and i'd like to use CGI::Session for a login script w/ a MSSQL database... but on the CGI::Session page on cpan, it looks like it only works w/ text files or a MySQL database. is it possible to use this module with a MS SQL Server database? thanks

Replies are listed 'Best First'.
Re: CGI::Session with MS SQL database?
by Tanktalus (Canon) on Jan 18, 2005 at 17:53 UTC

    Having written a CGI::Session driver, I can tell you it's pretty trivial to create a new driver. I just started from CGI::Session::MySQL, and wrote a new one. That's most likely what you'll need to do, too. And might I suggest submitting it back to CPAN when you're done? :-)

[reply]
Re: CGI::Session with MS SQL database?
by simonm (Vicar) on Jan 18, 2005 at 17:57 UTC
[reply]
Re: CGI::Session with MS SQL database?
by gellyfish (Monsignor) on Jan 18, 2005 at 18:05 UTC

    You would have to create a new driver module to do this (say CGI::Session::MSSQL) you could start with a copy of CGI:Session::MySQL and alter it appropriately to work with an ODBC connection to SQL Server, this would entail altering the connection string as well as the SQL - in particular the application locking that MySQL provides and that will have to implemented for MS SQL Server.

    /J\

[reply]
[d/l]
Re: CGI::Session with MS SQL database?
by borisz (Canon) on Jan 18, 2005 at 20:30 UTC
[reply]

Back to Seekers of Perl Wisdom