Re: [PHP-DB] DB access failure...

2004-07-24 Thread Jason Wong
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?

2004-07-24 Thread weston
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

2004-07-24 Thread Unreal HSHH
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...

2004-07-24 Thread \[php\]Walter
"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