April 20, 2006 at 2:00 am
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.
April 20, 2006 at 9:39 am
You could create an ADO connection.
April 21, 2006 at 11:20 am
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!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply