SPUG: Perl and Connecting to SQL Server.

[Terry Nightingale]

On Fri, 18 May 2001, Aaron Salo wrote:

> If you are initiating a connection from a UNIX box, you have a bit of a
> prob. There are some kinky things you can try. SQLServer is really Sybase
> under the hood. You can sometimes use DBD::Sybase to connect natively,
> but this is a little kinky because you may run into some version specific
> cracks. Also, support may (poof) vanish somewhere down the road, if your
> app has a life cycle you may be concerned about that.

Another option to be explored is using DBD::Proxy and DBI::ProxyServer.
Your Unix script uses DBD::Proxy to connect to a DBI::ProxyServer on
Win9x/NT/2k, which then uses the native SQL Server driver or an ODBC
data source to connect.

This has been a very successful approach in a recent major project I was
involved in.


--
Terry Nightingale <tnight at pobox.com>
+1-425-649-9304(v) / +1-425-643-7112(f)

Prediction is very difficult, especially of the future.  -Niels Bohr


 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
     POST TO: spug-list at pm.org       PROBLEMS: owner-spug-list at pm.org
      Subscriptions; Email to majordomo at pm.org:  ACTION  LIST  EMAIL
  Replace ACTION by subscribe or unsubscribe, EMAIL by your Email-address
 For daily traffic, use spug-list for LIST ;  for weekly, spug-list-digest
  Seattle Perl Users Group (SPUG) Home Page: http://www.halcyon.com/spug/