[Openinteract-help] Re: openinteract-help digest, Vol 1 #186 - 3 msgs

[John S. <jo...@po...>]

Chris McD,

Are you sure you have to purchase a driver?

Have you looked at the freetds project (freetds.org) or considered a 
proxy approach (DBD::Proxy or DBD::JDBC 
http://www.cwinters.com/News/show/?news_id=238)?

FWIW,  I've used xml-rpc proxies from linux-to-mssql server before to 
avoid licensing hassles like this for a low volume application,  but not 
the aforementioned approaches.  I hear good things about freetds,  however.

JS

>Message: 1
>From: "Chris McDaniel" <Chr...@te...>
>To: "'ope...@li...'"
>	<ope...@li...>
>Date: Tue, 17 Dec 2002 02:09:54 -0700
>Subject: [Openinteract-help] database connection question (concurrent users)
>
>
>Hello,
>
>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?  
>
>Also, any tips on a good way to do this?
>
>Thanks,
>
>Chris McDaniel
>  
>