RE: [PHP-DB] ODBC connection- can anybody help....

I would *assume* you could use PHP's native SQL_Server calls (or ODBC). If you use ODBC, you will of course have to have ODBC setup on the Linux machine. I have never done this before. For documentation please reference: http://www.php.net/manual/ref.mssql.php for the PHP MS SQL functions http://www.php.net/manual/ref.odbc.php for the PHP ODBC functions. http://www.openlink.co.uk/ I think you can get ODBC drivers here (for linux - again, I *think*) also, http://dadmin.sourceforge.net another plug for my database library that's being developed :) Sean Finkel alarion@planetunreal.com -----Original Message----- From: Tigger-oN [mailto:tigger@ebom.org] Sent: Wednesday, October 04, 2000 10:51 AM To: php-db@lists.php.net Subject: RE: [PHP-DB] ODBC connection- can anybody help.... I'm pretty keen to learn more about PHP4 and SQL7 connections where the web server (apache) is on one box (or a cluster or load balanced) and the SQL7 server is on another. I would also prefer to use a TCP/IP connection string as well. Basically we have a number of ASP sites where we wish to move (slowly) over to PHP4 on Linux but wish to keep the SQL7 databases as is. Any URL's, examples or other doc's would be a great help. > -----Original Message----- > From: Andrew Hill [mailto:ahill@openlinksw.com] > Sent: Wednesday, 4 October 2000 11:16 PM > To: ahill@openlinksw.com; Ermanno Iannacci; Donna Clark; > php-db@lists.php.net > Subject: RE: [PHP-DB] ODBC connection- can anybody help.... > > > Whups, > > I missed that you want to connect to a DSN on server 2... you cannot do > this with most drivers, but you will be able to make a connection > by setting > up your DSN and driver manager on Server 1. If you do need to make a > connection to another DSN on a second box for some reason, you > will want to > explore Openlink's Multi-Tier drivers, setup in a 3 tier configuration. I > would be happy to assist. > > Best regards, > Andrew > ---------------------------------------------------- > Andrew Hill > Director Technology Evangelism > OpenLink Software > http://www.openlinksw.com > XML & E-Business Infrastructure Technology Provider > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net