How do I make DBI::Proxy work between unix and NT?
It works fine, but it takes a little effort to get going. Heres what we did: • Active State perl running on NT (hostname romeo in our test) • MS SQL running on NT • On NT, define ODBC system DSN called ‘MSSQL’, with appropriate configuration to be able to conenct to your MS-SQL database • Install PlRPC module from active state on NT, using PPM • Install Net-Daemon module from active state on NT, using PPM • Install DBD-ODBC module from active state on NT, using PPM • Install DBI module from active state on NT, using PPM • Build and install Net-Daemon-0.31 or better from CPAN on Unix • Build and install PlRPC-0.2012 or better from CPAN on Unix • Build and install DBI-1.13 or better from CPAN on Unix • ON NT in dir c:\perl\bin run the proxy server with perl dbiproxy –localport 9991 • On Unix, Radiator configured for AuthBy SQL with: DBSource dbi:Proxy:hostname=romeo;port=9991;dsn=dbi:ODBC:MSSQL DBUsername sa DBAuth sa Caution: be sure that you have the same version of DBI and its suppor
