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
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
From: Anthony [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 9:04 AM
To: Andrew Hill
Cc: [EMAIL PROTECTED]; '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 [EMAIL PROTECTED]
Andrew Hill wrote:
> You can certainly connect to a remote database using ODBC, it's simply
> case of configuring DSN's on your PHP server to use a local ODBC
> to connect to the remote database. In the case of MS Access,
> 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
> Gerardo, your problem might be no ODBC Driver Manager linked in, as
> 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:[EMAIL PROTECTED]]
> Sent: Monday, January 21, 2002 8:14 AM
> To: [EMAIL PROTECTED]; Gerardo Morales
> Cc: [EMAIL PROTECTED]
> 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),
> would make the app I'm working on much easier to develop. I have
> a program called ODBCSocketServer, that will send and recieve ODBC
> requests via an XML stream. This works ok, but is limited and
> 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 [EMAIL PROTECTED]
> Gerardo Morales wrote:
>>I have a little problem.
>>I must design a little system in a linux server, this should be in
>>The system must read a MS Access DB in a remote server (Win NT).
>>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
>>$dbaccess["accessusername"] = "user"; // username
>>$dbaccess["accesspassword"] = "password"; // password
>>$dbaccess["defaultdb"] = "database"; // database
>>In the code above i tried to inser the remote server address, port
>>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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php