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

Hi Lalit
Have a look at the thread starting with the post I made on 25th Feb with
subject of  "MySQL -> Linked Server in MS SQL Server" I don't know if it
will do what you want but it may be of some help

Cheers

Mike

-----Original Message-----
From: lalit jairath [mailto:lkjairath@xxxxxxxxx]
Sent: Thursday, 11 March 2004 3:41
To: myodbc@xxxxxxxxxxxxxxx
Cc: grant.reid@xxxxxxxxxxxxxx
Subject: 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.

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx