[Openinteract-help] Re:proxying to mssql server

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

Chris,

Just to clarify,  I would definitely not add to your security woes by 
installing proxy software on the SQL Server.  In my xml-rpc scenario, 
 the client had an existing web farm of IIS-only boxes,  with a single 
SQL Server database/hot-spare in the back tier.  It was easy for me to 
drop the XML-RPC scripts on the existing IIS boxes.  If doing something 
similar: allocating a middle tier between your solaris app and the SQL 
Server is possibile,  the dbd::proxy approach becomes viable.  1U 
rackmounts are probably going to be cheaper than the Openlink license, 
 but otoh I guess maintaining it might not be.

Also,  MS gives away Openlink's Type 4 JDBC drivers IIRC.  Using them, 
 you could run DBD::JDBC only on your Solaris box,  and you should be 
golden.  

Anyway,  good luck with freetds - that's probably simplest.  

JS


Chris McDaniel wrote:

>The admin of the MS SQL box wants to avoid installing anything on it - it is
>a vendor turnkey type system, and he's very wary of breakage as it is a main
>component in a high-volume production teleconferencing system...  Even a
>.exe service built using activestate's PDK (which I've done before - worked
>pretty good) is too much for their comfort.  
>
>I'd imagine the xml-rpc approach requires server-side stuff too...
>
>Funny you should mention freetds - the vendor driver I'm evaluating
>(Openlink) encorporates it.  I've tried compiling freetds myself, but it
>seems to hate my Solaris box.  I am getting some support on the freetds
>mailing list though, so hopefully it will all work out.
>
>Thanks for the reply - much appreciated.
>
>-----Original Message-----
>From: John Sequeira [mailto:jo...@po...]
>Sent: December 17, 2002 4:52 PM
>To: ope...@li...
>Subject: [Openinteract-help] Re: openinteract-help digest, Vol 1 #186 -3
>msgs
>
>
>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
>> 
>>
>>    
>>
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by:
>With Great Power, Comes Great Responsibility 
>Learn to use your power at OSDN's High Performance Computing Channel
>http://hpc.devchannel.org/
>_______________________________________________
>openinteract-help mailing list
>ope...@li...
>https://lists.sourceforge.net/lists/listinfo/openinteract-help
>
>
>
>  
>