[PHP-DB] Re: question about Zend PHP Studio ...Zend gave useless answer
Can you explain what does it have to do with Zend PHP Studio (the PHP editor) ? Fred Silsbee napsal(a): I have Fedora 9/Apache 2/PHP 5.2.6 Everything is great but I cannot add the libraries for oci8 1.3.4 I have in a directory. The entries are grayed out. I was getting an error oci_connect not found. I rebooted! The php program runs **great** from /var/www/html under Apache here is the error: Fatal error: Call to undefined function oci_connect() in /var/www/html/handle_log_book11g1.php on line 22 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: question on select
** Or send XML files up and down dynamically using xmlhttp in IE and Mozilla ;-) Cheers - Neil At 04:06 13/05/2004 +, you wrote: To make a client-side solution possible, you'd have to send ALL POSSIBLE data to the page all at the same time then manipulate it with JavaScript. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Question concerning hostnames
[EMAIL PROTECTED] (2b4ever Php) writes: I want http://www.pageTwo.com to be redirected to http://www.pageOne.com/pageTwoindex.html, without losing the address http://www.pageTwo.com. Maybe something like header(location: http://www.pageOne.com/pageTwoindex.html?ref=http://.$_SERVER[HTTP_HOST].$_SERVER[PHP_SELF;]); on http://www.pageTwo.com Then $_GET[ref] will contain the referers url provided http://www.pageOne.com/pageTwoindex.html is a PHP file. If you just want it for logging purposes, the url will still be saved in the server log (at least if you use apache). -- --Fredrik In an organization, each person rises to the level of his own incompetency -- The Peter Principle -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: question
[EMAIL PROTECTED] (Ali M) writes: Is this the place to post questions on php db's? php.db - yes ;-) -- --Fredrik Whether you can hear it or not The Universe is laughing behind your back -- National Lampoon, Deteriorata -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: question in ADODB
yes, but can you tell me how? I have read the manual, but they didn't tell
how to do so!
Look at testdatabases.inc.php in the adodb release.
Basically, you would have to write something like :
include(adodb.inc.php);
$conn = NewADOConnection('ado_access');
$conn-debug = TRUE; // useful for test
$access = '\path\to\mydatabase.mdb';
$myDSN = PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=$access;USER
ID=;PASSWORD=;;
$conn-PConnect($myDSN, '', '', '');
$recordSet = $conn-Execute('select * from products');
if (!$recordSet) { echo $conn-ErrorMsg();}
Regards,
Philippe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: question in ADODB
thank you very much
--
Sincerely your;
pei_world ( .::IT::. )
Philippe Saladin [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
yes, but can you tell me how? I have read the manual, but they didn't
tell
how to do so!
Look at testdatabases.inc.php in the adodb release.
Basically, you would have to write something like :
include(adodb.inc.php);
$conn = NewADOConnection('ado_access');
$conn-debug = TRUE; // useful for test
$access = '\path\to\mydatabase.mdb';
$myDSN = PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=$access;USER
ID=;PASSWORD=;;
$conn-PConnect($myDSN, '', '', '');
$recordSet = $conn-Execute('select * from products');
if (!$recordSet) { echo $conn-ErrorMsg();}
Regards,
Philippe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: question in ADODB
yes, but can you tell me how? I have read the manual, but they didn't tell
how to do so!
--
Sincerely your;
pei_world ( .::IT::. )
Philippe Saladin [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I found the following code on the internet. I'd like to know that what I
need to do, if I want to use the actually Access file with out the DSN,
how
to use the Microsoft Jet?
thx
-- code
include(adodb.inc.php);
$db = NewADOConnection('mysql');
Look at the adodb manual : http://php.weblogs.com/adodb_manual
$db = NewADOConnection('access');
(Microsoft Access/Jet. You need to create an ODBC DSN)
or
$db = NewADOConnection('ado_access');
(Microsoft Access/Jet using ADO. Allows DSN-less connections. For best
performance, use an OLEDB provider.)
Regards,
Philippe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: question in ADODB
I found the following code on the internet. I'd like to know that what I
need to do, if I want to use the actually Access file with out the DSN,
how
to use the Microsoft Jet?
thx
-- code
include(adodb.inc.php);
$db = NewADOConnection('mysql');
Look at the adodb manual : http://php.weblogs.com/adodb_manual
$db = NewADOConnection('access');
(Microsoft Access/Jet. You need to create an ODBC DSN)
or
$db = NewADOConnection('ado_access');
(Microsoft Access/Jet using ADO. Allows DSN-less connections. For best
performance, use an OLEDB provider.)
Regards,
Philippe
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Question about replacing large textfields
Wart, You can use Horde and Giapeto to achieve this. Giapeto is a Horde component that is written to give end users the ability to create and modify web sites through their web browser. You can obtain Horde and Giapeto from http://www.horde.org. You will have to obtain both from their public CVS server (since Giapeto is not quite released code yet) Thanks, Mike Hilty Wart Van Ingen [EMAIL PROTECTED] wrote in message 153E04744A5AD5118FC900306E001A7202159561@FMEMAIL1">news:153E04744A5AD5118FC900306E001A7202159561@FMEMAIL1... Hi there, I'm looking for a way to let people without any knowledge of coding replace large fields of text and images on their website. Is there anyone who knows some way to do this with MySQL and PHP ? Maybe someone knows where I can find an online tutorial about this? Thanks a bunch -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Question about rollback in mysql
Arno Kruit wrote: I have php 4.2.3 and Mysql- Max 3.23.54b. If I use the rollback or Commit function it wil work until the scripts ends Is it possible to rollback or commit commands after the scripts ends with a another script? or is rollback only possible in the same script? A.J. Kruit I have sold the problem I upgrade to php 4.3.0 and the problem was sold. A.J. Kruit -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: Question - thanks
Hi there everyone, Thanks for the response to my question - both the attachments and PHP as a full blown dev language. I know the latter isn't really for this group, but this is the best PHP group I have found and the only one I write in regularly. Thanks again Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Question
Thanks for all of the advice. I am learning, and want to learn the right way, and all the advice given will benefit me greatly in the long run. I wish there was an easier way to deal with relationships in MySql, but I am sure that will come along in time. Mike From: Tracker 1 [EMAIL PROTECTED] Date: Mon, 24 Jun 2002 01:57:17 -0700 To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Question you are thinking backwards.. drives 1- computers tblComputers iCompID As BigInt Primary Key Autonumber, sCompName As VARCHAR(25) ... tblDrives iDriveID As BigInt Primary Key Autonumber, iComputerID As BigInt Not Null, Foreign Key fkDriveComputer (iCompID) References tblComputers(iCompID) note, you need to use InnoDB tables in mysql for foreign key references to work properly, you should do it in your code anyway.. select * from tblComputers for each rsComp.. select * from drives where iComputerID = (rsComp.iCompID) there you go.. :) -- === Michael J. Ryan - tracker1[*at*]theroughnecks.com Roughneck BBS: http://www.theroughnecks.net telnet://theroughnecks.net === Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email One program for aim/icq/yahoo/msn/irc - http://www.trillian.cc/ Mike Tuller [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am wanting to create a PHP frontend to a database that holds information about the computers that I take care of. I have a problem though when it comes to storing hard drive information. In most cases, the computers have one drive, but some have 2 or more, so I can't create the main database with fields like this. ComputerID HardDriveType HardDriveSize I know I will need to create a separate table to hold information about the drives, and connect them to the computer by attaching the primary key of the drives table to the Computer table. Computer Table ComputerID DriveID Drive Table DriveID HardDriveType HardDriveSize This is where I am unsure. If there is more than one drive, then this would be incomplete because it would only show one drive. What is the best way to make it so that all drives show for the computer, or am I doing this backwards? Should I tie the computer to the drive instead? Thanks, Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Question
you are thinking backwards.. drives 1- computers tblComputers iCompID As BigInt Primary Key Autonumber, sCompName As VARCHAR(25) ... tblDrives iDriveID As BigInt Primary Key Autonumber, iComputerID As BigInt Not Null, Foreign Key fkDriveComputer (iCompID) References tblComputers(iCompID) note, you need to use InnoDB tables in mysql for foreign key references to work properly, you should do it in your code anyway.. select * from tblComputers for each rsComp.. select * from drives where iComputerID = (rsComp.iCompID) there you go.. :) -- === Michael J. Ryan - tracker1[*at*]theroughnecks.com Roughneck BBS: http://www.theroughnecks.net telnet://theroughnecks.net === Y!: aztracker1 - aim: azTracker1 - icq: 4935386 - msn: see email One program for aim/icq/yahoo/msn/irc - http://www.trillian.cc/ Mike Tuller [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I am wanting to create a PHP frontend to a database that holds information about the computers that I take care of. I have a problem though when it comes to storing hard drive information. In most cases, the computers have one drive, but some have 2 or more, so I can't create the main database with fields like this. ComputerID HardDriveType HardDriveSize I know I will need to create a separate table to hold information about the drives, and connect them to the computer by attaching the primary key of the drives table to the Computer table. Computer Table ComputerID DriveID Drive Table DriveID HardDriveType HardDriveSize This is where I am unsure. If there is more than one drive, then this would be incomplete because it would only show one drive. What is the best way to make it so that all drives show for the computer, or am I doing this backwards? Should I tie the computer to the drive instead? Thanks, Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: question from newbie
Hi Chris, if you have your keywords already in an array all you have to do is to create the statement: foreach($arrayname AS $value) $where_stmt .= OR $value; $stmt = SELECT ... WHERE .$where_stmt ; you might have to include an if stmt in the foreach loop because you are not allowed to start with an OR. But you get the idea? Hope this helps, Andy -- http://www.globosapiens.net Global Travellers Network! Chris Barnes [EMAIL PROTECTED] schrieb im Newsbeitrag 000201c21ace$65e66ba0$[EMAIL PROTECTED]">news:000201c21ace$65e66ba0$[EMAIL PROTECTED]... Hi people, Im quite new to the list. I am trying to construct a php script that will take a string submitted from a web site, break it up into keywords and add to an array, then perform a query to a mysql db for each keyword in the array. It will then send the result to the browser. the script is complete so far as I have added the functions to get the string from the web site, explode it and add it to an array, but i'm having trouble putting together a loop that will do a new query for every keyword in the array. is anyone able to help me with an example of a loop which could work for me? any help very much apreciated :) Chris Barnes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Question about ODBC databases
Estimado Gerardo, estoy comenzado a desarrollar una solución utilizando un servicio en NT y un cliente en php (los estoy desarrollando en java). El servicio en NT no es más que un socket server que consulta vía ODBC a los archivos de bases de datos que están en el propio NT Server. Las soluciones de Benjamin Walling [[EMAIL PROTECTED]] y de John Lim [[EMAIL PROTECTED]] no se me habían ocurrido y me parecen por demás ingeniosas. El unico inconveniente que veo es que pasan la consulta por la URL y tengo entendido que esta tiene un tamaño máximo. De la pregunta que me haces, realmente no tengo idea de donde colocar la base de datos en el linux. En cuanto tenga la solución te cuento. Saludos Juan I'm developing a solution by using an NT service and a client into a php code (developed with java). The NT service is a socket server that query the datafiles through ODBC localized in the NT Server. The solutions proposed by Benjamin Walling and John Lim are pretty smart and I didn't occurs to me. But I found some troubles with this approach: as far as I know the URL has a maximum length. About your question, I don't know where locate the datafile in a Linux Server. ASAP I was finished my proposal of solution I'll tell you -Mensaje original- De: Gerardo Morales [mailto:[EMAIL PROTECTED]] Enviado el: Lunes 20 de Mayo de 2002 14:44 Para: [EMAIL PROTECTED] Asunto: Re: [PHP-DB] Re: Question about ODBC databases Gracias Juan. Sobre el mismo tema, aunque a la vez separado, en el caso de que la BD se pusiera en forma local, en que directorio se especifica? es necesario hacer algun cambio en php.ini para especificarle una localidad en especifico?? en el caso de que asi sea, alguien sabra si es posible utilizar MOUNT, NFSD o alguna otra opcion dentro de Linux??? Thanks, Another questions are the following, If I can add the Access DB in a local directory in the Linux server, which location should be (dev/, usr/, etc)?? If I add it in a especific path for example /htdocs/MyDB/Access how can I especified to PHP that read thiis path, Need i modified the php.ini file?? Can I Mount a Network File System on Linux, as I can mount the HD with the DB (win nt OS) to a local Path?? using NFSD, MOUNT or another option?? Thanks In advanced Juan Angel Ringhetti wrote: Gerardo, tuve el mismo problema. Compartir con Samba no te soluciona el problema porque ODBC no cruza servers sino que trabaja en el mismo server. Encontré una solucion con un ODBCBridge (www.easysoft.com) pero su licencia no es gratuita sino que tiene un período de trial. Si resolvés el problema avisame. Juan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 [EMAIL PROTECTED] 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[accessusername],$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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 [EMAIL PROTECTED] 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[accessusername],$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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 [EMAIL PROTECTED] 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[accessusername],$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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Question about ODBC databases
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:[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), 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 [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Question about ODBC databases
Gerardo, Access can only be served by Windows - you need to connect to it remotely. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Gerardo Morales [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 12:44 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Question about ODBC databases Gracias Juan. Sobre el mismo tema, aunque a la vez separado, en el caso de que la BD se pusiera en forma local, en que directorio se especifica? es necesario hacer algun cambio en php.ini para especificarle una localidad en especifico?? en el caso de que asi sea, alguien sabra si es posible utilizar MOUNT, NFSD o alguna otra opcion dentro de Linux??? Thanks, Another questions are the following, If I can add the Access DB in a local directory in the Linux server, which location should be (dev/, usr/, etc)?? If I add it in a especific path for example /htdocs/MyDB/Access how can I especified to PHP that read thiis path, Need i modified the php.ini file?? Can I Mount a Network File System on Linux, as I can mount the HD with the DB (win nt OS) to a local Path?? using NFSD, MOUNT or another option?? Thanks In advanced Juan Angel Ringhetti wrote: Gerardo, tuve el mismo problema. Compartir con Samba no te soluciona el problema porque ODBC no cruza servers sino que trabaja en el mismo server. Encontré una solucion con un ODBCBridge (www.easysoft.com) pero su licencia no es gratuita sino que tiene un período de trial. Si resolvés el problema avisame. Juan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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:[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: 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:[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), 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 [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Question about ODBC databases
Write a simple web service. Put a few PHP pages on the NT server, which take parameters, and return results. For example, create a function that takes a string (sql statement, eg) as a parameter, and echos a comma delimited page (the resulting recordset). Then, on the Linux/Unix box, use the HTTP methods to call the page, passing the string and then parses the output. I've done this with ASP to interact with some VB programs that some of our remote sites use. It works well. Anthony [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... 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: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Question about ODBC databases
Gracias Juan. Sobre el mismo tema, aunque a la vez separado, en el caso de que la BD se pusiera en forma local, en que directorio se especifica? es necesario hacer algun cambio en php.ini para especificarle una localidad en especifico?? en el caso de que asi sea, alguien sabra si es posible utilizar MOUNT, NFSD o alguna otra opcion dentro de Linux??? Thanks, Another questions are the following, If I can add the Access DB in a local directory in the Linux server, which location should be (dev/, usr/, etc)?? If I add it in a especific path for example /htdocs/MyDB/Access how can I especified to PHP that read thiis path, Need i modified the php.ini file?? Can I Mount a Network File System on Linux, as I can mount the HD with the DB (win nt OS) to a local Path?? using NFSD, MOUNT or another option?? Thanks In advanced Juan Angel Ringhetti wrote: Gerardo, tuve el mismo problema. Compartir con Samba no te soluciona el problema porque ODBC no cruza servers sino que trabaja en el mismo server. Encontré una solucion con un ODBCBridge (www.easysoft.com) pero su licencia no es gratuita sino que tiene un período de trial. Si resolvés el problema avisame. Juan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Question, using Interbase on Win32 platform, please help...
Hello Wee ,
I had the same problem as you one week ago : 'Unable to load dynamic library
'php_interbase.dll'
with this version for gds32.dll : WI-V5.6.0.29 (347 136 bytes) (this is the
dll which is used by php_interbase.dll to access Interbase )
After , i have tried with a new version of gds32.dll (WI-V6.0.0.530 , 361
984 bytes) , from directory c:\php\dll and now i can load php_interbase
correctly : (this version is for version 6 but i can use it with
(this dll works properly with the tool from Interbase: Communication
Diagnostic Tool and also with ISQL ... )
= when i run phpinfo() (in a little script ) , i see informations about
Interbase : Interbase Enabled ...
I can connect to Interbase :
Connection on database ...
Connection OK=Resource id #1
Query on database ...
Warning: InterBase: Dynamic SQL Error SQL error code = -901 feature is not
supported in C:\InetPub\Pub\www\TestInterbase.php on line 33
End Query on database
Result= ()
But as you see , i can't Query Interbase !!!
This is the script i have run:
$host = 'SERVER1:e:\Data\Interbase\DB1.GDB';
$username = 'SYSDBA';
$password = 'passwd';
echo ' Connection on database ...br';
$dbh = ibase_connect($host, $username, $password);
echo ' Connexion OK=' . $dbh . 'br';
echo ' Query on database ...br';
$Q = ibase_query($dbh, 'Select * From customer');
echo ' End Query on databasebr';
echo Result= ( . $Q . )br;
ibase_close ($dbh);
I don't undestand why the Query don't work properly , perhaps a bug in
php_interbase.dll ...
Hope this help ...
If you find a solution of our problem , don't forget me ;-
Pascal
[EMAIL PROTECTED]
Wee Kyoungsub [EMAIL PROTECTED] a ecrit dans le message news:
005301c080b5$0440ded0$[EMAIL PROTECTED]
Hi,
My Server is Windows 2000 ( Advanced Server ).
I use Apache WebServer(1.3.12) and PHP 4.0.2
I use Interbase 5.6 Server, PHP module (extension) not loading problem.
My PHP root is c:\php
My PHP.INI, this
extension_dir=C:\php\extensions
extension=php_interbase.dll
-
when I Start Apache Service, Appear this message
'Unable to load dynamic library 'php_interbase.dll'
but any PHP function execute good.
I execute sample php code, this
--
?
phpinfo();
$dbh = ibase_connect (d:\project\klpg\database\tank.gdb, sysdba,
masterkey);
$stmt = 'SELECT * FROM customer';
$sth = ibase_query ($dbh, $stmt);
while ($row = ibase_fetch_object ($sth))
{
print $row-email . \n;
}
ibase_close ($dbh);
?
--
result is
Fatal error: Call to undefined function: ibase_connect() in
d:/webroot/index.php3 on line 36
I don't know this..help...please
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Question about strlen .. I think
Sorry wrong section :\ Dennis Kaandorp [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Hello, On my site users can submit ftp's. Is there a way to replace the spaces between the paths? This is what I mean: /uploads//by/ /dennis/ must become /uploads/4sp/by/3spdennis/ Thnx, Dennis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
