Re: Re: Question about ODBC databases

Have a look at http://php.weblogs.com/adodb_csv This allows you to tunnel sql queries and recordsets over http using PHP's serialize protocol, say between apache on linux and iis on windows. We use it internally to access ms access (using odbc) from linux also. Regards, John "Anthony" <atampone@attechcomputer.com> wrote in message news:3C4C1FCB.1000901@attechcomputer.com... > 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 > >> > >> > > > > > >