connect to SQLServer database from php application

• aizkorri

  SSC Rookie

  Points: 33

  More actions

  April 20, 2006 at 2:00 am

  #167970

  Hello,

  This is my first post and I am a total newbie here.

  I have a php web application and now I have to make a dayly query to an external SLQServer database table to update my mySQL database table.

  Could you please give me some hints on how could I do it?

  thanks a lot.

• Marshall Smith

  SSCrazy

  Points: 2041

  More actions

  April 20, 2006 at 9:39 am

  #633304

  You could create an ADO connection.

• Longv-278915

  SSC-Addicted

  Points: 442

  More actions

  April 21, 2006 at 11:20 am

  #633580

  I have a php web application and now I have to make a dayly query to an external SLQServer database table to update my mySQL database table.

  Could you please give me some hints on how could I do it?

  **************************************************

   

  Here's a simple process that shows how you can connect to an external SQL Server database via PHP:

   $db = new COM("ADODB.Connection");

   $dsn = "DRIVER={SQL Server}; SERVER={servername};UID={login_name};PWD={login_pwd}; DATABASE={database_name}";

   $db->Open($dsn);

  You mentioned the SQL Server was external, so an example servername would be:  extserver.externaldomain.com.

  Hope this helps!

   

  ---

  Kindest Regards,

  VL