Thanks for your quick response! Tried and are able to access MS-SQL server using an OBDC driver(unix) It seen the MS-server But, error message; client unable to establish connection. If The MS-server access is a non existing server we get a different Message. Thank you -----Original Message----- John McKown wrote: We have an application (not on Linux) which connects to an MS SQL server via ODBC. PHP seems to support this. Does Debian PHP support ODBC?
http://php.net/odbc -- John -----Original Message----- From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On Behalf Of McKown, John Sent: Tuesday, April 17, 2007 4:00 PM To: [email protected] Subject: Re: Database access > -----Original Message----- > From: Linux on 390 Port [mailto:[EMAIL PROTECTED] On > Behalf Of P L Lovely > Sent: Tuesday, April 17, 2007 2:56 PM > To: [email protected] > Subject: Database access > > > Hello, our team has formatted the scenario below and we need > some directions > and feedback. > > Issue: Accessing a Microsoft (MS) SQL Server Database from > Debian LINUX > Running on an 390 Mainframe > > Problem: current Debian Linux installation does not support the MSSQL > extensions of PHP. > > Background: Running Debian LINUX Version 3.1 under Z/VM V > 5.2. We have > two applications that need to share data in separate database > systems. One > application utilizes a database in a Microsoft SQL server and > the second > application uses a database in a MySQL database running on > the Debian Linux > server. MySQL version 4.0.18; MS SQL server version 2000 > > Goal: development writes a script in PHP to run under the > Apache Web Server > running on the Debian LINUX installation that accesses both > database systems > > The Requirements: > To access (READ) information stored in a Microsoft SQL data > base. Utilizing > A PHP program; running on a LINUX Apache Web Server, to have > update (WRITE) > the information to a MYSQL database running on LINUX guest > > Questions: > Does Debian have a package for the environment > described above that > installs the PHP MS-SQL extensions? We have looked and do > not see any. > > If Debian does not have such a package, are you aware of other > installations of Linux for the System 390 that support this > environment? > > Although it seems cumbersome, would it be possible to > recompile PHP > in Debian for System 390 and include these extensions? If > so, are there any > other prerequisites (such as an ODBC driver) that would be required? > Thank you, Our Team > We have an application (not on Linux) which connects to an MS SQL server via ODBC. PHP seems to support this. Does Debian PHP support ODBC? http://php.net/odbc -- John McKown Senior Systems Programmer HealthMarkets Keeping the Promise of Affordable Coverage Administrative Services Group Information Technology The information contained in this e-mail message may be privileged and/or confidential. It is for intended addressee(s) only. If you are not the intended recipient, you are hereby notified that any disclosure, reproduction, distribution or other use of this communication is strictly prohibited and could, in certain circumstances, be a criminal offense. If you have received this e-mail in error, please notify the sender by reply and delete this message without copying or disclosing it. ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390
