[PHP] Memory exhausted message wrong
Hi all, I'm trying to run phpDocumentor 1.3.0RC3 under PHP 4.3.10, and I get the following error: Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 3668 bytes) in /usr/local/lib/php/PhpDocumentor/phpDocumentor/phpDocumentorTWordParser. inc on line 236 The problem is that in my php.ini file, I have the line: memory_limit = 8M So, why is PHP reporting that the allowed memory size is 256M? The phpinfo() function correctly reports that memory_limit is set to 8M. With this problem, I can't run phpDocumentor, as it doesn't matter how large I set memory_limit in php.ini, it always crashes with the same error. TIA, -- Andrew Hill Software Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7367 F: +44 (0)20 7299 7374 IRC: #max on freenode.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Memory exhausted message wrong
Marek Kilimajer wrote: Andrew Hill wrote: The problem is that in my php.ini file, I have the line: memory_limit = 8M So, why is PHP reporting that the allowed memory size is 256M? The phpinfo() function correctly reports that memory_limit is set to 8M. Are you running phpini() from command line? cli-php might be using another php.ini I've checked, and it's the same php.ini file. Thanks, -- Andrew Hill Software Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7367 F: +44 (0)20 7299 7374 IRC: #max on freenode.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Memory exhausted message wrong
Andrew Hill wrote: The problem is that in my php.ini file, I have the line: memory_limit = 8M So, why is PHP reporting that the allowed memory size is 256M? The phpinfo() function correctly reports that memory_limit is set to 8M. I've just been informed off-list that phpDocumentor sets the memory limit to 256M in the code. Thanks all! -- Andrew Hill Software Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7367 F: +44 (0)20 7299 7374 IRC: #max on freenode.net -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Use of date(), and therefore time(), in the PEAR Date class
Hi all, I've run into a bit of a doozy that I can't seem to figure out. I'm using the PEAR Date class to deal with some time/date requirements for some code, and everything has been working (to the best of my knowledge) really well, up until now. I decided to extend my code test suite (using Simple Test, http://www.lastcraft.com/simple_test.php), by caluclating the execution time. I did this by: 1) Creating a Date object at the start of the test suite, via new Date(); 2) Creating another Date object at the end of the test suite, via new Date(); 3) Creating a Date_Span object, via new Date_Span(); 4) Setting the Date_Span object's span by using the Date_Span::setFromDateDiff() method, with the two Date objects. Finally, I can use the Date_Span object to output the time taken to run the test suite, using the Date_Span::format() method. However, this gave me a run time that was clearly wrong, so I started looking into why, and discovered that the Date object I create at the end of the test suite run is one hour earlier than the current time. I have traced the code through the execution of the creation of the Date objects, and it is correctly setting the time zone as UTC during the creation of *both* Date objects -- however, as each Date object is created with the code new Date(), the PEAR Date class uses a call to date(Y-m-d H:i:s) (and, by association, to time()) in order to get the current time, and use it to set the properties of the Date object. It is the call to PHP's date()/time() function that returns a time that is one hour earlier than my system clock. What I don't understand is *why* this is happening. If I call the time() function directly before/after the creation of the second call to Date (which is the one that generates the incorrect date), I actually get the correct time! Can anyone please suggest what might be causing date()/time() to (sometimes) return an incorrect time inside the Date class? Cheers, -- Andrew Hill Developer Awarez Ltd. Kirkman House, 12-14 Whitfield Street, London W1T 2RF T: +44 (0)20 7299 7370 F: +44 (0)20 7299 7374 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] flock(), fclose() and O/S buffering
Hi all, I have a question about the way flock() and fclose() work in PHP. Consider the following code, slightly modified from the flock() PHP manual page: $fp = fopen(/tmp/lock.txt, w+); if (flock($fp, LOCK_EX)) { // do an exclusive lock fwrite($fp, $processName\n); flock($fp, LOCK_UN); // release the lock } else { echo Couldn't lock the file !; } fclose($fp); If the above code was executed by two processes, process A and process B, one possible sequence of events is: Process A opens the file. Process B opens the file. Process A obtains an exclusive lock. Process A writes it's process name to the file. Process A releases the exclusive lock. Process A closes the file. Process B obtains an exclusive lock. Process B writes it's process name to the file. Process B releases the exclusive lock. Process B closes the file. The results would be as desired - that is, as process B obtained the lock on the file after process A, it is process B's process name that is in the contents of the file, not process A. However, another possible sequence of events is: Process A opens the file. Process B opens the file. Process A obtains an exclusive lock. Process A writes it's process name to the file. Process A releases the exclusive lock. Process B obtains an exclusive lock. Process B writes it's process name to the file. Process B releases the exclusive lock. Process B closes the file. Process A closes the file. In this case, although process B is the second process to obtain a lock and write its process name to the file, it is the first process to close the file handle. This raises the question of when the operating system actually writes file contents to disk. Is it when PHP performs an fwrite()? Or does the O/S buffer the file contents? Essentially, when performing the style of concurrent programming above, can one be certain at what point in time the file contents will be written (on any operating system)? My suspicion is that the answer to the above question is no, and as a result, in order to be certain of correctly serialising the file locking and output process, it would be necessary to use a separate lockfile, which is opened and locked *before* the file to be written to is opened, written, and then closed, after which the lock on the lockfile can be released. Can anyone please confirm that this is the case? Thanks, -- Andrew Hill [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] OCDB Connection from unix box
Hi Peter, Check out the PHP-ODBC HOWTO's on http://www.iodbc.org, this will help you get the *nix side set up. You will also need an appropriate driver to install on the *nix box - OpenLink has 30 day trials if you require one. Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access and the Virtuoso Universal Server http://www.openlinksw.com/virtuoso/whatis.htm On Sunday, October 27, 2002, at 07:56 PM, Peter Houchin wrote: can any one point me to a good tutorial or article that has web server on a unix box and a win2k server with access on it? is there anything other than the ocdb_connect... that i need to get/use to connect to it? Cheers Peter the only dumb question is the one that wasn't asked -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] php and databases
Or, more simply - set up an ODBC DSN on the Windows box to the MySQL database, and simply link the tables into Access. Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access and the Virtuoso Universal Server http://www.openlinksw.com/virtuoso/whatis.htm On Friday, October 25, 2002, at 12:43 PM, Jay Blanchard wrote: [snip] Is there anyway to have php convert a database from mySQL to Access via a webpage? I have a couple of people here who use Access to do mail merging things with word and it would make my life a ton easier if I did not have to convert the db's everytime they want the info. If anyone has any thoughts on how to go about this it would be greatly appreciated. Thanks in advance. [/snip] Open and read the data via mysql_ ..() functions into an array. Then open an ODBC connection to the acce$$ database and insert the data from the array. Shouldn't be too hard. HTH! Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Does anyone knows File Maker
Elliot, PHP works just fine with ODBC, using the iODBC Driver Manager as per the HOWTO at http://www.iodbc.org. This should work against FMPro under Windows as well. Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software Universal Data Access and the Virtuoso Universal Server http://www.openlinksw.com/virtuoso/whatis.htm On Thursday, October 3, 2002, at 11:23 AM, Webmaster MBTRADINGCO wrote: I ran yesterday into a company that wants me to implement a solution with PHP and File Maker. I don't even know if it is possible, so I was wondering: A) Does anyone has any experience with filemaker? b) Can PHP save data from internet via ODBC to a database (other than the ones it supports) in a windows server? c) Does anyone knows if PHP supports file maker? Thanks in advance. Elliot J. Balanza -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] xml to mysql
Hi, Virtuoso http://www.openlinksw.com/virtuoso can do the opposite - represent tables and SQL queries, either from relational data in Virtuoso or another back-end database (including MySQL and all the usual suspects) and provide an XML document in real time for PHP to use. Virtuoso Universal Server is available as a free download - let me know what you think. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: DtM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 04, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: [PHP] xml to mysql Hi, Is there a way to create a DB from a xml file or it's better to use the xml file for DB, i have lot of files so i think a DB will be better. If you know a program or tutorial let me know. thanx. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] can i use --with-unixODBC instead of --with-ibm-db2?
Doug, Have you tried setting the variables with putenv() ? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Doug Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 2:28 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] can i use --with-unixODBC instead of --with-ibm-db2? I just checked my config, and I *actually* have that line in apachectl. Try that, and if it fixes it, I'll correct the doc. although my apache is built via rpm, i put the line (. /home/db2inst1/sqllib/db2profile) in apachectl and started httpd w/ apachectl, bt... unfortunately i'm still getting the Warning: SQL error: , SQL state ËtøO@Ùÿ¿6#A@ in SQLConnect in /var/www/html/db2php/db2lib.php on line 8 error... i also tried to add export DB2INSTANCE=db2inst1 in the same script and that didn't help either. could the problem be that i'm starting httpd (or apachectl) as root? i know the . /home/db2inst1/sqllib/db2profile is supposed to make apachectl inherit the db2 environment variables, but.. somehow it's not working :/ matt, thank you again :) -doug p.s. for the record__ ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbind ir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/includ e --libdir=/usr/lib --sysconfdir=/etc --with-apxs=/usr/sbin/apxs --with-ibm- db2 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2?
Doug, It may be - I'm a bit more familiar with iODBC. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Doug Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 3:14 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2? does this look like the ODBC SDK of unixODBC (not that i expect you to know unixODBC) /usr/lib/libboundparam.so.1 /usr/lib/libboundparam.so.1.0.0 /usr/lib/libesoobS.so.1 /usr/lib/libesoobS.so.1.0.0 /usr/lib/libgtrtst.so.1 /usr/lib/libgtrtst.so.1.0.0 /usr/lib/libnn.so.1 /usr/lib/libnn.so.1.0.0 /usr/lib/libodbc.so.1 /usr/lib/libodbc.so.1.0.0 /usr/lib/libodbccr.so.1 /usr/lib/libodbccr.so.1.0.0 /usr/lib/libodbcdrvcfg1S.so.1 /usr/lib/libodbcdrvcfg1S.so.1.0.0 /usr/lib/libodbcdrvcfg2S.so.1 /usr/lib/libodbcdrvcfg2S.so.1.0.0 /usr/lib/libodbcextras.so.1 /usr/lib/libodbcextras.so.1.0.0 /usr/lib/libodbcinst.so.1 (...it continues) I found this from $rpm -q --list unixODBC ... somehow I was under the assumption that IBM DB2 UDB came with a ODBC SDK -- i.e. this stuff... /usr/IBMdb2/V7.1/lib/libdb2ccai.so.1 /usr/IBMdb2/V7.1/lib/libdb2ar.so /usr/IBMdb2/V7.1/lib/libdb2.so /usr/IBMdb2/V7.1/lib/libdb2qp.so /usr/IBMdb2/V7.1/lib/libdb2apie.so /usr/IBMdb2/V7.1/lib/libdb2jdbc.so (which continues as well...) or am i still missing something? thanks again, and thanks for your patience too, i really appreciate it. -doug Andrew Hill [EMAIL PROTECTED] wrote in message news:043601c23f0c$0d74efc0$[EMAIL PROTECTED]... Doug, You need an ODBC SDK - you should be able to find the libs in UnixODBC or simply use iODBC from www.iodbc.org Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Doug Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 10:11 AM To: Andrew Hill Subject: Re: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2? Thanks for the suggestion. I tried issuing the command # export LD_LIBRARY_PATH=/usr/IBMdb2/V7.1/include/ (which is where i found sql.h and sqlext.h to be living) Before I ran make install but, unfortunately it came up with the same errors. Well... Maybe it is time I head back to the drawing board and checkout iodbc -- thank you very much, I appreciate it. -Doug Smith Andrew Hill [EMAIL PROTECTED] wrote in message news:03f101c23eea$986d8960$[EMAIL PROTECTED]... Doug, You can try --with-iodbc if you like, there is a howto at www.iodbc.org. That being said, I think that you simply need to set LD_LIBRARY_PATH to the location of your ODBC SDK, so the .h files can be found. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Doug Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 08, 2002 9:38 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: can i use --with-unixODBC instead of --with-ibm-db2? well i figured i'd try it... i run $ ./configure i386-redhat-linux --sysconfdir=/etc --with-unixODBC=shared --with-apxs=/usr/ sbin/apxs $ make clean $ make install which returns this aweful mess :/ Making install in odbc make[2]: Entering directory `/home/doug/php-4.2.2/ext/odbc' make[3]: Entering directory `/home/doug/php-4.2.2/ext/odbc' /bin/sh /home/doug/php-4.2.2/libtool --silent --mode=compile gcc -I. -I/home/dou g/php-4.2.2/ext/odbc -I/home/doug/php-4.2.2/main -I/home/doug/php-4.2.2 -I/u sr/i nclude/apache -I/home/doug/php-4.2.2/Zend -I/home/doug/php-4.2.2/ext/mysql/l ibmy sql -I/usr/local/include -I/home/doug/php-4.2.2/ext/xml/expat -DLINUX=22 -D EAPI -DEAPI_MM -DEAPI_MM_CORE_PATH=/var/run/httpd.mm -I/home/doug/php-4.2.2/TSRM -g -O2 -prefer-pic -c php_odbc.c touch php_odbc.slo In file included from php_odbc.c:37: php_odbc.h:120:17: sql.h: No such file or directory php_odbc.h:121:20: sqlext.h: No such file or directory make[3]: *** [php_odbc.slo] Error 1 make[3]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' make[2]: *** [install-recursive] Error 1 make[2]: Leaving directory `/home/doug/php-4.2.2/ext/odbc' make[1]: *** [install-recursive] Error 1 make[1]: Leaving directory `/home/doug/php-4.2.2/ext' make: *** [install-recursive] Error 1 how do i let php know where the sql.h / sqlext.h files are? TIA -- any ideas are appreciated. ___ Doug Smith [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... can i use --with-unixODBC instead of --with-ibm-db2? I've had a lot of trouble getting php to talk to IBM DB2 (see
RE: [PHP] Close A Databse Connection
+1 right. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Friday, July 26, 2002 2:22 PM To: [EMAIL PROTECTED] Subject: [PHP] Close A Databse Connection Well, it's Friday afternoon and the pre-pub run debates have started :^] The choice of arguement today is born of the fact that I advised a newbie to always use mysql_close() to close the connection to the database. It's good form and will cover any ills where the database connection fails to close for some other reason (say the user stops the page from loading after the connection is made). I know that it is not required, but always being competitive I thought I would turn to the group for a concensus, whether I am right or wrong. Thoughts? Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: Where do I specify a DSN?
Naw, this is Linux :) But for anyone searching the archives, the Data source name not found, and no default driver specified means one of four things: 1. you don't have a DSN with the name you are using 2. you don't have a driver where the DSN expects to find it 3. on Windows, you are trying to use a File/User DSN instead of a System DSN. 4. on *nix - you haven't specified your ODBCINI environment variable like: putenv(ODBCINI=/path/to/odbc.ini); (note LD_LIBRARY_PATH and ODBCINSTINI may have to be defined as well!) Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Tracker 1 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 8:28 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: Where do I specify a DSN? Richard Lynch [EMAIL PROTECTED] wrote in message... I'm getting this error message...where does it come from? Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/html/index.php on line 4@ Microsoft. :-) Microsoft defines possible database connections as DSN in the ODBC Control Panel. Open up the ODBC Control Panel, and make a DSN named foo and point it to the database you want to access. it said unixODBC, not sure what he was trying to connect to though, may be best to use the native connection drivers? -- === 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/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Using PHP to access a Microsoft SQL server
ODBC can do this directly - no root privs needed. http://www.php.net/odbc Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Lazor, Ed [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 5:12 PM To: php-general Subject: RE: [PHP] Using PHP to access a Microsoft SQL server It sounds like you need to give your apache account access to the database. You can test this by logging in as root and running su - apache. You'll be logged in as Apache; try running the commands you used to test everything when logged in as root. You'll probably get errors that will hopefully lead you to an answer. -Original Message- From: David Busby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 3:01 PM To: php-general Subject: [PHP] Using PHP to access a Microsoft SQL server List, Has anyone done this before? I got it to work for my root account on my computer but I cannot get access from my PHP scripts when I run under the apache user? What the dilly yo? Setup: RH7.3 PHP4 unixODBC freeTDS -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete the message. Thank you very much. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] [GURU] PHP w/ Informix DB ISQL 7.20 and Dynamic server 7.30
Hi Emile, Sure, ODBC should work just fine. Let me know if you need info on setting it up. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Emile Bosch [mailto:[EMAIL PROTECTED]] Sent: Saturday, June 29, 2002 3:08 AM To: [EMAIL PROTECTED] Subject: [PHP] [GURU] PHP w/ Informix DB ISQL 7.20 and Dynamic server 7.30 Hi group, I have to automate (read: Put there internal informix db online) an company and they are using this configuration: ISQL 7.20 Embedded sql for C. 9.14 4GL 7.30 4GL runtime 7.20 Dynamic server 7.30 Java API1.05 Now i was wondering wheter it is possible to make an PHP connection to this DB so that i can query it and use it in PHP. Does someone knows how to do this? Or is it maybe possible to make an ODBC connection or anything like that/ Warm regards Emile Bosch -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] ODBC Failures
How does it fail? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: David Busby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 4:29 PM To: php-general Subject: [PHP] ODBC Failures List, My ODBC connection is failing it seems...I can run this code just fine...odbc_connect and odbc_pconnect seem to work...the odbc_prepare even works just fine...but as soon as I execute (with odbc_execute, odbc_exec, or odbc_do it fails...any ideas? ?php $db = odbc_pconnect(Desire,sa, ); echo Database Connection:.$db.br; $sql = odbc_prepare($db, execute spGetItems); echo Prepared SQL id:.$sql.br; // This line will fail $rs = odbc_execute($sql); ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Where do I specify a DSN? v0.2
David, The error probably has to do with your PHP environment being unable to locate your odbc.ini file. You will need to set your odbc.ini location as well as the location of the driver manager. Check out this HOWTO http://www.iodbc.org/odbc-phpHOWTO.html to get an idea of how it all works - the instructions should be similar for UnixODBC. Hint - look at the putenv() calls. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: David Busby [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 2:55 PM To: php-general Subject: [PHP] Where do I specify a DSN? v0.2 List, Guess I should be more specific: Heres line four: $db = odbc_connect(somedsn,sa, ); My System: RedHat 7.3/Apache/PHP 4.1.2-7 I'm getting this error message...I think I just need to define the DSN...is that done in /etc/odbc.ini? Or what? /B Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/html/index.php on line 4@ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] HOWTO: ODBC-PHP-Apache2
Hello folks, Apologies for the cross-post, but I wanted to announce the publication of a new HOWTO on compiling ODBC support into PHP and Apache with the iODBC Driver Manager: It's available at the www.iodbc.org site in the left hand column. You may view the document directly at: http://www.iodbc.org/odbc-php-apache2.html Please provide feedback and comments! Best regards, Andrew Hill Director of Technology Evangelism - OpenLink Software What is Virtuoso? http://www.openlinksw.com/virtuoso/whatis.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] RE: ODBC for Informix
Hi Kevin, You can also obtain ODBC Drivers for Informix from OpenLink - http://www.openlinksw.com Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Juraj Hasko [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 23, 2002 2:45 AM To: 'Kevin Meredith' Cc: [EMAIL PROTECTED] Subject: [PHP] RE: ODBC for Informix Hi, ODBC drivers should be installed on server, you can download latest Informix SDK w/ ODBC drivers from IBM: http://www6.software.ibm.com/devcon/devcon/docs/clnt27wx.htm Juraj -Original Message- From: Kevin Meredith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 3:22 PM To: PHP Subject: ODBC for Informix Hi there. Could someone please tell me where I could get hold of the ODBC drivers to connect to Informix with PHP. Is there anything else I should know. Thanks Kevin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Error Reporing Questions with Mac
Kevin, This can either be set dynamically by the error_reporting() function, or changed in the php.ini file. http://www.php.net/manual/en/function.error-reporting.php http://www.php.net/manual/en/features.error-handling.php Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Kevin Ruiz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 9:58 AM To: [EMAIL PROTECTED] Subject: [PHP] Error Reporing Questions with Mac I'm running php 4 on a unix server and am experiencing a problem with error reporting I'm getting on my mac. When I get a parse error it won't tell me what line the error is on...it simply says parse error on line 1. When I test the page on a pc I get an error message that I can use... parse error on line 143. Does anyone have any ideas? I get the same error when using IE for both OS X and 9. Thanks in advance, Kevin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: Getting PHP on FreeBSD to talk to MSSQL Server 7...
And you can also use ODBC Drivers, after linking --with-iodbc as per the HOWTO's on www.iodbc.org. You may obtain drivers from OpenLink. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Danny Shepherd [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 3:29 PM To: [EMAIL PROTECTED]; Michael Kimsal Subject: Re: [PHP] Re: Getting PHP on FreeBSD to talk to MSSQL Server 7... In my expierence you'll have much greater chance of sucess if you compile with --with-sybase-ct :) I just used --with-sybase-ct=/usr/local - I didn't bother with --with-mssql or --with-sybase Paticulars: FreeBSD 4.5 PHP 4.2.0 FreeTDS 0.53 Of course, using this methods means you also have to use the sybase commands not the mssql commands but they're pretty much identical in function - just the names that are different. HTH Danny. - Original Message - From: Michael Kimsal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 2:08 AM Subject: [PHP] Re: Getting PHP on FreeBSD to talk to MSSQL Server 7... Glenn Sieb wrote: Hi.. it's me again :) We have a few different servers here, most of which are FreeBSD, including our internal web server (Apache 1.3.24). We have PHP 4.2.0 installed as well. Currently I'm running my MSSQL query scripts on a Win2k webserver, as I can't seem to get PHP to talk to MSSQL on the FreeBSD side. I'd really prefer to have my PHP scripts all running on the FreeBSD side, rather than on Win2k. We do have Perl able to talk to the MSSQL server using FreeTDS and the DBI::Sybase package on the same FreeBSD machine. My ./configure: ./configure --prefix=/usr/local --with-apache=/home/src/Apache/Apachetoolbox -1.5.56/apache_1.3.24 --enable-exif --enable-track-vars --with-calendar=shared - -enable-safe-mode --enable-magic-quotes --enable-trans-sid --enable-wddx --enabl e-ftp --with-gd=/usr/local --with-zlib --enable-gd-native-tt --with-t1lib=/usr/l ocal --with-jpeg-dir=/usr/local --with-png-dir=/usr/local --with-zlib-dir=/usr - -with-ttf --with-freetype-dir=/usr/local --with-unixodbc=/usr/local/unixODBC --w ith-openssl=/usr/local --with-curl=/usr/local --enable-apc --with-mysql=/sw/mysq l --with-mssql=/usr/local/etc/freetds --with-sybase=/usr/local/etc/freetds (built using ApacheToolbox, 1.5.56) FreeTDS' interfaces file is located in /usr/local/etc/freetds, which it is/was my understanding that this is what's supposed to be there. Yet not only does PHP give me: the --with-sybase= line needs to point to where freetds was compiled, not the interfaces file. We don't use the interfaces file, which seems to be primarily a way to map names to IPs. We just use the IP address directly in the mssql_connect() functions and it works. Michael Kimsal http://www.phphelpdesk.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] ODBC number of rows?
Brian, This returns -1 for most drivers in a Select, but should return appropriate info in an Update, Alter, Insert, etc. If you need the feature when returning rows of data, you may simply create a loop and increment a counter variable as you iterate over the result se5t. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Brian McGarvie [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 7:07 AM To: PHP General Subject: [PHP] ODBC number of rows? odbc_num_rows($result); the above return -1 always, what other way can you check if any rows have been returned? === Brian M McGarvie, Web Appications Co-ordinator/Consultant === [ www.mcgarvie.net | www.lennox-mckinlay.co.uk] === -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP and MS Access
Ronan, Check these: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q306269 http://support.microsoft.com/default.aspx?scid=kb;EN-US;q174943 It's most likely an issue with how you have your DSN setup or how apache is running. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Universal Server -Original Message- From: ronan cleary [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 6:42 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP and MS Access I am running PHP and Apache and have a problem connecting to an Ms Access database I cannot connect to my database. I am using an Apache Server with PHP. Now as far as I can see these work fine apart from some dll files in PHP. I have also set up an ODBC connection to my database, but when I try and run the PHP code I get errors. This is the PHP code I am using. The ODBC is called link1 and the database db1. ?php $db = ODBC_Connect(link1, ,); $res = ODBC_Exec($db, SELECT Employee.Name FROM Employee;); while (ODBC_Fetch_Row($res)) { echo TRTD.ODBC_Result($res, 'fieldname')./TD/TR; } ODBC_Free_Result($res); ? These are the errors that it returns X-Powered-By: PHP/4.0.6 Content-type: text/html Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in o:\program files\apache group\apache\htdocs\name1.php on line 2 Warning: Supplied argument is not a valid ODBC-Link resource in o:\program files\apache group\apache\htdocs\name1.php on line 3 Warning: Supplied argument is not a valid ODBC result resource in o:\program files\apache group\apache\htdocs\name1.php on line 4 Warning: Supplied argument is not a valid ODBC result resource in o:\program files\apache group\apache\htdocs\name1.php on line 7 Any help on where to go would be great. Thanks a million Ronan _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Using ODBC
What problems are you having? It's fairly straightforward - create a System DSN and test it in the ODBC Administrator, and use it in the odbc functions in PHP. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Virtuoso Universal Server -Original Message- From: Someone Somewhere [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:17 AM To: [EMAIL PROTECTED] Subject: [PHP] Using ODBC Does anyone have any experience using ODBC to connect to an Access database, I'm runing php and Apache in Windows 2000. Any help will be apreciated. Thanks Someone -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Mac Classic and PHP...
Or even put the 68k linux distro (I forget its name) on their 8500. Actually, an 8500 can run LinuxPPC or SuSe for PPC just fine. I've got PHP, iODBC, Apache, etc running great on this setup for testing purposes. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Database abstraction layer oci
Most powerful meaning being tied to Oracle? :) ODBC is not inherently slower than oci or any native access, and a properly written ODBC driver will actually enforce additional functionality against the back-end database. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Thies C. Arntzen [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 09, 2002 5:10 AM To: Andrew Hill Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] Database abstraction layer oci hi, the fastest and most powerful is always to use the native api. i would use the PHP oci driver. tc On Fri, Mar 08, 2002 at 09:00:17AM -0500, Andrew Hill wrote: I suggest simply using ODBC. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 5:39 AM To: [EMAIL PROTECTED] Subject: [PHP] Database abstraction layer oci Hi everybody. I would like your opinion on the Database Abstraction Layer you prefer (I will use it with Oracle 8i) I know that there is Metabase end Pear DB What's your opinion on both or others ? Laurent Drouet -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Database abstraction layer oci
I suggest simply using ODBC. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 5:39 AM To: [EMAIL PROTECTED] Subject: [PHP] Database abstraction layer oci Hi everybody. I would like your opinion on the Database Abstraction Layer you prefer (I will use it with Oracle 8i) I know that there is Metabase end Pear DB What's your opinion on both or others ? Laurent Drouet -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] DB2 from PHP : ODBC ?
Mário, It runs fine, either using the unified-ODBC or compiling PHP --with-iodbc as per the HOWTO at www.iodbc.org and using real ODBC drivers. As in every case with ODBC, the quality of your experience will be determined by the quality of the ODBC drivers you use. OpenLink provides free, non-expiring downloads at www.openlinksw.com for development and testing. Hope this helps! Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: Mario Bittencourt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 3:27 PM To: [EMAIL PROTECTED] Subject: [PHP] DB2 from PHP : ODBC ? Hi phpers, Does anybody know if accessing DB2 using ODBC runs ok ? I've never tried that and was wondering if there are any tips/limitations (like configuration settings on both ends...) ? Thanks, Mário -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP + ODBC on IIS (Win2k)
Sebastian, Check your System DSN - Options button, and verify that you don't have Exclusive checked off. Hope this helps. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: Sebastian Timocea [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 9:47 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP + ODBC on IIS (Win2k) Hello! I am having a really ugly problem here and I hope somebody can help me with this. I work on - Windows 2000 Advanced Server - PHP for Windows and IIS (it works ok) I have a DBTest.mdb database (Access 2000) and an ODBC connection to this database: System DSN=DBTest, no user and password to connect! I have tested this ODBC connection with a VBasic simple application and it works just fine. Now I create a Test.php file with this content: ?php odbc_connect(DBTest, , ); ? When I open this file in the browser http://localhost/directory/Test.php? I get the next error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in C:\inetpub\wwwroot\directory\Test.php on line 3 I have checked everything and the database is not opened by anybody. Plus, the Security rights are set to enable Everyone and Internet Guest Account (IUSR_myserver) to have Full Control ont the database. So, could anybody help me with this PLEASE?? :`-( Thank you in advance, Sebastian. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PHP + ODBC on IIS (Win2k)
Ignacio, He can use Access and local ODBC just fine, as he is on a Windows box. Actually, the ODBC Socket server isn't needed from Linux either, as OpenLink provides Single-Tier and Multi-Tier ODBC drivers from *nix platforms to many databases. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 10:35 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] PHP + ODBC on IIS (Win2k) PHP will not work on that way in order to retrieve data from Access using ODBC. Check the URL: http://www.phpbuilder.com/columns/timuckun20001207.php3 See you !!! Atte. Ignacio Estrada F. Centro Nacional de Control de Energia Area de Control Occidental 025+6463, 025+6464, 025+6469 - Remitido por Ignacio Estrada Fonseca/CEN/GDL/CFE con fecha 02/26/2002 09:34 - Andrew Hill ahill@openliPara: Sebastian Timocea [EMAIL PROTECTED], [EMAIL PROTECTED] nksw.comcc: Asunto: RE: [PHP] PHP + ODBC on IIS (Win2k) 02/26/2002 08:53 Sebastian, Check your System DSN - Options button, and verify that you don't have Exclusive checked off. Hope this helps. Best regards, Andrew Hill Director of Technology Evangelism http://www.openlinksw.com/virtuoso/whatis.htm OpenLink Virtuoso Internet Data Integration Server -Original Message- From: Sebastian Timocea [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 9:47 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP + ODBC on IIS (Win2k) Hello! I am having a really ugly problem here and I hope somebody can help me with this. I work on - Windows 2000 Advanced Server - PHP for Windows and IIS (it works ok) I have a DBTest.mdb database (Access 2000) and an ODBC connection to this database: System DSN=DBTest, no user and password to connect! I have tested this ODBC connection with a VBasic simple application and it works just fine. Now I create a Test.php file with this content: ?php odbc_connect(DBTest, , ); ? When I open this file in the browser http://localhost/directory/Test.php? I get the next error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data., SQL state S1000 in SQLConnect in C:\inetpub\wwwroot\directory\Test.php on line 3 I have checked everything and the database is not opened by anybody. Plus, the Security rights are set to enable Everyone and Internet Guest Account (IUSR_myserver) to have Full Control ont the database. So, could anybody help me with this PLEASE?? :`-( Thank you in advance, Sebastian. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] RE: [PHP-DB] odbc functions
Richard, Simple example using MS SQL Server: ?php $dsn=Northwind; $usr=sa; $pwd=; $qual=Northwind; $owner=dbo; $table=Orders; $conn_id = odbc_connect($dsn, $usr, $pwd) or die (odbc_error()); $result_id = odbc_primarykeys($conn_id, $qual, $owner, $table) or die (odbc_error()); odbc_result_all($result_id); ? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Richard Black [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 10:36 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: [PHP-DB] odbc functions Does anyone have experience of using odbc_primarykeys??? I'm writing a script to let me port a database from Access to MySQL without having to write all the table definitions by hand. But I can't get odbc_primarykeys to work - it comes back with: Warning: SQL error: , SQL state 0 in SQLPrimaryKeys I don't really know what the modifier and owner parameters should do, and suspect thats where the problem lies. I tried them as , % and . Running PHP 4.0.4 on NT 4.0 Workstation, with Access 97 Richy. == Richard Black Systems Programmer, DataVisibility Ltd - http://www.datavisibility.com Tel: 0141 435 3504 Email: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Building my site... again
Note, This will not work with PHP as a CGI. Best regards, Andrew Hill * and then Torkil Johnsen blurted Now. I would of course like for my site to be listed in the search engines, and I wouldn't mind getting search hits on both cars and ferrari. But. Will the web spiders and web crawlers ever follow a link like index.php?page=carssubpage=ferrari and will they ever index what they find there, and, and, and, and... Some will, some wont. The trick is to use something like this index.php/cars/ferrari using Apache's backward searching feature. Together with a very simple .htaccess you can fool Apache into looking for the dirctory 'ferrari' and when it doesn't find it look for the dir cars (php assigns these values to the vars $page and $subpage) and when it finally finds index.php you can feed it those vars and let it do its stuff. -- PHP General 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]
RE: [PHP] Building my site... again
Nick, Dunno, but in my experience (and that of a few people who also opened bugs on it) any path info that is not real causes the CGI to bomb out with an Internal Server Error. So while this will work: index.php?foo=bar This will not, since there is no physical directory foo and no file bar: index.php/foo/bar Best regards, Andrew Hill -Original Message- From: Nick Wilson [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:03 AM To: PHP-General Subject: Re: [PHP] Building my site... again -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Andrew Hill blurted Note, This will not work with PHP as a CGI. How come? - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8UYGlHpvrrTa6L5oRAiOUAJ4+utKQrhQ2Vy4533lLjriNO8sXmQCfRJrw cackhuwr2ACMGFu/fbYxfcs= =3wVL -END PGP SIGNATURE- -- PHP General 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 General 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]
RE: [PHP] Re: odbc linux to win2000
Hi Ergin, Not entirely true - ODBC drivers to MS SQL Server and Sybase, etc are available. You may use OpenLink's Multi-Tier driver, which has linux client support. Free downloads are available at http://www.openlinksw.com and free support is offered at http://www.openlinksw.com/support/suppindx.htm if you run into problems. You will need to link your PHP against the iODBC Driver Manager, as per the HOWTOs at www.iodbc.org. Let me know how you get on. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Ergin Aytac [mailto:[EMAIL PROTECTED]] Sent: Friday, January 18, 2002 1:23 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: odbc linux to win2000 I think I know it again. There is no sqlbase-odbc driver available for linux, only for win2000. So I have to write a bridge, which runs on win2000 and answers the php-sql-requests. sorry for this question ergin aytac Ergin Aytac [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I want to make a database connection with odbc. My php-script is running on linux, the database (centura sqlbase 7.5) is running on win2000. Is it possible to make a direct odbc-connection to the database or do I really need a software-bridge for this connection? Someone said it is unpossible without a software-bridge, even though when I use odbc. But I forgot why, how und who... thanx ergin aytac -- PHP General 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 General 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]
RE: [PHP] ODBC Connection
Fernando, check http://www.php.net/odbc From Windows you can just create a System DSN and then use it in an odbc_connect() function. From some *nix flavor, you will need to build PHP --with-iodbc as per the howto at www.iodbc.org, and then install OpenLink's Multi-Tier ODBC driver with the server-side components on the Windows box. Let me know if you need additional assistance configuring ODBC from *nix. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Ing. Fernando Proll Segura [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 1:54 PM To: [EMAIL PROTECTED] Subject: [PHP] ODBC Connection Hi guys: I'm trying to make a connection from PHP to a MS Access. How can I do this?, I know that there are a function for this, but what about the parameters. Thanks in advanced, Fernando -- PHP General 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]
RE: [PHP] Apache Error 500
Patrick, It's likeley that one that one server PHP is installed as a GGI - unfortunatley the trick you want to use only work when PHP is installed as a module. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 31, 2001 10:20 AM To: [EMAIL PROTECTED] Subject: [PHP] Apache Error 500 Hi, I am using the list comment to decompose urls for navigation. This works fine. Except on one particular server and I don't know why.. if my url is like : test.php everything is ok, but when I use test.php/1, I get the Apache Internal 500 Error. I believe that apache is checking if the 1 in the dir test.php exists, which of course is not the case since test.php is a file. I am only allowed to modify a htaccess file... Does anyone have a suggestion how to fix this? Thanks, Patrick PS: my file test.php looks like list($dummy1,$dummy2,$pid1,$pid2) = split(/,$PHP_SELF); switch( $pid1 ) { case 1: include file1.html; break; case 2: include file2.html; break; default: include default.html; break; } -- PHP General 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 General 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]
RE: [PHP] PHP + DB2
Rares, Using ODBC should be fine; what problems are you having with input/output parameters? Also, what ODBC drivers are you using? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Rares Vasilescu [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 9:44 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP + DB2 hi Anyone here used PHP to connect to a IBM DB2 database? Of course, using ODBC. I am having difficulties calling stored procedures with input/output parameters. Any help is appreciated. Rares -- PHP General 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]
RE: [PHP] UPDATE Query works in odbc/Mysql, but fails in odbc/MS Access
mweb, MS points to a datetime issue: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q246570 As far as a reference - I'm guessing somewhere on MS's site? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 7:30 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] UPDATE Query works in odbc/Mysql, but fails in odbc/MS Access Hello, I have one MS Access DB on the server, and an exact (theoretically) copy of it in MySQL on my machine, so I can test PHP pages on Linux and install them on an NT server (using odbc of course). I can insert and select just fine, thankl to all your help. The problem is that this UPDATE query: UPDATE rec SET Aut = 1 WHERE Un = 2927230327; works perfectly on PHP/ODBC/MySQL on Linux, while on PHP/ODBC/ACCESS/ it gives this error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression., SQL state 22005 in SQLExecDirect in C:\domini\m.net\update_db.php on line 54 No cursor Initially I though well, maybe I'm trying to write a string into a number, or something like that, but I can SELECT from that same table using the same format, so what is the trick? Different UPDATE syntax between MySQL and ACCESS? If so, where is an online ACCESS syntax reference? TIA, mweb -- PHP General 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 General 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]
RE: [PHP] FreeBSD 4.3, PHP 4.0.6 unixODBC -- Undefined Symbol
Joe, What is the problem you were having with OpenLink and iODBC under BSD? If threading errors, you can simply download the non-threaded version of the SDK and drivers from our site. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Joe Koenig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 9:40 AM To: [EMAIL PROTECTED] Subject: [PHP] FreeBSD 4.3, PHP 4.0.6 unixODBC -- Undefined Symbol I had previously attempted to get the Openlink ODBC drivers work with iodbc and PHP. I was having no luck and turned to easysoft's solution, which includes unixODBC. I re-configured PHP (removing the config.cache file) and used --with-unixODBC=path/to/unixODBC instead of --with-iodbc=/path/to/iodbc. However, when starting Apache, I now get a 'Cannot load /usr/local/libexec/apache/libphp4.so into server: /usr/local/src/lib/libiodbc.so.3: Undefined symbol pthread_mutex_unlock'. The version of Apache that is installed is 1.3.20. I must not understand something about unixODBC because I didn't think libiodbc should even be getting loaded. Regardless, does anyone have a fix? Thanks, Joe -- PHP General 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 General 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]
RE: [PHP] Re: FOLLOW UP on column names not liked by odbc/php/access
mweb, I suggest you use the ODBC Metadata functions in PHP to describe your database, e.g. odbc_tables, odbc_columns, odbc_primarykeys, odbc_foreignkeys, etc. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 6:44 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Re: FOLLOW UP on column names not liked by odbc/php/access On Wednesday 05 December 2001 12:21, Dr. Michael Wittmann wrote: - you dont need apostrophes for numeric fields. you get the table definition using sql command 'DESC tablename' Thanks to Michael and all the others who pointed out my errors. The query works now. The real problem however, which is REALLY slowing me down, is that in this project I have to live with php+odbc+MS access, all on a remote server. I know the DESC instruction above, but access won't take it via odbc. It gave me this error: Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'., SQL state 37000 in SQLExecDirect in C/ etcetera.. This is the reason for all my questions in these days: is there really so little knowledge/documentation on how to handle this particular combination? If it were all mysql+apache+php I would perfectly manage everything by myself. I have also posted to comp.databases.ms.access without luck so far. Again, any pointer to such resources is appreciated. In the meantime, let me thank you all once more for your quick and kind suggestions. regards, mweb -- PHP General 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 General 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]
RE: [PHP] URGENT: IIS server now OK, but MS access DB not reachable
mweb, Are you using a File or User DSN? You DSN domain needs to be a working System DSN, succesfully tested in your ODBC Adminsistrator. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 7:28 AM To: [EMAIL PROTECTED] Subject: [PHP] URGENT: IIS server now OK, but MS access DB not reachable Still me. Thank you all, you were right!! The sysadmin did find out that the server config was wrong. Now php is OK. However, I have to access an MS access database with those pages. The sysadmin says relevant data are: DSN: domain Absolute path: c:\domini\domain_name.net\domaindata.mdb To give you an idea of the environment, a previous working ASP version was like this: Set conn = Server.CreateObject(ADODB.Connection) Set rs = Server.CreateObject(ADODB.Recordset) conn.Open Provider = Microsoft.Jet.OLEDB.4.0; Data Source = Server.MapPath(.) \domain.mdb; Persist Security Info = False The following snippet of code (copied from phpbuilder) fails as pasted at the end of the message. Now this must be even stupider than the other problem, but again any help is appreciated mweb ### MY CODE: $DB_PATH=c:\domini\domain_name.net\domaindata.mdb; $DSN=domain; / // // function Output_Entries() { //Make the connection to the database. The syntax is odbc_connect( 'SYSTEM_DSN' , 'USER', 'PASSWORD' ); //$cnx will hold the //pconnect is used to establish a persistent database connection to the Database //until the procedure is completed. $cnx = odbc_connect( $DSN , '', '' ); ## ERROR MESSAGE: Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\domini\domain_name.net\test.php on line 20 Error in odbc_connect Warning: Supplied argument is not a valid ODBC-Link resource in C:\domini\domain_name.net\test.php on line 52 Warning: Supplied argument is not a valid ODBC-Link resource in C:\domini\domain_name.net\test.php on line 52 -- PHP General 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 General 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]
RE: [PHP] Column name not liked by PHP/ODBC and Access
mweb, Just a guess - is Note a reserved word? you might want to quote/escape it. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 4:53 PM To: [EMAIL PROTECTED] Subject: [PHP] Column name not liked by PHP/ODBC and Access Hello, still fighting to drive MS access from PHP, I have come into an error when I feed odbc_exec with this statement (db connection is fine now): INSERT INTO Redazione (ID, Name, Nickname, Username, password, From, Note, amministratore, playlist, email, role, web) VALUES (NULL , me, webmin, webber, 12321, 0, , on, on, e2e2e, 222e, www.test.com); Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:\domini\m.net\cng_red.php on line 71 Error(no cursor odbc_exec) The weird thing is that I this syntax error ONLY if I write Note in the columns list. If I omit it, or even change to not existing column name (like note_fake for example, no errors are reported. If I omit it I get just complaints that there are not enough fields, but no errors. Also, it couldn't care less what I put as the Note field value ( in the case above). Ideas? Mweb -- PHP General 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 General 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]
RE: [PHP] Problem connecting to mysql via odbc
Mweb, Set your ODBCINI environment variable (and others) as per the HOWTO at www.iodbc.org. This HOWTO is for iODBC, but the concepts are the same for this error condition. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 12:02 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Problem connecting to mysql via odbc Hello, I have a page whoch should connect to a mysql database via odbc, on a RH 7.2 PC with the relevant rpm listed below. I know what to do when the db is reachable, but can't start: the instruction: $conn=odbc_connect(db9,,); just yelds this result: Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in one.php on line 20 Warning: Supplied argument is not a valid ODBC-Link resource in one.php on line 22 THis is certainly something wrong with my odbc setup, but can't figure it out. I saw a thread couple of days ago about myodbc dsn creation, but can't relate it to my problem. Actually, I only have odbcinst, not the commands mentioned in that message. Any help is appreciated! Thanks, mweb RPM list php-ldap-4.0.6-7 unixODBC-devel-2.0.7-3 mod_auth_mysql-1.11-1 mysqlclient9-3.23.22-6 php-mysql-4.0.6-7 unixODBC-2.0.7-3 asp2php-0.75.17-1 php-imap-4.0.6-7 php-pgsql-4.0.6-7 mysql-3.23.41-1 MyODBC-2.50.37-2 mysql-server-3.23.41-1 php-manual-4.0.6-7 php-odbc-4.0.6-7 libodbc++-0.2.2pre4-12 php-4.0.6-7 mysql-devel-3.23.41-1 perl-DBD-MySQL-1.2216-4 -- PHP General 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 General 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]
RE: [PHP] odbc with access on win2k
Paul, Use a System DSN. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Paul Roberts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 1:48 PM To: [EMAIL PROTECTED] Subject: [PHP] odbc with access on win2k I just installed win2k to dual boot with 98 while I change over os's, I have a script that connects to an access 97 DB via odbc_connect, it works fine under win 98 but gives an error that it can't connect on win2000.(error follows) any ideas what I'm doing wrong, I have set up user and file dsn on the odbc applet. Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\my documents\\links\hs~links.php on line 48 thanks in advance. Paul Roberts [EMAIL PROTECTED] -- PHP General 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 General 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]
RE: [PHP] Setting up PHP and ODBC on Linux
Mweb, The iODBC site is back up; I recommend downloading the iODBC SDK and using that. I apologize for the inconvenience; we had a power station fire in the neighborhood! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: mweb [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 17, 2001 6:09 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP] Setting up PHP and ODBC on Linux Hello, as you may remember, some day ago, I asked how to develop on linux PHP pages accessing Mysql via ODBC (The reasons why I *have* to cope with this exact sub optimal set up are in the original message, no reason to repeat them here). I have installed all the UnixODBC rpms I could find ( I have RH 7.1); the iodbc packages on the openlinksw were not accessible. Now I have the following packages installed: [root@ari mweb] rpm -qa|egrep -i 'php|odbc|sql' php-4.0.4pl1-9 php-manual-4.0.4pl1-9 mysql-server-3.23.36-1 MyODBC-2.50.39-1 unixODBC-devel-2.0.7-1 asp2php-0.75.11-1 mysql-3.23.36-1 mysql-devel-3.23.36-1 php-mysql-4.0.4pl1-9 unixODBC-2.0.7-1 unixODBC-generic-2.0.7-1 mysqlclient9-3.23.22-4 unixODBC-mysql-2.0.7-1 However, I currently have PHP set up as pasted below (from phpinfo): that means I have to recompile it from scratch, doesn't it? If so, with which options? Is it enough to change --without-mysql to --with-mysql and add --with-odbc? Also, is it safer/worst/irrelevant/mandatory to erase the php rpm package before building it again from source? TIA, mweb './configure' '--prefix=/usr' '--with-config-file-path=/etc' '--disable-debug' '--enable-pic' '--enable-shared' '--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs' '--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext' '--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2' '--with-db3' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp' '--enable-wddx' '--without-mysql' '--without-oracle' '--without-oci8' '--with-xml' -- If you have the right attitude, interesting problems will find you Eric S. Raymond, The Cathedral and the bazaar, chapter 2 -- PHP General 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 General 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]
RE: [PHP] Desperate: odbc_connect() does not work! Please help!
Simon, You may use the 91b driver against a 91c database, connecting in sockets, or you may use the 91 object file we ship and relink it against your 91c installation to produce a shared-memory version. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 3:12 AM To: '[EMAIL PROTECTED]'; Kraa de Simon; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! I checked openlinksw and the driver for Progress 9.1b is indeed available... (for client is Linux glibc2.1 (x86) and server is UnixWare 7 (x86)) ...but we are on Progress 9.1c. When will the Progress 9.1c driver for this client/server config be available? Regards, Simon. -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 21:32 To: Kraa de Simon; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Kraa, Sorry for the confusion; we should have that component available by the end of the week. Best regards, Andrew -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 2:50 PM To: '[EMAIL PROTECTED]'; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Hi, The problem is that a Progress 9.1c is not available at openlinksw.com for: Client: Linux glibc2.1 (x86) Server: UnixWare 7 (x86) Only Progress 8.3b is supported. So you are saying that a setting in the .ini files or some environment variable could be missing. I will have a look at it. Thanks, Simon. -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 20:25 To: Kraa de Simon; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Kraa, I'm not sure why the two sample apps are using different connection calls; It's not terribly relevant - both are legal. Driver manager and driver are not typically dependent on each other, no. The fact that the connection fails in odbctest is probably due to a missing parameter that iODBC wants in the DSN or the environment variables. You can look at error messages for the Merant driver - I'm not going to get into debugging it :) If you want to try OpenLink's ODBC drivers, you will find they work fine with PHP and Progress. I suggest you download the Multi-Tier driver from our site - they comes free with a 2 user connection. I would also suggest that you compile --with-iodbc, as it is in greater use and has been more thoroughly tested with PHP. Free support is available as well if you have difficulties, at: http://www.openlinksw.com/support/suppindx.htm. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 1:59 PM To: '[EMAIL PROTECTED]'; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Hi Andrew, I'm using the Merant DataDirect 3.6 Progress SQL92 ODBC drivers and they seem to be working fine when I try their test C program. I can connect to the Progress database en retrieve data. I'm using their driver manager as well (--with-custom-odbc). The test C program uses: SQLConnect (hdbc, driver, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS); SQLConnect is executed without problems. A connection can be made. When I try odbctest (from iODBC / odbcsdk) the connect fails (same drivers, same odbc.ini, same odbcinst.ini). SQLDriverConnect (hdbc, 0, (UCHAR *) dataSource, SQL_NTS, (UCHAR *) buf, sizeof (buf), buflen, SQL_DRIVER_COMPLETE); SQLDriverConnect returns -1. A connection cannot be made. Why is the first program using SQLConnect() and the other SQLDriverConnect()? Are ODBC driver and ODBC driver manager dependent on each other? Or can I use the iODBC driver manager and the Merant ODBC drivers together? Are there alternatives to the Merant ODBC drivers? I am connect a Progress 9.1c database on SCO UnixWare 7.1.1 from Red Hat Linux 7.1 with Merant DataDirect 3.6 Progress SQL92 ODBC drivers and ODBC driver manager. Any ideas? Regards
RE: [PHP] Anyone knows how to prevent nonACSII chars convertion with MSSQL?
Tomaz, In spite of your ODBC adversion it may be your best bet :) One related option - OpenLink has a FreeTDS based driver available that you may wish to try. Please let me know if you require assistance. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Tomaz Kovacic [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 6:32 AM To: [EMAIL PROTECTED] Subject: [PHP] Anyone knows how to prevent nonACSII chars convertion with MSSQL? Hi! Anyone knows how to prevent anoying convertion of nonACSII characters when MSSQL Server stores data in database? I know, that when I use ODBC there is no problem with conversion, but I'd like to avoid using ODBC connection if possible. Tomaz -- PHP General 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 General 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]
RE: [PHP] newbie question about odbc_connect
Johannnes, To enable ODBC support in PHP on Linux, configure --with-iodbc per the HOWTO at www.iodbc.org. This will link PHP against an ODBC Driver Manager, but you will still require an ODBC Driver. If you cannot obtain an ODBC driver for FMPro for Linux, you can use the OpenLink Multi-Tier ODBC Driver and piggyback it on the FMPro DSN on the server. eg: 1. create a DSN on the FMPro server (I assume either Windows or Mac OS X?) that we'll call foo for this example. 2. install the OpenLink Multi-Tier driver with Linux as your client, and FMPro box as server. Ensure that you install the ODBC agent on your server platform (this is a non-database specific database agent). 3. create a DSN on your Linux box, specifying ServerType = ODBC, Hostname = [FMPro server IP address], Database = foo All other parameters should be self-explanatory. Note - you may also use the above method to piggyback a Linux ODBC DSN onto a local or remote JDBC Driver instead of an ODBC driver; let me know if you require assistance. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Johannes Ambrose [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 7:22 PM To: [EMAIL PROTECTED] Subject: [PHP] newbie question about odbc_connect Hi, I've been happily using mysql_connect() for various scripts on a linux box. Now I'd like to connect to a filemaker pro database using odbc_connect(). However, the response I get is Call to undefined function. Do I need to compile odbc support? (I thought it was built in.) Is there an include file somewhere that I need to specifiy? regards -- Johannes Ambrose Computer Systems Manager School of Life Sciences University of Queensland, Brisbane Australia ph: 07 3365 4826 fax:3365 1655 mob: 0401 714 835 -- PHP General 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 General 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]
RE: [PHP] Re: Faking MS Access on MySQL linux box
John, OpenLink's Multi-Tier drivers can get you from Linux to MSAcess on Windows. Mweb, I'd just use ODBC against MySQL for testing. There isn't any way to actually run an Access DB on Linux. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: John Lim [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 10, 2001 12:06 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: Faking MS Access on MySQL linux box Hi Mweb, yes it is overkill, but I don't know any other way to do it unless you want to buy a 3rd party odbc driver for Access on Linux (is there one?) Bye, John Mweb [EMAIL PROTECTED] wrote in message 2000104958.B3706@polaris">news:2000104958.B3706@polaris... John, thanks for the link, but isn't it a bit of overkill in my case? What I need is to write PHP pages which manipulate a MS Access DB via ODBC, because this is what the hosting company makes available (and it's not going to change because of several reasons) So, I am looking for explanation on how to do ONLY the testing of suche pages on a STAND-ALONE Linux box. I want to run some DB engine on it which is accessible through ODBC, so that I can say if my ODBC call was OK here, it will work also when I upload on the NT/IIS server, because the interface is the same. Keep in mind that performance is not an issue here. On the linux PC I would only do testing, and the site on the real server currently has ~4000 visits/month querying a DB with some hundreds of entries. What do you think? mweb On Sat, Nov 10, 2001 13:02:14 at 01:02:14PM +0800, John Lim wrote: See http://php.weblogs.com/adodb_csv ADODB also supports SQL communications through HTTP as a database proxy. In plain English, if you have a FoxPro or Access database that you need to connect to from Unix, you can do so via HTTP (eg. Apache talking to IIS, which talks to a small PHP program [the proxy] that queries the database, packs it into serialized text and sends it back to Apache). PHP client -- Apache IIS -- PHP server -- Database Or if you have to go through a firewall to access your database, this solution allows you to stream SQL queries as HTTP through the firewall. [EMAIL PROTECTED] [EMAIL PROTECTED] wrote in message GMJD1G$[EMAIL PROTECTED]">news:GMJD1G$[EMAIL PROTECTED]... Hello, For reasons not worth discussing here, I have to develop and test on Linux/Apache some PHP pages that will have to access via ODBC a MS Access database on an NT/IIS/PHP server. I would like to do it by writing PHP pages that access via ODBC some mysql or other database on my linux box, in such a way that, if it works there, I just change some general setting, upload the pages and they work for sure on the MS Access thing (something like: ifdef LINUX then ODBC_ACCESSES_MYSQL ifdef NTthen ODBC_ACCESSES_MS_Access) I am sure that this must be possible, but would really appreciate some examples/pointers to specific tutorial/similar stories/etc. TIA, mweb -- PHP General 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] -- Never let your sense of morals prevent you from doing what is right Salvor Hardin , Foundation -- PHP General 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 General 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]
RE: [PHP] Desperate: odbc_connect() does not work! Please help!
Kraa, The 01000 error is a 'General Error', probably at connect time. This suggest that your DSN settings might be bad or not being passed into PHP. Is your DSN named results and is that the one you are using in your tests? Also, are you setting your environment variables as appropriate? e.g.: setenv(ODBCINI=/path/to/odbc.ini); setenv(LD_LIBRARY_PATH=/path/to/your/driver/manager/lib); You may also which to try this connection with odbctest, a sample application available in the iODBC SDK at www.iodbc.org. HTH! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 8:44 AM To: Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! So desperate I even forgot the attachment... -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 14:40 To: Php-General (E-mail) Subject: [PHP] Desperate: odbc_connect() does not work! Please help! Hi, When I execute: ? odbc_pconnect(results, sysprogress, mls); ? I get error: Warning: SQL error: , SQL state 01000 in SQLConnect in /usr/local/apache/htdocs/odbc.php on line 1 See attachment for phpinfo(). BTW 1 The ODBC config itself works fine. I can make a connection and retrieve data from the database using a test C program. BTW 2 I used --with-custom-odbc and set env var CUSTOM_ODBC_LIBS to the lib dirs and env var CFLAGS to the include dirs. Met vriendelijke groet / With kind regards, ICL Nederland B.V. Simon de Kraa e-Applications / Logistic Systems Systems Architect Het Kwadrant 1 Tel. +31 346 598865 Postbus 4000Fax +31 346 562703 3600 KA MAARSSEN The Netherlands mailto:[EMAIL PROTECTED] --- Progress 9.1c, Roundtable 9.1c, NuSphere Pro Advantage 2.3.1 @ MS Windows 2000 5.00.2195 SP 2 Progress 9.1b @ SCO UnixWare 7.1.1 -- PHP General 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 General 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]
RE: [PHP] Desperate: odbc_connect() does not work! Please help!
Kraa, I'm not sure why the two sample apps are using different connection calls; It's not terribly relevant - both are legal. Driver manager and driver are not typically dependent on each other, no. The fact that the connection fails in odbctest is probably due to a missing parameter that iODBC wants in the DSN or the environment variables. You can look at error messages for the Merant driver - I'm not going to get into debugging it :) If you want to try OpenLink's ODBC drivers, you will find they work fine with PHP and Progress. I suggest you download the Multi-Tier driver from our site - they comes free with a 2 user connection. I would also suggest that you compile --with-iodbc, as it is in greater use and has been more thoroughly tested with PHP. Free support is available as well if you have difficulties, at: http://www.openlinksw.com/support/suppindx.htm. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 1:59 PM To: '[EMAIL PROTECTED]'; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Hi Andrew, I'm using the Merant DataDirect 3.6 Progress SQL92 ODBC drivers and they seem to be working fine when I try their test C program. I can connect to the Progress database en retrieve data. I'm using their driver manager as well (--with-custom-odbc). The test C program uses: SQLConnect (hdbc, driver, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS); SQLConnect is executed without problems. A connection can be made. When I try odbctest (from iODBC / odbcsdk) the connect fails (same drivers, same odbc.ini, same odbcinst.ini). SQLDriverConnect (hdbc, 0, (UCHAR *) dataSource, SQL_NTS, (UCHAR *) buf, sizeof (buf), buflen, SQL_DRIVER_COMPLETE); SQLDriverConnect returns -1. A connection cannot be made. Why is the first program using SQLConnect() and the other SQLDriverConnect()? Are ODBC driver and ODBC driver manager dependent on each other? Or can I use the iODBC driver manager and the Merant ODBC drivers together? Are there alternatives to the Merant ODBC drivers? I am connect a Progress 9.1c database on SCO UnixWare 7.1.1 from Red Hat Linux 7.1 with Merant DataDirect 3.6 Progress SQL92 ODBC drivers and ODBC driver manager. Any ideas? Regards, Simon. -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 16:12 To: Kraa de Simon; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Kraa, The 01000 error is a 'General Error', probably at connect time. This suggest that your DSN settings might be bad or not being passed into PHP. Is your DSN named results and is that the one you are using in your tests? Also, are you setting your environment variables as appropriate? e.g.: setenv(ODBCINI=/path/to/odbc.ini); setenv(LD_LIBRARY_PATH=/path/to/your/driver/manager/lib); You may also which to try this connection with odbctest, a sample application available in the iODBC SDK at www.iodbc.org. HTH! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 8:44 AM To: Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! So desperate I even forgot the attachment... -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 14:40 To: Php-General (E-mail) Subject: [PHP] Desperate: odbc_connect() does not work! Please help! Hi, When I execute: ? odbc_pconnect(results, sysprogress, mls); ? I get error: Warning: SQL error: , SQL state 01000 in SQLConnect in /usr/local/apache/htdocs/odbc.php on line 1 See attachment for phpinfo(). BTW 1 The ODBC config itself works fine. I can make a connection and retrieve data from the database using a test C program. BTW 2 I used --with-custom-odbc and set env var CUSTOM_ODBC_LIBS to the lib dirs and env var CFLAGS to the include dirs. Met vriendelijke groet / With kind regards, ICL Nederland B.V. Simon de Kraa e-Applications / Logistic Systems Systems Architect Het Kwadrant 1 Tel. +31 346 598865 Postbus 4000Fax +31 346 562703 3600 KA MAARSSEN The Netherlands mailto:[EMAIL PROTECTED] --- Progress 9.1c, Roundtable 9.1c, NuSphere Pro Advantage
RE: [PHP] Desperate: odbc_connect() does not work! Please help!
Kraa, Sorry for the confusion; we should have that component available by the end of the week. Best regards, Andrew -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 2:50 PM To: '[EMAIL PROTECTED]'; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Hi, The problem is that a Progress 9.1c is not available at openlinksw.com for: Client: Linux glibc2.1 (x86) Server: UnixWare 7 (x86) Only Progress 8.3b is supported. So you are saying that a setting in the .ini files or some environment variable could be missing. I will have a look at it. Thanks, Simon. -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 20:25 To: Kraa de Simon; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Kraa, I'm not sure why the two sample apps are using different connection calls; It's not terribly relevant - both are legal. Driver manager and driver are not typically dependent on each other, no. The fact that the connection fails in odbctest is probably due to a missing parameter that iODBC wants in the DSN or the environment variables. You can look at error messages for the Merant driver - I'm not going to get into debugging it :) If you want to try OpenLink's ODBC drivers, you will find they work fine with PHP and Progress. I suggest you download the Multi-Tier driver from our site - they comes free with a 2 user connection. I would also suggest that you compile --with-iodbc, as it is in greater use and has been more thoroughly tested with PHP. Free support is available as well if you have difficulties, at: http://www.openlinksw.com/support/suppindx.htm. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 1:59 PM To: '[EMAIL PROTECTED]'; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Hi Andrew, I'm using the Merant DataDirect 3.6 Progress SQL92 ODBC drivers and they seem to be working fine when I try their test C program. I can connect to the Progress database en retrieve data. I'm using their driver manager as well (--with-custom-odbc). The test C program uses: SQLConnect (hdbc, driver, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS); SQLConnect is executed without problems. A connection can be made. When I try odbctest (from iODBC / odbcsdk) the connect fails (same drivers, same odbc.ini, same odbcinst.ini). SQLDriverConnect (hdbc, 0, (UCHAR *) dataSource, SQL_NTS, (UCHAR *) buf, sizeof (buf), buflen, SQL_DRIVER_COMPLETE); SQLDriverConnect returns -1. A connection cannot be made. Why is the first program using SQLConnect() and the other SQLDriverConnect()? Are ODBC driver and ODBC driver manager dependent on each other? Or can I use the iODBC driver manager and the Merant ODBC drivers together? Are there alternatives to the Merant ODBC drivers? I am connect a Progress 9.1c database on SCO UnixWare 7.1.1 from Red Hat Linux 7.1 with Merant DataDirect 3.6 Progress SQL92 ODBC drivers and ODBC driver manager. Any ideas? Regards, Simon. -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: woensdag 31 oktober 2001 16:12 To: Kraa de Simon; Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! Kraa, The 01000 error is a 'General Error', probably at connect time. This suggest that your DSN settings might be bad or not being passed into PHP. Is your DSN named results and is that the one you are using in your tests? Also, are you setting your environment variables as appropriate? e.g.: setenv(ODBCINI=/path/to/odbc.ini); setenv(LD_LIBRARY_PATH=/path/to/your/driver/manager/lib); You may also which to try this connection with odbctest, a sample application available in the iODBC SDK at www.iodbc.org. HTH! Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 8:44 AM To: Php-General (E-mail) Subject: RE: [PHP] Desperate: odbc_connect() does not work! Please help! So desperate I even forgot the attachment... -Original Message- From: Kraa
RE: [PHP] Installing ODBC
Hi, You should compile --with-iodbc pointing to the odbcsdk directory, not just the libiodbc file. The SDK is available at www.iodbc.org. You will also need your LD_LIBRARY_PATH varible set to include the directory where libiodbc is. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: webmaster uva [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 12:53 PM To: php Subject: [PHP] Installing ODBC Hello, I have problems compiling libiodbc-3.0.5 I have tried to compile being root and being a normal user and I get the same error. I execute $ ./configure --prefix=/usr/local --exec-prefix=/usr/local --with-iodbc-inidir=/etc --build=i686 and it works properly (I think) when I execute $ make I get the next error. *** Warning: inter-library dependencies are not known to be supported. *** All declared inter-library dependencies are being dropped. *** The inter-library dependencies that have been dropped here will be *** automatically added whenever a program is linked with this library *** or is declared to -dlopen it. gcc -shared catalog.lo connect.lo dlf.lo dlproc.lo execute.lo fetch.lo hdbc.lo henv.lo herr.lo hstmt.lo info.lo itrace.lo misc.lo prepare.lo result.lo odbc3.lo -Wl,-soname -Wl, -Wl,-retain-symbols-file -Wl,./iodbc.exp -o .libs/ /usr/i386-slackware-linux/bin/ld: cannot open output file .libs/: Is a directory collect2: ld returned 1 exit status gmake[1]: *** [libiodbc.la] Error 1 gmake[1]: Leaving directory `/opt/src/libiodbc-3.0.5/iodbc' gmake: *** [all-recursive] Error 1 Please, could you help me? I am trying to install it on a linux machine. I am trying to connect that linux machine with Apache and PHP with a Windows NT with SQL-Server. Would I need any other software on the Linux or the NT machines? Thanks Regards. Félix García Renedo mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Tfn: 983-423000 Ext. 26520 Fax: 983-423271 Centro de Telecomunicaciones e Informatica Universidad de Valladolid España -- PHP General 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]
RE: [PHP] Microsoft Access
Alex, You can access MS Access via ODBC, but you do need a Windows box (and Access) to serve the .mbd file. It's possible to connect from BSD to Windows using ODBC - OpenLink's Multi-Tier drivers can affect this connection for you, and can be downloaded for free. Let me know if you need any assistance. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Alex Shi [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 8:56 PM To: [EMAIL PROTECTED] Subject: [PHP] Microsoft Access Hi Folks, Does any one here know how to access MS Access file in PHP? And is it possible to do it on a platform other than Window NT/2K, such as Linux or FreeBSD? Alex -- PHP General 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 General 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]
RE: [PHP] php/Oracle db connection
Toni, You need to enter a string of the syntax: DSN=[name of your dsn] Since nothing shows up with a ? I bet you haven't set your ODBCINI environment variables. Running the openlink.sh against the current shell should do this: . openlink.sh If you are doing it by hand, you need to set: ODBCINI (pointing to the odbc.ini) ODBCINSTINI (pointitng to the odbcinst.ini) LD_LIBARARY_PATH (pointing to the lib directory that contains the libiodbc.so file) DSNs need to be configured in the odbc.ini Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: toni baker [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 11:11 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] php/Oracle db connection When I run odbctest I get the following prompt: OpenLink ODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): ? DSN| Description --- Enter ODBC connect string (? shows list): What ODBC connet string should I enter here? Thanks Toni. --- Andrew Hill [EMAIL PROTECTED] wrote: Toni, Note the Unknown host. Check your odbc.ini for the Host field of the DSN you are using. Ensure it's resolvable. Try an IP address instead maybe. Also, set the variables in the environment and see if your DSN works in odbctest without PHP in the mix. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: toni baker [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 4:56 PM To: [EMAIL PROTECTED] Subject: [PHP] php/Oracle db connection I have successfully compiled php with linked iODBC driver manager as an Apache shared module. However when trying to connect php to the Oracle database I get an error. The error and the sample connection code is below. Warning: SQL error: [OpenLink][ODBC]RPC: Unknown host, SQL state 08004 in SQLConnect in /home/httpd/html/ronsdev/putenv.php on line 9 can not connect to DSN: data1.tsl.state.tx.us ? putenv(LD_LIBRARY_PATH=/usr/local/src/odbcsdk/lib); putenv(ODBCINSTINI=/usr/local/src/bin/odbcinst.ini); putenv(ODBCINI=/usr/local/src/bin/odbc.ini); $dsn=data1.tsl.state.tx.us; $user=scott; $password=tiger; $sql=SELECT * FROM scott.emp; if($conn_id=odbc_connect($dsn,,)) { echo connected to DSN: $dsn; if($result=odbc_do($conn_id, $sql)) { echo executing '$sql'; echo Results: ; odbc_result_all($result); echo freeing result; odbc_free_result($result); } else { echo can not execute '$sql'; } echo closing connection $conn_id; odbc_close($conn_id); } else { echo can not connect to DSN: $dsn; } ? Can someone help with this? Thanks Toni __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- PHP General 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 General 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] __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- PHP General 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 General 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]
RE: [PHP] php/Oracle db connection
Toni, Note the Unknown host. Check your odbc.ini for the Host field of the DSN you are using. Ensure it's resolvable. Try an IP address instead maybe. Also, set the variables in the environment and see if your DSN works in odbctest without PHP in the mix. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: toni baker [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 4:56 PM To: [EMAIL PROTECTED] Subject: [PHP] php/Oracle db connection I have successfully compiled php with linked iODBC driver manager as an Apache shared module. However when trying to connect php to the Oracle database I get an error. The error and the sample connection code is below. Warning: SQL error: [OpenLink][ODBC]RPC: Unknown host, SQL state 08004 in SQLConnect in /home/httpd/html/ronsdev/putenv.php on line 9 can not connect to DSN: data1.tsl.state.tx.us ? putenv(LD_LIBRARY_PATH=/usr/local/src/odbcsdk/lib); putenv(ODBCINSTINI=/usr/local/src/bin/odbcinst.ini); putenv(ODBCINI=/usr/local/src/bin/odbc.ini); $dsn=data1.tsl.state.tx.us; $user=scott; $password=tiger; $sql=SELECT * FROM scott.emp; if($conn_id=odbc_connect($dsn,,)) { echo connected to DSN: $dsn; if($result=odbc_do($conn_id, $sql)) { echo executing '$sql'; echo Results: ; odbc_result_all($result); echo freeing result; odbc_free_result($result); } else { echo can not execute '$sql'; } echo closing connection $conn_id; odbc_close($conn_id); } else { echo can not connect to DSN: $dsn; } ? Can someone help with this? Thanks Toni __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- PHP General 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 General 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]
RE: [PHP] Re: Submitting variables via /'s
Note, this is not currently possible under the CGI, only as a module. Best regards, Andrew Hill -Original Message- From: John A. Grant [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 4:04 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: Submitting variables via /'s Ashley M. Kirchner [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I want to move away from file.php?var1=1var2=2var3=3 ...and go to file.php/1/2/3 [...] Why? What's wrong with ?var1=1var2=2 -- John A. Grant * I speak only for myself * (remove 'z' to reply) Radiation Geophysics, Geological Survey of Canada, Ottawa If you followup, please do NOT e-mail me a copy: I will read it here -- PHP General 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 General 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]
RE: [PHP] XML works like a DataBase?
Augusto, Regardless if you CAN do this, I recommend against it :) Relational Databases are much better for storing, updating, and accessing disparate information than XML. XML should be used for communication between applications or for an intermediary output format from relational data. If you do need XML, then convert from relational data to XML on the fly. There are several ways to do this. An easy one is our database: Virtuoso You can download it for free at http://www.openlinksw.com/virtuoso Hope this helps. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Augusto Cesar Castoldi [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 25, 2001 2:03 PM To: [EMAIL PROTECTED] Subject: [PHP] XML works like a DataBase? Hi. I've been looking for XML, and I'd like to know if you know if with the XML funtions of PHP I can create a XML file, add and remove data just, or almost equal of I do with MySQL. regards, Augusto __ _ Yahoo! GeoCities Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis! http://br.geocities.yahoo.com/ -- PHP General 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 General 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]
RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle
Jeffrey, Ensure your ORACLE_SID is also set. This is a case of Oracle environment variables. Log in as the oracle user and look at the output of an 'env'. You are missing something there. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Jeffrey Iskandar Ahmad [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 1:04 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle I have reinstalled but still cannot work. How i compile: ./configure --with-mysql --with-apxs=/usr/local/apache/bin/apxs \ --with-ldap=/home/jeffrey/download/directory/install --with-oci8=/home/oracl e Apache server stop and started. Im using redhat 7. Oracle 8i installed as programmer, apache_1.3.14. Remote oracle server version is 8.0.5 My bash env as below: ORACLE_HOME=/home/oracle TNS_ADMIN=$ORACLE_HOME/network/admin PATH=$PATH:$ORACLE_HOME/bin:/usr/bin:/bin LD_LIBRARY_PATH=$ORACLE_HOME/lib ORA_NLS33=/home/oracle/ocommon/nls/admin/data my php content: putenv('TNS_ADMIN=/home/oracle/network/admin'); putenv(ORACLE_HOME=/home/oracle); $db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = patin)(PORT = 1521)) ) (CONNECT_DATA = (SID = I32) ) ); $c1 = ocilogon(ims,ims,$db); if ($c1 == false){ echo OCIError($c1).; } else { echo success; } I still get the same error OCISessionBegin: Error while trying to retrieve text for error ORA-03106 meening : fatal two-task communication protocol error) I have tested using sqlplus(same php server) connect to remote server, there is no problem. Do you have sample configuration how to do it.. please.. :) Jeffrey Iskandar Ahmad System Engineer Technology Division TIME dotNet -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 11:31 PM To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED] Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle Ensure that this is sent in the envrionment before compiling php and starting apache as well. Cheers, Andrew -Original Message- From: Jeffrey Iskandar Ahmad [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 11:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle I did but didnt work. Jeffrey Iskandar Ahmad System Engineer Technology Division TIME dotNet -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:09 PM To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED] Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle Jeffrey, Set your ORACLE_HOME environment variable. putenv(ORACLE_HOME=/path/to/oracle/home/dir); etc. HTH Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Jeffrey Iskandar Ahmad [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 5:47 AM To: [EMAIL PROTECTED] Subject: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle I cannot connect to remote oracle database. I get the error below. OCISessionBegin: Error while trying to retrieve text for error ORA-03106 (meening : fatal two-task communication protocol error) My env is all correct. My test.php: $db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = patin)(PORT = 1521)) ) (CONNECT_DATA = (SID = I32) ) ); $c1 = ocilogon(ims,ims,$db); if ($c1 == false){ echo OCIError($c1).; exit; } else { echo success; } Jeffrey Iskandar Ahmad System Engineer Technology Division TIME dotNet -- PHP General 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 General 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 General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED
RE: [PHP] Progress database
Richard, Regarding Progress, you are probably going to come back to ODBC :) When you do, feel free to give our drivers a try. You will be pleasantly surprised. Let me know if I can help in any way. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Meredith-Wilks, Richard [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 8:22 AM To: [EMAIL PROTECTED] Subject: [PHP] Progress database Help, Can anyone help me ? I have a progress database running and require PHP to read and write to it. We have looked at ODBC and would like to avoid that if possible. Richard -- PHP General 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 General 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]
RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle
Jeffrey, Set your ORACLE_HOME environment variable. putenv(ORACLE_HOME=/path/to/oracle/home/dir); etc. HTH Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Jeffrey Iskandar Ahmad [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 5:47 AM To: [EMAIL PROTECTED] Subject: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle I cannot connect to remote oracle database. I get the error below. OCISessionBegin: Error while trying to retrieve text for error ORA-03106 (meening : fatal two-task communication protocol error) My env is all correct. My test.php: $db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = patin)(PORT = 1521)) ) (CONNECT_DATA = (SID = I32) ) ); $c1 = ocilogon(ims,ims,$db); if ($c1 == false){ echo OCIError($c1).; exit; } else { echo success; } Jeffrey Iskandar Ahmad System Engineer Technology Division TIME dotNet -- PHP General 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 General 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]
RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle
Ensure that this is sent in the envrionment before compiling php and starting apache as well. Cheers, Andrew -Original Message- From: Jeffrey Iskandar Ahmad [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 11:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle I did but didnt work. Jeffrey Iskandar Ahmad System Engineer Technology Division TIME dotNet -Original Message- From: Andrew Hill [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:09 PM To: Jeffrey Iskandar Ahmad; [EMAIL PROTECTED] Subject: RE: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle Jeffrey, Set your ORACLE_HOME environment variable. putenv(ORACLE_HOME=/path/to/oracle/home/dir); etc. HTH Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Jeffrey Iskandar Ahmad [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 5:47 AM To: [EMAIL PROTECTED] Subject: [PHP] installing PHP with-apxs with-oci8 --with-oracle onLinux - remote oracle I cannot connect to remote oracle database. I get the error below. OCISessionBegin: Error while trying to retrieve text for error ORA-03106 (meening : fatal two-task communication protocol error) My env is all correct. My test.php: $db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = patin)(PORT = 1521)) ) (CONNECT_DATA = (SID = I32) ) ); $c1 = ocilogon(ims,ims,$db); if ($c1 == false){ echo OCIError($c1).; exit; } else { echo success; } Jeffrey Iskandar Ahmad System Engineer Technology Division TIME dotNet -- PHP General 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 General 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 General 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]
Re: [PHP] Help a newbie?
Apache is my vote. And change your system date, please - it's messing with my inbox sort :) Cheers, Andrew Hill OpenLink Software On Sunday, August 2, 1998, at 03:14 AM, Peter Gibson wrote: Hi! Simple question... Should I use IIS (5.0) or apache for development of PHP before I upload it? -- PHP General 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]
RE: [PHP] PHP + FreeBSD + ODBC -- Progress Database
Joseph, It does appear you have iODBC compiled in already. To confirm for this do a find for libiodbc.so. Yes, you do need iODBC here to act as the Driver Manager (a binding point so PHP can interface with ODBC) but you will still need an actual ODBC driver. Try the Multi-Tier driver from our site - the Product Availabilty link will walk you through the selection process. You will need to install the MT client components on your BSD box and the MT server components on your Win box. The drivers will download for free with a non-expiring 2-connection license, and free support is available at http://www.openlinksw.com/support/suppindx.htm if you require assistance configuring your connection. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Joseph Koenig [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 10:02 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP + FreeBSD + ODBC -- Progress Database This is probably a really stupid question. I've been reading info on phpbuilder and at iodbc.org and I must just be missing something. What I want to do is connect to a Progress Database on WinNT from a FreeBSD 4.3 server with PHP 4.0.6. Before I compiled PHP, I was under the impression I needed iodbc. On my PHP info page, it shows this configure line: './configure' '--with-mysql=/usr/local/mysql' '--with-pgsql=/usr/local/pgsql' '--enable-trans-sid' '--with-curl=/usr/local/bin/curl' '--enable-ftp' '--enable-magic-quotes' '--with-apxs=/usr/local/sbin/apxs' However, as I scroll down the page, I find this info: odbc ODBC Support enabled Active Persistent Links 0 Active Links 0 ODBC library iodbc ODBC_INCLUDE -I/usr/local/include ODBC_LFLAGS -L/usr/local/lib ODBC_LIBS -liodbc Directive Local Value Master Value odbc.allow_persistent On On odbc.check_persistent On On odbc.default_db no value no value odbc.default_pw no value no value odbc.default_user no value no value odbc.defaultbinmode return as is return as is odbc.defaultlrl return up to 4096 bytes return up to 4096 bytes odbc.max_linksUnlimited Unlimited odbc.max_persistent Unlimited Unlimited Now, to me that looks like I could theoretically do what I want to, correct? Any help with PHP + ODBC on FreeBSD would be much appreciated. Thanks, Joe -- PHP General 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 General 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]
Re: [PHP] Dynamic Form
Here is my take on it, cobbled together with the help of a js wizard friend of mine: ?php include(config.inc.php); //config contains database connection params ? html head titleDynamic Dropdown Menus/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 script language=JavaScript !-- //array of arrays of select options corresponding to //the values in the static menu. var menus = new Array(); ?php //get set of names of level 1 categories $sql=select parent_cat from site_map where site_level = 1; $link_id = mysql_connect($host, $usr, $pass) or die (mysql_error()); mysql_select_db($database, $link_id); //select database catalog $parent_cat_result = mysql_query($sql, $link_id) or die (mysql_error()); //return result set to php $parent_cat_count = mysql_num_rows($parent_cat_result); //build a option list for js function //currently this echoes a number for the menu - must be replaced with parent cat. $i=0; //start menus[] at zero while (list ($current_parent) = mysql_fetch_row ($parent_cat_result)) { //debug//echo current parent is $current_parentbr; $sql=select link_show, child_cat from site_map where parent_cat = \$current_parent\; $link_id = mysql_connect($host, $usr, $pass) or die (mysql_error()); mysql_select_db($database, $link_id); //select database catalog $child_cat_result = mysql_query($sql, $link_id) or die (mysql_error()); //return result set to php echomenus[$i]=new Array( \n; $i++; $child_cat_count=mysql_num_rows($child_cat_result); $cc=0; while (list ($link_show, $child_cat) = mysql_fetch_row ($child_cat_result)) { echonew Option(\$link_show\, '$child_cat') ; $cc++; if ($cc $child_cat_count) { echo , \n; } else{ echo \n; } } echo); \n; } ? Best regards, Andrew On Wednesday, September 12, 2001, at 06:59 PM, Jared Mashburn wrote: I have tried using onChange in my script but have faild to load the values of the first drop-down list. Can I place an array inside an array. Or is there a better way of doing this? -Original Message- From: Jason Bell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 4:47 PM To: Jared Mashburn; PHP Users Subject: Re: [PHP] Dynamic Form PHP does not know what the user has selected in the first drop down. You can either reload the page with the new value once the user has selected the value for the first drop down list, and go from there, or use Javascript. - Original Message - From: Jared Mashburn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 12, 2001 3:45 PM Subject: [PHP] Dynamic Form Hell0, I have a MySql database with 3 columns. The first column is id second is name and third is value, I have two drop-down lists, with the first filled with an array from the column name. I would like for the second drop-down list be changed according to the value of what has been selected in the first drop-down list. I have fill that I'm going in the right direction, but have run into a wall. Can anyone give me some advice in doing this miraculous feat? Thanks, Jared -- PHP General 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 General 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 General 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 General 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]
RE: [PHP] HELP!!!
Boris, Compiling with ODBC translates to linking with an ODBC Driver Manager. An Open Source Driver Manager is iODBC - www.iodbc.org There is also a HOWTO on the site for PHP compiling --with-iodbc. You will still need a driver for your ASA, but it appears you have this. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Boris [mailto:[EMAIL PROTECTED]] Sent: Monday, September 10, 2001 4:01 AM To: [EMAIL PROTECTED] Subject: [PHP] HELP!!! I installed Red Hat 7 as server and get Apache and Php installed with that. I have connect from my new Linux box (with dbisqlc) to ASA 7 database what is on one Windows server and thats works fine. My Apache also works fine with Php only problem is when I try to use odbc_connect() or some other odbc funkctions I get Fatal error: Call to undefined function: odbc_connect() in I think my php is not compiled with odbc and I don't no how to do that. Please help! Best regards Boris -- PHP General 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 General 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]
RE: [PHP] iODBC support (--with-iodbc[=DIR])
Simon, The HOWTO on www.iodbc.org walks through the steps with links to specific file downloads. As far as what libc version you need, do the following on your RedHat box: rpm -qa |grep libc the latest version number that shows up is what you need compatibility for. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Kraa de Simon [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 04, 2001 7:52 AM To: Php-General (E-mail) Subject: [PHP] iODBC support (--with-iodbc[=DIR]) Hi, I'd like to configure the iODBC support (--with-iodbc[=DIR]) On http://www.iodbc.org I can choose between 'iODBC Driver Manager' and 'OpenLink iODBC SDK binaries'. When I choose 'iODBC Driver Manager' I see the following options: - iODBC Driver Manager Administrator SOURCE Release V3.0.5 - iODBC RPM Packaging Source Files - iODBC Driver Manager Runtime Package (For Linux glibc21) - iODBC RPM Developers Kit (Linux glibc21) - iODBC Administrator (Linux glibc21) And when I choose 'OpenLink iODBC SDK binaries': - Linux libc5 (Intel) - Linux glibc2 (Intel) - Linux glibc2.1.1 (Intel) Can anyone please give me a hint what I need to download? I'm running on Red Hat Linux 7.1 / PHP 4.0.5. [/root] uname -a Linux nt-cpu04 2.4.2-2 #1 Sun Apr 8 19:37:14 EDT 2001 i586 unknown [/root] rpm -q --all | grep glib glibc-common-2.2.2-10 glibc-2.2.2-10 glib-1.2.9-1 glib-devel-1.2.9-1 glibc-devel-2.2.2-10 Thanks!!! Simon. -- PHP General 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 General 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]
RE: [PHP] PHP with Access?
Jeff, No, Access will not run on Linux. Either export the mdb to MySQL format (there is a utility to do this on the MySQL site) or connect from Linux to Windows using ODBC - check the iODBC HowTO at www.iodbc.org for steps to compile PHP --with-iodbc. The reason that ODBC isn't working on Windows is you have not configured your PHP installation to support ODBC :) Either view the install docs to enable the extension: http://www.php.net/manual/en/install-windows.php or upgrade to 4.0.6 or later, which will support ODBC on Windows by default. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Jeff Lewis [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 10:02 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP with Access? I am using mySQL with all of my stuff but a friend who started writing some files for our online baseball league was using Access as his database. We tried running it on my server but it returns an error that says undefined function odbc_connect. Now my questions, can I get this to work on a Linux box? If not, is there a nice way to convert the MDB to mySQL? :) Jeff -- PHP General 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]
RE: [PHP] iODBC Troubles / Troubles in ODBC Land
Jonathan, It looks like you are mixing threaded and non-threaded libraries. I assume PHP is non-threaded here, ensure you are using the non-threaded version of iODBC and check with your MyODBC driver maintainer for a libmyodbc.so that is non-threaded. Also, you may wish to just post these question on the DB list - the cross post to the general list isn't necessary. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 28, 2001 11:26 AM To: [EMAIL PROTECTED] Subject: [PHP] iODBC Troubles I first tried unixODBC in order to get ODBC functionality on my FreeBSD 4.2 box with PHP 4.0.3 on Apache 1.3.14. It didn't work too well, and I kept getting an error about undefined symbols like pthread_mutex_init or something when trying to run command-line sample applications. So someone suggested I use iODBC instead and I responded: Okay, I uninstalled unixODBC and tried iODBC ( I actually began to try it before, but then thought of something that might work on unixODBC, so I went back to it ). Now iODBC's odbctest application works with myODBC installed. However, after I recompile PHP with iodbc parameters, I try to run the odbc_connect function. If I misspell the DSN or use a non-existent one, I will get the following message: Warning: SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in SQLConnect Now, if I spell the defined DSN correctly and reload the page, the application just hangs. If I look at my error logs I see this: /usr/libexec/ld-elf.so.1: /usr/local/lib/libmyodbc.so: Undefined symbol pthread_mutex_init Once for every time I reload the page. This is odd, because this was a problem message I was receiving when testing unixODBC on the command line. After I installed iODBC, the command-line application was able to connect and query perfectly! So what gives? Why does one application work and another does not? I set the following environment vars - some may not make sense, but I've been trying everything: $EnvVars[LD_LIBRARY_PATH] = /usr/local/lib:/usr/include; $EnvVars[LD_RUN_PATH] = /usr/local/lib:/usr/include; $EnvVars[ODBCINI] = /usr/local/src/odbcsdk/doc/odbc.ini; $EnvVars[PATH] = /sbin:/bin:/usr/sbin:/usr/bin:/usr/games:/usr/local/bin:/usr/X11R 6/bin:/hom e/suroot/bin:/usr/libexec:/usr/include; foreach($EnvVars as $Key = $Val) { putenv($Key=$Val); $HTTP_ENV_VARS[$Key] = $Val; } I can see via phpinfo() that they are getting set. Any more ideas? - Jonathan -- PHP General 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 General 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]
Re: [PHP] Use PHP to connect to Oracle 8i database
Toni You don't have to use the OCI libraries if you use ODBC. Compiling PHP --with-iodbc as per the HOWTO at www.iodbc.org will get you started. Non-expiring ODBC drivers with a 2-connection license are available as a free download from http://www.openlinksw.com. Free support is also available if you encounter problems. Best regards, Andrew Hill Director of Technology Evangeslim OpenLink Software http://www.openlinksw.com XML and eBusiness Infrastructure Technology Providers On Monday, August 27, 2001, at 05:04 PM, Joe Conway wrote: I want to use php to connect to an Oracle 8i database. I have 2 questions: 1) does the webserver have to be installed on the database server? No -- you just have to configure your tnsnames.ora so that the web server can connect. Try sqlplus first. If you can connect with sqlplus, you should be able to connect from PHP. 2) do you have to use the OCI libraries? Yes, you do need the oracle client. See http://www.php.net/manual/en/ref.oci8.php for more info. Particularly see the note on pthread. HTH, -- Joe -- PHP General 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 General 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] Archives
Richard, Check out http://marc.theaimsgroup.com The WWW section contains many PHP list archives. I couldn't live without this resource. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Richard Baskett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 9:19 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] PHP Editor I would have had no clue that there was an archive, so it's good to know. Thanks! What tool do you recommend to compose PHP pages? I am traditionaly an ASP developer and I have always used Ultradev and Interdev. Welcome to the club.. If you take a moment to search the archive.. this question has ben answered quite a few times in the last month. Bye, B. -- PHP General 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 General 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]
RE: [PHP] PHP-Linux Sybase-Windows
Veniamin, You can use OpenLink's Multi-Tier ODBC drivers for this. Compile PHP --with-iodbc as per the HOWTO at www.iodbc.org. The presence of the iODBC Driver Manager will let you use any ODBC drivers, and then you can do compariative testing. Our drivers download with a free non-expiring 2-user license, and free support is available at http://www.openlinksw.com/support/suppindx.htm. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Veniamin Goldin [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 02, 2001 6:14 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP-Linux Sybase-Windows Hi ! Wich odbc (and how to set it) is bettet to use to connect to remote Sybase DB server from PHP on Linux? -- PHP General 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]
RE: [PHP] Connecting PHP to SQL Server
Hi, One fairly straightfoward way is to use an ODBC driver. You will want to compile PHP --with-iodbc as per the HOWTO on www.iodbc.org, and then install your ODBC driver of choice. OpenLink supports the Solaris-to-SQLServer architecture with our Multi-Tier drivers, which are available for a free download and come with a non-expiring 2-user license. Free support is also available at http://www.openlinksw.com/support/suppindx.htm should you run into problems. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: webmaster uva [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 7:56 AM To: php Subject: [PHP] Connecting PHP to SQL Server Hello, I have to connect one Solaris computer (Netscape Enterprise Server) with PHP to another one with NT (database SQL Server). I have to get data from the SQL Server database using PHP. Is it possible? How? Thankyou. Regards. Félix García Renedo mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Tfn: 983-423000 Ext. 26520 Fax: 983-423271 Centro de Telecomunicaciones e Informatica Universidad de Valladolid España -- PHP General 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]
RE: [PHP] Apache + Oracle + PHP on HPUX
Hi, You can use OpenLink ODBC drivers, and compile PHP/apache --with-iodbc as per the HOWTO at www.iodbc.org. The HOWTO is Linux-based, but the major different will be environment variables. During the install of OpenLink MT drivers a shell script will be automatically created (openlink.sh, openlink.csh) that will set the appropriate variables for you before you try to compile php and apache. Also, this saves you from installing the Oracle client. Just place the iODBC archive in the same directory as the OpenLink MT drivers, and run the install.sh that comes with the OpenLink drivers. This should get your environment fairly well setup. If you require assistance, free support is available at http://www.openlinksw.com/support/suppindx.htm Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 5:04 AM To: [EMAIL PROTECTED] Subject: [PHP] Apache + Oracle + PHP on HPUX Hi! I've got an HP-UX 10.20 and I would like to install Apache + Oracle + PHP. Does anyone know a place to get an installation guide? Or must I install in the same way as Linux? Regards, - This mail was sent through Eoffice: http://www.eoffice.dk -- PHP General 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 General 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]
Re: [PHP] progress dbi?
Susan, OpenLink has Progress ODBC drivers available. The Multi-Tier Drivers are available for many versions of Progress. The Product Availability link will walk you through the selection process for the components specific to your OS. Regarding ODBC - for PHP to use an ODBC driver, you have to link PHP at compile time to a Driver Manager. This is used in conjunction with ODBC drivers to affect your connection. An open source iODBC Driver Manager is available at www.iodbc.org, as well as a HOWTO on compiling PHP --with-iodbc. The iODBC Driver Manager is maintained by OpenLink, and supports the ODBC 3.5 API and includes a GUI control panel on Mac OS X, Linux, and many Unix platforms. OpenLink's commercial drivers download with a free non-expiring 2 user license. Support is available at http://www.openlinksw.com Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers On Wednesday, July 25, 2001, at 08:47 PM, [EMAIL PROTECTED] wrote: I'm thinking of writing some web aps to interface with a progress database created with Association Plus. I'm wondering if anyone has done this and if it was hard. I'm not certain how to go about understanding this whole ODBC thing ... Susan -- [EMAIL PROTECTED] http://futurebird.diaryland.com -- PHP General 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 General 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]
RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array
Bob, Why doesn't odbc_fetch_into give you what you want? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Bob Horton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 1:23 AM To: [EMAIL PROTECTED] Subject: [PHP] ODBC Function equivalent to MySql_Fetch_Array Hi, I'm trying to write a function (see below) that will provide equivalent functionality between ODBC and MySQL for mysql_fetch_array based upon a preset variable. I've written something that works but A) I'm afraid it might be quite slow; and B) I'm hoping that there is an existing function to do it that I just didn't see! If there isn't an existing function ... how do I go about requesting it for a future release? One of the key things I was looking for was the field names in the associative array (Note: I already had ... and commented out ... the odbc_fetch_into function ... nice but not quite what I was wanting) Thanks. - function db_fetch_array($result) { global $db_type, $db_connection; if ($db_type == 1) : return mysql_fetch_array($result); else: $i = 0; $fCount = odbc_num_fields($result); $result_array = array(); if (odbc_fetch_row($result)) : while ($i $fCount) $i++; $fName = odbc_field_name($result, $i); $result_array[$fName] = odbc_result($result, $i); } // odbc_fetch_into ($conn, $result_array); return $result_array; else: return false; endif; endif; -- PHP General 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 General 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]
RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array
Bob, Perhaps use odbc_field_name or even odbc_specialcolumns with odbc_fetch_into? I do agree that mysql_fetch_array is quite useful. Dan - what do you think? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Bob Horton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 10:39 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array odbc_fetch_into gives me an array but it doesn't give the column names. While many might consider that a small point I find that it helps substantially in making my code self documenting. $row[2] is much less readable than $row[Name] -Original Message- Bob, Why doesn't odbc_fetch_into give you what you want? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- Hi, I'm trying to write a function (see below) that will provide equivalent functionality between ODBC and MySQL for mysql_fetch_array based upon a preset variable. I've written something that works but A) I'm afraid it might be quite slow; and B) I'm hoping that there is an existing function to do it that I just didn't see! If there isn't an existing function ... how do I go about requesting it for a future release? One of the key things I was looking for was the field names in the associative array (Note: I already had ... and commented out ... the odbc_fetch_into function ... nice but not quite what I was wanting) Thanks. - function db_fetch_array($result) { global $db_type, $db_connection; if ($db_type == 1) : return mysql_fetch_array($result); else: $i = 0; $fCount = odbc_num_fields($result); $result_array = array(); if (odbc_fetch_row($result)) : while ($i $fCount) $i++; $fName = odbc_field_name($result, $i); $result_array[$fName] = odbc_result($result, $i); } // odbc_fetch_into ($result, $result_array); return $result_array; else: return false; endif; endif; -- PHP General 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 General 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 General 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]
RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array
Bob, Perhaps use odbc_field_name or even odbc_specialcolumns with odbc_fetch_into? I do agree that mysql_fetch_array is quite useful. Dan - what do you think? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Bob Horton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 10:39 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] ODBC Function equivalent to MySql_Fetch_Array odbc_fetch_into gives me an array but it doesn't give the column names. While many might consider that a small point I find that it helps substantially in making my code self documenting. $row[2] is much less readable than $row[Name] -Original Message- Bob, Why doesn't odbc_fetch_into give you what you want? Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- Hi, I'm trying to write a function (see below) that will provide equivalent functionality between ODBC and MySQL for mysql_fetch_array based upon a preset variable. I've written something that works but A) I'm afraid it might be quite slow; and B) I'm hoping that there is an existing function to do it that I just didn't see! If there isn't an existing function ... how do I go about requesting it for a future release? One of the key things I was looking for was the field names in the associative array (Note: I already had ... and commented out ... the odbc_fetch_into function ... nice but not quite what I was wanting) Thanks. - function db_fetch_array($result) { global $db_type, $db_connection; if ($db_type == 1) : return mysql_fetch_array($result); else: $i = 0; $fCount = odbc_num_fields($result); $result_array = array(); if (odbc_fetch_row($result)) : while ($i $fCount) $i++; $fName = odbc_field_name($result, $i); $result_array[$fName] = odbc_result($result, $i); } // odbc_fetch_into ($result, $result_array); return $result_array; else: return false; endif; endif; -- PHP General 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 General 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 General 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]
RE: [PHP] Which DB abstraction ?
Robert, Whichever you choose, using ODBC will further insulate you from the 'pain' of adopting other databases. Also, ODBC by itself will give you a great deal of db abstraction. There are HOWTO's on setting up PHP with the iODBC Driver Manager (needed to use ODBC drivers) at www.iodbc.org Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Robert Mena [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 11:47 PM To: php mailing list Subject: [PHP] Which DB abstraction ? Hi, I am in a middle of the process of chosing which DB will be used for future projects. I've been using Mysql for almost 5 years (coupled with php of course) but it seems to have reached it's limits (actually the lack of some features). The other options include some traditional comercial dbs and postgresql. I am about to choose postgresql because it seems to support the features I need (foreign key, transaction, triggers, stored procedures) and is open source with active development. Even tough I'd like to receive (perhaps in private) personal thought about this decision I would not like to start a war...so my focus here is : which db abstraction layer is ready for use ? disavantages ? I am considering : Manuel Lemos' Metabase, Phplib and Pear. So far I've played a little bit with pear, and read about metabase and phplib with no real experience in both. The ideia is to start using it right away so the adption of other DB would be painless (almost). Thanks, RT __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- PHP General 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 General 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]
RE: [PHP] Forum script
www.phorum.org Best regards, Andrew -Original Message- From: Rosen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 11:23 AM To: [EMAIL PROTECTED] Subject: [PHP] Forum script Hi Can someone recommend me some good script for forums ? Thanks, Rosen -- PHP General 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 General 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]
RE: [PHP] PHP Interact with DreamWaver
Jack, Check out www.interakt.ro Best regards, Andrew -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 6:45 AM To: [EMAIL PROTECTED] Subject: [PHP] PHP Interact with DreamWaver Dear All I'm fresh on the php, but i just want to ask what should i do to let my existing Dreamwaver Made homepage to interact with Php, which means i had used dreamwave to draw the layout, using firework for the image, then i want to provide some function for the user like forms input, which i knew php can handle these things well, so i want to let the php to interact with the Dreamwaver! Is there anything i got to set on the Dreamwaver or the php side? Thx -- Jack [EMAIL PROTECTED]
RE: [PHP] A universal Database Class
Brandon, You may wish to try ODBC. Counter to some misconceptions expressed, ODBC is neither slow nor necessarily an 'additional' layer, and will provide you the abstraction you mention. ODBC requires a Driver Manager to work, there are HOWTO's on compiling PHP with the iODBC Driver Manager at www.iodbc.org. Please let me know if you require assistance. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Brandon Orther [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 3:22 PM To: PHP User Group Subject: [PHP] A universal Database Class Hello, I am making a suite of online tools. Right Now I am connecting to a MS SQL 2000 database. Is there any class out there that will let you send a query to more than just one type of databases? Like someone could run it off a MSSQL server and another could run it off a MySQL database. thanks Brandon -- PHP General 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 General 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]
RE: [PHP] PHP4 and MySQL on Macintosh
Andy, Go Mac OS X - and roll your own install. I notice you are using ODBC in another post - there is a HOWTO at www.iodbc.org for compiling PHP, Apache, and iODBC (ODBC Driver Manager) under Mac OS X. Let me know if you run into problems. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Andreas Pucko [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 5:44 PM To: Php (E-mail) Subject: [PHP] PHP4 and MySQL on Macintosh Hi there, does anybody know if it is possible to run these applications on MAC 0S? Any experiences? Cheers Andy -- PHP General 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 General 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]
RE: [PHP] ODBC connect
Andy, What information are you trying to get? If nr and name are fields that you want values for, then odbc_fetch_row() or odbc_fetch_into() should work fine. If you are looking for column information, check out odbc_field_name() and odbc_field_num() http://www.php.net/manual/en/ref.odbc.php Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Andreas Pucko [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 9:02 PM To: Php (E-mail) Subject: [PHP] ODBC connect Hi there, I would like to get information out of a database via ODBC. I switched from MySQL. The old syntax does not work which was like: while ($row = odbc_fetch_row($result)) { printf (option value = \%s\%s/option, $row-nr,$row-name); } so, how do I get the nr and name out of the row?? Any suggestions? Cheers Andy -- PHP General 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 General 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]
RE: [PHP] installing PHP on a sun box
Joseph, You should check that 'cc' is installed on your system. (try typing: cc) If you get language optional software package not installed then you will need to install the developer tools, including the c-compiler. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Joseph Bannon [mailto:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 12:41 PM To: PHP (E-mail) Subject: [PHP] installing PHP on a sun box I'm installing PHP on a sun box and when type in make and i get not found. How can I run make if it's not found? Thanks, Joseph -- PHP General 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 General 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]
RE: [PHP] Shopping cart search
You may wish to check here for comparsons: http://www.l-i-e.com/compare/ Plus, there was a discussion set up in onelist - phpcart. It's idle now but may be searchable. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Todd Cary [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 11:24 AM To: [EMAIL PROTECTED] Subject: [PHP] Shopping cart search Can someone pass on the URL for searching for PHP shopping cart programs and shopping cart related questions. Many thanks... Todd -- Todd Cary Ariste Software [EMAIL PROTECTED] -- PHP General 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 General 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]
RE: [PHP] trying to activate php4 module
Jeff, You have an extra / this: --activate-module=/src/modules/php4/libphp4.a should be: --activate-module=src/modules/php4/libphp4.a Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access Data Integration Technology Providers -Original Message- From: Jeff Orrok [mailto:[EMAIL PROTECTED]] Sent: Friday, May 04, 2001 4:03 PM To: php general Subject: [PHP] trying to activate php4 module Below is the transcript of my attempt and the error that results: [gatchaman:/packages/apache_1.3.19] root# ./configure --enable-module=so --activate-module=/src/modules/php4/libphp4.a Configuring for Apache, Version 1.3.19 + using installation path layout: Mac OS X Server (config.layout) configure:Error: Module source already has to be below src/modules/ to be activated [gatchaman:/packages/apache_1.3.19] root# cd ../php-4.0.5/sapi/apache [gatchaman:php-4.0.5/sapi/apache] root# ls .deps apMakefile.tmpl mod_php4.h php_apache_http.h .libs config.m4 mod_php4.lo sapi_apache.c CREDITS libphp4.module.in php.sym sapi_apache.lo Makefilelibsapi.la php4apache.dsp Makefile.in mod_php4.c php_apache.c apMakefile.libdir mod_php4.expphp_apache.lo What do I need to do?? thanks for your help jeff -- :-J -- -- PHP General 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 General 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]
Re: [PHP] Trouble Setup !!!!!!!!!
Hi Luis, I recommend you 'roll your own'. There are some straightforward steps for a install on Unix in the manual: http://www.php.net/manual/en/install.unix.php Best regards, Andrew Andrew Hill - OpenLink Software Directory of Technology Evangelism Internet Data Integration Technology http://www.openlinksw.com On Wednesday, May 2, 2001, at 10:56 PM, Luis wrote: Hi all I was wondering if someone could help me out with a little problem I'm having .. I donwloaded the php tarball today. I will be installing it on my linux bo x. But the problem is that I already have apache running on my box. ( I installed the rpm apache-1.3.12-25 a while back. I just ran the ./configuration out of php folder.but i notice that i need to copy a php.ini file to my user/locar/lib folder. I guess it going to over right the old file. but theres no php.ini file in there. how do i setup php (tar) with apache-1.3.12-25 (rpm ) file that I installed .. Lusi -- PHP General 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]
RE: [PHP] PHP+MS Access and/or MS SQL
Hi, A small correction, remote ODBC DSNs work fine with Access. It's simply a question of installing appropriate drivers. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com Hi, www.mysql.com, and check the website for a myaccess or myodbc doc's. I know (I dwnloaded it) that exist a myaccess plugin to save access dB to mysql structure files. From php side you have a lot of classical dbfunction to access MSAccess dB, simply using odbc_function and creating a ODBC Data Source Name using Manage ODBC data source in Control Panel on the 'db server' machine. Notice that These odbc with MSAccess work ONLY LOCALLY (in lan,not remotely). U have to use MSSQL server to realize remote dB storage. Good Luck, Ivan [EMAIL PROTECTED] wrote: just point your browser to phpbuilder.net. Alternatively, just send me an email =) Date: Wed, 25 Apr 2001 19:02:12 -0700 (PDT) From: John Monfort [EMAIL PROTECTED] To: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Subject: PHP+MS Access and/or MS SQL Hello everyone, I'm looking for information on PHP+ MS Access , and PHP+MS SQL. Any recommendations? Thx in advance! __John Monfort_ _+---+_ P E P I E D E S I G N S www.pepiedesigns.com The world is waiting, are you ready? -+___+- On Thu, 26 Apr 2001, Ben Quinn wrote: Hi all, I am trying to copy an image from an external server and save it to my own. I have the following script to do this for a txt file and it works great! ? $page = ../temp/yep.txt; $date = date(http:/www.example.com/yep.txt); $cartFile = fopen($page,a); fwrite($cartFile,$date,strlen($date)); fclose($cartFile); ? But i can't get it to work for image files - the images are saved and displayed on screen as a whole bunch of rubbish. I'd appreciate any help you can give me -- PHP General 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] k.e.l.v.i.n c.h.a.n the open web technology company www.eXtropia.com [EMAIL PROTECTED] Tel: 7738550 -- (p)Ivan Student DIST Bio-Lab Viale Causa 13 16145 Genoa - Italy tel: +39 010 3532789 e-mail: [EMAIL PROTECTED] -- PHP General 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 General 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]
RE: [PHP] PHP+MS Access and/or MS SQL
John, If you are using PHP from Windows you can use ODBC or the mssql_functions. From Linux/Unix, you should compile the iODBC Driver Manager into your PHP/Apache build, and then drop in an ODBC driver. There is a HOWTO at www.iodbc.org on compiling PHP with iODBC. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com -Original Message- From: John Monfort [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 10:02 PM To: [EMAIL PROTECTED] Subject: [PHP] PHP+MS Access and/or MS SQL Hello everyone, I'm looking for information on PHP+ MS Access , and PHP+MS SQL. Any recommendations? Thx in advance! __John Monfort_ _+---+_ P E P I E D E S I G N S www.pepiedesigns.com The world is waiting, are you ready? -+___+- On Thu, 26 Apr 2001, Ben Quinn wrote: Hi all, I am trying to copy an image from an external server and save it to my own. I have the following script to do this for a txt file and it works great! ? $page = ../temp/yep.txt; $date = date(http:/www.example.com/yep.txt); $cartFile = fopen($page,a); fwrite($cartFile,$date,strlen($date)); fclose($cartFile); ? But i can't get it to work for image files - the images are saved and displayed on screen as a whole bunch of rubbish. I'd appreciate any help you can give me -- PHP General 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 General 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 General 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]
Re: [PHP] Ultradev PHP Server Model
Check out www.interakt.ro It's beta... but functional. Best regards, Andrew On Thursday, April 26, 2001, at 06:46 PM, John Platte wrote: John Monfort wrote: I was wondering, is anyone aware of a PHP server model, for Ultradev? Or, any leads on how I can create one? I'm developing a site with PHP+MS Access+Ultradev. I wanted to use some of the Ultradev server model features (and convenience), but they only support ASP/JSP/JScript. I'm not aware of one -- I wish I were! The book Extending Dreamweaver 4 from Macromedia documents their API's, including server models. I've got the book...it's pretty hefty. I *think* it's fairly complete, though I can't immediately determine if it has all the info necessary to create a new server model. I sincerely hope someone does this! I would give it a shot if I weren't so green... John Platte Truth binds the mind to what satisfies it, but worldly thinking does not satisfy and therefore ignites curiosity. -- St. Theophan the Recluse -- PHP General 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 General 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]
Re: [PHP] What is this??
You want to find the Error : Modify the error reporting section of you php.ini. You may combine different error settings with the symbols ~ (not) , | (or), and . to control the final error reporting level. As an example, the default setting E_ALL ~E_NOTICE means report all errors, except notices. All the options you can use are listed here: http://www.php.net/manual/en/html/features.error-handling.html Best regards, Andrew Andrew Hill - OpenLink Software Directory of Technology Evangelism Internet Data Integration Technology http://www.openlinksw.com On Thursday, April 26, 2001, at 10:38 PM, Manesh wrote: where is that? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jack Dempsey Sent: Thursday, April 26, 2001 10:38 PM To: Manesh Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] What is this?? Manesh wrote: Warning: Undefined variable How do i get rid of this??? -- PHP General 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: php-list- [EMAIL PROTECTED] if you're sure that its because you didn't initialize first before using, then look in your php.ini file...there are options there where you can error strictness... -- PHP General 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]
RE: [PHP] db to xls
Rahul, Why not just create a pivot table in Excel directly to Oracle? That way you would have a live view of the data. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com office:781.273.0900 x 27 mobile:781.608.4217 -Original Message- From: Rahul Hari Bhide [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 24, 2001 11:07 AM To: Calin Rotaru Cc: Rahul Bhide; [EMAIL PROTECTED] Subject: Re: [PHP] db to xls Thanks Calin, I have already tried with the csv and the tab delimited text file . I wanted to know a better option bye `Rahul Calin Rotaru wrote: You can query the oracle database and generate a text file with tab delimiter. Then you can open this file in Excel. Calin On Tuesday 24 April 2001 10:31, Rahul Bhide wrote: Gurus, I want to query an oracle database and push the output to an MS Excel spreadsheet . Currently I am dumping it to a csv text file and reading into Excel. Is there a better way to do this?? Is there a php function for this ?? Regards ~Rahul -- PHP General 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 General 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 General 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]
RE: [PHP] Connecting to a MS Access database
Actually, I must put my .02 in again. ODBC is not by nature slow. Some implementations of ODBC are indeed slow, especially the ones that are additional abstraction layers on top of a native driver, but other ODBC drivers (OpenLink's included) can bypass the native networking layer, producing a connection that is as fast and in some cases far faster than the native driver. Not that the speed would be an issue with Access, though :) I agree fully with Geir - install a full-fledged multi-user database. If you are looking for another 'free' one, try Virtuoso http://www.openlinksw.com/virtuoso It is a fully functional SQL92 db and comes with a free 2 user license - enough to give you the same scalability as Access and you have the option of upgrading it's license later. It works quite well as a backend for PHP, and also lets you link other databases transparently through it (so you can access multiple database schemas as if they are a single local schema). Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com -Original Message- From: Geir Eivind Mork [mailto:[EMAIL PROTECTED]] Sent: Monday, April 23, 2001 4:07 AM To: Steve Maroney; Andrew Hill Cc: Søren Soltveit; [EMAIL PROTECTED] Subject: Re: [PHP] Connecting to a MS Access database On Sunday 22 April 2001 22:02, Steve Maroney wrote: This brings up a question that I always wondered. Does Access have server functionality? Where do you configure these settings ? If you go over the menuchoice - file, shake your mouse, bite in the cord, slam your head in the monitor fifteen times and then trow a bucket of water over your computer a new option called 'server' comes up. if not, repeat the steps. Or install a database server. when using ex. asp towards an accessbase it's odbc that deals with the communication. it's slow, it's a bottleneck.. but it works :) -- php developer / CoreTrek AS| Thus spake the master programmer: Sandnes / Rogaland / Norway| After three days without programming, web: http://www.moijk.net/ | life becomes meaningless. -- Geoffrey -- PHP General 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]
Re: [PHP] Connecting to a MS Access database
The Access native driver IS an ODBC driver. That is, I believe, your only option. Best regards, Andrew Andrew Hill - OpenLink Software Directory of Technology Evangelism Internet Data Integration Technology http://www.openlinksw.com On Saturday, April 21, 2001, at 07:00 PM, Søren Soltveit wrote: How can I connect to a Microsoft Access database, whitout using ODBC?? -- PHP General 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 General 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]
Re: [PHP] Last Element in an Array?
Jason, You can use array_pop() to return the last element of the array - $last_item = array_pop ($array); but if you just want your array processing to stop when it's reached the last item in the array (and avoid the loop) then do something like: while (list ($var1, $var2) = each ($array)) HTH! Best regards, Andrew Andrew Hill - OpenLink Software Directory of Technology Evangelism Internet Data Integration Technology http://www.openlinksw.com On Thursday, April 19, 2001, at 07:57 PM, Jason Caldwell wrote: Is there a command which will tell me that it is the last in an array? When I use END it just gives me the value IN the array... I want to know when I hit the last element in an array... This is driving me crazy... Thanks. Jason -- PHP General 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 General 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]
RE: [PHP] New problem with PHP odbc_exec.
Scott, This error indicates that there is no index/primary key on a table that the result set is coming from - and PHP has told the driver read the result set into a into a cursor (which requires a primary key). Adding a primary key to the table will fix this, or passing a different cursor type - keyset driven cursors are essentially 'sliding windows' - they read a set of rows in, and then scroll back and forth. Upon reaching the end of the set, they grab the next keyset in the direction of scroll, etc. Alternatively, instead of adding the primary key, you can disable "#define HAVE_SQL_EXTENDED_FETCH 1 " in php_odbc.h and recompile. This will prevent PHP from atomatically setting a cursor. Best regards, Andrew ------ Andrew Hill - OpenLink Software Director Technology Evangelism Universal Data Access Integration http://www.openlinksw.com -Original Message- From: Scott Fletcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 9:37 AM To: [EMAIL PROTECTED] Subject: [PHP] New problem with PHP "odbc_exec". Hi! I don't understand why PHP is having trouble with the odbc_exec. Is there a bug in PHP code? Here's what the error messages said! "SQL error: [OpenLink][ODBC][Driver]No key columns found for table referenced by keyset driven cursor., SQL state IM909 in SQLExecDirect". This show that it had to do with primary (or secondary) keys or index issues. I'm using MS-SQL Sever and this table I'm using in the database have primary key already! So, what can I do to fix it? I need it to be working. When I use the Linux odbctest command and it execute without a problem. So, it is obvious the problem lie with PHP code, odbc_exec(); Thanks, Scott -- PHP General 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 General 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]
Re: [PHP] Oracle Connection
You can use ODBC as well. Compile PHP with iODBC (http://www.iodbc.org) and you can use an ODBC driver instead of the oci - this can bypass the Oracle client install in many cases. Best regards, Andrew Andrew Hill . Director Technology Evangelism OpenLink Software . www.openlinksw.com Internet Data Integration Technology On 4/10/01 11:53 AM, "Brian S. Dunworth" [EMAIL PROTECTED] wrote: At 08:42 AM 4/10/01 -0700, Dunaway, Brian wrote: I need to access a remote oracle database. What I mean is that the machine that is allowed access to the oracle database is not running php...I have access to the machine with the oracle access from my machine which is running php. Boy that sounds confusing. No, not really. anyway I am setting my environment with putenv(oracle_home=/something) and putenv(oracle_sid=database)...what can I do? any ideas? I'm assuming that this isn't working for you. Make sure you set NLS_LANG etc, as well in your environment, as specified in the PHP documentation. Do you have an Oracle client installed on the machine that has PHP installed on it? Did you compile PHP with oci8 support? Here, our web server (Linux) has Apache/PHP and Oracle Net8 client installed. The Net8 client talks to our Sun box with Oracle 8i installed. Works with PHP with no hitches. Brian D. yeah, me too. :) Running PHP 4 yeah, me too. :) - Brian - Brian S. Dunworth Sr. Software Development Engineer Oracle Database Administrator The Printing House, Ltd. (850) 875-1500 x225 [EMAIL PROTECTED] - -- PHP General 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]
Re: [PHP] Access/SQL Server?
Locally on a Win32 box, use the odbc functions built in, with a local DSN. On Unix, compile php with iodbc (http://www.iodbc.org) and use an ODBC driver to connect to the SQLServer or Access db on the Win32 box. You can use OpenLink's drivers if you like - For SQLServer: - install Multi-Tier driver from www.openlinksw.com, with client as unix and server as win box. - configure DSN in unix side odbc.ini, per the example. - test with odbctest - use odbc_connect() in your script, making sure you have specified putenv("ODBCINI=/path/to/odbc.ini"); For Access -similar to above, but unix side DSN needs to pass Database field as name of a Win32 side DSN using the native MS driver. The ServerType should also be ODBC instead of Access on the unix side. Please let me know if you require assistance. Best regards, Andrew -------- Andrew Hill . Director Technology Evangelism OpenLink Software . www.openlinksw.com Internet Data Integration Technology On 4/15/01 2:40 PM, "Bob Clingan" [EMAIL PROTECTED] wrote: What to I need to do/configure in order for PHP 4 to be able to connect to Access and/or SQL Server databases? --Bob -- PHP General 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] RE: [PHP-DB] mysql_result()
Jordan, If you know your result is going to product one row, try using: $row=mysql_fetch_array($result, MSQL_ASSOC); // returns an assoc array where the field names are keys, field value is value $id=row[id]; $name=row[name]; etc. Best regards, Andrew -- Andrew Hill - OpenLink Software Director Technology Evangelism eBusiness Infrastructure Technology http://www.openlinksw.com -Original Message- From: Jordan Elver [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:46 AM To: PHP Database Mailing List; PHP General Mailing List Subject: [PHP-DB] mysql_result() Hi, If I knnow that a query will only retrun one row, can I do thiss (below) rather than using a while loop for one record? $id = @mysql_result($result, 0, 'id'); $name = @mysql_result($result, 0, 'name'); $email = @mysql_result($result, 0, 'email'); $address1 = @mysql_result($result, 0, 'address1'); $address2 = @mysql_result($result, 0, 'address2'); $town_city = @mysql_result($result, 0, 'town_city'); $postcode = @mysql_result($result, 0, 'postcode'); Cheers, Jord -- 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 General 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]