RE: [PHP-DB] Re: Question about ODBC databases

Anthony, No, you are right. The closest you could do is to use an ODBC-ODBC Bridge, and connect to a DSN on computer A that piggybacked on a DSN on computer B. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Virtuoso Universal Server office 781.273.0900 x 27 mobile 781.608.4127 -----Original Message----- From: Anthony [mailto:atampone@attechcomputer.com] Sent: Monday, January 21, 2002 9:04 AM To: Andrew Hill Cc: php-db@lists.php.net; 'Gerardo Morales' Subject: Re: [PHP-DB] Re: Question about ODBC databases That is not entirely what I'm trying to do. What I need is for the NT server that is running ODBC to respond to remote requests from other servers or clients. In other words, I need computer A to access database on computer B which is running ODBC. Computer A does not have ODBC, I need computer a to be able to query against computer B as if it were a SQL server. As far as I can tell, I can't make an NT server running ODBC respond to remote requests. If I am wrong though, PLEASE let me know. Thanks. - Anthony atampone@attechcomputer.com Andrew Hill wrote: > Anthony, > > You can certainly connect to a remote database using ODBC, it's simply a > case of configuring DSN's on your PHP server to use a local ODBC Driver > to connect to the remote database. In the case of MS Access, OpenLink's > Multi-Tier ODBC Agent works quite well. > > This of course requires that the Linux instance of PHP has been built > with an ODBC Driver manager, such as --with-iodbc as per the HOWTO on > www.iodbc.org. > > Gerardo, your problem might be no ODBC Driver Manager linked in, as well > as no local Driver/DSN. Check the output of a phpinfo(); to see what > the state of your instance is with regards to ODBC. > > Let me know if you have configuration questions. > > Best regards, > Andrew Hill > Director of Technology Evangelism > OpenLink Software http://www.openlinksw.com > Universal Data Access & Virtuoso Universal Server > > -----Original Message----- > From: Anthony [mailto:atampone@attechcomputer.com] > Sent: Monday, January 21, 2002 8:14 AM > To: php-db@lists.php.net; Gerardo Morales > Cc: php-db@lists.php.net > Subject: [PHP-DB] Re: Question about ODBC databases > > As far as I know, you can not connect to an ODBC source remotly. If I > could do this (make a NT server running ODBC look like a SQL server), it > > would make the app I'm working on much easier to develop. I have found > a program called ODBCSocketServer, that will send and recieve ODBC > requests via an XML stream. This works ok, but is limited and difucult > to work with. At the current time it it incapable of sending over a > secure port also. If you happen to find a way to make the ODBC server > take remote requests, please let me know (I will from then on refer to > you as god). Hope this helps. > > - Anthony atampone@attechcomputer.com > > > Gerardo Morales wrote: > > >>I have a little problem. >> >>I must design a little system in a linux server, this should be in >> > php. > >>The system must read a MS Access DB in a remote server (Win NT). >> > After > >>a single process the system must update a MySQL DB in the same server >>(Linux) and the Access DB. >> >>The current code works fine in the Linux server, so i can update the >>MySQL DB, but it doesn't connect with the NT server. >> >>When i tried to connect to it i have the following error. >>Fatal error: Call to undefined function: odbc_connect() in >>/usr/local/etc/httpd/htdocs/vox/loginAccess.inc on line 14 >> >>I never developed with ODBC DB, only with MySQL. >> >>I was searching about what could be the problem, but i don't found it. >> >>The code in liginAccess is the following: >> >>$dbaccess = array(); >>$dbaccess["accessserver"] = "NT.server.ip.address"; // >>Access server hostname >>$dbaccess["accessport"] = ""; // Access server >> > port > >>$dbaccess["accessusername"] = "user"; // username >>$dbaccess["accesspassword"] = "password"; // password >>$dbaccess["defaultdb"] = "database"; // database >> >> > $conexionAccess=odbc_connect($dbaccess["defaultdb"],$dbaccess["accessuse > rname"],$dbaccesss["accesspassword"],""); > >> >>In the code above i tried to inser the remote server address, port >> > etc, > >>and the error codee is the same >> >>I hope you cant help me. >> >>I don't who else can i ask for it. >> >>Thanks in advanced >> >> > >