Hi Folks - new user here,
My question is on the setup of my local server.
I'm using Windows 2000 and IIS 5
I've just started to use php on my local IIS as a cgi .exe file.
Under c:\Inetpub I have:
\mySQL
\php
\wwwroot etc
(php seems to working fine)
In a php test page I'm trying to connect to the 'test' database (in
c:\inetpub\mysql\data\ ) and hardware 'table'.
$link = mysql_connect("mySQL_test", "mysql_login", "mysql_password")
or die ("Could not connect");
print ("Connected successfully");
mysql_select_db ("test")
or die ("Could not select database");
I get the error message:
Warning: Unknown MySQL Server Host 'mySQL_test' (2) in
C:\Inetpub\wwwroot/mySQL.php on line 9
In my ODBC sources I have a user DSN of
name: mySQLtest
driver: mySQL
mySQL host: 127.0.0.1
mySQL database name: test
I have a system DSN:
name: mySQL_test
driver: mySQL
mySQL host: 127.0.0.1
mySQL database name: test
I get the same message using mySQLtest in the php file. (names are case
sensitive?)
I run WinMySQLadmin 1.1 on startup, and it runs okay. Details are:
Server Info: 3.23.38-nt
Host Info: localhost via TCP/IP
Client Info: 3.23.36
MyODBC driver version 02.50
Everything looks fine to my untrained eye.
<!--emph-->Help appreciated!<!--emph-->
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php