conventions. ODBC queries are pretty standard but the connections string
aren't always. There may be information on the PHP site on how to do this -
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:6als42do2hrecr933a16k2f22mo2iuo91b@4ax.com...
> You are trying to connect to MySQL. I'm not sure what
> exactly you installed but it looks like you are confusing
> Microsoft SQL Server and MySQL. They are two different
> products.
> For MySQL questions, try posting to:
> comp.databases.mysql
>
> -Sue
>
> On Tue, 25 Apr 2006 07:49:01 -0700, Tech Parts
> <TechParts@discussions.microsoft.com> wrote:
>
>>After a new installation of MS Enterprise SQL Server, i am unable to
>>connect
>>to the database from a website, and i dont know if MS SQL is working at
>>all.
>>All the startup services and SQL services are started.Here is the website
>>that im trying to access my SQL server:
>>
http://www.techparts.org/scripts/install.php >>
>>The error message is: Warning: mysql_connect(): Can't connect to MySQL
>>server on '10.10.8.6' (10061)
>>
>>Here are the logistics:
>>
>>The database name is "master" and I just reset the password for
>>"db_website"
>>to "database"
>>
>>Username: db_website
>>Password: database
>>Database: master
>>Host: 10.10.8.6 (MAIN)
>>Website:
http://www.techparts.org/scripts/install.php >>Forwarded Ports: 1433 and 3306 to 10.10.8.6
>>Firewall: No firewall on server or router
>>Software: MS SQL enterprise server, PHP, and SBS 2003
>>Permissions: db_website has full permissions to the master database
>>Authentication: db_website has full permissions to root and subfolders for
>>the website.
>>
>>Is there something that im missing on the intial setup of SQL, and why
>>cant
>>i login?
>