SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Evangelist barbara1712's Avatar
    Join Date
    Apr 2007
    Location
    India
    Posts
    509
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to connect SQL Server with PHP Project on centos

    Hi,

    I am having one PHP project with Mysql Database. Project is hosted on CentOS. I want also to connect the database of SQL Server 2005 with this PHP Project.

    Can you please give me some pointers for this?

    Your help will be highly appreciated.

    Thanks,
    Barbara

  2. #2
    Foozle Reducer ServerStorm's Avatar
    Join Date
    Feb 2005
    Location
    Burlington, Canada
    Posts
    2,699
    Mentioned
    89 Post(s)
    Tagged
    6 Thread(s)
    Hi Barbra1712,

    I would recommend that you download MySQL workbench. This tool can be found here http://www.mysql.com/products/workbench/

    Once installed you will need to configure it. It will be divided into three areas 'SQL Development, Data Modeling, and Server Administration'

    Under 'SQL Development' you will need to create a connection using 'New Connection' . It will ask for the Connection Name, for the 'Connection Method:' you will select Standard (TCP/IP). Under Parameters you will need to put you Hostname. If the MySQL DB is running on a server and not your local machine then you will need to put the I.P. Address or local DNS hostname (i.e. mysql.mydomain.com - you may not have an internal host set?). The default port should be left as 3306 and then you need to put the Username and Password for this. Make sure you store your Password in the Keychain the first time; otherwise you'll have to enter it every time you open this connection. Once configured you can run 'Test Connecition' to ensure you have set it correctly.

    I don't know how you manage the CENTOS server, but I would recommend you install WebMin (a free and powerful) Server and Services web based manager. You can install this from your CENTOS package manager.

    Hope this helps,
    Steve
    ictus==""

  3. #3
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    358
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Maybe this will help

    http://msdn.microsoft.com/en-us/sqlserver/cc299381.aspx

    You need a mssql driver that php understands. There is also the older mssql_connect() drivers in php to hook up to a Microsoft sql server dbms.
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •