RE: connecting SQL server on W and PHP/MYSQL on Unix

Is your MYSQL on unix machine? so, how do you do it? Thx. lkj

Grant Reid <grant.reid@xxxxxxxxxxxxxx> wrote:From: "Grant Reid" 
To: "lalit jairath" 
Subject: RE: connecting SQL server on W and PHP/MYSQL on Unix
Date: Wed, 10 Mar 2004 14:53:31 +0100

Why don't you use ODBC and MS-SQL Server DTS.

Inside Ms-SQL Server open "Data Transformation Services" and set up a
package. It can contain a connection to an ODBC source which can point to a
PHP MySQL database. I'm doing this. It works fine.

If you happen to find out any information about how the password is
transmitted, I would be interested to know. My situation is that I am
connecting to an online Web database. I obviously don't want to transmit my
password openly so everyone can connect.

I'm not a guru on ODBC or MySQL.

Regards
Grant Reid

-----Original Message-----
From: lalit jairath [mailto:lkjairath@xxxxxxxxx]
Sent: 10 March 2004 14:39
To: myodbc@xxxxxxxxxxxxxxx
Subject: connecting SQL server on W and PHP/MYSQL on Unix


connecting SQL server on W and PHP/MYSQL on Unix

The scenario:
My department with MYSQL/PHP on Unix machine (Lucky me!) would like to
connect/synchronize with SQL Server, Windows environment(thank God!)
in other dept.
How could I achieve that! Any code, resources would be appreciated.
Thank you in advance.
Lkj



---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what youre looking for faster.



---------------------------------
Do you Yahoo!?
Yahoo! Search - Find what you?re looking for faster.