RE: Remote DB Connection
Ji, José, most probably to setup ODBC You need a kind of client software to access particular DB. For example, if You use Oracle it looks like that: Oracle DB is running on server, Oracle client software (usially named as SQL*Net or Net8, delivered with Oracle) is running on Your computer. ODBC driver is making a connection with that client software which in turn connects to Oracle server over the network and delivers the results (or errors) back to ODBC driver. So Your DBD::ODBC driver talks with that client software. As I remember the name of the client software for Informix is Informix*Net or something like that, but the idea is the same. I would suggest You to use DBD::Proxy which doesn't require any additional client software installed on local box. Looks like it works quite OK for simple queries. But don't forget that You will have to install Informix client software on the DB server itself because DBI::ProxyServer which has to be run on the server will need it to talk to DB. Reg's Oleg > -Original Message- > From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]] > Sent: Monday, August 20, 2001 4:27 PM > To: 'Sterin, Ilya'; NYIMI Jose (BMB); [EMAIL PROTECTED] > Subject: RE: Remote DB Connection > > > It seems that DBD::ODBC module works only with local > databases, according to > the following document: > http://search.cpan.org/doc/JWIED/DBD-pNET-0.1003/pNET.pm > What you mean by third party ODBC software ? > > Regards, > > José > > > > > -Original Message- > From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] > Sent: zaterdag 18 augustus 2001 18:45 > To: NYIMI Jose (BMB); [EMAIL PROTECTED] > Subject: RE: Remote DB Connection > > > Well if you use DBD::ODBC for which you will have to have > third party ODBC > software installed, then just set up a DSN and use that in > your connection. > Anyways just see perldoc DBD::Informix and perldoc DBD::ODBC > for different > connect methods. > > Ilya > > > -Original Message- > > From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 17, 2001 11:02 AM > > To: '[EMAIL PROTECTED]' > > Subject: Remote DB Connection > > > > > > How I can connect to a remote Informix database ? > > > > The database from which I would like to extract > > data (a simple SQL select ...) is installed on a remote > machine(Solaris > > 8). > > > > The local machine is also a Sun machine using Solaris 8. I > don't have > > an Informix database installed on this local machine. > > > > Can you provide me an exemple of code ? > > > > Should I use RPC,Socket and stuff like that ? > > > > I have the intention to use DBD::ODBC module instead of > DBD::Informix > > > > José. > > > > > > > > DISCLAIMER > > > > "This e-mail and any attachment thereto may contain information > > which is confidential and/or protected by intellectual > property rights > > and are intended for the sole use of the recipient(s) named above. > > Any use of the information contained herein (including, but not > > limited to, total or partial reproduction, communication or > distribution > > in any form) by other persons than the designated recipient(s) is > > prohibited. > > If you have received this e-mail in error, please > notify the sender > > either by telephone or by e-mail and delete the material from any > > computer". > > > > Thank you for your cooperation. > > > > For further information about Proximus mobile phone > services please see > > our website at http://www.proximus.be or refer to any > Proximus agent. > > >
RE: Remote DB Connection
It seems that DBD::ODBC module works only with local databases, according to the following document: http://search.cpan.org/doc/JWIED/DBD-pNET-0.1003/pNET.pm What you mean by third party ODBC software ? Regards, José -Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: zaterdag 18 augustus 2001 18:45 To: NYIMI Jose (BMB); [EMAIL PROTECTED] Subject: RE: Remote DB Connection Well if you use DBD::ODBC for which you will have to have third party ODBC software installed, then just set up a DSN and use that in your connection. Anyways just see perldoc DBD::Informix and perldoc DBD::ODBC for different connect methods. Ilya > -Original Message- > From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 17, 2001 11:02 AM > To: '[EMAIL PROTECTED]' > Subject: Remote DB Connection > > > How I can connect to a remote Informix database ? > > The database from which I would like to extract > data (a simple SQL select ...) is installed on a remote machine(Solaris > 8). > > The local machine is also a Sun machine using Solaris 8. I don't have > an Informix database installed on this local machine. > > Can you provide me an exemple of code ? > > Should I use RPC,Socket and stuff like that ? > > I have the intention to use DBD::ODBC module instead of DBD::Informix > > José. > > > > DISCLAIMER > > "This e-mail and any attachment thereto may contain information > which is confidential and/or protected by intellectual property rights > and are intended for the sole use of the recipient(s) named above. > Any use of the information contained herein (including, but not > limited to, total or partial reproduction, communication or distribution > in any form) by other persons than the designated recipient(s) is > prohibited. > If you have received this e-mail in error, please notify the sender > either by telephone or by e-mail and delete the material from any > computer". > > Thank you for your cooperation. > > For further information about Proximus mobile phone services please see > our website at http://www.proximus.be or refer to any Proximus agent. >
RE: Remote DB Connection
>-Original Message- >From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]] >Sent: Saturday, August 18, 2001 1:02 AM >To: '[EMAIL PROTECTED]' >Subject: Remote DB Connection > > >How I can connect to a remote Informix database ? > >The database from which I would like to extract >data (a simple SQL select ...) is installed on a remote >machine(Solaris 8). > >The local machine is also a Sun machine using Solaris 8. I don't have >an Informix database installed on this local machine. > >Can you provide me an exemple of code ? > >Should I use RPC,Socket and stuff like that ? perldoc dbiproxy perldoc DBD::Proxy --Neil > >I have the intention to use DBD::ODBC module instead of DBD::Informix > >José. > > > > DISCLAIMER > > "This e-mail and any attachment thereto may contain >information which is confidential and/or protected by >intellectual property rights and are intended for the sole use >of the recipient(s) named above. > Any use of the information contained herein (including, >but not limited to, total or partial reproduction, >communication or distribution in any form) by other persons >than the designated recipient(s) is prohibited. > If you have received this e-mail in error, please notify >the sender either by telephone or by e-mail and delete the >material from any computer". > > Thank you for your cooperation. > >For further information about Proximus mobile phone services >please see our website at http://www.proximus.be or refer to >any Proximus agent. > __ Please Note : Only the intended recipient is authorised to access or use this e-mail. If you are not the intended recipient, please delete this e-mail and notify the sender immediately. The contents of this e-mail are the writer's opinion and are not necessarily endorsed by the Gunz Companies unless expressly stated. We use virus scanning software but exclude all liability for viruses or similar in any attachment.
RE: Remote DB Connection
Well if you use DBD::ODBC for which you will have to have third party ODBC software installed, then just set up a DSN and use that in your connection. Anyways just see perldoc DBD::Informix and perldoc DBD::ODBC for different connect methods. Ilya > -Original Message- > From: NYIMI Jose (BMB) [mailto:[EMAIL PROTECTED]] > Sent: Friday, August 17, 2001 11:02 AM > To: '[EMAIL PROTECTED]' > Subject: Remote DB Connection > > > How I can connect to a remote Informix database ? > > The database from which I would like to extract > data (a simple SQL select ...) is installed on a remote machine(Solaris > 8). > > The local machine is also a Sun machine using Solaris 8. I don't have > an Informix database installed on this local machine. > > Can you provide me an exemple of code ? > > Should I use RPC,Socket and stuff like that ? > > I have the intention to use DBD::ODBC module instead of DBD::Informix > > José. > > > > DISCLAIMER > > "This e-mail and any attachment thereto may contain information > which is confidential and/or protected by intellectual property rights > and are intended for the sole use of the recipient(s) named above. > Any use of the information contained herein (including, but not > limited to, total or partial reproduction, communication or distribution > in any form) by other persons than the designated recipient(s) is > prohibited. > If you have received this e-mail in error, please notify the sender > either by telephone or by e-mail and delete the material from any > computer". > > Thank you for your cooperation. > > For further information about Proximus mobile phone services please see > our website at http://www.proximus.be or refer to any Proximus agent. >
