Re: [PHP-DB] DB access failure...
On Saturday 24 July 2004 15:24, \[php\]Walter wrote: > That's what I thought. so I tried this test using PHP functions... > >mysql_connect($db_host, $db_user, $db_pass) > > I get this... > > Warning: mysql_connect(): Unknown MySQL Server Host 'db.torres.ws' Well that sounds like something, somewhere is not using the system's DNS resolve mechanism. As I don't have a Windows box handy I'm afraid I cannot help you. > Sometimes things are not done for "practical purposes." Right. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* "Who is General Failure and why is he reading my hard disk ?" Microsoft spel chekar vor sail, worgs grate !! (By [EMAIL PROTECTED], Felix von Leitner) */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Getting PHP for Windows to talk to MS SQL?
On Fri, Jul 23, 2004 at 01:56:08PM -0700, Marcjon wrote: > php_mssql.dll doesn't go in your windows\system dir. It goes in the > extensions dir. I believe the default in #PHPINSTALLDIR#\etx, though I > may be wrong. Look in your PHP.ini file for the extensions directory > setting and place the php_mssql.dll there. Thanks for your help everyone! After getting the placement of php_mssql.dll right and puzzling over the fact that I had in fact edited php.ini correctly... I discovered that PHP was not looking at C:\php\php.ini. Rather, somehow it was looking at C:\Windows\php.ini. Anyway, now all is well. Thanks again! -Weston -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] [mysqli] how can i define the charset for connection
i want to use utf8 charset to connect the mysql4.1.x,and use the mysql charset for tables,columns. but i cant found the charset setting or function in php. mysqli_character_set_name still return iso charset how can i do it? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] DB access failure...
"Jason Wong" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Saturday 24 July 2004 10:25, \[php\]Walter wrote: > > Does: > > ping hostname.as.listed.in.hosts.file > > correctly resolves to the IP address as listed in the HOSTS file? yes > If it does then you probably haven't setup the permissions correctly in MySQL. > You need to use the GRANT command to allow connections from > [EMAIL PROTECTED] See MySQL docs for info. That's what I thought. so I tried this test using PHP functions... mysql_connect($db_host, $db_user, $db_pass) I get this... Warning: mysql_connect(): Unknown MySQL Server Host 'db.torres.ws' So, at least now I know it is a connection issue, not a id/password issue. > If your IP address is not going to change over time then for practical > purposes there will be no difference whether you connect using IP address > or hostname. Sometimes things are not done for "practical purposes." Thanks Walter -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php