Re: [Openinteract-help] database connection question (concurrent users)

[Chris W. <ch...@cw...>]

Chris McDaniel wrote:
> I just wanted to clarify something about DB connections before I go off
> spending my company's money.  I'm encountering a situation where I need to
> purchase a db driver (for MS SQL - surprise) to interact with a remote
> datasource for a certain package I'm working on.  Worse, it is per-user
> licensing.  So, I read Openinteract::DBI and it seems to me that if I figure
> out a way to make OI make the DB connection at the beginning as it does for
> my main DB, it would show as only one user.  Is that correct?  or is it one
> per httpd child?  

It will create at most one as needed per httpd child. The user for all 
the connections will be the same.

> Also, any tips on a good way to do this?

By "do this", do you mean actually make the connection? In SPOPS terms, 
MS SQL == Sybase, if that helps at all. So if you're using DBD::ODBC 
you'd do something like:

[db_info main]
db_owner      =
username      = foo
password      = bar
dsn           = DSN=mydsn
db_name       =
driver_name   = ODBC
sql_install   = Sybase
long_read_len = 65536
long_trunc_ok = 0

If you haven't already done so, I'd make sure you can use it with 
Perl/DBI before you purchase the driver. Most companies don't have 
"Perl-compatibility" high on their feature list :-)

Chris