On Thu, 19 Dec 2002 12:21:52 +0000, Tim Bunce wrote: > ----- Forwarded message from Abhishek_Gupta <[EMAIL PROTECTED]> ----- > > Delivered-To: [EMAIL PROTECTED] > From: Abhishek_Gupta <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED] > Subject: Enquiry > Date: Thu, 19 Dec 2002 13:03:44 +0530 > > Hi, > > I was searching thru the net and saw an article in a forum about connceting > to an SQL server thru perl on a Solaris box, which links to your website. > > I require this urgently and if you could help me out it would be really > helpful. I am using Solaris 2.8, Perl 5 connecting to MS SQL 7.0. Perl will > reside on the solaris box and MSSQL on Windows 2k.
There are a number of wasy you can connect an unixen system to an SS7 db under NT/Win2K The choice depends upon your requirements and for sake of similicity I will use ours which include use of placeholders re-usable sths (prepare execute fetch execute fetch finish) multiple sths at one time access to BLOBS/CLOBS (without data corruption or loss) persistent connections and if posible prepare_cached's If this set of requirements matches yours (many WDBI apps require these) then the only ODBC driver that comes close if openODBC (a commercial product) however this blows up badly when you try and bind an undef to a placeholder and support were less tnan usefull when we reported this during the evaluation. If fact they failed to respond! We tried DBI::ProxyServer and managed to tweak the proxyserver to pre-thread (rather than pre-fork under NT) while using a DBD::ADO backend however stability and performance are not exactly perfect. In the end we moved the web app to Apache/NT as we simply ran out of time to fix the problems being found. When this project is finally released we will be providing feedback on changes to ADO proxyserver and RPC::PIServer::Comm etc but at the mo I dont even have free time to write this email :-) Note taht if your requirements are less 'strict' than ours then other options such as freeTDS may be a better solution but as always YMMV. > Would be indeed kind of you to revert on this asap. > > Thanks in advance. > Regards > Abhishek Jacqui Caren, Ingram Group Ltd. [EMAIL PROTECTED] ph: +44 (0) 1483 8628xx main=00 fax=01 ddi=65 http://www.ig.co.uk/ http://www.sitedirector.org/ http://www.perl.co.uk/
