dbi between nt and unix (code)

deprecated has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: dbi between nt and unix (code) by Jonathan (Curate) on Jun 20, 2001 at 19:50 UTC
Have you considered using DBD::Proxy and DBI::ProxyServer to communicate between the boxes? It seems quite a good solution to this sort of problem. When the bells justle in the tower, the hollow night amid. Then on my tongue the taste is sour, of all I ever did....	[reply]
Re: Re: dbi between nt and unix (code) by clemburg (Curate) on Jun 21, 2001 at 14:49 UTC
I want to second this recommendation. Using DBD::Proxy and DBI::ProxyServer is a very good approach to NT/Unix cross-platform database access. The only drawback is that you will have one server process more on the database server. You might have to fiddle with the default transfer unit lengths if you transfer a lot of BLOB stuff, like image data or so. I have used this approach several times at work, and it is the perfect thing to do if you need the access only for a limited time, like when you are porting legacy data. Much easier to install then anything else, IMHO. Christian Lemburg Brainbench MVP for Perl http://www.brainbench.com	[reply]
Re: dbi between nt and unix (code) by DeaconBlues (Monk) on Jun 20, 2001 at 19:28 UTC
If you have ActivePerl installed on the NT machine, you can use the pre-built ASPSN zip archives for the DBI and DBD modules. They are located here: http://aspn.activestate.com/ASPN/Downloads/ActivePerl/PPM/Zips/ Using this set up I have perl scripts running on my NT workstation that access Oracle Databases on UNIX machines. Dave There is some set up involved with the Data Sources control panel	[reply]
Re: dbi between nt and unix (code) by MrCromeDome (Deacon) on Jun 20, 2001 at 21:16 UTC
What version of postgres are you accessing? There is an ODBC driver available from the postgres site that works with 6.5.x (and potentially earlier versions). If this is the case, you can use DBD::ODBC (which works exceptionally well for me) to access your postgres database. From checking the ActiveState site, there doesn't appear to be a DBD available for postgres. I know from experience however that this ODBC driver does not work with postgres version 7.x. Good luck! MrCromeDome Update: Whoops! I appear to have made a liar of myself. Just checked out the postgres site for the first time in a while, and they appear to have a pretty recently updated ODBC driver for postgres 7.x. This might be just what you need. Haven't had the chance to test it though. Again, good luck!	[reply]


"be consistent"
	PerlMonks