SPUG: Perl and Connecting to SQL Server.

[Aaron Salo]

Terry: I haven't done this but I presume there is some performance or
overhead hit to running this way? Can you comment based on your experience?
The last two times I had to do this kind of thing (connect my app to some
godforsaken remote database running MSSybase) running the proxy and proxy
server simply wasn't an option due to lack of cooperation on the other end
of the wire.

While we're fleshing out the full set of options for those keeping score,
worth mentioning that although there is no native UN*Xish driver for
SQLServer[x], there are UN*Xish ODBC drivers available on a pay-for-play
basis from intersolv, openlink, and merant. OpenLink has a free UN*Xish
ODBC driver manager called iODBC. I've not used any of them. I don't
usually have the luxury of passing substantial licensing costs into my
clients' dev budgets.

~!a

At 03:25 PM 5/18/01 -0700, Terry N wrote:
>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.

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
     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/