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
|
