Re: Help with installation and use of the DBD::ODBC module

You cannot use DBD::ODBC to connect to an ODBC data source defined on a different computer - at least not directly. You need some kind of bridge to connect the two - some of these are listed in the "Random Links" section of the DBD::ODBC documentation.

Comment on Re: Help with installation and use of the DBD::ODBC module

Replies are listed 'Best First'.
Re^2: Help with installation and use of the DBD::ODBC module by EvanCarroll (Chaplain) on Oct 24, 2005 at 05:05 UTC
Maybe something like DBD::Proxy, with DBD::ODBC running on the remote machine? Evan Carroll www.EvanCarroll.com	[reply]
Re^3: Help with installation and use of the DBD::ODBC module by Errto (Vicar) on Oct 24, 2005 at 05:15 UTC
Yes, that would work I think. In that case the steps to follow are Install Perl, DBI, and DBD::ODBC on your Windows box. Configure DBI::ProxyServer to meet your security needs. Get dbiproxy running on the Windows box, preferably as a service (but make sure this service has permissions to get at your Access file!) Use DBD::Proxy to connect to your Windows server from the Unix box.	[reply]