Re: [PHP-DB] MS SQL 7
Which way? I've tried with mssql_query, but it didn't work. Thanks. > -- Initial message --- > > From: "Frank M. Kromann" <[EMAIL PROTECTED]> > To : Ouster <[EMAIL PROTECTED]> > Cc : <[EMAIL PROTECTED]> > Date: Thu, 04 Oct 2001 12:17:18 -0700 > Subject : Re: [PHP-DB] MS SQL 7 > > If your storred procedure returns a result set you can get it with the mssql_functions as well. > > If the precedure returns values or output parameters you will need php 4.0.7 (or current cvs). The updated version of php_mssql.dll includes three new functions aimed for storred procedures. > > - Frank > > > Is there a way to retrieve records from a stored procedure with MS SQL 7? > > I've tried but I couldn't get anything. > > I read on the PHP bug site that I can only use SELECT statement, but ODBC > > should work; is that true? > > > > Thanks > > > > > > -- > > 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: php-list- [EMAIL PROTECTED] > > > > > > > > > > Sempre 'n testa 'a ranocchia gialla. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Oracle 9i?
Just looking at upgrading an existing application which is potentially turning from small-fry to enterprise level (aren't they all :P) and was wondering what the situation is on Oracle 9i support. I have never worked with Oracle/PHP together, but all I can find in the manual are the ORA and OCI8 functions - can the ORA functions be used for 9i? is this a reasonable path to take? TIA Beau -- Beau F Lebens, Technical Officer National Key Centre for School Science and Mathematics Science and Mathematics Education Centre Curtin University of Technology, GPO Box U1987 Perth, Western Australia 6845 t: +61 8 9266-7297 (has voice-mail) f: +61 8 9266-2503 (ATT: Beau Lebens) e: [EMAIL PROTECTED] w: http://learnt.smec.curtin.edu.au/ -- 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]
Re: [PHP-DB] Difference between OCI* functions and ORA_* functions
FYI, You can use OCI8 on a Oracle 7 database, if the net8 client is configured Regards, Philippe "B. Perrine" <[EMAIL PROTECTED]> a écrit dans le message news: [EMAIL PROTECTED] ORA are for Oracle7 OCI8 for Oracle8 Read the manual on www.php.net B. le jeu 04-10-2001 at 17:02 Sridhar Moparthy a écrit : > Hi All, > > Does any one know the difference between OCI* functions from PHP_OCI8.DLL > and ORA_* functions from PHP_ORACLE.DLL? > Which one is better in terms of speed and which one is better for future > compatibility?. > > Thanks in advance > Sridhar Moparthy. > > > -- > 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 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]
Re: [PHP-DB] Email Processors Wanted Immediately!!!
HAAHAHAHAHAHAHHAHAHH!!! does this seem like a spam mail or what! :) my suggestion. do not even touch this email. the person is wanting some more emails to spam. Neil - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 04, 2001 4:04 PM Subject: [PHP-DB] Email Processors Wanted Immediately!!! > Dear [EMAIL PROTECTED], > > WE are looking for serious inquires from > individuals who want to make a difference!!! > > Our company is offering an opportunity > for individuals who want to become an > E-Mail PROCESSOR. Work from home > and be apart of this tremendous opportunity > to sustain an income of your choice. > Free 30 day trial membership, not MLM. > > Requirements: Computer, internet hookup, > some basic computer skills and a little > time & effort. > > > SEND AN EMAIL TO: [EMAIL PROTECTED] > WITH SUBJECT: "SHOW ME". > > > ***Thanks for taking the time to look at this offer. Please > accept my apologies if this email has offended you in > any way. If you wish to no longer receive email please send > an email message to [EMAIL PROTECTED] with "Remove" > placed in the subject line.*** > > > Web Site; http://www.geocities.com/project_internetca/ > > -- > 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 Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Email Processors Wanted Immediately!!!
Dear [EMAIL PROTECTED], WE are looking for serious inquires from individuals who want to make a difference!!! Our company is offering an opportunity for individuals who want to become an E-Mail PROCESSOR. Work from home and be apart of this tremendous opportunity to sustain an income of your choice. Free 30 day trial membership, not MLM. Requirements: Computer, internet hookup, some basic computer skills and a little time & effort. SEND AN EMAIL TO: [EMAIL PROTECTED] WITH SUBJECT: "SHOW ME". ***Thanks for taking the time to look at this offer. Please accept my apologies if this email has offended you in any way. If you wish to no longer receive email please send an email message to [EMAIL PROTECTED] with "Remove" placed in the subject line.*** Web Site; http://www.geocities.com/project_internetca/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] updating records in ODBC with cursor
is there a way to update records with cursor thru ODBC? thanx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Date
Is there a way that the default sql data base date -00-00 can be changed using php? Cheers -- 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]
Re: [PHP-DB] Howto make a double LEFT JOIN
Hello Sheridan Saint-Michel, Well it works fine, tnx!!! But now i want to understand it too. bit_count(bit_or(1<999.999.999)) Now i thougth bit_count(bit_or(32< To: "Bas Jobsen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, October 04, 2001 8:02 PM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN > Sheridan Saint-Michel > Website Administrator > FoxJet, an ITW Company > www.foxjet.com > > > - Original Message - > From: "Bas Jobsen" <[EMAIL PROTECTED]> > To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, October 03, 2001 2:52 PM > Subject: Re: [PHP-DB] Howto make a double LEFT JOIN > > > > Hello Sheridan Saint-Michel, > > > > Let's see. > > > > Table2 contains data with a unique identifier (id) > > b.e > > id|url > > > > Table1 and Table3 contain the same identifier (id) but it isn't unique > now. > > Table1 and Table3 contain couting of action. Cause i want to count only > the > > actions of the last X hours, each count is on a row apart. Each row in > this > > table contains a timestamp, so i could do something like "DELETE FROM > Table1 > > WHERE time identifier > > (sid)). > > > > Table1 and Table3: > > sid|id|count|time > > > > count is always 1 > > You probably don't need count, as each entry implies one event, unless you > are using > it for something else I don't know about... otherwise this looks good. > > > Oke, what do i want? > > > > First i want to know which id's are in Table1 and how many times (know > not > > all the id's from Table2 have to be in Table1(or in Table3, and not all > the > > id's from Table1 have to be in Table3)) > > > > something like: "SELECT DISTINCT id, SUM(count) FROM table1 GROUP BY id" > > > > For each id found in Table1 i want to know two things: > > > > 1) the url from Table2 > > 2) is there any row in Table3 where table1.id=table3.id and if so, how > many > > are there? > > > > This is it. > > > > thanks!!!, > > > > Bas > > Okay, now that you have added a unique Primary Key to each table this > becomes a doable task. The query to do everything you list here should be: > > select table1.id,bit_count(bit_or(1< count1,bit_count(bit_or(1< table1 left join table3 using(id) left join table2 using(id) group by > table1.id; > > As you can see, count is never used... which is why I said you probably > don't need it. > > Let me know if this helps > > Sheridan Saint-Michel > Website Administrator > FoxJet, an ITW Company > www.foxjet.com > > > -- > 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 Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP with Domino Notes
Hi.. There is any possibility to work with Domino Notes databases in PHP? Thanks, Kiko -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Other ODBC driver besides an openlink one?
We have had nothing but problems with our openlink drivers connecting to an oracle database from our bug tracking software, so I'm not allowed to use openlink odbc drivers. Is there another way to set up an odbc connection to a linux system using php and odbc??? I know I can do native connections, but I'm having a few problems installing oracle on Linux. Thanks Ricky
[PHP-DB] RE: [PHP-WIN] Setting up MySQL for PHP
Even with it being on a separate server, setting up MySQL and PHP to work together is almost flawless, with ODBC and MySQL being enabled by default on the windows PHP ver, just plugin the code.. To test this theory you can always use the following code (as I do when setting up a new server): That will test to see if you can connect to the host. Simple :) For more information, either read the MySQL documentation along with the PHP documentation, or check out devshed's tutorials. -- Charles Butler [EMAIL PROTECTED] Research and Development American Telanet Corp. -- 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]
Re: [PHP-DB] MS SQL 7
If your storred procedure returns a result set you can get it with the mssql_functions as well. If the precedure returns values or output parameters you will need php 4.0.7 (or current cvs). The updated version of php_mssql.dll includes three new functions aimed for storred procedures. - Frank > Is there a way to retrieve records from a stored procedure with MS SQL 7? > I've tried but I couldn't get anything. > I read on the PHP bug site that I can only use SELECT statement, but ODBC > should work; is that true? > > Thanks > > > -- > 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 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]
RE: [PHP-DB] Bug in new PHP Version?
> -Original Message- > From: Luditus [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 03, 2001 3:13 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Bug in new PHP Version? > > > I just downloaded the new 4.06 PHP Version and installed it on a new > machine. > > My application does not work properly anymore, nor does mysqladmin. > > This are some warnings: > > [snip] > > Does anybody have an idea? You don't say what version you were upgrading from, but if you jumped forward a few versions, I believe there was a change in the default value of the error_reporting configuration option that'd result in the display of more non-fatal warning messages (things like the unitialized variable message you posted). Note that, for the most part, your application should still behave the way it did before (except for the printing of those messages). I didn't see anything in either of the messages you posted that appeared to indicate a change in functionality...do you have some reason to believe that things aren't working the same behind the scenes as they did before? --- Mark Roedel | "Blessed is he who has learned to laugh Systems Programmer | at himself, for he shall never cease LeTourneau University | to be entertained." Longview, Texas, USA| -- John Powell -- 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]
Re: Re[2]: [PHP-DB] padding an id field
On Thu, 4 Oct 2001 14:17:22 -0300 WebDev <[EMAIL PROTECTED]> wrote: > Thursday, October 04, 2001, 1:13:59 PM, you wrote: > > RR> When you define your auto-incrementing column, can't you specify > RR> "ZEROFILL"? I believe it pads to the left with zeroes. > > Hello Raquel, > > Yes, but is it possible to append a code such as 'abc' along with the > zerofill to create an id like 'abc000123' for the 123rd id record. > > /Merle > I don't believe that's a possibility. However, if I were doing it myself, I would have two columns ... one that contained the 'abc' identifier (or whatever) and the second which contained the auto-incremented ID. Then when I retrieved the full ID, I would do it using ... SELECT concat(first_id,auto_id) AS full_id FROM id_table ORDER BY full_id; -- Raquel Don't be afraid of opposition. Remember, a kite rises against ... not with ... the wind. --Hamilton Mabie -- 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]
Re: [PHP-DB] Difference between OCI* functions and ORA_* functions
ORA are for Oracle7 OCI8 for Oracle8 Read the manual on www.php.net B. le jeu 04-10-2001 at 17:02 Sridhar Moparthy a écrit : > Hi All, > > Does any one know the difference between OCI* functions from PHP_OCI8.DLL > and ORA_* functions from PHP_ORACLE.DLL? > Which one is better in terms of speed and which one is better for future > compatibility?. > > Thanks in advance > Sridhar Moparthy. > > > -- > 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 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]
Re: [PHP-DB] Howto make a double LEFT JOIN
Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: "Bas Jobsen" <[EMAIL PROTECTED]> To: "Sheridan Saint-Michel" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, October 03, 2001 2:52 PM Subject: Re: [PHP-DB] Howto make a double LEFT JOIN > Hello Sheridan Saint-Michel, > > Let's see. > > Table2 contains data with a unique identifier (id) > b.e > id|url > > Table1 and Table3 contain the same identifier (id) but it isn't unique now. > Table1 and Table3 contain couting of action. Cause i want to count only the > actions of the last X hours, each count is on a row apart. Each row in this > table contains a timestamp, so i could do something like "DELETE FROM Table1 > WHERE time (sid)). > > Table1 and Table3: > sid|id|count|time > > count is always 1 You probably don't need count, as each entry implies one event, unless you are using it for something else I don't know about... otherwise this looks good. > Oke, what do i want? > > First i want to know which id's are in Table1 and how many times (know not > all the id's from Table2 have to be in Table1(or in Table3, and not all the > id's from Table1 have to be in Table3)) > > something like: "SELECT DISTINCT id, SUM(count) FROM table1 GROUP BY id" > > For each id found in Table1 i want to know two things: > > 1) the url from Table2 > 2) is there any row in Table3 where table1.id=table3.id and if so, how many > are there? > > This is it. > > thanks!!!, > > Bas Okay, now that you have added a unique Primary Key to each table this becomes a doable task. The query to do everything you list here should be: select table1.id,bit_count(bit_or(1
[PHP-DB] sybase extensions
Hello, I am very new to PHP and am having problems finding out information regarding loading up the Sybase extensions for IIS on Win2K. Any help would be greatly appreciated. Art Chevalier Sybase Replication Administrator Space and Naval Warfare Center, Chesapeake 1-757-523-8303 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MySql special characters (éàôï)
Hi ! My question is pretty simple. How do I specify a language for MySQL ? I cannot retreive (or correctly insert, i'm not sure) any accentuated characters (french canada) from my database with php, ODBC or the mysql client. I may be a little off-topic, but it's pretty important for me to be able to display these characters on my webpage. Thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MS SQL 7
Is there a way to retrieve records from a stored procedure with MS SQL 7? I've tried but I couldn't get anything. I read on the PHP bug site that I can only use SELECT statement, but ODBC should work; is that true? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Bug in new PHP Version?
which version you ised before? and which version of the mysqladmin you are using? seems you need a new version of mysqladmin. -- Hidulf http://www.hidulf.com "Luditus" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there, > > I just downloaded the new 4.06 PHP Version and installed it on a new > machine. > > My application does not work properly anymore, nor does mysqladmin. > > This are some warnings: > > > Warning: mysql_db_query is deprecated; use mysql_select_db() and > mysql_query() instead in c:\dokumente und > einstellungen\administrator\desktop\my > files\projects\globosapiens\07_production\actual\mysqladmin\lib.inc.php on > line 506 > > > Warning: Undefined variable: picture in c:\dokumente und > einstellungen\administrator\desktop\my > files\projects\globosapiens\07_production\actual\gallery\app_local\dsp_album > .inc on line 273 > > > > Does anybody have an idea? > > Cheers Andy > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] padding an id field
Is there anyway to pad an id field in MySQL? I have a table with a PK field (id). This field is auto incrementing a 6 digit number ie. 000223. Is there anyway to pad this id so that it is padded with a code along with the auto incrementing part, such as ABC000223. Now I wouldn't want the ABC pad to change but the 6 digits would still auto incr as required. Is this possible without doing any field editing, exclusively with a MySQL utility? thanks /Merle -- 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]
RE: [PHP-DB] MYSQL Problems Please help
>-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: 04 October 2001 17:11 >To: Jason Wong >Subject: Re: [PHP-DB] MYSQL Problems Please help > > >Jason, > >Mysql is running, so thats not the problem. >I tired to run your updatedb to no avail. >my directory for mysql is /var/lib/mysql >so I tried the configure with the directory /var/lib still no joy. > >I really dont want to have to rebuid the box again as I have been >doing this >for a couple of days now. > >Any other ideas?? > >Thank you for your help it is much appreciated OK, you say you can't find "mysql.h", that is a file which is provided by the MySQL-devel package --have you installed it? Next, you need to configure php using "--with-mysql=/dir/to/parent/of/mysql/mysql.h". regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- 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]
RE: [PHP-DB] MYSQL Problems Please help
>-Original Message- >From: Peter [mailto:[EMAIL PROTECTED]] >Sent: 04 October 2001 16:42 >To: [EMAIL PROTECTED] >Subject: [PHP-DB] MYSQL Problems Please help > > >I am runing RH 7 Mysql (installed of RPM), Apache (compiled >version) and PHP >4.0.4pl1 >configure command './configure' '--with-xml' >'--with-apache=../apache_1.3.19' '--enable-shared-pdflib' >'--enable-track-vars' [snip] >and I am getting the following error > >Warning: MySQL Connection Failed: Can't connect to local MySQL server >through socket '/var/lib/mysql/mysql.sock' (111) in >/home/webgen/public_html/index3.php on line 10 It sounds like the mysql server is not running. Do: /etc/init.d/mysql status If that says "mysql is not running" (or words to that effect) then do: /etc/init.d/mysql start >I have tried to recompile PHP using --with-mysql but it wont >compile even if >I specify the mysql location. It claims it cant find mysql.h IIRC you have to specify the parent directory. EG if you had: /usr/include/mysql/mysql.h then you would specify "/usr/include" >runnig locate mysql.h brings back nothing. If this is a fresh install you probably need to run "updatedb" to update the db that locate uses. regards -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MYSQL Problems Please help
I am runing RH 7 Mysql (installed of RPM), Apache (compiled version) and PHP 4.0.4pl1 configure command './configure' '--with-xml' '--with-apache=../apache_1.3.19' '--enable-shared-pdflib' '--enable-track-vars' I am trying to connect to a mysql database using the following: "; $host = "localhost"; $user = "root"; $password = "password here"; $database = "webgen"; echo "trying to connect to $host as $user"; $db = mysql_connect($host,$user,$password) or die ("Connection could not be established"); echo "Connected"; echo "End of PHp."; ?> and I am getting the following error Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /home/webgen/public_html/index3.php on line 10 I have tried to recompile PHP using --with-mysql but it wont compile even if I specify the mysql location. It claims it cant find mysql.h runnig locate mysql.h brings back nothing. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: PHP and MS Access
For information: For step by step info on using ODBC to connect MySQL to M$ Access go to: http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm Cheers. Russ On Wed, 3 Oct 2001 15:47:07 -0500 Carlos Augusto Abarca <[EMAIL PROTECTED]> wrote: > This is absolutely not true. Although there isn´t a direct way to connect to > Access from PHP (like you can do with PosgresSQL) you may connect to access > using an ODBC connection. The only thing they have to do is Configure an > ODBC DSN in their server pointing to your specific DB file and that´s it. > > I hope I understood your problem correctly and I hope this answer is > satisfactory. > > > > > -- > 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] > #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- 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]